obclient [(none)]> SELECT /*+ query_timeout(60000000) */ TENANT_ID, TENANT_NAME, TENANT_TYPE, PRIMARY_ZONE, LOCALITY, COMPATIBILITY_MODE, STATUS, IN_RECYCLEBIN, (CASE WHEN LOCKED = 'YES' THEN 1 ELSE 0 END) AS LOCKED, TIMESTAMPDIFF(SECOND, CREATE_TIME, now()) AS exist_seconds , ARBITRATION_SERVICE_STATUS, REPLACE(`SWITCHOVER_STATUS`, ' ', '_') as SWITCHOVER_STATUS, LOG_MODE, SYNC_SCN, RECOVERY_UNTIL_SCN, TENANT_ROLE FROM oceanbase.DBA_OB_TENANTS WHERE TENANT_TYPE IN ('SYS', 'USER'); ERROR 4016 (HY000): Internal error obclient [(none)]> obclient [(none)]> obclient [(none)]> obclient [(none)]> obclient [(none)]> select last_trace_id(); +-----------------------------------+ | last_trace_id() | +-----------------------------------+ | YB42AC10FD75-000617C248BBB31D-0-0 | +-----------------------------------+ 1 row in set (0.003 sec) obclient [(none)]> select usec_to_time(request_time),svr_ip,query_sql,IS_EXECUTOR_RPC,ret_code,trace_id from gv$ob_sql_audit where trace_id='YB42AC10FD75-000617C248BBB31D-0-0' order by request_time; ERROR 1046 (3D000): No database selected obclient [(none)]> use oceanbase; Database changed obclient [oceanbase]> obclient [oceanbase]> select usec_to_time(request_time),svr_ip,query_sql,IS_EXECUTOR_RPC,ret_code,trace_id from gv$ob_sql_audit where trace_id='YB42AC10FD75-000617C248BBB31D-0-0' order by request_time; +----------------------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------+----------+-----------------------------------+ | usec_to_time(request_time) | svr_ip | query_sql | IS_EXECUTOR_RPC | ret_code | trace_id | +----------------------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------+----------+-----------------------------------+ | 2024-06-07 09:42:37.891403 | 172.16.253.117 | SELECT /*+ query_timeout(60000000) */ TENANT_ID, TENANT_NAME, TENANT_TYPE, PRIMARY_ZONE, LOCALITY, COMPATIBILITY_MODE, STATUS, IN_RECYCLEBIN, (CASE WHEN LOCKED = 'YES' THEN 1 ELSE 0 END) AS LOCKED, TIMESTAMPDIFF(SECOND, CREATE_TIME, now()) AS exist_seconds , ARBITRATION_SERVICE_STATUS, REPLACE(`SWITCHOVER_STATUS`, ' ', '_') as SWITCHOVER_STATUS, LOG_MODE, SYNC_SCN, RECOVERY_UNTIL_SCN, TENANT_ROLE FROM oceanbase.DBA_OB_TENANTS WHERE TENANT_TYPE IN ('SYS', 'USER') | 0 | -4016 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.903448 | 172.16.253.117 | SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_stat ON col_stat.tenant_id = hist_stat.tenant_id AND col_stat.table_id = hist_stat.table_id AND col_stat.partition_id = hist_stat.partition_id AND col_stat.column_id = hist_stat.column_id WHERE (col_stat.TENANT_ID=0 AND col_stat.TABLE_ID=12358 AND col_stat.PARTITION_ID IN (12358) AND col_stat.COLUMN_ID IN (16)) ORDER BY tenant_id, table_id, partition_id, column_id, endpoint_num; | 0 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.904246 | 172.16.253.113 | | 1 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.910073 | 172.16.253.117 | SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_stat ON col_stat.tenant_id = hist_stat.tenant_id AND col_stat.table_id = hist_stat.table_id AND col_stat.partition_id = hist_stat.partition_id AND col_stat.column_id = hist_stat.column_id WHERE (col_stat.TENANT_ID=0 AND col_stat.TABLE_ID=12358 AND col_stat.PARTITION_ID IN (12358) AND col_stat.COLUMN_ID IN (28)) ORDER BY tenant_id, table_id, partition_id, column_id, endpoint_num; | 0 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.910749 | 172.16.253.113 | | 1 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.914774 | 172.16.253.117 | SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_stat ON col_stat.tenant_id = hist_stat.tenant_id AND col_stat.table_id = hist_stat.table_id AND col_stat.partition_id = hist_stat.partition_id AND col_stat.column_id = hist_stat.column_id WHERE (col_stat.TENANT_ID=0 AND col_stat.TABLE_ID=12358 AND col_stat.PARTITION_ID IN (12358) AND col_stat.COLUMN_ID IN (30)) ORDER BY tenant_id, table_id, partition_id, column_id, endpoint_num; | 0 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.915450 | 172.16.253.113 | | 1 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.918491 | 172.16.253.117 | SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_stat ON col_stat.tenant_id = hist_stat.tenant_id AND col_stat.table_id = hist_stat.table_id AND col_stat.partition_id = hist_stat.partition_id AND col_stat.column_id = hist_stat.column_id WHERE (col_stat.TENANT_ID=0 AND col_stat.TABLE_ID=12358 AND col_stat.PARTITION_ID IN (12358) AND col_stat.COLUMN_ID IN (31)) ORDER BY tenant_id, table_id, partition_id, column_id, endpoint_num; | 0 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.918920 | 172.16.253.113 | | 1 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.923828 | 172.16.253.117 | SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_stat ON col_stat.tenant_id = hist_stat.tenant_id AND col_stat.table_id = hist_stat.table_id AND col_stat.partition_id = hist_stat.partition_id AND col_stat.column_id = hist_stat.column_id WHERE (col_stat.TENANT_ID=0 AND col_stat.TABLE_ID=12358 AND col_stat.PARTITION_ID IN (12358) AND col_stat.COLUMN_ID IN (22)) ORDER BY tenant_id, table_id, partition_id, column_id, endpoint_num; | 0 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.924491 | 172.16.253.113 | | 1 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.929138 | 172.16.253.117 | SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_stat ON col_stat.tenant_id = hist_stat.tenant_id AND col_stat.table_id = hist_stat.table_id AND col_stat.partition_id = hist_stat.partition_id AND col_stat.column_id = hist_stat.column_id WHERE (col_stat.TENANT_ID=0 AND col_stat.TABLE_ID=12358 AND col_stat.PARTITION_ID IN (12358) AND col_stat.COLUMN_ID IN (32)) ORDER BY tenant_id, table_id, partition_id, column_id, endpoint_num; | 0 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.929816 | 172.16.253.113 | | 1 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.933146 | 172.16.253.117 | SELECT partition_id, object_type, row_cnt as row_count, avg_row_len as avg_row_size, macro_blk_cnt as macro_block_num, micro_blk_cnt as micro_block_num, stattype_locked as stattype_locked,last_analyzed FROM __all_table_stat WHERE TENANT_ID = 0 AND TABLE_ID=12255 | 0 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.933730 | 172.16.253.113 | | 1 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.936761 | 172.16.253.117 | SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_stat ON col_stat.tenant_id = hist_stat.tenant_id AND col_stat.table_id = hist_stat.table_id AND col_stat.partition_id = hist_stat.partition_id AND col_stat.column_id = hist_stat.column_id WHERE (col_stat.TENANT_ID=0 AND col_stat.TABLE_ID=12255 AND col_stat.PARTITION_ID IN (12255) AND col_stat.COLUMN_ID IN (19)) ORDER BY tenant_id, table_id, partition_id, column_id, endpoint_num; | 0 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.937587 | 172.16.253.113 | | 1 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.940802 | 172.16.253.117 | SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_stat ON col_stat.tenant_id = hist_stat.tenant_id AND col_stat.table_id = hist_stat.table_id AND col_stat.partition_id = hist_stat.partition_id AND col_stat.column_id = hist_stat.column_id WHERE (col_stat.TENANT_ID=0 AND col_stat.TABLE_ID=12255 AND col_stat.PARTITION_ID IN (12255) AND col_stat.COLUMN_ID IN (20)) ORDER BY tenant_id, table_id, partition_id, column_id, endpoint_num; | 0 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.941366 | 172.16.253.113 | | 1 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.943815 | 172.16.253.117 | SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_stat ON col_stat.tenant_id = hist_stat.tenant_id AND col_stat.table_id = hist_stat.table_id AND col_stat.partition_id = hist_stat.partition_id AND col_stat.column_id = hist_stat.column_id WHERE (col_stat.TENANT_ID=0 AND col_stat.TABLE_ID=12255 AND col_stat.PARTITION_ID IN (12255) AND col_stat.COLUMN_ID IN (22)) ORDER BY tenant_id, table_id, partition_id, column_id, endpoint_num; | 0 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.944205 | 172.16.253.113 | | 1 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.946909 | 172.16.253.117 | SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_stat ON col_stat.tenant_id = hist_stat.tenant_id AND col_stat.table_id = hist_stat.table_id AND col_stat.partition_id = hist_stat.partition_id AND col_stat.column_id = hist_stat.column_id WHERE (col_stat.TENANT_ID=0 AND col_stat.TABLE_ID=12255 AND col_stat.PARTITION_ID IN (12255) AND col_stat.COLUMN_ID IN (25)) ORDER BY tenant_id, table_id, partition_id, column_id, endpoint_num; | 0 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.947491 | 172.16.253.113 | | 1 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.949938 | 172.16.253.117 | SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_stat ON col_stat.tenant_id = hist_stat.tenant_id AND col_stat.table_id = hist_stat.table_id AND col_stat.partition_id = hist_stat.partition_id AND col_stat.column_id = hist_stat.column_id WHERE (col_stat.TENANT_ID=0 AND col_stat.TABLE_ID=12255 AND col_stat.PARTITION_ID IN (12255) AND col_stat.COLUMN_ID IN (26)) ORDER BY tenant_id, table_id, partition_id, column_id, endpoint_num; | 0 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.950456 | 172.16.253.113 | | 1 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.952873 | 172.16.253.117 | SELECT col_stat.tenant_id as tenant_id, col_stat.table_id as table_id, col_stat.partition_id as partition_id, col_stat.column_id as column_id, col_stat.object_type as stat_level, col_stat.distinct_cnt as num_distinct, col_stat.null_cnt as num_null,col_stat.b_max_value as b_max_value, col_stat.b_min_value as b_min_value,col_stat.avg_len as avg_len,col_stat.distinct_cnt_synopsis as distinct_cnt_synopsis,col_stat.distinct_cnt_synopsis_size as distinct_cnt_synopsis_size,col_stat.histogram_type as histogram_type,col_stat.sample_size as sample_size,col_stat.bucket_cnt as bucket_cnt,col_stat.density as density,col_stat.last_analyzed as last_analyzed,hist_stat.endpoint_num as endpoint_num, hist_stat.b_endpoint_value as b_endpoint_value,hist_stat.endpoint_repeat_cnt as endpoint_repeat_cnt FROM __all_column_stat col_stat LEFT JOIN __all_histogram_stat hist_stat ON col_stat.tenant_id = hist_stat.tenant_id AND col_stat.table_id = hist_stat.table_id AND col_stat.partition_id = hist_stat.partition_id AND col_stat.column_id = hist_stat.column_id WHERE (col_stat.TENANT_ID=0 AND col_stat.TABLE_ID=12255 AND col_stat.PARTITION_ID IN (12255) AND col_stat.COLUMN_ID IN (16)) ORDER BY tenant_id, table_id, partition_id, column_id, endpoint_num; | 0 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.953260 | 172.16.253.113 | | 1 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.959355 | 172.16.253.117 | SELECT /*+ query_timeout(100000000) */ `tenant_id`, `tenant_name`, `gmt_create`, `primary_zone`, `locality`, `compatibility_mode`, `status`, `in_recyclebin`, `locked`, `arbitration_service_status` FROM `__all_tenant` WHERE 1=1 ORDER BY `tenant_id` ASC | 0 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.964289 | 172.16.253.113 | | 1 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.966627 | 172.16.253.117 | SELECT /*+ query_timeout(100000000) */ `tenant_id`, `tenant_role`, `switchover_status`, `sync_scn`, `recovery_until_scn`, `log_mode` FROM `__all_tenant_info` WHERE 1=1 AND tenant_id = 1 | 0 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.969883 | 172.16.253.113 | | 1 | 0 | YB42AC10FD75-000617C248BBB31D-0-0 | | 2024-06-07 09:42:37.973998 | 172.16.253.117 | SELECT /*+ query_timeout(100000000) */ `tenant_id`, `tenant_role`, `switchover_status`, `sync_scn`, `recovery_until_scn`, `log_mode` FROM `__all_tenant_info` WHERE 1=1 AND tenant_id = 1001 | 0 | -4016 | YB42AC10FD75-000617C248BBB31D-0-0 | +----------------------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------+----------+-----------------------------------+ 32 rows in set (0.581 sec) [root@CloudOBSvr5 log]# grep -i "YB42AC10FD75-000617C248BBB31D-0-0" observer.log.2024060709* observer.log.20240607094254290:[2024-06-07 09:42:37.894005] WDIAG [SQL.RESV] get_table_schema (ob_schema_checker.cpp:850) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=14][errcode=-4002] invalid arguments(table_id=18446744073709551615, ret=-4002, lbt()="0x1149e4ac 0xcc7e6d9 0xcc5e00e 0xd00b792 0xd0b24ff 0xcffcae6 0xd21e39b 0xd21c9c9 0xd21d7ec 0xd07ff08 0xcff6d31 0xd1ea463 0xd1e30b2 0xd1f59ea 0xcbf859e 0x4c90724 0x4c863f9 0x4c84799 0x4c80381 0x49fb597 0x49e79bf 0x49e180d 0x49d91c4 0x49d463c 0x91d8064 0x11b49683 0x7fc11b3d9f1b 0x7fc11b30f1c0") observer.log.20240607094254290:[2024-06-07 09:42:37.894089] WDIAG [SQL.RESV] get_table_schema (ob_schema_checker.cpp:850) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=57][errcode=-4002] invalid arguments(table_id=18446744073709551615, ret=-4002, lbt()="0x1149e4ac 0xcc7e6d9 0xcc5e00e 0xd00b792 0xd0b24ff 0xcffcae6 0xd21e39b 0xd21c9c9 0xd21d7ec 0xd07ff08 0xcff6d31 0xd1ea463 0xd1e30b2 0xd1f59ea 0xcbf859e 0x4c90724 0x4c863f9 0x4c84799 0x4c80381 0x49fb597 0x49e79bf 0x49e180d 0x49d91c4 0x49d463c 0x91d8064 0x11b49683 0x7fc11b3d9f1b 0x7fc11b30f1c0") observer.log.20240607094254290:[2024-06-07 09:42:37.894124] WDIAG [SQL.RESV] get_table_schema (ob_schema_checker.cpp:850) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=10][errcode=-4002] invalid arguments(table_id=18446744073709551615, ret=-4002, lbt()="0x1149e4ac 0xcc7e6d9 0xcc5e00e 0xd00b792 0xd0b24ff 0xcffcae6 0xd21e39b 0xd21c9c9 0xd21d7ec 0xd07ff08 0xcff6d31 0xd1ea463 0xd1e30b2 0xd1f59ea 0xcbf859e 0x4c90724 0x4c863f9 0x4c84799 0x4c80381 0x49fb597 0x49e79bf 0x49e180d 0x49d91c4 0x49d463c 0x91d8064 0x11b49683 0x7fc11b3d9f1b 0x7fc11b30f1c0") observer.log.20240607094254290:[2024-06-07 09:42:37.894142] WDIAG [SQL.RESV] get_table_schema (ob_schema_checker.cpp:850) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=5][errcode=-4002] invalid arguments(table_id=18446744073709551615, ret=-4002, lbt()="0x1149e4ac 0xcc7e6d9 0xcc5e00e 0xd00b792 0xd0b24ff 0xcffcae6 0xd21e39b 0xd21c9c9 0xd21d7ec 0xd07ff08 0xcff6d31 0xd1ea463 0xd1e30b2 0xd1f59ea 0xcbf859e 0x4c90724 0x4c863f9 0x4c84799 0x4c80381 0x49fb597 0x49e79bf 0x49e180d 0x49d91c4 0x49d463c 0x91d8064 0x11b49683 0x7fc11b3d9f1b 0x7fc11b30f1c0") observer.log.20240607094254290:[2024-06-07 09:42:37.894171] WDIAG [SQL.RESV] get_table_schema (ob_schema_checker.cpp:850) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=5][errcode=-4002] invalid arguments(table_id=18446744073709551615, ret=-4002, lbt()="0x1149e4ac 0xcc7e6d9 0xcc5e00e 0xd00b792 0xd0b24ff 0xcffcae6 0xd21e39b 0xd21c9c9 0xd21d7ec 0xd07ff08 0xcff6d31 0xd1ea463 0xd1e30b2 0xd1f59ea 0xcbf859e 0x4c90724 0x4c863f9 0x4c84799 0x4c80381 0x49fb597 0x49e79bf 0x49e180d 0x49d91c4 0x49d463c 0x91d8064 0x11b49683 0x7fc11b3d9f1b 0x7fc11b30f1c0") observer.log.20240607094254290:[2024-06-07 09:42:37.894505] WDIAG [SQL.RESV] get_table_schema (ob_schema_checker.cpp:850) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=250][errcode=-4002] invalid arguments(table_id=18446744073709551615, ret=-4002, lbt()="0x1149e4ac 0xcc7e6d9 0xcc5e00e 0xd00b792 0xd0b24ff 0xcffcae6 0xd21e39b 0xd21c9c9 0xd21d7ec 0xd07ff08 0xcff6d31 0xd1ea463 0xd1e30b2 0xd1f59ea 0xcbf859e 0x4c90724 0x4c863f9 0x4c84799 0x4c80381 0x49fb597 0x49e79bf 0x49e180d 0x49d91c4 0x49d463c 0x91d8064 0x11b49683 0x7fc11b3d9f1b 0x7fc11b30f1c0") observer.log.20240607094254290:[2024-06-07 09:42:37.894711] WDIAG [SQL.RESV] get_table_schema (ob_schema_checker.cpp:850) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=184][errcode=-4002] invalid arguments(table_id=18446744073709551615, ret=-4002, lbt()="0x1149e4ac 0xcc7e6d9 0xcc5e00e 0xd00b792 0xd0b24ff 0xcffcae6 0xd21e39b 0xd21c9c9 0xd21d7ec 0xd07ff08 0xcff6d31 0xd1ea463 0xd1e30b2 0xd1f59ea 0xcbf859e 0x4c90724 0x4c863f9 0x4c84799 0x4c80381 0x49fb597 0x49e79bf 0x49e180d 0x49d91c4 0x49d463c 0x91d8064 0x11b49683 0x7fc11b3d9f1b 0x7fc11b30f1c0") observer.log.20240607094254290:[2024-06-07 09:42:37.902454] INFO [SQL.JO] compute_table_location (ob_join_order.cpp:277) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=5] succeed to calculate base table sharding info(table_id=18446744073709551610, ref_table_id=12358, is_global_index=false) observer.log.20240607094254290:[2024-06-07 09:42:37.902569] INFO [SQL.JO] init_est_sel_info_for_access_path (ob_join_order.cpp:12118) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=77] total rowcount, use statistics(table_meta_info_.table_row_count_=3, table_meta_info_.average_row_size_=3.800000000000000000e+02, table_meta_info_.micro_block_count_=0, table_meta_info_.part_size_=1.140000000000000000e+03) observer.log.20240607094254290:[2024-06-07 09:42:37.932398] INFO [SHARE.LOCATION] vtable_nonblock_renew (ob_vtable_location_service.cpp:446) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=22] add_update_task succeed(ret=0, ret="OB_SUCCESS", task={tenant_id:1, table_id:12255, add_timestamp:1717724557932355}) observer.log.20240607094254290:[2024-06-07 09:42:37.932543] INFO [SQL.JO] compute_table_location (ob_join_order.cpp:277) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=122] succeed to calculate base table sharding info(table_id=18446744073709551609, ref_table_id=12255, is_global_index=false) observer.log.20240607094254290:[2024-06-07 09:42:37.935650] INFO [SQL.JO] init_est_sel_info_for_access_path (ob_join_order.cpp:12118) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=11] total rowcount, use statistics(table_meta_info_.table_row_count_=1, table_meta_info_.average_row_size_=2.410000000000000000e+02, table_meta_info_.micro_block_count_=0, table_meta_info_.part_size_=2.410000000000000000e+02) observer.log.20240607094254290:[2024-06-07 09:42:37.955771] INFO [SQL.JO] compute_table_location (ob_join_order.cpp:277) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=61] succeed to calculate base table sharding info(table_id=18446744073709551608, ref_table_id=12396, is_global_index=false) observer.log.20240607094254290:[2024-06-07 09:42:37.955845] INFO [SQL.JO] init_est_sel_info_for_access_path (ob_join_order.cpp:12118) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=56] total rowcount, use statistics(table_meta_info_.table_row_count_=4, table_meta_info_.average_row_size_=2.170000000000000000e+02, table_meta_info_.micro_block_count_=0, table_meta_info_.part_size_=8.680000000000000000e+02) observer.log.20240607094254290:[2024-06-07 09:42:37.962385] INFO [SQL.JO] compute_table_location (ob_join_order.cpp:277) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=69] succeed to calculate base table sharding info(table_id=18446744073709551614, ref_table_id=108, is_global_index=false) observer.log.20240607094254290:[2024-06-07 09:42:37.962482] INFO [SQL.JO] init_est_sel_info_for_access_path (ob_join_order.cpp:12118) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=58] total rowcount, use statistics(table_meta_info_.table_row_count_=3, table_meta_info_.average_row_size_=3.800000000000000000e+02, table_meta_info_.micro_block_count_=3, table_meta_info_.part_size_=1.140000000000000000e+03) observer.log.20240607094254290:[2024-06-07 09:42:37.965797] INFO [SERVER] inner_get_next_row (ob_agent_virtual_table.cpp:270) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=21] mysql compat mode agent do not do convert(ret=0, ret="OB_SUCCESS", input={"BIGINT":1}) observer.log.20240607094254290:[2024-06-07 09:42:37.965842] INFO [SERVER] inner_get_next_row (ob_agent_virtual_table.cpp:270) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=45] mysql compat mode agent do not do convert(ret=0, ret="OB_SUCCESS", input={"VARCHAR":"sys", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}) observer.log.20240607094254290:[2024-06-07 09:42:37.965871] INFO [SERVER] inner_get_next_row (ob_agent_virtual_table.cpp:270) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=28] mysql compat mode agent do not do convert(ret=0, ret="OB_SUCCESS", input={"TIMESTAMP":"2024-05-06 03:46:22.718270"}) observer.log.20240607094254290:[2024-06-07 09:42:37.965881] INFO [SERVER] inner_get_next_row (ob_agent_virtual_table.cpp:270) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=10] mysql compat mode agent do not do convert(ret=0, ret="OB_SUCCESS", input={"VARCHAR":"zone1;zone2;zone3", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}) observer.log.20240607094254290:[2024-06-07 09:42:37.965887] INFO [SERVER] inner_get_next_row (ob_agent_virtual_table.cpp:270) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=6] mysql compat mode agent do not do convert(ret=0, ret="OB_SUCCESS", input={"VARCHAR":"FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}) observer.log.20240607094254290:[2024-06-07 09:42:37.965892] INFO [SERVER] inner_get_next_row (ob_agent_virtual_table.cpp:270) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=5] mysql compat mode agent do not do convert(ret=0, ret="OB_SUCCESS", input={"BIGINT":0}) observer.log.20240607094254290:[2024-06-07 09:42:37.965896] INFO [SERVER] inner_get_next_row (ob_agent_virtual_table.cpp:270) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=4] mysql compat mode agent do not do convert(ret=0, ret="OB_SUCCESS", input={"VARCHAR":"NORMAL", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}) observer.log.20240607094254290:[2024-06-07 09:42:37.965901] INFO [SERVER] inner_get_next_row (ob_agent_virtual_table.cpp:270) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=4] mysql compat mode agent do not do convert(ret=0, ret="OB_SUCCESS", input={"BIGINT":0}) observer.log.20240607094254290:[2024-06-07 09:42:37.965904] INFO [SERVER] inner_get_next_row (ob_agent_virtual_table.cpp:270) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=3] mysql compat mode agent do not do convert(ret=0, ret="OB_SUCCESS", input={"BIGINT":0}) observer.log.20240607094254290:[2024-06-07 09:42:37.965908] INFO [SERVER] inner_get_next_row (ob_agent_virtual_table.cpp:270) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=4] mysql compat mode agent do not do convert(ret=0, ret="OB_SUCCESS", input={"VARCHAR":"DISABLED", collation:"utf8mb4_general_ci", coercibility:"IMPLICIT"}) observer.log.20240607094254290:[2024-06-07 09:42:37.968616] INFO [SQL.JO] compute_table_location (ob_join_order.cpp:277) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=5] succeed to calculate base table sharding info(table_id=18446744073709551614, ref_table_id=366, is_global_index=false) observer.log.20240607094254290:[2024-06-07 09:42:37.975917] INFO [SQL.JO] compute_table_location (ob_join_order.cpp:277) [2816837][T1_L0_G0][T1001][YB42AC10FD75-000617C248BBB31D-0-0] [lt=38] succeed to calculate base table sharding info(table_id=18446744073709551614, ref_table_id=366, is_global_index=false) observer.log.20240607094254290:[2024-06-07 09:42:37.976012] INFO [SQL.JO] init_est_sel_info_for_access_path (ob_join_order.cpp:12118) [2816837][T1_L0_G0][T1001][YB42AC10FD75-000617C248BBB31D-0-0] [lt=55] total rowcount, use statistics(table_meta_info_.table_row_count_=1, table_meta_info_.average_row_size_=2.410000000000000000e+02, table_meta_info_.micro_block_count_=11, table_meta_info_.part_size_=2.410000000000000000e+02) observer.log.20240607094254290:[2024-06-07 09:42:37.980260] WDIAG setup_next_scanner (ob_direct_receive_op.cpp:204) [2816837][T1_L0_G0][T1001][YB42AC10FD75-000617C248BBB31D-0-0] [lt=35][errcode=-4016] REACH SYSLOG RATE LIMIT [bandwidth] observer.log.20240607094254290:[2024-06-07 09:42:37.981231] INFO [SERVER] send_error_packet (obmp_packet_sender.cpp:319) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=2] sending error packet(ob_error=-4016, client error=-4016, extra_err_info=NULL, lbt()="0x1149e4ac 0x936fe00 0x931c539 0x4a01525 0x49e7c4c 0x49e180d 0x49d91c4 0x49d463c 0x91d8064 0x11b49683 0x7fc11b3d9f1b 0x7fc11b30f1c0") observer.log.20240607094254290:[2024-06-07 09:42:37.981503] INFO [SERVER] send_error_packet (obmp_packet_sender.cpp:502) [2816837][T1_L0_G0][T1][YB42AC10FD75-000617C248BBB31D-0-0] [lt=201] dump txn free route audit_record(value=5, session->get_sessid()=3222148331, session->get_proxy_sessid()=12398688436113047577) [root@CloudOBSvr5 log]#