If full link tracing is not enabled

OceanBase 技术问题
#1

问题一：
MySQL [test]> SET ob_enable_show_trace=ON;
Query OK, 0 rows affected (0.00 sec)

MySQL [test]> SELECT /+trace_log=on/ * FROM t1 ;
±-----±-------------------±-------±-----±-------------------±-------+
| tid | name | gender | age | subject | salary |
±-----±-------------------±-------±-----±-------------------±-------+
| 2004 | LinXiang Zhang | Male | 49 | Chinese | 9000 |
| 2008 | Robert Baratheon | Male | 50 | Chemistry | 8500 |
| 2012 | Rickon Stark | Male | 20 | English | 7000 |
| 2003 | Tyrion Lannister | Male | 38 | History | 9000 |
| 2007 | Robb Stark | Male | 26 | Physics | 8000 |
| 2011 | Chenkang Li | Male | 36 | Physics | 8000 |
| 2002 | Daenerys Targaryen | Female | 22 | xxxxxxxxxx | 7500 |
| 2006 | Brandon Stark | Male | 22 | Maths | 7000 |
| 2010 | Peihua Xu | Female | 39 | Chinese | 9000 |
| 2001 | Jon Snow | Male | 22 | Physical Education | 8000 |
| 2005 | Arya Stark | Female | 20 | English | 7000 |
| 2009 | Sansa Stark | Male | 22 | Maths | 7000 |
±-----±-------------------±-------±-----±-------------------±-------+
12 rows in set (0.01 sec)

MySQL [test]> show trace;
ERROR 1235 (0A000): If full link tracing is not enabled, show trace is not supported
MySQL [test]>

问题二：
MySQL [test]> SET ob_enable_show_trace=ON;
Query OK, 0 rows affected (0.01 sec)

MySQL [test]>
MySQL [test]> select * from t1;
±-----±-------------------±-------±-----±-------------------±-------+
| tid | name | gender | age | subject | salary |
±-----±-------------------±-------±-----±-------------------±-------+
| 2001 | Jon Snow | Male | 22 | Physical Education | 8000 |
| 2005 | Arya Stark | Female | 20 | English | 7000 |
| 2009 | Sansa Stark | Male | 22 | Maths | 7000 |
| 2004 | LinXiang Zhang | Male | 49 | Chinese | 9000 |
| 2008 | Robert Baratheon | Male | 50 | Chemistry | 8500 |
| 2012 | Rickon Stark | Male | 20 | English | 7000 |
| 2002 | Daenerys Targaryen | Female | 22 | xxxxxxxxxx | 7500 |
| 2006 | Brandon Stark | Male | 22 | Maths | 7000 |
| 2010 | Peihua Xu | Female | 39 | Chinese | 9000 |
| 2003 | Tyrion Lannister | Male | 38 | History | 9000 |
| 2007 | Robb Stark | Male | 26 | Physics | 8000 |
| 2011 | Chenkang Li | Male | 36 | Physics | 8000 |
±-----±-------------------±-------±-----±-------------------±-------+
12 rows in set (0.00 sec)

MySQL [test]>
MySQL [test]> show trace;
ERROR 1235 (0A000): If full link tracing is not enabled, show trace is not supported
MySQL [test]>

问题三：
MySQL [test]> call dbms_monitor.ob_session_trace_enable(null,1,1,‘ALL’);
Query OK, 0 rows affected (0.01 sec)

MySQL [test]>
MySQL [test]> select * from t1;
±-----±-------------------±-------±-----±-------------------±-------+
| tid | name | gender | age | subject | salary |
±-----±-------------------±-------±-----±-------------------±-------+
| 2004 | LinXiang Zhang | Male | 49 | Chinese | 9000 |
| 2008 | Robert Baratheon | Male | 50 | Chemistry | 8500 |
| 2012 | Rickon Stark | Male | 20 | English | 7000 |
| 2002 | Daenerys Targaryen | Female | 22 | xxxxxxxxxx | 7500 |
| 2006 | Brandon Stark | Male | 22 | Maths | 7000 |
| 2010 | Peihua Xu | Female | 39 | Chinese | 9000 |
| 2001 | Jon Snow | Male | 22 | Physical Education | 8000 |
| 2005 | Arya Stark | Female | 20 | English | 7000 |
| 2009 | Sansa Stark | Male | 22 | Maths | 7000 |
| 2003 | Tyrion Lannister | Male | 38 | History | 9000 |
| 2007 | Robb Stark | Male | 26 | Physics | 8000 |
| 2011 | Chenkang Li | Male | 36 | Physics | 8000 |
±-----±-------------------±-------±-----±-------------------±-------+
12 rows in set (0.01 sec)

MySQL [test]> show trace;
ERROR 4016 (HY000): Internal error
MySQL [test]>

#3

MySQL [test]> select /+trace_log=on/ * from t1;
±-----±-------------------±-------±-----±-------------------±-------+
| tid | name | gender | age | subject | salary |
±-----±-------------------±-------±-----±-------------------±-------+
| 2001 | Jon Snow | Male | 22 | Physical Education | 8000 |
| 2004 | LinXiang Zhang | Male | 49 | Chinese | 9000 |
| 2007 | Robb Stark | Male | 26 | Physics | 8000 |
| 2010 | Peihua Xu | Female | 39 | Chinese | 9000 |
| 2002 | Daenerys Targaryen | Female | 22 | Music Education | 7500 |
| 2005 | Arya Stark | Female | 20 | English | 7000 |
| 2008 | Robert Baratheon | Male | 50 | Chemistry | 8500 |
| 2011 | Chenkang Li | Male | 36 | Physics | 8000 |
| 2003 | Tyrion Lannister | Male | 38 | History | 9000 |
| 2006 | Brandon Stark | Male | 22 | Maths | 7000 |
| 2009 | Sansa Stark | Male | 22 | Maths | 7000 |
| 2012 | Rickon Stark | Male | 20 | English | 7000 |
±-----±-------------------±-------±-----±-------------------±-------+
12 rows in set (0.01 sec)

MySQL [test]> show trace;
Empty set (0.07 sec)

MySQL [test]>

#4

ob是哪个版本？是通过odp 的2883端口连的？ 还是2881直连？

#5

以上，企业版不行。

以上，社区版是可以的。

但是社区版的下面这个命令就不行。

[root@observer1 ~]# mysql -h10.10.1.78 -uroot@sys -P2881 -p’ABcd__1100’ -c -A test
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 3221578309
Server version: 5.7.25 OceanBase_CE 4.2.1.9 (r109000032024092015-f2b0ead618247181e253e3912072c30ff965632d) (Built Sep 20 2024 22:22:28)

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MySQL [test]>
MySQL [test]>
MySQL [test]> select /+trace_log=on/ * from t1;
±-----±-------------------±-------±-----±-------------------±-------+
| tid | name | gender | age | subject | salary |
±-----±-------------------±-------±-----±-------------------±-------+
| 2001 | Jon Snow | Male | 22 | Physical Education | 8000 |
| 2004 | LinXiang Zhang | Male | 49 | Chinese | 9000 |
| 2007 | Robb Stark | Male | 26 | Physics | 8000 |
| 2010 | Peihua Xu | Female | 39 | Chinese | 9000 |
| 2002 | Daenerys Targaryen | Female | 22 | Music Education | 7500 |
| 2005 | Arya Stark | Female | 20 | English | 7000 |
| 2008 | Robert Baratheon | Male | 50 | Chemistry | 8500 |
| 2011 | Chenkang Li | Male | 36 | Physics | 8000 |
| 2003 | Tyrion Lannister | Male | 38 | History | 9000 |
| 2006 | Brandon Stark | Male | 22 | Maths | 7000 |
| 2009 | Sansa Stark | Male | 22 | Maths | 7000 |
| 2012 | Rickon Stark | Male | 20 | English | 7000 |
±-----±-------------------±-------±-----±-------------------±-------+
12 rows in set (0.00 sec)

MySQL [test]> show trace;
Empty set (0.02 sec)

MySQL [test]>

居然没有收集到信息 ？

#6

商业版 你可以反馈给商业团队那边 社区主要是开源的 你的社区版ob版本是多少？

#7

社区版是

Server version: 5.7.25 OceanBase_CE 4.2.1.9 (r109000032024092015-f2b0ead618247181e253e3912072c30ff965632d) (Built Sep 20 2024 22:22:28)

#8

image
image901×817 37.6 KB

OceanBase 数据库 V4.1.0 版本新增系统变量 ob_enable_show_trace 用于控制全链路诊断 Show Trace 功能的开启关闭。在连接 OceanBase 数据库 V4.0.0 及之前版本的数据库时，请继续使用 ob_enable_trace_log 变量控制 Show Trace 功能的开启和关闭。