2026-02-19T23:28:02.99389+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_query_rt_hbase_total, duration: 138.836878ms (over 100ms), sql: select tenant_id, svr_ip, response_time, cumulative_count from (select t1.tenant_id, t1.svr_ip, (case when t1.response_time >= t0.max_rt then '+Inf' else t1.response_time * 1000000 end) as response_time, t1.total_count, t1.total_value * 1000000 as total_value, sum(t2.total_count) as cumulative_count, sum(t2.total_value) * 1000000 as cumulative_value from (select max(response_time) as max_rt from v$ob_query_response_time_histogram) t0 join (select tenant_id, svr_ip, sql_type, response_time, sum(count) as total_count, sum(total) as total_value from v$ob_query_response_time_histogram group by response_time, tenant_id, svr_ip, sql_type) t1 inner join (select tenant_id, svr_ip, sql_type, response_time, sum(count) as total_count, sum(total) as total_value from v$ob_query_response_time_histogram group by response_time, tenant_id, svr_ip, sql_type) t2 on t1.response_time >= t2.response_time and t1.tenant_id = t2.tenant_id and t1.svr_ip = t2.svr_ip and t1.sql_type = t2.sql_type where t1.svr_ip = ? and t1.sql_type in ('HBASE SCAN', 'HBASE PUT', 'HBASE DELETE', 'HBASE APPEND', 'HBASE INCREMENT', 'HBASE CHECK AND PUT', 'HBASE CHECK AND DELETE', 'HBASE HYBRID BATCH') group by t1.response_time, t1.tenant_id)
2026-02-19T23:28:03.04983+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_table, duration: 195.510033ms (over 100ms), sql: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ con_id tenant_id, count(*) as cnt from CDB_TABLES group by con_id
2026-02-19T23:28:03.38757+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_cache, duration: 533.465603ms (over 100ms), sql: select /* MONITOR_AGENT */ tenant_id, cache_name, cache_size from GV$OB_KVCACHE where svr_ip = ? and svr_port = ?
2026-02-19T23:28:18.01966+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_table, duration: 155.979796ms (over 100ms), sql: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ con_id tenant_id, count(*) as cnt from CDB_TABLES group by con_id
2026-02-19T23:28:18.34629+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_cache, duration: 483.222321ms (over 100ms), sql: select /* MONITOR_AGENT */ tenant_id, cache_name, cache_size from GV$OB_KVCACHE where svr_ip = ? and svr_port = ?
2026-02-19T23:28:32.95556+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_query_rt_hbase_total, duration: 100.269736ms (over 100ms), sql: select tenant_id, svr_ip, response_time, cumulative_count from (select t1.tenant_id, t1.svr_ip, (case when t1.response_time >= t0.max_rt then '+Inf' else t1.response_time * 1000000 end) as response_time, t1.total_count, t1.total_value * 1000000 as total_value, sum(t2.total_count) as cumulative_count, sum(t2.total_value) * 1000000 as cumulative_value from (select max(response_time) as max_rt from v$ob_query_response_time_histogram) t0 join (select tenant_id, svr_ip, sql_type, response_time, sum(count) as total_count, sum(total) as total_value from v$ob_query_response_time_histogram group by response_time, tenant_id, svr_ip, sql_type) t1 inner join (select tenant_id, svr_ip, sql_type, response_time, sum(count) as total_count, sum(total) as total_value from v$ob_query_response_time_histogram group by response_time, tenant_id, svr_ip, sql_type) t2 on t1.response_time >= t2.response_time and t1.tenant_id = t2.tenant_id and t1.svr_ip = t2.svr_ip and t1.sql_type = t2.sql_type where t1.svr_ip = ? and t1.sql_type in ('HBASE SCAN', 'HBASE PUT', 'HBASE DELETE', 'HBASE APPEND', 'HBASE INCREMENT', 'HBASE CHECK AND PUT', 'HBASE CHECK AND DELETE', 'HBASE HYBRID BATCH') group by t1.response_time, t1.tenant_id)
2026-02-19T23:28:32.95865+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_query_rt_table_total, duration: 103.422236ms (over 100ms), sql: select tenant_id, svr_ip, response_time, cumulative_count from (select t1.tenant_id, t1.svr_ip, (case when t1.response_time >= t0.max_rt then '+Inf' else t1.response_time * 1000000 end) as response_time, t1.total_count, t1.total_value * 1000000 as total_value, sum(t2.total_count) as cumulative_count, sum(t2.total_value) * 1000000 as cumulative_value from (select max(response_time) as max_rt from v$ob_query_response_time_histogram) t0 join (select tenant_id, svr_ip, sql_type, response_time, sum(count) as total_count, sum(total) as total_value from v$ob_query_response_time_histogram group by response_time, tenant_id, svr_ip, sql_type) t1 inner join (select tenant_id, svr_ip, sql_type, response_time, sum(count) as total_count, sum(total) as total_value from v$ob_query_response_time_histogram group by response_time, tenant_id, svr_ip, sql_type) t2 on t1.response_time >= t2.response_time and t1.tenant_id = t2.tenant_id and t1.svr_ip = t2.svr_ip and t1.sql_type = t2.sql_type where t1.svr_ip = ? and t1.sql_type in ('TABLEAPI SELECT', 'TABLEAPI INSERT', 'TABLEAPI DELETE', 'TABLEAPI UPDATE', 'TABLEAPI REPLACE', 'TABLEAPI QUERY AND MUTATE', 'TABLEAPI OTHER') group by t1.response_time, t1.tenant_id)
2026-02-19T23:28:33.01836+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_table, duration: 163.762751ms (over 100ms), sql: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ con_id tenant_id, count(*) as cnt from CDB_TABLES group by con_id
2026-02-19T23:28:33.0385+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_index, duration: 184.430878ms (over 100ms), sql: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ count(*) as cnt from CDB_INDEXES where status in ('ERROR','UNUSABLE')
2026-02-19T23:28:33.32073+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_cache, duration: 466.280756ms (over 100ms), sql: select /* MONITOR_AGENT */ tenant_id, cache_name, cache_size from GV$OB_KVCACHE where svr_ip = ? and svr_port = ?
2026-02-19T23:28:42.7724+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_query_response_time_seconds, duration: 9.918034466s (over 100ms), sql: select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ __all_tenant.tenant_name as tenant_name, v_acc_response_time.response_time as response_time_seconds,  v_acc_response_time.count as bucket, case when  v_acc_response_time.response_time = '+inf' then v_acc_response_time.count else null end as count, case when  v_acc_response_time.response_time = '+inf' then cast(v_acc_response_time.sum / 1000000 as float) else null end as sum from (select b.tenant_id, b.response_time / 1000000  as response_time, sum(a.count) as count, sum(a.total) as sum from  __all_virtual_query_response_time a,  __all_virtual_query_response_time b where a.response_time <= b.response_time and a.svr_ip = b.svr_ip and a.svr_port = b.svr_port and b.svr_ip = ? and b.svr_port = ? group by b.tenant_id, b.response_time union  select tenant_id, '+inf', sum(count), sum(total) from __all_virtual_query_response_time) v_acc_response_time,  __all_tenant where v_acc_response_time.tenant_id = __all_tenant.tenant_id;
2026-02-19T23:28:42.77251+08:00 WARN [1107725,] caller=mysql/table_input.go:284:collectWithConfig: failed to do collect with sql select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ __all_tenant.tenant_name as tenant_name, v_acc_response_time.response_time as response_time_seconds,  v_acc_response_time.count as bucket, case when  v_acc_response_time.response_time = '+inf' then v_acc_response_time.count else null end as count, case when  v_acc_response_time.response_time = '+inf' then cast(v_acc_response_time.sum / 1000000 as float) else null end as sum from (select b.tenant_id, b.response_time / 1000000  as response_time, sum(a.count) as count, sum(a.total) as sum from  __all_virtual_query_response_time a,  __all_virtual_query_response_time b where a.response_time <= b.response_time and a.svr_ip = b.svr_ip and a.svr_port = b.svr_port and b.svr_ip = ? and b.svr_port = ? group by b.tenant_id, b.response_time union  select tenant_id, '+inf', sum(count), sum(total) from __all_virtual_query_response_time) v_acc_response_time,  __all_tenant where v_acc_response_time.tenant_id = __all_tenant.tenant_id;, args:[xx.xx.xx.12 18082], err: Error 4012: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again.
2026-02-19T23:28:42.77257+08:00 WARN [1107725,] caller=mysql/table_input.go:376:doCollect: collect table err: Error 4012: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. fields:, name=ob_query_response_time_seconds, duration=9.918251817s
2026-02-19T23:28:48.00007+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_table, duration: 141.93501ms (over 100ms), sql: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ con_id tenant_id, count(*) as cnt from CDB_TABLES group by con_id
2026-02-19T23:28:48.33071+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_cache, duration: 472.98789ms (over 100ms), sql: select /* MONITOR_AGENT */ tenant_id, cache_name, cache_size from GV$OB_KVCACHE where svr_ip = ? and svr_port = ?
2026-02-19T23:29:03.00366+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_table, duration: 149.252988ms (over 100ms), sql: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ con_id tenant_id, count(*) as cnt from CDB_TABLES group by con_id
2026-02-19T23:29:03.34324+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_cache, duration: 489.051494ms (over 100ms), sql: select /* MONITOR_AGENT */ tenant_id, cache_name, cache_size from GV$OB_KVCACHE where svr_ip = ? and svr_port = ?
2026-02-19T23:29:18.01161+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_table, duration: 148.49809ms (over 100ms), sql: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ con_id tenant_id, count(*) as cnt from CDB_TABLES group by con_id
2026-02-19T23:29:18.33773+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_cache, duration: 474.836749ms (over 100ms), sql: select /* MONITOR_AGENT */ tenant_id, cache_name, cache_size from GV$OB_KVCACHE where svr_ip = ? and svr_port = ?
2026-02-19T23:29:33.01405+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_table, duration: 158.892124ms (over 100ms), sql: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ con_id tenant_id, count(*) as cnt from CDB_TABLES group by con_id
2026-02-19T23:29:33.34436+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_cache, duration: 489.410034ms (over 100ms), sql: select /* MONITOR_AGENT */ tenant_id, cache_name, cache_size from GV$OB_KVCACHE where svr_ip = ? and svr_port = ?
2026-02-19T23:29:42.77664+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_query_response_time_seconds, duration: 9.921844586s (over 100ms), sql: select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ __all_tenant.tenant_name as tenant_name, v_acc_response_time.response_time as response_time_seconds,  v_acc_response_time.count as bucket, case when  v_acc_response_time.response_time = '+inf' then v_acc_response_time.count else null end as count, case when  v_acc_response_time.response_time = '+inf' then cast(v_acc_response_time.sum / 1000000 as float) else null end as sum from (select b.tenant_id, b.response_time / 1000000  as response_time, sum(a.count) as count, sum(a.total) as sum from  __all_virtual_query_response_time a,  __all_virtual_query_response_time b where a.response_time <= b.response_time and a.svr_ip = b.svr_ip and a.svr_port = b.svr_port and b.svr_ip = ? and b.svr_port = ? group by b.tenant_id, b.response_time union  select tenant_id, '+inf', sum(count), sum(total) from __all_virtual_query_response_time) v_acc_response_time,  __all_tenant where v_acc_response_time.tenant_id = __all_tenant.tenant_id;
2026-02-19T23:29:42.77679+08:00 WARN [1107725,] caller=mysql/table_input.go:284:collectWithConfig: failed to do collect with sql select /*+ MONITOR_AGENT READ_CONSISTENCY(WEAK) */ __all_tenant.tenant_name as tenant_name, v_acc_response_time.response_time as response_time_seconds,  v_acc_response_time.count as bucket, case when  v_acc_response_time.response_time = '+inf' then v_acc_response_time.count else null end as count, case when  v_acc_response_time.response_time = '+inf' then cast(v_acc_response_time.sum / 1000000 as float) else null end as sum from (select b.tenant_id, b.response_time / 1000000  as response_time, sum(a.count) as count, sum(a.total) as sum from  __all_virtual_query_response_time a,  __all_virtual_query_response_time b where a.response_time <= b.response_time and a.svr_ip = b.svr_ip and a.svr_port = b.svr_port and b.svr_ip = ? and b.svr_port = ? group by b.tenant_id, b.response_time union  select tenant_id, '+inf', sum(count), sum(total) from __all_virtual_query_response_time) v_acc_response_time,  __all_tenant where v_acc_response_time.tenant_id = __all_tenant.tenant_id;, args:[xx.xx.xx.12 18082], err: Error 4012: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again.
2026-02-19T23:29:42.77684+08:00 WARN [1107725,] caller=mysql/table_input.go:376:doCollect: collect table err: Error 4012: Timeout, query has reached the maximum query timeout: 10000000(us), maybe you can adjust the session variable ob_query_timeout or query_timeout hint, and try again. fields:, name=ob_query_response_time_seconds, duration=9.922091404s
2026-02-19T23:29:47.99536+08:00 WARN [1107725,] caller=common/cache.go:127:refreshProcesses: failed to get process name of pid: 2682136 fields: error="open /proc/2682136/status: no such file or directory"
2026-02-19T23:29:48.00348+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_table, duration: 145.769297ms (over 100ms), sql: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ con_id tenant_id, count(*) as cnt from CDB_TABLES group by con_id
2026-02-19T23:29:48.33438+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_cache, duration: 476.916014ms (over 100ms), sql: select /* MONITOR_AGENT */ tenant_id, cache_name, cache_size from GV$OB_KVCACHE where svr_ip = ? and svr_port = ?
2026-02-19T23:30:02.99327+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_table, duration: 138.762206ms (over 100ms), sql: select /*+ MONITOR_AGENT QUERY_TIMEOUT(100000000) */ con_id tenant_id, count(*) as cnt from CDB_TABLES group by con_id
2026-02-19T23:30:03.33645+08:00 WARN [1107725,] caller=mysql/table_input.go:274:collectWithConfig: slow sql, name: ob_cache, duration: 482.161848ms (over 100ms), sql: select /* MONITOR_AGENT */ tenant_id, cache_name, cache_size from GV$OB_KVCACHE where svr_ip = ? and svr_port = ?
2026-02-19T23:30:08.35668+08:00 INFO [1107725,] caller=shell/exec.go:99:execute: execute shell command start, command=Command{[root@prod-12 log]