关于Show trace出现的问题

jujuer · 2024 年5 月 10 日 14:00

这个是什么问题

王利博 · 2024 年5 月 10 日 14:06

当前版本是多少呢

shiyh · 2024 年5 月 11 日 20:20

obclient [oceanbase]> SET ob_enable_trace_log = 1;
ERROR 1193 (HY000): Unknown system variable ‘ob_enable_trace_log’
obclient [oceanbase]>
obclient [oceanbase]> select version();
±-----------------------------+
| version() |
±-----------------------------+
| 5.7.25-OceanBase_CE-v4.2.2.0 |
±-----------------------------+
1 row in set (0.002 sec)

obclient [oceanbase]>

4.2.2.0社区版，没有show trace功能了？

jujuer · 2024 年5 月 13 日 10:11

版本：

执行其他查询语句的show trace没问题，就这条语句报了这个错误

秃蛙 · 2024 年5 月 13 日 10:16

麻烦提供两个信息

1）复现的语句（建表+查询）
2）提供下报错trace信息：

登录系统租户，打开enable_rich_error_msg 参数

alter system set enable_rich_error_msg=true;

登录业务租户，执行报错 SQL 语句，会直接返回执行节点 IP 和 trace_id 信息。

例如：
obclient [test]> select count(*) from t2;
ERROR 1146 (42S02): Table 'test.t2' doesn't exist
[xx.xx.xx.1:2882] [2024-04-13 20:10:20.292087] [YB420BA1CC68-000615A0A8EA5E38-0-0]

去 xx.xx.xx.1 节点过滤日志，如果最新日志无法过滤到，可以正则匹配多个日志进行过滤

[root@x.x.x.1 ~]$ grep "YB420BA1CC68-000615A0A8EA5E38-0-0"  rootservice.log
[root@x.x.x.1 ~]$ grep "YB420BA1CC68-000615A0A8EA5E38-0-0"  observer.log

获取完日志信息后，关闭enable_rich_error_msg参数

alter system set enable_rich_error_msg=false;

jujuer · 2024 年5 月 13 日 13:50

root@hnn-PowerEdge-R740:~$ grep “YB427F000001-00061655CDBCD75F-0-0” rootservice.log
grep: rootservice.log: 没有那个文件或目录
root@hnn-PowerEdge-R740:~$ grep “YB427F000001-00061655CDBCD75F-0-0” observer.log
grep: observer.log: 没有那个文件或目录
为什么找不到这个文件

秃蛙 · 2024 年5 月 13 日 14:04

得去observer安装目录下 ps -ef|grep observer 可以看到安装目录，进入log目录下执行、

jujuer · 2024 年5 月 13 日 14:26

mayi@hnu-PowerEdge-R740:/home/hnu/Disk0/MaYiProject/oceanbase-ce/log$ grep -E “YB427F000001-00061655CDBCDEAE-0-0” observer.log
[2024-05-13 14:18:26.951000] INFO [SHARE.LOCATION] vtable_nonblock_renew (ob_vtable_location_service.cpp:446) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=24] add_update_task succeed(ret=0, ret=“OB_SUCCESS”, task={tenant_id:1, table_id:12339, add_timestamp:1715581106950976})
[2024-05-13 14:18:26.951046] INFO [SQL.JO] compute_table_location (ob_join_order.cpp:245) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=31] succeed to calculate base table sharding info(table_id=18446744073709551614, ref_table_id=12339, is_global_index=false)
[2024-05-13 14:18:26.951111] INFO [SQL.JO] init_est_sel_info_for_access_path (ob_join_order.cpp:11870) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=20] total rowcount, use statistics(table_meta_info_.table_row_count_=0, table_meta_info_.average_row_size_=0.000000000000000000e+00, table_meta_info_.micro_block_count_=0, table_meta_info_.part_size_=0.000000000000000000e+00)
[2024-05-13 14:18:26.953833] INFO [SHARE.LOCATION] vtable_nonblock_renew (ob_vtable_location_service.cpp:446) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=13] add_update_task succeed(ret=0, ret=“OB_SUCCESS”, task={tenant_id:1, table_id:11042, add_timestamp:1715581106953815})
[2024-05-13 14:18:26.977256] INFO [SERVER] inner_get_next_row (ob_virtual_span_info.cpp:137) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=9] scan finished(start_id_=0, end_id_=18105, cur_id_=18105)
[2024-05-13 14:18:26.977451] WDIAG [SERVER] find_child_span_info (ob_virtual_show_trace.cpp:651) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=2][errcode=-4016] invalid trace span(arr.at(arr.count() - 1)->data_={tenant_id:1, trace_id:“0006184f-da25-4013-45c5-15888f17778c”, req_id:18060, span_id:“0006184f-da3d-c904-be22-edfd76f57813”, parent_span_id:“0006184f-da38-c68c-6d14-83e45ee33e9a”, span_name:“close_das_task”, start_ts:1715581103229188, end_ts:1715581103229238, tags:"", logs:""}, tmp_arr.at(i)->data_={tenant_id:1, trace_id:“0006184f-da25-4013-45c5-15888f17778c”, req_id:18059, span_id:“0006184f-da3d-c23d-8896-f3649a992c67”, parent_span_id:“0006184f-da25-46fc-bb95-e1a7d8d324a9”, span_name:“px_schedule”, start_ts:1715581103227453, end_ts:1715581103227798, tags:"", logs:""})
[2024-05-13 14:18:26.977464] WDIAG [SERVER] find_child_span_info (ob_virtual_show_trace.cpp:666) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=13][errcode=-4016] failed to push back show trace value(ret=-4016, i=1)
[2024-05-13 14:18:26.977467] WDIAG [SERVER] find_child_span_info (ob_virtual_show_trace.cpp:666) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=4][errcode=-4016] failed to push back show trace value(ret=-4016, i=1)
[2024-05-13 14:18:26.977470] WDIAG [SERVER] find_child_span_info (ob_virtual_show_trace.cpp:666) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=2][errcode=-4016] failed to push back show trace value(ret=-4016, i=0)
[2024-05-13 14:18:26.977472] WDIAG [SERVER] find_child_span_info (ob_virtual_show_trace.cpp:666) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=2][errcode=-4016] failed to push back show trace value(ret=-4016, i=2)
[2024-05-13 14:18:26.977475] WDIAG [SERVER] generate_span_info_tree (ob_virtual_show_trace.cpp:301) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=2][errcode=-4016] failed to find child span info(ret=-4016)
[2024-05-13 14:18:26.977480] WDIAG [SERVER] inner_get_next_row (ob_virtual_show_trace.cpp:689) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=3][errcode=-4016] failed to generate span info tree(ret=-4016)
[2024-05-13 14:18:26.977483] WDIAG [COMMON] get_next_row (ob_virtual_table_iterator.cpp:373) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=3][errcode=-4016] fail to inner get next row(ret=-4016, scan_param_={tablet_id:{id:1}, ls_id:{id:1}, column_ids:[25, 27, 29], index_id:12339, key_ranges:[], ss_key_ranges:[], range_array_pos:[], timeout:1715581116847848, scan_flag:{scan_order:1, daily_merge:0, rmmb_optimize:0, whole_macro_scan:0, full_row:0, index_back:0, query_stat:0, sql_mode:0, read_latest:0, prewarm:0, join_type:0, use_row_cache:0, use_block_index_cache:0, use_bloomfilter_cache:0, multi_version_minor_merge:0, is_need_feedback:1, use_fuse_row_cache:0, use_fast_agg:0, iter_uncommitted_row:0, ignore_trans_stat:0, is_large_query:0, is_sstable_cut:0, skip_read_lob:0, is_lookup_for_4377:0, is_for_foreign_key_check:0, reserved:1985962349}, sql_mode:12582912, reserved_cell_count:3, schema_version:1698309758031152, query_begin_schema_version:1715319929715440, limit_offset:{offset_:0, limit_:-1}, for_update:false, wait:-1, frozen_version:-1, is_get:false, output_exprs:[{type:“T_REF_COLUMN”, datum_meta:{type:“VARCHAR”, cs_type:“utf8mb4_general_ci”, scale:-1, precision:-1}, obj_meta:{type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“IMPLICIT”}, obj_datum_map:1, flag:2, eval_func:null, eval_batch_func:null, inner_functions:null, inner_func_cnt:0, arg_cnt:0, parent_cnt:0, frame_idx:1, datum_off:0, res_buf_off:160, dyn_buf_header_offset:144, res_buf_len:128, eval_flags_off:0, pvt_skip_off:0, expr_ctx_id:4294967295, extra:0, batch_idx_mask:0, this:0x7f7a619fc060}, {type:“T_REF_COLUMN”, datum_meta:{type:“TIMESTAMP”, cs_type:“binary”, scale:6, precision:25}, obj_meta:{type:“TIMESTAMP”, collation:“binary”, coercibility:“NUMERIC”}, obj_datum_map:3, flag:2, eval_func:null, eval_batch_func:null, inner_functions:null, inner_func_cnt:0, arg_cnt:0, parent_cnt:0, frame_idx:1, datum_off:16, res_buf_off:288, dyn_buf_header_offset:272, res_buf_len:8, eval_flags_off:0, pvt_skip_off:0, expr_ctx_id:4294967295, extra:0, batch_idx_mask:0, this:0x7f7a619fc110}, {type:“T_REF_COLUMN”, datum_meta:{type:“BIGINT”, cs_type:“binary”, scale:0, precision:20}, obj_meta:{type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, obj_datum_map:3, flag:2, eval_func:null, eval_batch_func:null, inner_functions:null, inner_func_cnt:0, arg_cnt:0, parent_cnt:1, frame_idx:1, datum_off:32, res_buf_off:296, dyn_buf_header_offset:280, res_buf_len:8, eval_flags_off:0, pvt_skip_off:0, expr_ctx_id:4294967295, extra:0, batch_idx_mask:0, this:0x7f7a619fc1c0}], op_filters:NULL, trans_desc:NULL, snapshot:{this:0x7f7a5d1ae930, valid:false, source:0, core:{version:{val:18446744073709551615, v:3}, tx_id:{txid:0}, scn:0}, uncertain_bound:0, snapshot_lsid:{id:-1}, snapshot_ls_role:0, parts:[]}, table_param:{table_id:12339, output_projector:[0, 1, 2], aggregate_projector:[], output_sel_mask:[true, true, true], pad_col_projector:[], main_read_info:{schema_column_count:16, schema_rowkey_cnt:0, rowkey_cnt:2, trans_col_index:-1, seq_read_column_count:0, max_col_index:15, is_oracle_mode:false, cols_index:{rowkey_mode:false, for_memtable:false, array:{ObIArray:[11, 13, 15], data:0x7f7a619fdd20, count:3, allocator:0x7f7a619f46b0, capacity:3, init_cnt:3}}, memtable_cols_index:{rowkey_mode:false, for_memtable:true, array:{ObIArray:[9, 11, 13], data:0x7f7a619fdd30, count:3, allocator:0x7f7a619f46b0, capacity:3, init_cnt:3}}, cols_desc:{ObIArray:[column_id=25 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=27 {type:“TIMESTAMP”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=29 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0], data:0x7f7a619fdcf0, count:3, allocator:0x7f7a619f46b0, capacity:3, init_cnt:3}, datum_utils:{is_oracle_mode:false, rowkey_cnt:2, col_cnt:5, is_inited:true, is_oracle_mode:false}, cols_param:[{column_id:25, meta_type:{type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:1024, precision:-1, scale:-1}, orig_default_value:{“NULL”:“NULL”}, cur_default_value:{“NULL”:“NULL”}, is_nullable_for_write:false, is_nullable_for_read:false, is_gen_col:false, is_virtual_gen_col:false, is_gen_col_udf_expr:false, is_hidden:false}, {column_id:27, meta_type:{type:“TIMESTAMP”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:25, scale:6}, orig_default_value:{“NULL”:“NULL”}, cur_default_value:{“NULL”:“NULL”}, is_nullable_for_write:false, is_nullable_for_read:false, is_gen_col:false, is_virtual_gen_col:false, is_gen_col_udf_expr:false, is_hidden:false}, {column_id:29, meta_type:{type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:20, scale:0}, orig_default_value:{“NULL”:“NULL”}, cur_default_value:{“NULL”:“NULL”}, is_nullable_for_write:false, is_nullable_for_read:false, is_gen_col:false, is_virtual_gen_col:false, is_gen_col_udf_expr:false, is_hidden:false}]}, use_lob_locator:false, rowid_version:0, rowid_projector:[], enable_lob_locator_v2:true}, sample_info:{method:0, percent:“1.000000000000000000e+02”, seed:-1, table_id:0, scope:0, force_block:false}, need_scn:false, need_switch_param:false, fb_read_tx_uncommitted:false, external_file_format:}, external_file_location:""})
[2024-05-13 14:18:26.977596] WDIAG [COMMON] get_next_row (ob_virtual_table_iterator.cpp:474) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=112][errcode=-4016] get next row failed(ret=-4016)
[2024-05-13 14:18:26.977600] WDIAG [SQL.ENG] get_next_row_with_das (ob_table_scan_op.cpp:1764) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=4][errcode=-4016] get next row from das result failed(ret=-4016)
[2024-05-13 14:18:26.977604] WDIAG [SQL.ENG] inner_get_next_row_for_tsc (ob_table_scan_op.cpp:1951) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=3][errcode=-4016] fail to get next row from ObNewRowIterator(ret=-4016)
[2024-05-13 14:18:26.977608] WDIAG [SQL.ENG] inner_get_next_row_implement (ob_table_scan_op.cpp:1928) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=3][errcode=-4016] failed to get next row(ret=-4016)
[2024-05-13 14:18:26.977611] WDIAG [SQL.ENG] inner_get_next_row (ob_table_scan_op.cpp:2884) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=3][errcode=-4016] get next row failed(ret=-4016)
[2024-05-13 14:18:26.977615] WDIAG [SQL.ENG] get_next_row (ob_operator.cpp:1088) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=2][errcode=-4016] inner get next row failed(ret=-4016, type=3, op=“PHY_TABLE_SCAN”, op_id=0)
[2024-05-13 14:18:26.977622] WDIAG [SQL.EXE] get_next_row (ob_execute_result.cpp:136) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=5][errcode=-4016] get next row from operator failed(ret=-4016)
[2024-05-13 14:18:26.977625] WDIAG [SQL] inner_get_next_row (ob_result_set.cpp:403) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=2][errcode=-4016] get next row from exec result failed(ret=-4016)
[2024-05-13 14:18:26.977630] WDIAG [SERVER] response_query_result (ob_query_driver.cpp:301) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=4][errcode=-4016] fail to iterate and response(ret=-4016, row_num=0, can_retry=true)
[2024-05-13 14:18:26.977640] WDIAG [SERVER] response_result (ob_sync_plan_driver.cpp:101) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=3][errcode=-4016] response query result fail(ret=-4016)
[2024-05-13 14:18:26.977648] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:928) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=3][errcode=-4016] [RETRY] check if need retry(v={force_local_retry:false, stmt_retry_times:0, local_retry_times:0, err_:-4016, err_:“OB_ERR_UNEXPECTED”, retry_type:0, client_ret:-4016}, need_retry=false)
[2024-05-13 14:18:26.977655] WDIAG [SERVER] response_result (ob_sync_plan_driver.cpp:113) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=7][errcode=-4016] result response failed, check if need retry(ret=-4016, cli_ret=-4016, retry_ctrl_.need_retry()=0)
[2024-05-13 14:18:26.977700] WDIAG [SERVER] response_result (ob_sync_plan_driver.cpp:120) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=3][errcode=-4016] close result set fail(cret=-4016)
[2024-05-13 14:18:26.977710] INFO [SERVER] send_error_packet (obmp_packet_sender.cpp:315) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=3] sending error packet(ob_error=-4016, client error=-4016, extra_err_info=NULL, lbt()=“0x113aea2c 0x93d0112 0x937cad1 0x48b6b01 0x4897d5b 0x4891e7f 0x488849b 0x4883944 0x92a13b4 0x116659bf 0x7f7b1927e609 0x7f7b191a1353”)
[2024-05-13 14:18:26.977762] INFO [SERVER] send_error_packet (obmp_packet_sender.cpp:498) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=6] dump txn free route audit_record(value=1048581, session->get_sessid()=3221678571, session->get_proxy_sessid()=13882423607646421674)
[2024-05-13 14:18:26.977772] WDIAG [SERVER] do_process (obmp_query.cpp:808) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=2][errcode=-4016] execute query fail(ret=-4016, timeout_timestamp=1715581116947848)
[2024-05-13 14:18:26.977809] WDIAG [SQL.PC] common_free (ob_lib_cache_object_manager.cpp:141) [1882504][T1_L0_G0][T1][YB427F000001-00061655CDBCDEAE-0-0] [lt=4][errcode=0] set logical del time(cache_obj->get_logical_del_time()=5590834094777, cache_obj->added_lc()=false, cache_obj->get_object_id()=17751, cache_obj->get_tenant_id()=1, lbt()=“0x113aea2c 0x9b98d20 0x48a4df4 0x48a19dc 0x48997b8 0x4891e7f 0x488849b 0x4883944 0x92a13b4 0x116659bf 0x7f7b1927e609 0x7f7b191a1353”)
[2024-05-13 14:18:33.802579] INFO [RPC.OBMYSQL] destroy (obsm_conn_callback.cpp:243) [1882201][sql_nio12][T0][Y0-0000000000000000-0-0] [lt=13] connection close(sessid=3221678571, proxy_sessid=13882423607646421674, tenant_id=1, server_id=1, from_proxy=true, from_java_client=false, c/s protocol=“OB_2_0_CS_TYPE”, is_need_clear_sessid_=true, is_sess_alloc_=true, ret=0, trace_id=YB427F000001-00061655CDBCDEAE-0-0, conn.pkt_rec_wrapper_=[start_pkt_pos_:36, cur_pkt_pos_:39, pkt_rec[7]:{send:obp_compess_header_{com_len:370, com_seq:2}, obp20_header_:{payload_len:342, pkt_seq:2, req_id:3057806, flag_.flags:11, ext_flags:0}, obp_mysql_header_{len_:53, seq_:8}, pkt_name:“PKT_OKP”, obp_mysql_header_.is_send_:1}, pkt_rec[8]:{receive:obp20_header_:{payload_len:118, pkt_seq:0, req_id:3057807, flag_.flags:43, ext_flags:0}, obp_mysql_header_{len_:33, rec_:37, seq_:0}, obp_mysql_header_.type_:3, obp_mysql_header_.is_send_:0}, pkt_rec[9]:{send:obp_compess_header_{com_len:267, com_seq:1}, obp20_header_:{payload_len:239, pkt_seq:1, req_id:3057807, flag_.flags:11, ext_flags:0}, obp_mysql_header_{len_:49, seq_:2}, pkt_name:“PKT_RESHEAD”, obp_mysql_header_.is_send_:1}, pkt_rec[10]:{send:obp_compess_header_{com_len:267, com_seq:1}, obp20_header_:{payload_len:239, pkt_seq:1, req_id:3057807, flag_.flags:11, ext_flags:0}, obp_mysql_header_{pkt_num_:1, seq_:3}, pkt_name:“PKT_FIELD”, obp_mysql_header_.is_send_:1}, pkt_rec[11]:{send:obp_compess_header_{com_len:267, com_seq:1}, obp20_header_:{payload_len:239, pkt_seq:1, req_id:3057807, flag_.flags:11, ext_flags:0}, obp_mysql_header_{len_:9, seq_:4}, pkt_name:“PKT_EOF”, obp_mysql_header_.is_send_:1}, pkt_rec[12]:{send:obp_compess_header_{com_len:267, com_seq:1}, obp20_header_:{payload_len:239, pkt_seq:1, req_id:3057807, flag_.flags:11, ext_flags:0}, obp_mysql_header_{pkt_num_:1, seq_:5}, pkt_name:“PKT_ROW”, obp_mysql_header_.is_send_:1}, pkt_rec[13]:{send:obp_compess_header_{com_len:267, com_seq:1}, obp20_header_:{payload_len:239, pkt_seq:1, req_id:3057807, flag_.flags:11, ext_flags:0}, obp_mysql_header_{len_:9, seq_:6}, pkt_name:“PKT_EOF”, obp_mysql_header_.is_send_:1}, pkt_rec[14]:{send:obp_compess_header_{com_len:267, com_seq:1}, obp20_header_:{payload_len:239, pkt_seq:1, req_id:3057807, flag_.flags:11, ext_flags:0}, obp_mysql_header_{len_:12, seq_:7}, pkt_name:“PKT_OKP”, obp_mysql_header_.is_send_:1}, pkt_rec[15]:{receive:obp20_header_:{payload_len:9, pkt_seq:0, req_id:3057808, flag_.flags:42, ext_flags:0}, obp_mysql_header_{len_:5, rec_:9, seq_:0}, obp_mysql_header_.type_:3, obp_mysql_header_.is_send_:0}, pkt_rec[16]:{send:obp_compess_header_{com_len:345, com_seq:1}, obp20_header_:{payload_len:317, pkt_seq:1, req_id:3057808, flag_.flags:10, ext_flags:0}, obp_mysql_header_{len_:242, seq_:2}, pkt_name:“PKT_ERR”, obp_mysql_header_.is_send_:1}, pkt_rec[17]:{send:obp_compess_header_{com_len:345, com_seq:1}, obp20_header_:{payload_len:317, pkt_seq:1, req_id:3057808, flag_.flags:10, ext_flags:0}, obp_mysql_header_{len_:75, seq_:3}, pkt_name:“PKT_OKP”, obp_mysql_header_.is_send_:1}, pkt_rec[18]:{receive:obp20_header_:{payload_len:22, pkt_seq:0, req_id:3057809, flag_.flags:42, ext_flags:0}, obp_mysql_header_{len_:18, rec_:22, seq_:0}, obp_mysql_header_.type_:3, obp_mysql_header_.is_send_:0}, pkt_rec[19]:{send:obp_compess_header_{com_len:443, com_seq:1}, obp20_header_:{payload_len:415, pkt_seq:1, req_id:3057809, flag_.flags:11, ext_flags:0}, obp_mysql_header_{len_:335, seq_:2}, pkt_name:“PKT_RESHEAD”, obp_mysql_header_.is_send_:1}, pkt_rec[20]:{send:obp_compess_header_{com_len:443, com_seq:1}, obp20_header_:{payload_len:415, pkt_seq:1, req_id:3057809, flag_.flags:11, ext_flags:0}, obp_mysql_header_{pkt_num_:1, seq_:3}, pkt_name:“PKT_FIELD”, obp_mysql_header_.is_send_:1}, pkt_rec[21]:{send:obp_compess_header_{com_len:443, com_seq:1}, obp20_header_:{payload_len:415, pkt_seq:1, req_id:3057809, flag_.flags:11, ext_flags:0}, obp_mysql_header_{len_:9, seq_:4}, pkt_name:“PKT_EOF”, obp_mysql_header_.is_send_:1}, pkt_rec[22]:{send:obp_compess_header_{com_len:443, com_seq:1}, obp20_header_:{payload_len:415, pkt_seq:1, req_id:3057809, flag_.flags:11, ext_flags:0}, obp_mysql_header_{pkt_num_:1, seq_:5}, pkt_name:“PKT_ROW”, obp_mysql_header_.is_send_:1}, pkt_rec[23]:{send:obp_compess_header_{com_len:443, com_seq:1}, obp20_header_:{payload_len:415, pkt_seq:1, req_id:3057809, flag_.flags:11, ext_flags:0}, obp_mysql_header_{len_:9, seq_:6}, pkt_name:“PKT_EOF”, obp_mysql_header_.is_send_:1}, pkt_rec[24]:{send:obp_compess_header_{com_len:443, com_seq:1}, obp20_header_:{payload_len:415, pkt_seq:1, req_id:3057809, flag_.flags:11, ext_flags:0}, obp_mysql_header_{len_:12, seq_:7}, pkt_name:“PKT_OKP”, obp_mysql_header_.is_send_:1}, pkt_rec[25]:{send:obp20_header_:{payload_len:9, pkt_seq:0, req_id:3057810, flag_.flags:42, ext_flags:0}, obp_mysql_header_{len_:404, seq_:2}, pkt_name:“PKT_OKP”, obp_mysql_header_.is_send_:1}, pkt_rec[26]:{send:obp20_header_:{payload_len:48, pkt_seq:0, req_id:3057811, flag_.flags:42, ext_flags:0}, obp_mysql_header_{len_:12, seq_:2}, pkt_name:“PKT_OKP”, obp_mysql_header_.is_send_:1}, pkt_rec[27]:{send:obp20_header_:{payload_len:33, pkt_seq:0, req_id:3057812, flag_.flags:42, ext_flags:0}, obp_mysql_header_{len_:546, seq_:2}, pkt_name:“PKT_OKP”, obp_mysql_header_.is_send_:1}, pkt_rec[28]:{receive:obp20_header_:{payload_len:610, pkt_seq:0, req_id:3057813, flag_.flags:43, ext_flags:0}, obp_mysql_header_{len_:525, rec_:529, seq_:0}, obp_mysql_header_.type_:3, obp_mysql_header_.is_send_:0}, pkt_rec[29]:{send:obp_compess_header_{com_len:234, com_seq:1}, obp20_header_:{payload_len:206, pkt_seq:1, req_id:3057813, flag_.flags:9, ext_flags:0}, obp_mysql_header_{len_:49, seq_:2}, pkt_name:“PKT_RESHEAD”, obp_mysql_header_.is_send_:1}, pkt_rec[30]:{send:obp_compess_header_{com_len:234, com_seq:1}, obp20_header_:{payload_len:206, pkt_seq:1, req_id:3057813, flag_.flags:9, ext_flags:0}, obp_mysql_header_{pkt_num_:3, seq_:5}, pkt_name:“PKT_FIELD”, obp_mysql_header_.is_send_:1}, pkt_rec[31]:{send:obp_compess_header_{com_len:234, com_seq:1}, obp20_header_:{payload_len:206, pkt_seq:1, req_id:3057813, flag_.flags:9, ext_flags:0}, obp_mysql_header_{len_:9, seq_:6}, pkt_name:“PKT_EOF”, obp_mysql_header_.is_send_:1}, pkt_rec[32]:{send:obp_compess_header_{com_len:234, com_seq:1}, obp20_header_:{payload_len:206, pkt_seq:1, req_id:3057813, flag_.flags:9, ext_flags:0}, obp_mysql_header_{pkt_num_:6161, seq_:7}, pkt_name:“PKT_ROW”, obp_mysql_header_.is_send_:1}, pkt_rec[33]:{send:obp_compess_header_{com_len:459, com_seq:2}, obp20_header_:{payload_len:431, pkt_seq:2, req_id:3057813, flag_.flags:11, ext_flags:0}, obp_mysql_header_{len_:356, seq_:8}, pkt_name:“PKT_EOF”, obp_mysql_header_.is_send_:1}, pkt_rec[34]:{send:obp_compess_header_{com_len:459, com_seq:2}, obp20_header_:{payload_len:431, pkt_seq:2, req_id:3057813, flag_.flags:11, ext_flags:0}, obp_mysql_header_{len_:75, seq_:9}, pkt_name:“PKT_OKP”, obp_mysql_header_.is_send_:1}, pkt_rec[35]:{receive:obp20_header_:{payload_len:865, pkt_seq:0, req_id:3057814, flag_.flags:43, ext_flags:0}, obp_mysql_header_{len_:11, rec_:15, seq_:0}, obp_mysql_header_.type_:3, obp_mysql_header_.is_send_:0}, pkt_rec[36]:{send:obp_compess_header_{com_len:256, com_seq:1}, obp20_header_:{payload_len:228, pkt_seq:1, req_id:3057814, flag_.flags:11, ext_flags:0}, obp_mysql_header_{len_:153, seq_:2}, pkt_name:“PKT_ERR”, obp_mysql_header_.is_send_:1}, pkt_rec[37]:{send:obp_compess_header_{com_len:256, com_seq:1}, obp20_header_:{payload_len:228, pkt_seq:1, req_id:3057814, flag_.flags:11, ext_flags:0}, obp_mysql_header_{len_:75, seq_:3}, pkt_name:“PKT_OKP”, obp_mysql_header_.is_send_:1}, pkt_rec[38]:{receive:obp20_header_:{payload_len:86, pkt_seq:0, req_id:3057815, flag_.flags:43, ext_flags:0}, obp_mysql_header_{len_:1, rec_:5, seq_:0}, obp_mysql_header_.type_:1, obp_mysql_header_.is_send_:0}], disconnect_state=1)
上述是匹配的结果，请问还需要建表语句吗，查询语句上面就有

秃蛙 · 2024 年5 月 13 日 14:32

表结构和语句麻烦也提供下，本地需要尝试复现下。

jujuer · 2024 年5 月 14 日 10:36

可以直接参考社区文档的TPC-H测试，我是使用其中的建表文件create_tpch_mysql_table_part.ddl来创建的
DROP TABLE IF EXISTS lineitem;
DROP TABLE IF EXISTS orders;
DROP TABLE IF EXISTS partsupp;
DROP TABLE IF EXISTS part;
DROP TABLE IF EXISTS customer;
DROP TABLE IF EXISTS supplier;
DROP TABLE IF EXISTS nation;
DROP TABLE IF EXISTS region;
DROP TABLEGROUP IF EXISTS tpch_tg_lineitem_order_group;
DROP TABLEGROUP IF EXISTS tpch_tg_partsupp_part;

CREATE TABLEGROUP IF NOT EXISTS tpch_tg_lineitem_order_group binding true partition by key 1 partitions cpu_num;
CREATE TABLEGROUP IF NOT EXISTS tpch_tg_partsupp_part binding true partition by key 1 partitions cpu_num;

DROP TABLE IF EXISTS lineitem;
CREATE TABLE lineitem (
l_orderkey BIGINT NOT NULL,
l_partkey BIGINT NOT NULL,
l_suppkey INTEGER NOT NULL,
l_linenumber INTEGER NOT NULL,
l_quantity DECIMAL(15,2) NOT NULL,
l_extendedprice DECIMAL(15,2) NOT NULL,
l_discount DECIMAL(15,2) NOT NULL,
l_tax DECIMAL(15,2) NOT NULL,
l_returnflag char(1) DEFAULT NULL,
l_linestatus char(1) DEFAULT NULL,
l_shipdate date NOT NULL,
l_commitdate date DEFAULT NULL,
l_receiptdate date DEFAULT NULL,
l_shipinstruct char(25) DEFAULT NULL,
l_shipmode char(10) DEFAULT NULL,
l_comment varchar(44) DEFAULT NULL,
PRIMARY KEY(l_orderkey, l_linenumber))row_format = condensed
tablegroup = tpch_tg_lineitem_order_group
partition by key (l_orderkey) partitions cpu_num;

DROP TABLE IF EXISTS orders;
CREATE TABLE orders (
o_orderkey bigint not null,
o_custkey bigint not null,
o_orderstatus char(1) default null,
o_totalprice bigint default null,
o_orderdate date not null,
o_orderpriority char(15) default null,
o_clerk char(15) default null,
o_shippriority bigint default null,
o_comment varchar(79) default null,
PRIMARY KEY (o_orderkey))row_format = condensed
tablegroup = tpch_tg_lineitem_order_group
partition by key(o_orderkey) partitions cpu_num;

DROP TABLE IF EXISTS partsupp;
CREATE TABLE partsupp (
ps_partkey bigint not null,
ps_suppkey bigint not null,
ps_availqty bigint default null,
ps_supplycost bigint default null,
ps_comment varchar(199) default null,
PRIMARY KEY (ps_partkey, ps_suppkey))row_format = condensed
tablegroup tpch_tg_partsupp_part
partition by key(ps_partkey) partitions cpu_num;

DROP TABLE IF EXISTS part;
CREATE TABLE part (
p_partkey bigint not null,
p_name varchar(55) default null,
p_mfgr char(25) default null,
p_brand char(10) default null,
p_type varchar(25) default null,
p_size bigint default null,
p_container char(10) default null,
p_retailprice bigint default null,
p_comment varchar(23) default null,
PRIMARY KEY (p_partkey))row_format = condensed
tablegroup tpch_tg_partsupp_part
partition by key(p_partkey) partitions cpu_num;

DROP TABLE IF EXISTS customer;
CREATE TABLE customer (
c_custkey bigint not null,
c_name varchar(25) default null,
c_address varchar(40) default null,
c_nationkey bigint default null,
c_phone char(15) default null,
c_acctbal bigint default null,
c_mktsegment char(10) default null,
c_comment varchar(117) default null,
PRIMARY KEY (c_custkey))row_format = condensed
partition by key(c_custkey) partitions cpu_num;

DROP TABLE IF EXISTS supplier;
CREATE TABLE supplier (
s_suppkey bigint not null,
s_name char(25) default null,
s_address varchar(40) default null,
s_nationkey bigint default null,
s_phone char(15) default null,
s_acctbal bigint default null,
s_comment varchar(101) default null,
PRIMARY KEY (s_suppkey))row_format = condensed
partition by key(s_suppkey) partitions cpu_num;

DROP TABLE IF EXISTS nation;
CREATE TABLE nation (
n_nationkey bigint not null,
n_name char(25) default null,
n_regionkey bigint default null,
n_comment varchar(152) default null,
PRIMARY KEY (n_nationkey))row_format = condensed;

DROP TABLE IF EXISTS region;
CREATE TABLE region (
r_regionkey bigint not null,
r_name char(25) default null,
r_comment varchar(152) default null,
PRIMARY KEY (r_regionkey))row_format = condensed;

链接如下： OceanBase 数据库 TPC-H 测试-OceanBase 数据库-OceanBase文档中心-分布式数据库使用文档

秃蛙 · 2024 年5 月 16 日 16:52

测试暂未复现，内部先再尝试分析下。