【 使用环境 】 测试环境
【 OB or 其他组件 】视图gv$ob_sql_audit
【 使用版本 】OceanBase_CE 4.2.5.7 (r107000022025120120-96355d7a296a4aeb80e5fd07dc6dc34aa8cdce8f) (Built Dec 1 2025 20:15:53)
【问题描述】业务租户ob_mysql 视图gv$ob_sql_audit 中 query_sql 字段内容为空，sys 租户可以正常查询
【复现路径】
- enable_sql_audit 参数为true
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | default_value | isdefault |
+-------+----------+----------------+----------+------------------+-----------+-------+---------------------------------------------------------------------------------------------------------------+----------+---------+---------+-------------------+---------------+-----------+
| zone1 | observer | 192.168.30.101 | 2882 | enable_sql_audit | NULL | True
- query_sql 为空
obclient(root@ob_mysql)[test]> create table news(id int ,title varchar(80),info varchar(80))
-> ;
Query OK, 0 rows affected (0.369 sec)
obclient(root@ob_mysql)[test]> select * from oceanbase.gv$ob_sql_audit where query_sql like '%create table news(id int%'\G;
Empty set (0.063 sec)
obclient(root@ob_mysql)[test]> select query_sql from oceanbase.gv$ob_sql_audit limit 5;
+-----------+
| query_sql |
+-----------+
| |
| |
| |
| |
| |
+-----------+
5 rows in set (0.026 sec)
obclient(root@ob_mysql)[test]>
sys 租户下测试
obclient(root@sys)[test]> create table news(id int ,title varchar(80),info varchar(80));
Query OK, 0 rows affected (0.226 sec)
obclient(root@sys)[test]> select last_trace_id();
+-----------------------------------+
| last_trace_id() |
+-----------------------------------+
| YB42C0A81E66-00064905A7C8597E-0-0 |
+-----------------------------------+
1 row in set (0.002 sec)
obclient(root@sys)[test]> select * from oceanbase.gv$ob_sql_audit where query_sql like '%create table news(id int%'\G;
*************************** 1. row ***************************
SVR_IP: 192.168.30.102
SVR_PORT: 2882
REQUEST_ID: 33308
SQL_EXEC_ID: 72665
TRACE_ID: YB42C0A81E66-00064905A7C8597E-0-0
SID: 3221791827
CLIENT_IP: 192.168.30.101
CLIENT_PORT: 50902
TENANT_ID: 1
TENANT_NAME: sys
EFFECTIVE_TENANT_ID: 1
USER_ID: 200001
USER_NAME: root
USER_GROUP: 0
USER_CLIENT_IP: 192.168.30.101
DB_ID: 500001
DB_NAME: test
SQL_ID: 477F4893848D79580D8663365CFD865A
QUERY_SQL: create table news(id int ,title varchar(80),info varchar(80))
请协助帮忙确定原因！