drop table 报错 ERROR 4017 (HY000): Duplicate entry '741294-741294-1713929435347088' for key 'idx_task_key'

AntTech_S9A1W1 · 2024 年4 月 26 日 17:56

【使用环境】测试环境
【 OB or 其他组件】OB
【使用版本】4.1.0.0
【问题描述】drop table 时报错 ERROR 4017 (HY000): Duplicate entry ‘741294-741294-1713929435347088’ for key ‘idx_task_key’
【复现路径】通过Navicat或obclient执行drop table，报错ERROR 4017 (HY000): Duplicate entry ‘741294-741294-1713929435347088’ for key ‘idx_task_key’，长时间等待仍然报错
【附件及日志】

piping · 2024 年4 月 26 日 18:34

可以参考下这个帖子https://ask.oceanbase.com/t/topic/35604777

兹拉坦 · 2024 年4 月 28 日 10:15

版本是 4100 社区版吗？麻烦发下详细的版本号，例如这种：Server version: OceanBase_CE 4.2.3.0 (r1-568a095b071187f3d9fe6ff6539ede75976ad3bc)

麻烦发一下完整的复现方法？

例如：

create table xxx;

insert into xxx;

drop table xxx;
ERROR 4017 (HY000): Duplicate entry

报错之后，在同一个连接里紧接着执行下

select last_trace_id();
+------------------------------------+
| last_trace_id()                    |
+------------------------------------+
| Y584A0B9E1F14-000615B51A77CB36-0-0 |
+------------------------------------+
1 row in set (0.002 sec)

然后在 ob 的日志里 grep 一下这个 trace id，把相关的报错日志发上来

[xiaofeng.lby@obvos-dev-d3 /home/xiaofeng.lby/obn.obs0/log]
$grep Y584A0B9E1F14-000615B51A77CB36-0-0 *
observer.log.20240428101436811:[2024-04-28 10:10:32.478938] INFO  [STORAGE.TRANS] init_before_handle_request (ob_tx_free_route.cpp:92) [121910][T1002_L0_G0][T1002][Y584A0B9E1F14-000615B51A77CB36-0-0] [lt=8] [tx free route] after sync state and before handle request(tx=NULL, this={tx_id:{txid:0}, txn_addr:"0.0.0.0:0", is_proxy_support:false, in_txn_before_handle_request:false, can_free_route:false, is_fallbacked:false, static_changed:false, dynamic_changed:false, parts_changed:false, extra_changed:false, calculated:false, flag:{v:0}, local_version:3, global_version:0, global_version_water_mark:0, state_sync_infos:{[{last_backend_sess_id:0, last_version:0}, {last_backend_sess_id:0, last_version:0}, {last_backend_sess_id:0, last_version:0}, {last_backend_sess_id:0, last_version:0}, ]}, audit_record:0})
observer.log.20240428101436811:[2024-04-28 10:10:32.479006] INFO  [SQL] stmt_query (ob_sql.cpp:208) [121910][T1002_L0_G0][T1002][Y584A0B9E1F14-000615B51A77CB36-0-0] [lt=30] Begin to handle text statement(trunc_stmt=select @@version_comment limit 1, sess_id=3221703343, proxy_sess_id=0, tenant_id=1002, execution_id=161337971)
observer.log.20240428101436811:[2024-04-28 10:10:32.480735] WDIAG [COMMON] get_event_code (ob_tracepoint.h:263) [121910][T1002_L0_G0][T1002][Y584A0B9E1F14-000615B51A77CB36-0-0] [lt=11][errcode=-5434] [ERRSIM] sim error(event_code=-5434)
observer.log.20240428101436811:[2024-04-28 10:10:32.480789] WDIAG [COMMON] get_event_code (ob_tracepoint.h:263) [121910][T1002_L0_G0][T1002][Y584A0B9E1F14-000615B51A77CB36-0-0] [lt=19][errcode=-5434] [ERRSIM] sim error(event_code=-5434)
observer.log.20240428101436811:[2024-04-28 10:10:32.481099] INFO  [SQL.EXE] implicit_end_trans (ob_sql_trans_control.cpp:206) [121910][T1002_L0_G0][T1002][Y584A0B9E1F14-000615B51A77CB36-0-0] [lt=8] implicit end trans(is_rollback=false, exec_ctx.get_execution_id()=18446744073709551615, callback=NULL)
observer.log.20240428101436811:[2024-04-28 10:10:32.481122] INFO  [SQL.EXE] end_trans (ob_sql_trans_control.cpp:270) [121910][T1002_L0_G0][T1002][Y584A0B9E1F14-000615B51A77CB36-0-0] [lt=22] end_trans(session->is_in_transaction()=false, session->has_explicit_start_trans()=false, exec_ctx.get_execution_id()=18446744073709551615, callback=NULL)

AntTech_S9A1W1 · 2024 年4 月 28 日 11:30

开发告知某个表无法删除，发了一个Navicat截图，我通过obclient登录，执行drop table 报错，我重新建表，插入数据，再drop，可以正常执行。

版本 5.7.25-OceanBase_CE-v4.1.0.0

这是报错日志，谢谢
observer.log:[2024-04-28 11:23:50.375327] WDIAG [RPC.OBRPC] rpc_call (ob_rpc_proxy.ipp:453) [83380][T1_L0_G0][T1][YB420A0A1625-000616F6D7CE8C2A-0-0] [lt=16][errcode=-4017] execute rpc fail(ret=-4017, dst=“10.10.22.38:2882”)
observer.log:[2024-04-28 11:23:50.375345] WDIAG log_user_error_and_warn (ob_rpc_proxy.cpp:252) [83380][T1_L0_G0][T1][YB420A0A1625-000616F6D7CE8C2A-0-0] [lt=17][errcode=-4017] Duplicate entry ‘741294-741294-1713929435347088’ for key ‘idx_task_key’
observer.log:[2024-04-28 11:23:50.375365] WDIAG [SQL.ENG] execute (ob_table_executor.cpp:1617) [83380][T1_L0_G0][T1][YB420A0A1625-000616F6D7CE8C2A-0-0] [lt=6][errcode=-4017] rpc proxy drop table failed(ret=-4017, dst=“10.10.22.38:2882”)
observer.log:[2024-04-28 11:23:50.375414] INFO [SHARE] add_event (ob_event_history_table_operator.h:268) [83380][T1_L0_G0][T1][YB420A0A1625-000616F6D7CE8C2A-0-0] [lt=10] event table add task(ret=0, event_table_name="_all_server_event_history", sql=INSERT INTO all_server_event_history (gmt_create, module, event, name1, value1, name2, value2, name3, value3, svr_ip, svr_port) VALUES (usec_to_time(1714274630375376), ‘sql’, ‘execute_cmd’, ‘cmd_type’, 21, ‘sql_text’, X’64726F70207461626C6520656E646F7273656D656E745F696E73757265645F6F626A6563745F6368616E67655F696E666F’, ‘return_code’, -4017, ‘10.10.22.37’, 2882))
observer.log:[2024-04-28 11:23:50.375431] WDIAG [SQL] open_cmd (ob_result_set.cpp:98) [83380][T1_L0_G0][T1][YB420A0A1625-000616F6D7CE8C2A-0-0] [lt=13][errcode=-4017] execute cmd failed(ret=-4017)
observer.log:[2024-04-28 11:23:50.375439] WDIAG [SQL] open (ob_result_set.cpp:157) [83380][T1_L0_G0][T1][YB420A0A1625-000616F6D7CE8C2A-0-0] [lt=7][errcode=-4017] execute plan failed(ret=-4017)
observer.log:[2024-04-28 11:23:50.375449] WDIAG [SERVER] response_result (ob_sync_cmd_driver.cpp:126) [83380][T1_L0_G0][T1][YB420A0A1625-000616F6D7CE8C2A-0-0] [lt=5][errcode=-4017] close result set fail(cret=-4017)
observer.log:[2024-04-28 11:23:50.375455] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:868) [83380][T1_L0_G0][T1][YB420A0A1625-000616F6D7CE8C2A-0-0] [lt=4][errcode=-4017] [RETRY] check if need retry(v={force_local_retry:false, stmt_retry_times:0, local_retry_times:0, err:-4017, err:“OB_ENTRY_EXIST”, retry_type:0, client_ret:-4017}, need_retry=false)
observer.log:[2024-04-28 11:23:50.375469] WDIAG [SERVER] response_result (ob_sync_cmd_driver.cpp:132) [83380][T1_L0_G0][T1][YB420A0A1625-000616F6D7CE8C2A-0-0] [lt=13][errcode=-4017] result set open failed, check if need retry(ret=-4017, cli_ret=-4017, retry_ctrl.need_retry()=0)
observer.log:[2024-04-28 11:23:50.375497] INFO [SERVER] send_error_packet (obmp_packet_sender.cpp:311) [83380][T1_L0_G0][T1][YB420A0A1625-000616F6D7CE8C2A-0-0] [lt=6] sending error packet(err=-4017, extra_err_info=NULL, lbt()=“0xd9f6cf5 0x75d3e81 0x7596e3a 0x3bf2bd3 0x39f42c7 0x39eb654 0x39e75aa 0x39e56db 0x39e14dc 0x6339f84 0xdc6a1a7 0xdc6402a 0x7f9a5c216ea5 0x7f9a5bf3fb0d”)
observer.log:[2024-04-28 11:23:50.375543] INFO [SERVER] send_error_packet (obmp_packet_sender.cpp:472) [83380][T1_L0_G0][T1][YB420A0A1625-000616F6D7CE8C2A-0-0] [lt=11] dump txn free route audit_record(value=5, session->get_sessid()=3221736957, session->get_proxy_sessid()=723415038504928277)
observer.log:[2024-04-28 11:23:50.375553] WDIAG [SERVER] do_process (obmp_query.cpp:840) [83380][T1_L0_G0][T1][YB420A0A1625-000616F6D7CE8C2A-0-0] [lt=7][errcode=-4017] execute query fail(ret=-4017, timeout_timestamp=1714275630314755)

兹拉坦 · 2024 年4 月 28 日 14:11

日志没搜全，用这个 YB420A0A1625-000616F6D7CE8C2A-0-0 trace id 去 10.10.22.38:2882 这台节点上搜下 rootservice 打头的日志~

问题如果无法复现的话，麻烦发下 show create table 看到的表结构？

AntTech_S9A1W1 · 2024 年4 月 30 日 10:24

这是DDL和重新执行命令，触发错误生成的日志，其他节点搜不到相关报错，请您帮忙看看，谢谢啦
obclient [insure]> show create table endorsement_insured_object_change_info\G
*************************** 1. row ***************************
Table: endorsement_insured_object_change_info
Create Table: CREATE TABLE endorsement_insured_object_change_info (
insured_object_code varchar(100) DEFAULT NULL COMMENT ‘保险标的代码’,
product_code varchar(100) DEFAULT NULL COMMENT ‘险种分类’,
clause_code varchar(100) DEFAULT NULL COMMENT ‘条款代码’,
main_coverage varchar(100) DEFAULT NULL COMMENT ‘主附险性质’,
object_number_chg_amount double(15,4) DEFAULT NULL COMMENT ‘承保数量变化量’
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = ‘zstd_1.3.8’ REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 COMMENT = ‘批单标的变化信息’

[root@test-oceanbase-cluster01 log]# grep YB420A0A1625-000616F6F896E2A4-0-0 *
observer.log:[2024-04-30 09:55:05.213321] WDIAG [RPC.OBRPC] rpc_call (ob_rpc_proxy.ipp:453) [91701][T1_L0_G0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=26][errcode=-4017] execute rpc fail(ret=-4017, dst=“10.10.22.37:2882”)
observer.log:[2024-04-30 09:55:05.213340] WDIAG log_user_error_and_warn (ob_rpc_proxy.cpp:252) [91701][T1_L0_G0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=16][errcode=-4017] Duplicate entry ‘741294-741294-1713929435347088’ for key ‘idx_task_key’
observer.log:[2024-04-30 09:55:05.213352] WDIAG [SQL.ENG] execute (ob_table_executor.cpp:1617) [91701][T1_L0_G0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=5][errcode=-4017] rpc proxy drop table failed(ret=-4017, dst=“10.10.22.37:2882”)
observer.log:[2024-04-30 09:55:05.213420] INFO [SHARE] add_event (ob_event_history_table_operator.h:268) [91701][T1_L0_G0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=10] event table add task(ret=0, event_table_name="__all_server_event_history", sql=INSERT INTO _all_server_event_history (gmt_create, module, event, name1, value1, name2, value2, name3, value3, svr_ip, svr_port) VALUES (usec_to_time(1714442105213372), ‘sql’, ‘execute_cmd’, ‘cmd_type’, 21, ‘sql_text’, X’64726F70207461626C6520656E646F7273656D656E745F696E73757265645F6F626A6563745F6368616E67655F696E666F’, ‘return_code’, -4017, ‘10.10.22.37’, 2882))
observer.log:[2024-04-30 09:55:05.213437] WDIAG [SQL] open_cmd (ob_result_set.cpp:98) [91701][T1_L0_G0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=12][errcode=-4017] execute cmd failed(ret=-4017)
…
observer.log:[2024-04-30 09:55:05.213474] WDIAG [SERVER] response_result (ob_sync_cmd_driver.cpp:132) [91701][T1_L0_G0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=13][errcode=-4017] result set open failed, check if need retry(ret=-4017, cli_ret=-4017, retry_ctrl.need_retry()=0)
…
rootservice.log:[2024-04-30 09:55:05.142890] INFO [SHARE.SCHEMA] retrieve_table_schema (ob_schema_retrieve_utils.ipp:297) [111498][DDLQueueTh0][T0][YB420A0A1625-000616F6F896E2A4-0-0] [lt=20] retrieve table schema succeed(*table_schema={simple_table_schema:{tenant_id:1, database_id:720560, tablegroup_id:18446744073709551615, table_id:741294, association_table_id:741295, in_offline_ddl_white_list:false, table_name:“endorsement_insured_object_change_info”, session_id:0, index_type:0, table_type:3, table_mode:{table_mode_flag:0, pk_mode:2, table_state_flag:1, view_created_method_flag:0, table_organization_mode:1, auto_increment_mode:0, rowid_mode:0, view_column_filled_flag:0}, tablespace_id:18446744073709551615, data_table_id:0, name_casemode:-1, schema_version:1713929435347088, part_level:0, part_option:{part_func_type:0, part_func_expr:"", part_num:1, auto_part:false, auto_part_size:0}, sub_part_option:{part_func_type:0, part_func_expr:"", part_num:0, auto_part:false, auto_part_size:0}, partition_num:0, def_subpartition_num:0, partition_array:null, def_subpartition_array:null, hidden_partition_array:null, index_status:1, duplicate_scope:0, encryption:"", encrypt_key:"", master_key_id:18446744073709551615, sub_part_template_flags:0, get_tablet_id():{id:306472}, max_dependency_version:-1, object_status:1, is_force_view:false, truncate_version:-1}, max_used_column_id:20, sess_active_time:0, rowkey_column_num:1, index_column_num:0, rowkey_split_pos:0, block_size:16384, is_use_bloomfilter:false, progressive_merge_num:0, tablet_size:134217728, pctfree:0, load_type:0, index_using_type:0, def_type:1, charset_type:2, collation_type:45, index_status:1, partition_status:0, code_version:1, comment:“批单标的变化信息”, pk_comment:"", create_host:"", tablegroup_name:"", compressor_type:6, row_store_type:1, store_format:3, expire_info:"", view_schema:{view_definition:"", check_option:“none”, is_updatable:“false”, is_materialized:“false”, character_set_client:0, collation_connection:“invalid_type”}, autoinc_column_id:0, auto_increment:1, read_only:false, simple_index_infos:[], mv_tid_array:null, base_table_ids:[], rowkey_info:{columns:null, capacity:0}, partition_key_info:{columns:null, capacity:0}, column_cnt:0, table_dop:1, constraints:null, column_array:null, aux_vp_tid_array:[], define_user_id:200001, aux_lob_meta_tid:18446744073709551615, aux_lob_piece_tid:18446744073709551615}, is_deleted=false)
rootservice.log:[2024-04-30 09:55:05.164173] [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] {“trace_id”:“00061746-a8aa-16ce-495a-5980a2d823c7”,“name”:“sql_compile”,“id”:“00061745-33f6-099c-9212-9b50df9df476”,“start_ts”:1714435852208540,“end_ts”:1714435852208569,“parent_id”:“00061745-33f6-097b-f3fe-191c724057ed”,“is_follow”:false,“tags”:[{“sql_id”:“7222544C4715703B717FAFF8E69B4480”},{“database_id”:201001},{“plan_hash”:15514170908265371714},{“hit_plan”:true},{“sql_text”:“SELECT MAX(schema_version) as version, host_ip() as myip, rpc_port() as myport FROM __all_ddl_operation”}]}
rootservice.log:[2024-04-30 09:55:05.164239] [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] {“trace_id”:“00061746-a8aa-16ce-495a-5980a2d823c7”,“name”:“sql_compile”,“id”:“00061744-f859-581a-f832-eb3a2b57427c”,“start_ts”:1714434852083738,“end_ts”:1714434852083761,“parent_id”:“00061744-f859-580b-9975-83a74bd9cc6d”,“is_follow”:false,“tags”:[{“sql_id”:“7222544C4715703B717FAFF8E69B4480”},{“database_id”:201001},{“plan_hash”:15514170908265371714},{“hit_plan”:true},{“sql_text”:“SELECT MAX(schema_version) as version, host_ip() as myip, rpc_port() as myport FROM __all_ddl_operation”}]}
…

rootservice.log:[2024-04-30 09:55:05.164267] [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] {“trace_id”:“00061746-a8aa-16ce-495a-5980a2d823c7”,“name”:“sql_compile”,“id”:“00061744-f859-55b5-4487-fa8da67fc6fd”,“start_ts”:1714434852083125,“end_ts”:1714434852083149,“parent_id”:“00061744-f859-55a8-d5d3-3a0119150094”,“is_follow”:false,“tags”:[{“sql_id”:“7222544C4715703B717FAFF8E69B4480”},{“database_id”:201001},{“plan_hash”:15514170908265371714},{“hit_plan”:true},{“sql_text”:“SELECT MAX(schema_version) as version, host_ip() as myip, rpc_port() as myport FROM __all_ddl_operation”}]}
…
{“trace_id”:“00061746-a8aa-16ce-495a-5980a2d823c7”,“name”:“sql_compile”,“id”:“00061744-f859-5377-ebe1-2c8b9664bc46”,“start_ts”:1714434852082551,“end_ts”:1714434852082576,“parent_id”:“00061744-f859-536a-918b-d8d6597f515c”,“is_follow”:false,“tags”:[{“sql_id”:“7222544C4715703B717FAFF8E69B4480”},{“database_id”:201001},{“plan_hash”:15514170908265371714},{“hit_plan”:true},{“sql_text”:“SELECT MAX(schema_version) as version, host_ip() as myip, rpc_port() as myport FROM __all_ddl_operation”}]}
…

rootservice.log:[2024-04-30 09:55:05.164343] [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] {“trace_id”:“00061746-a8aa-16ce-495a-5980a2d823c7”,“name”:“sql_compile”,“id”:“00061744-f859-50fb-981e-f8557fc92428”,“start_ts”:1714434852081915,“end_ts”:1714434852081948,“parent_id”:“00061744-f859-50ef-b611-ccb6f4bd47fb”,“is_follow”:false,“tags”:[{“sql_id”:“7222544C4715703B717FAFF8E69B4480”},{“database_id”:201001},{“plan_hash”:15514170908265371714},{“hit_plan”:true},{“sql_text”:"SELECT MAX(schema_version) as version, host_ip() as myip, rpc_port() as myport FROM all_ddl_operation"}]}
…
{“trace_id”:“00061746-a8aa-16ce-495a-5980a2d823c7”,“name”:“sql_compile”,“id”:“00061744-f859-4e31-0847-14b59f533af9”,“start_ts”:1714434852081201,“end_ts”:1714434852081226,“parent_id”:“00061744-f859-4e20-5258-bf1ee35ed64f”,“is_follow”:false,“tags”:[{“sql_id”:“7222544C4715703B717FAFF8E69B4480”},{“database_id”:201001},{“plan_hash”:15514170908265371714},{“hit_plan”:true},{“sql_text”:"SELECT MAX(schema_version) as version, host_ip() as myip, rpc_port() as myport FROM all_ddl_operation"}]}
rootservice.log:[2024-04-30 09:55:05.164396] [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] {“trace_id”:“00061746-a8aa-16ce-495a-5980a2d823c7”,“name”:“inner_execute_read”,“id”:“00061744-f859-4e20-5258-bf1ee35ed64f”,“start_ts”:1714434852081184,“end_ts”:1714434852081332,“parent_id”:“00061746-a8aa-187a-d53f-1173a117821f”,“is_follow”:false}
rootservice.log:[2024-04-30 09:55:05.168281] INFO [SHARE.SCHEMA] get_table_schema (ob_schema_service_sql_impl.cpp:5202) [111498][DDLQueueTh0][T0][YB420A0A1625-000616F6F896E2A4-0-0] [lt=15] get not core table schema succeed(schema_status={tenant_id:1, snapshot_timestamp:-1, readable_schema_version:-1}, table_id=741294, table_schema->get_table_name_str()=endorsement_insured_object_change_info)
rootservice.log:[2024-04-30 09:55:05.168376] INFO [RS] create_ddl_task (ob_ddl_scheduler.cpp:643) [111498][DDLQueueTh0][T0][YB420A0A1625-000616F6F896E2A4-0-0] [lt=50] create ddl task(param={tenant_id:1, object_id:741294, schema_version:1713929435347088, parallelism:0, parent_task_id:0, type:502, src_table_schema:NULL, dest_table_schema:NULL, ddl_arg:{ddl_stmt_str:“drop table endorsement_insured_object_change_info”, exec_tenant_id:1, ddl_id_str:"", sync_from_primary:false, based_schema_object_infos:[], parallelism:0, task_id:0}})
rootservice.log:[2024-04-30 09:55:05.169272] INFO [DETECT] maintain_deadlock_info_when_end_stmt (ob_trans_deadlock_adapter.cpp:644) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=23] inner session no need register to deadlock(step=2, ret=0, ret=“OB_SUCCESS”, exec_ctx.get_errcode()=-4008, exec_ctx.get_errcode()=“OB_ITER_END”, session={this:0x7f979c3180d8, id:1, tenant:“sys”, tenant_id:1, effective_tenant:“sys”, effective_tenant_id:1, database:“oceanbase”, user:“root@%”, consistency_level:3, session_state:0, autocommit:true, tx:0x7f98368ad0f0}, desc=NULL, is_rollback=false, conflict_txs=[])
rootservice.log:[2024-04-30 09:55:05.169333] INFO [DETECT] maintain_deadlock_info_when_end_stmt (ob_trans_deadlock_adapter.cpp:679) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=61] maintain deadlock info(step=2, ret=0, ret=“OB_SUCCESS”, exec_ctx.get_errcode()=-4008, exec_ctx.get_errcode()=“OB_ITER_END”, session={this:0x7f979c3180d8, id:1, tenant:“sys”, tenant_id:1, effective_tenant:“sys”, effective_tenant_id:1, database:“oceanbase”, user:“root@%”, consistency_level:3, session_state:0, autocommit:true, tx:0x7f98368ad0f0}, desc=NULL, is_rollback=false, conflict_txs=[])
rootservice.log:[2024-04-30 09:55:05.169359] INFO [SHARE] fetch_new_max_id (ob_max_id_fetcher.cpp:263) [111498][DDLQueueTh0][T0][YB420A0A1625-000616F6F896E2A4-0-0] [lt=11] fetch_new_max_id(ret=0, ret=“OB_SUCCESS”, size=1, tenant_id=1, fetch_id=7349, max_id_type=5, fetch_max_id_type=5, id=18446744073709551615, initial=1)
rootservice.log:[2024-04-30 09:55:05.171032] INFO [SQL.JO] init_est_sel_info_for_access_path (ob_join_order.cpp:10722) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=23] total rowcount, use statistics(table_meta_info.table_row_count=14, table_meta_info.average_row_size=1.850000000000000000e+02, table_meta_info_.micro_block_count_=1, table_meta_info_.part_size_=2.590000000000000000e+03)
rootservice.log:[2024-04-30 09:55:05.180886] INFO [DETECT] maintain_deadlock_info_when_end_stmt (ob_trans_deadlock_adapter.cpp:644) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=26] inner session no need register to deadlock(step=2, ret=0, ret=“OB_SUCCESS”, exec_ctx.get_errcode()=0, exec_ctx.get_errcode()=“OB_SUCCESS”, session={this:0x7f979c3180d8, id:1, tenant:“sys”, tenant_id:1, effective_tenant:“sys”, effective_tenant_id:1, database:“oceanbase”, user:“root@%”, consistency_level:3, session_state:0, autocommit:true, tx:0x7f98368ad0f0}, desc=NULL, is_rollback=false, conflict_txs=[])
rootservice.log:[2024-04-30 09:55:05.180919] INFO [SERVER] execute_write_inner (ob_inner_sql_connection.cpp:1915) [111498][DDLQueueTh0][T0][YB420A0A1625-000616F6F896E2A4-0-0] [lt=31] execute write sql(ret=0, tenant_id=1, affected_rows=1, sql=UPDATE all_sys_stat SET VALUE = ‘7350’, gmt_modified = now(6) WHERE ZONE = ‘’ AND NAME = ‘ob_max_used_ddl_task_id’ AND TENANT_ID = 0)
rootservice.log:[2024-04-30 09:55:05.185821] INFO [STORAGE] add_memtable (ob_i_memtable_mgr.cpp:353) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=8] succeed to add memtable(get_memtable_count()=1, memtable_handle={table:0x7f95a92ecd20, t3m_:0x7f99fe7e2030, allocator_:null, table_type_:0}, lbt()=“0xd9f6cf5 0xaa9c9de 0xaa9c534 0xb6ff1aa 0xb6901c4 0xb6b43a2 0xaba9477 0x3b119bd 0x3b99aba 0x3b96146 0x3b94fc9 0x3b94d2c 0x3b94880 0x3a2cf08 0x3be2f14 0x3a2c4c5 0x3a2aff4 0x3b66514 0x922f35f 0x3b65065 0x39f8966 0x3a3bf72 0x3d00123 0x3cff573 0x3cfe08c 0x3d93f01 0x5c42d19 0x5c42a3d 0x3d3b896 0x6dadac5 0x6da9ca7 0x6d57f60 0x6ed183f 0x60a89b0 0x3cae476 0xe535cef 0xe536ba1 0x3d99a09 0xdc671e7 0xdc6402a 0x7f9a5c216ea5 0x7f9a5bf3fb0d”)
rootservice.log:[2024-04-30 09:55:05.185852] INFO [STORAGE] create_memtable (ob_tablet_memtable_mgr.cpp:289) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=30] succeed to create memtable(ret=0, ls_id={id:1}, memtable={ObITable:{this:0x7f95a92ecd20, key:{tablet_id:{id:319}, column_group_idx:0, table_type:“MEMTABLE”, scn_range:{start_scn:{val:1714377220827103609}, end_scn:{val:4611686018427387903}}}, ref_cnt:2, upper_trans_version:9223372036854775807, timestamp:1714442105185805}, this:0x7f95a92ecd20, timestamp:1714442105185805, state:0, freeze_clock:12, max_schema_version:0, write_ref_cnt:0, local_allocator:{ListHandle:{freeze_stat:0, id:-1, clock:9223372036854775807}, host:0x7f99489ec380, arena_handle:{allocated:0}, last_freeze_timestamp:1714098786169177}, unsubmitted_cnt:0, unsynced_cnt:0, logging_blocked:false, unset_active_memtable_logging_blocked:false, resolve_active_memtable_left_boundary:true, contain_hotspot_row:false, max_end_scn:{val:0}, rec_scn:{val:4611686018427387903}, snapshot_version:{val:4611686018427387903}, migration_clog_checkpoint_scn:{val:0}, is_tablet_freeze:false, is_force_freeze:false, contain_hotspot_row:false, read_barrier:false, is_flushed:false, freeze_state:0, mt_stat_.frozen_time:0, mt_stat_.ready_for_flush_time:0, mt_stat_.create_flush_dag_time:0, mt_stat_.release_time:0, mt_stat_.last_print_time:0})
rootservice.log:[2024-04-30 09:55:05.185891] INFO [STORAGE] inner_create_memtable (ob_tablet.cpp:1903) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=37] succeeded to create memtable for tablet(ret=0, tablet_meta_={version:1, ls_id:{id:1}, tablet_id:{id:319}, data_tablet_id:{id:319}, ref_tablet_id:{id:0}, create_scn:{val:1680595864456689940}, start_scn:{val:1714276484560361310}, clog_checkpoint_scn:{val:1714377220827103609}, ddl_checkpoint_scn:{val:0}, snapshot_version:1714377220827103609, multi_version_start:1714327206203018205, autoinc_seq:{intervals:[]}, compat_mode:0, ha_status:{restore_status:0, data_status:0, expected_status:0, reserved:0}, report_status:{merge_snapshot_version:1714327206203018205, cur_report_version:1714327206203018205, data_checksum:3168009119, row_count:8}, tx_data:{version:1, length:24, tx_id:{txid:0}, tx_scn:{val:1680595864545142663}, tablet_status:{status:1}, is_tx_end:false, unsynced_cnt_for_multi_data:0}, ddl_data:{redefined:false, snapshot_version:-1, schema_version:-1, data_tablet_id:{id:0}, hidden_tablet_ids:[], lob_meta_tablet_id:{id:50319}, lob_piece_tablet_id:{id:60319}, is_tx_end:false, unsynced_cnt_for_multi_data:0}, table_store_flag:{with_major_sstable:1}, ddl_start_scn:{val:0}, ddl_snapshot_version:0, max_sync_storage_schema_version:1680595867371272, max_serialized_medium_scn:1714327206203018205, ddl_execution_id:-1, ddl_data_format_version:0, ddl_commit_scn:{val:0}}, tablet_id={id:319}, clog_checkpoint_scn={val:1714377220827103609}, schema_version=0)

AntTech_S9A1W1 · 2024 年4 月 30 日 10:25

rootservice.log:[2024-04-30 09:55:05.186034] INFO [STORAGE] add_memtable_ (ob_i_memtable_mgr.cpp:353) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=40] succeed to add memtable(get_memtable_count_()=1, memtable_handle={table:0x7f95a92f0ba0, t3m_:0x7f99fe7e2030, allocator_:null, table_type_:0}, lbt()=“0xd9f6cf5 0xaa9c9de 0xaa9c534 0xb6ff1aa 0xb6901c4 0xb6b43a2 0xaba9477 0x3b119bd 0x3b99aba 0x3b96146 0x3b94fc9 0x3b94d2c 0x3b9499c 0x3a2cf08 0x3be2f14 0x3a2c4c5 0x3a2aff4 0x3b66514 0x922f35f 0x3b65065 0x39f8966 0x3a3bf72 0x3d00123 0x3cff573 0x3cfe08c 0x3d93f01 0x5c42d19 0x5c42a3d 0x3d3b896 0x6dadac5 0x6da9ca7 0x6d57f60 0x6ed183f 0x60a89b0 0x3cae476 0xe535cef 0xe536ba1 0x3d99a09 0xdc671e7 0xdc6402a 0x7f9a5c216ea5 0x7f9a5bf3fb0d”)
rootservice.log:[2024-04-30 09:55:05.186049] INFO [STORAGE] create_memtable (ob_tablet_memtable_mgr.cpp:289) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=15] succeed to create memtable(ret=0, ls_id={id:1}, memtable={ObITable:{this:0x7f95a92f0ba0, key:{tablet_id:{id:101004}, column_group_idx:0, table_type:“MEMTABLE”, scn_range:{start_scn:{val:1714331776702853575}, end_scn:{val:4611686018427387903}}}, ref_cnt:2, upper_trans_version:9223372036854775807, timestamp:1714442105186024}, this:0x7f95a92f0ba0, timestamp:1714442105186024, state:0, freeze_clock:12, max_schema_version:0, write_ref_cnt:0, local_allocator:{ListHandle:{freeze_stat:0, id:-1, clock:9223372036854775807}, host:0x7f99489ec380, arena_handle:{allocated:0}, last_freeze_timestamp:1714098786169177}, unsubmitted_cnt:0, unsynced_cnt:0, logging_blocked:false, unset_active_memtable_logging_blocked:false, resolve_active_memtable_left_boundary:true, contain_hotspot_row:false, max_end_scn:{val:0}, rec_scn:{val:4611686018427387903}, snapshot_version:{val:4611686018427387903}, migration_clog_checkpoint_scn:{val:0}, is_tablet_freeze:false, is_force_freeze:false, contain_hotspot_row:false, read_barrier:false, is_flushed:false, freeze_state:0, mt_stat_.frozen_time:0, mt_stat_.ready_for_flush_time:0, mt_stat_.create_flush_dag_time:0, mt_stat_.release_time:0, mt_stat_.last_print_time:0})
rootservice.log:[2024-04-30 09:55:05.186076] INFO [STORAGE] inner_create_memtable (ob_tablet.cpp:1903) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=26] succeeded to create memtable for tablet(ret=0, tablet_meta_={version:1, ls_id:{id:1}, tablet_id:{id:101004}, data_tablet_id:{id:319}, ref_tablet_id:{id:0}, create_scn:{val:1680595864456689940}, start_scn:{val:1714276484560361310}, clog_checkpoint_scn:{val:1714331776702853575}, ddl_checkpoint_scn:{val:0}, snapshot_version:1714331776702853571, multi_version_start:1714327206203018205, autoinc_seq:{intervals:[]}, compat_mode:0, ha_status:{restore_status:0, data_status:0, expected_status:0, reserved:0}, report_status:{merge_snapshot_version:1714327206203018205, cur_report_version:1714327206203018205, data_checksum:856340389, row_count:8}, tx_data:{version:1, length:24, tx_id:{txid:0}, tx_scn:{val:1680595864545142663}, tablet_status:{status:1}, is_tx_end:false, unsynced_cnt_for_multi_data:0}, ddl_data:{redefined:false, snapshot_version:-1, schema_version:-1, data_tablet_id:{id:0}, hidden_tablet_ids:[], lob_meta_tablet_id:{id:0}, lob_piece_tablet_id:{id:0}, is_tx_end:false, unsynced_cnt_for_multi_data:0}, table_store_flag:{with_major_sstable:1}, ddl_start_scn:{val:0}, ddl_snapshot_version:0, max_sync_storage_schema_version:1680595867367456, max_serialized_medium_scn:1714327206203018205, ddl_execution_id:-1, ddl_data_format_version:0, ddl_commit_scn:{val:0}}, tablet_id={id:101004}, clog_checkpoint_scn={val:1714331776702853575}, schema_version=0)
rootservice.log:[2024-04-30 09:55:05.211422] WDIAG [STORAGE] insert_tablet_rows (ob_ls_tablet_service.cpp:3711) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=30][errcode=-5024] rowkeys already exist(ret=-5024, table={allow_not_ready:false, tablet_id:{id:101004}, schema_param:{table_id:101004, schema_version:1680595867367456, table_type:5, index_type:2, index_status:2, shadow_rowkey_column_num:1, fulltext_col_id:18446744073709551615, index_name:“idx_task_key”, pk_name:"", columns:[{column_id:21, 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}, {column_id:20, 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}, {column_id:23, 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}, {column_id:32785, 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:true, is_nullable_for_read:true, is_gen_col:false, is_virtual_gen_col:false, is_gen_col_udf_expr:false, is_hidden:true}, {column_id:18, 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}], read_info:{schema_column_count:5, schema_rowkey_cnt:4, rowkey_cnt:6, trans_col_index:-1, seq_read_column_count:4, max_col_index:6, is_oracle_mode:false, cols_index:[0, 1, 2, 3, 6], memtable_cols_index:[0, 1, 2, 3, 4], cols_desc:[column_id=21 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=20 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=23 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=32785 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=18 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0], datum_utils:{is_oracle_mode:false, rowkey_cnt:6, col_cnt:7, allocator:0x7f9865792530, is_inited:true}, cols_param:[{column_id:21, 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}, {column_id:20, 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}, {column_id:23, 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}, {column_id:32785, 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:true, is_nullable_for_read:true, is_gen_col:false, is_virtual_gen_col:false, is_gen_col_udf_expr:false, is_hidden:true}, {column_id:18, 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}], index_read_info:{schema_column_count:5, schema_rowkey_cnt:4, rowkey_cnt:6, trans_col_index:4, seq_read_column_count:7, max_col_index:6, is_oracle_mode:false, cols_index:[0, 1, 2, 3, 4, 5, 6], memtable_cols_index:[0, 1, 2, 3, -1, -1, 4], cols_desc:[column_id=21 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=20 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=23 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=32785 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=7 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=8 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=22 {type:“VARCHAR”, collation:“binary”, coercibility:“INVALID”} order=0], datum_utils:{is_oracle_mode:false, rowkey_cnt:6, col_cnt:7, allocator:0x7f9865792530, is_inited:true}, cols_param:null, index_read_info:NULL}}}, tablet_iter:{tablet_handle:{obj:0x7f99a4c7cdb0, obj_pool:0x7f99fe7f3cb0, wash_priority:0}, table_iter:{array:[{ObITable:{this:0x7f99af7f0080, key:{tablet_id:{id:101004}, column_group_idx:0, table_type:“MAJOR”, scn_range:{start_scn:{val:0}, end_scn:{val:1714327206203018205}}}, ref_cnt:1, upper_trans_version:1714015259387039649, timestamp:0}, this:0x7f99af7f0080, meta:{basic_meta:{version:1, length:92, row_count_:8, occupy_size_:682, original_size_:448, data_checksum_:856340389, index_type_:2, rowkey_column_count_:6, column_cnt_:7, data_macro_block_count_:1, data_micro_block_count_:1, use_old_macro_block_count_:0, index_macro_block_count_:0, sstable_format_version_:1, schema_version_:1680595867367456, create_snapshot_version_:0, progressive_merge_round_:1, progressive_merge_step_:0, data_index_tree_height_:2, table_mode_:{table_mode_flag:0, pk_mode:0, table_state_flag:0, view_created_method_flag:0, table_organization_mode:0, auto_increment_mode:0, rowid_mode:0, view_column_filled_flag:0}, upper_trans_version_:1714015259387039649, max_merged_trans_version_:1714015259387039649, recycle_version:0, ddl_scn_:{val:0}, filled_tx_scn_:{val:4611686018427387903}, contain_uncommitted_row_:false, status_:4, root_row_store_type:2, compressor_type:1, encrypt_id:0, master_key_id:0, sstable_logic_seq:0, encrypt_key:“data_size:16, data:00000000000000000000000000000000”, latest_row_store_type:1}, column_checksums_.count():7, data_root_info:{addr:0-0-0-3458764988414427136, block_data:{buf:0x7f9953c701e0, size:442, extra_buf:0x7f9953c70c00, extra_size:516, type:1}, block_data_allocator:0x7f99fe7e20b0}, macro_info:{macro_meta_info:{addr:0-0-0-3458765024921649152, block_data:{buf:0x7f9953c703b0, size:476, extra_buf:null, extra_size:0, type:1}, block_data_allocator:0x7f99fe7e20b0}, data_block_ids_.count():1, other_block_ids_.count():0, linked_block_ids_.count():0, is_meta_root_:true, nested_offset_:1441792, nested_size_:4096}, allocator:0x7f99fe7e20b0, column_checksums:[14851475313, 13932137546, 17262326678, 17577401280, 16347665724, 19110738824, 12273612187]}, valid_for_reading:true}, {ObITable:{this:0x7f99b0c20940, key:{tablet_id:{id:101004}, column_group_idx:0, table_type:“MINI”, scn_range:{start_scn:{val:1714276484560361310}, end_scn:{val:1714327206703163086}}}, ref_cnt:1, upper_trans_version:1714327206703163086, timestamp:0}, this:0x7f99b0c20940, meta:{basic_meta:{version:1, length:86, row_count_:0, occupy_size_:0, original_size_:0, data_checksum_:0, index_type_:2, rowkey_column_count_:6, column_cnt_:7, data_macro_block_count_:0, data_micro_block_count_:0, use_old_macro_block_count_:0, index_macro_block_count_:0, sstable_format_version_:1, schema_version_:1680595867367456, create_snapshot_version_:0, progressive_merge_round_:0, progressive_merge_step_:0, data_index_tree_height_:0, table_mode_:{table_mode_flag:0, pk_mode:0, table_state_flag:0, view_created_method_flag:0, table_organization_mode:0, auto_increment_mode:0, rowid_mode:0, view_column_filled_flag:0}, upper_trans_version_:1714327206703163086, max_merged_trans_version_:1714327206703163086, recycle_version:0, ddl_scn_:{val:0}, filled_tx_scn_:{val:4611686018427387903}, contain_uncommitted_row_:false, status_:4, root_row_store_type:0, compressor_type:1, encrypt_id:0, master_key_id:0, sstable_logic_seq:0, encrypt_key:“data_size:16, data:00000000000000000000000000000000”, latest_row_store_type:1}, column_checksums_.count():0, data_root_info:{addr:0-0-0-0, block_data:{buf:null, size:0, extra_buf:null, extra_size:0, type:1}, block_data_allocator:0x7f99fe7e20b0}, macro_info:{macro_meta_info:{addr:0-0-0-0, block_data:{buf:null, size:0, extra_buf:null, extra_size:0, type:1}, block_data_allocator:0x7f99fe7e20b0}, data_block_ids_.count():0, other_block_ids_.count():0, linked_block_ids_.count():0, is_meta_root_:false, nested_offset_:0, nested_size_:2097152}, allocator:0x7f99fe7e20b0, column_checksums:[]}, valid_for_reading:true}, {ObITable:{this:0x7f9990f8f2c0, key:{tablet_id:{id:101004}, column_group_idx:0, table_type:“MINI”, scn_range:{start_scn:{val:1714327206703163086}, end_scn:{val:1714331776702853575}}}, ref_cnt:1, upper_trans_version:1714331776702853571, timestamp:0}, this:0x7f9990f8f2c0, meta:{basic_meta:{version:1, length:86, row_count_:0, occupy_size_:0, original_size_:0, data_checksum_:0, index_type_:2, rowkey_column_count_:6, column_cnt_:7, data_macro_block_count_:0, data_micro_block_count_:0, use_old_macro_block_count_:0, index_macro_block_count_:0, sstable_format_version_:1, schema_version_:1680595867367456, create_snapshot_version_:0, progressive_merge_round_:0, progressive_merge_step_:0, data_index_tree_height_:0, table_mode_:{table_mode_flag:0, pk_mode:0, table_state_flag:0, view_created_method_flag:0, table_organization_mode:0, auto_increment_mode:0, rowid_mode:0, view_column_filled_flag:0}, upper_trans_version_:1714331776702853571, max_merged_trans_version_:1714331776702853571, recycle_version:0, ddl_scn_:{val:0}, filled_tx_scn_:{val:4611686018427387903}, contain_uncommitted_row_:false, status_:4, root_row_store_type:0, compressor_type:1, encrypt_id:0, master_key_id:0, sstable_logic_seq:0, encrypt_key:“data_size:16, data:00000000000000000000000000000000”, latest_row_store_type:1}, column_checksums_.count():0, data_root_info:{addr:0-0-0-0, block_data:{buf:null, size:0, extra_buf:null, extra_size:0, type:1}, block_data_allocator:0x7f99fe7e20b0}, macro_info:{macro_meta_info:{addr:0-0-0-0, block_data:{buf:null, size:0, extra_buf:null, extra_size:0, type:1}, block_data_allocator:0x7f99fe7e20b0}, data_block_ids_.count():0, other_block_ids_.count():0, linked_block_ids_.count():0, is_meta_root_:false, nested_offset_:0, nested_size_:2097152}, allocator:0x7f99fe7e20b0, column_checksums:[]}, valid_for_reading:true}, {ObITable:{this:0x7f95a92f0ba0, key:{tablet_id:{id:101004}, column_group_idx:0, table_type:“MEMTABLE”, scn_range:{start_scn:{val:1714331776702853575}, end_scn:{val:4611686018427387903}}}, ref_cnt:2, upper_trans_version:9223372036854775807, timestamp:1714442105186024}, this:0x7f95a92f0ba0, timestamp:1714442105186024, state:0, freeze_clock:12, max_schema_version:0, write_ref_cnt:0, local_allocator:{ListHandle:{freeze_stat:0, id:-1, clock:9223372036854775807}, host:0x7f99489ec380, arena_handle:{allocated:0}, last_freeze_timestamp:1714098786169177}, unsubmitted_cnt:0, unsynced_cnt:0, logging_blocked:false, unset_active_memtable_logging_blocked:false, resolve_active_memtable_left_boundary:true, contain_hotspot_row:false, max_end_scn:{val:0}, rec_scn:{val:4611686018427387903}, snapshot_version:{val:4611686018427387903}, migration_clog_checkpoint_scn:{val:0}, is_tablet_freeze:false, is_force_freeze:false, contain_hotspot_row:false, read_barrier:false, is_flushed:false, freeze_state:0, mt_stat_.frozen_time:0, mt_stat_.ready_for_flush_time:0, mt_stat_.create_flush_dag_time:0, mt_stat_.release_time:0, mt_stat_.last_print_time:0}], pos:9223372036854775807, memstore_retired:false, step:1}}}, rows_info={rowkeys:[{datum_cnt:4, group_idx:0, hash:0, [idx=0:{len: 8, flag: 0, null: 0, ptr: 0x7f9a2274a268, hex: AE4F0B0000000000, int: 741294},idx=1:{len: 8, flag: 0, null: 0, ptr: 0x7f9a2274a2a0, hex: AE4F0B0000000000, int: 741294},idx=2:{len: 8, flag: 0, null: 0, ptr: 0x7f9a2274a2d8, hex: 90F8294BCF160600, int: 1713929435347088},idx=3:null,]store_rowkey:{“BIGINT”:741294},{“BIGINT”:741294},{“BIGINT”:1713929435347088},{“NULL”:“NULL”}}], min_key:{datum_cnt:4, group_idx:0, hash:0, [idx=0:{len: 8, flag: 0, null: 0, ptr: 0x7f9a2274a268, hex: AE4F0B0000000000, int: 741294},idx=1:{len: 8, flag: 0, null: 0, ptr: 0x7f9a2274a2a0, hex: AE4F0B0000000000, int: 741294},idx=2:{len: 8, flag: 0, null: 0, ptr: 0x7f9a2274a2d8, hex: 90F8294BCF160600, int: 1713929435347088},idx=3:null,]store_rowkey:{“BIGINT”:741294},{“BIGINT”:741294},{“BIGINT”:1713929435347088},{“NULL”:“NULL”}}, table_id:101004, delete_count:0, exist_helper:{table_iter_param:{table_id:101004, tablet_id:{id:101004}, read_info:{schema_column_count:5, schema_rowkey_cnt:4, rowkey_cnt:6, trans_col_index:4, seq_read_column_count:7, max_col_index:6, is_oracle_mode:false, cols_index:[0, 1, 2, 3, 4, 5, 6], memtable_cols_index:[0, 1, 2, 3, -1, -1, 4], cols_desc:[column_id=18 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=17 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=19 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=20 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=7 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=8 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=16 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0], datum_utils:{is_oracle_mode:false, rowkey_cnt:6, col_cnt:7, allocator:0x7f99fe7e20b0, is_inited:true}, cols_param:null, index_read_info:{schema_column_count:5, schema_rowkey_cnt:4, rowkey_cnt:6, trans_col_index:4, seq_read_column_count:7, max_col_index:6, is_oracle_mode:false, cols_index:[0, 1, 2, 3, 4, 5, 6], memtable_cols_index:[0, 1, 2, 3, -1, -1, 4], cols_desc:[column_id=18 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=17 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=19 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=20 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=7 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=8 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=22 {type:“VARCHAR”, collation:“binary”, coercibility:“INVALID”} order=0], datum_utils:{is_oracle_mode:false, rowkey_cnt:6, col_cnt:7, allocator:0x7f99fe7e20b0, is_inited:true}, cols_param:null, index_read_info:NULL}}, full_read_info:{schema_column_count:5, schema_rowkey_cnt:4, rowkey_cnt:6, trans_col_index:4, seq_read_column_count:7, max_col_index:6, is_oracle_mode:false, cols_index:[0, 1, 2, 3, 4, 5, 6], memtable_cols_index:[0, 1, 2, 3, -1, -1, 4], cols_desc:[column_id=18 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=17 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=19 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=20 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=7 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=8 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=16 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0], datum_utils:{is_oracle_mode:false, rowkey_cnt:6, col_cnt:7, allocator:0x7f99fe7e20b0, is_inited:true}, cols_param:null, index_read_info:{schema_column_count:5, schema_rowkey_cnt:4, rowkey_cnt:6, trans_col_index:4, seq_read_column_count:7, max_col_index:6, is_oracle_mode:false, cols_index:[0, 1, 2, 3, 4, 5, 6], memtable_cols_index:[0, 1, 2, 3, -1, -1, 4], cols_desc:[column_id=18 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=17 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=19 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=20 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=7 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=8 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=22 {type:“VARCHAR”, collation:“binary”, coercibility:“INVALID”} order=0], datum_utils:{is_oracle_mode:false, rowkey_cnt:6, col_cnt:7, allocator:0x7f99fe7e20b0, is_inited:true}, cols_param:null, index_read_info:NULL}}, out_cols_project:NULL, pushdown_filter:NULL, is_multi_version_minor_merge:false, need_scn:false, is_same_schema_column:false, pd_storage_flag:0, vectorized_enabled:false, has_virtual_columns:false, has_lob_column_out:false, is_for_foreign_check:false, limit_prefetch:false, ss_rowkey_prefix_cnt:0}, table_access_context:{is_inited:true, timeout:1714443105032586, ls_id:{id:1}, tablet_id:{id:101004}, query_flag:{scan_order:0, daily_merge:0, rmmb_optimize:0, whole_macro_scan:0, full_row:0, index_back:0, query_stat:0, sql_mode:0, read_latest:1, prewarm:0, join_type:0, use_row_cache:1, use_block_index_cache:0, use_bloomfilter_cache:0, multi_version_minor_merge:0, is_need_feedback:0, 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, reserved:0}, sql_mode:0, store_ctx:0x7f9a2274b680, limit_param:null, stmt_allocator:0x7f9a22749db8, allocator:0x7f9a22749db8, range_allocator:null, table_scan_stat:null, out_cnt:0, trans_version_range:{multi_version_start:0, base_version:0, snapshot_version:4611686018427387902}, merge_scn:{val:4611686018427387903}, lob_locator_helper:null, iter_pool:null, block_row_store:null, io_callback:null}}})
rootservice.log:[2024-04-30 09:55:05.211862] WDIAG insert_tablet_rows (ob_ls_tablet_service.cpp:3744) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=433][errcode=-5024] Duplicate entry ‘741294-741294-1713929435347088’ for key ‘idx_task_key’
…

AntTech_S9A1W1 · 2024 年4 月 30 日 10:26

rootservice.log:[2024-04-30 09:55:05.211959] WDIAG [SQL.DAS] execute_dist_das_task (ob_data_access_service.cpp:185) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=16][errcode=-5024] do local das task failed(ret=-5024, task_arg={timeout_ts:1714443105132586, ctrl_svr:“10.10.22.37:2882”, runner_svr:“10.10.22.37:2882”, task_ops:[{parent:{tenant_id:1, task_id:28705841324, op_type:2, errcode:-5024, can_part_retry:0, task_started:1, in_part_retry:0, in_stmt_retry:0, need_switch_param:0, trans_desc:{this:0x7f98369d2d70, tx_id:{txid:2192897514}, state:3, addr:“10.10.22.37:2882”, tenant_id:1, session_id:1, assoc_session_id:1, xid:NULL, xa_mode:"", xa_start_addr:“0.0.0.0:0”, access_mode:0, tx_consistency_type:0, isolation:1, snapshot_version:{val:18446744073709551615}, snapshot_scn:0, active_scn:1714442105184908, op_sn:2, alloc_ts:1714442105184725, active_ts:1714442105185790, commit_ts:-1, finish_ts:-1, timeout_us:999949194, lock_timeout_us:-1, expire_ts:1714443105134984, coord_id:{id:-1}, parts:[{id:{id:1}, addr:“10.10.22.37:2882”, epoch:13479, first_scn:1714442105184908, last_scn:1714442105184909, last_touch_ts:1714442105184909}], exec_info_reap_ts:1714442105184908, commit_version:{val:18446744073709551615}, commit_cb:null, cluster_id:1710839653, cluster_version:17179934720, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:false, can_elr:false, cflict_txs:[], abort_cause:0, commit_expire_ts:0, commit_task_.is_registered():false, ref:2}, snapshot:{this:0x7f9a22751bb8, valid:true, source:5, core:{version:{val:18446744073709551615}, tx_id:{txid:2192897514}, scn:1714442105184907}, uncertain_bound:0, snapshot_lsid:{id:-1}, parts:[]}, tablet_id:{id:319}, ls_id:{id:1}, tablet_loc:{tablet_id:{id:319}, ls_id:{id:1}, server:“10.10.22.37:2882”, need_refresh:0}, related_ctdefs:[{ObDASBaseCtDef:{ObDASBaseDef:{op_type:2}, table_id:18446744073709551614, index_tid:101004, schema_version:1680595867367456, rowkey_cnt:4, spk_cnt:1, column_ids:[21, 20, 23, 32785, 18], column_types:[{type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}], column_accuracys:[{length:-1, precision:20, scale:0}, {length:-1, precision:20, scale:0}, {length:-1, precision:20, scale:0}, {length:-1, precision:20, scale:0}, {length:-1, precision:20, scale:0}], old_row_projector:[], new_row_projector:[5, 4, 7, 0, 0], is_total_quantity_log:1, is_ignore:0, is_batch_stmt:0, tz_info:{id:-1, offset:28800, error_on_overlap_time:false}, table_param:{tenant_schema_version:1714290189053400, data_table:{table_id:101004, schema_version:1680595867367456, table_type:5, index_type:2, index_status:2, shadow_rowkey_column_num:1, fulltext_col_id:18446744073709551615, index_name:“idx_task_key”, pk_name:"", columns:[{column_id:21, 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}, {column_id:20, 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}, {column_id:23, 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}, {column_id:32785, 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:true, is_nullable_for_read:true, is_gen_col:false, is_virtual_gen_col:false, is_gen_col_udf_expr:false, is_hidden:true}, {column_id:18, 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}], read_info:{schema_column_count:5, schema_rowkey_cnt:4, rowkey_cnt:6, trans_col_index:-1, seq_read_column_count:4, max_col_index:6, is_oracle_mode:false, cols_index:[0, 1, 2, 3, 6], memtable_cols_index:[0, 1, 2, 3, 4], cols_desc:[column_id=21 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=20 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=23 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=32785 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=18 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0], datum_utils:{is_oracle_mode:false, rowkey_cnt:6, col_cnt:7, allocator:0x7f9865792530, is_inited:true}, cols_param:[{column_id:21, 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}, {column_id:20, 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}, {column_id:23, 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}, {column_id:32785, 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:true, is_nullable_for_read:true, is_gen_col:false, is_virtual_gen_col:false, is_gen_col_udf_expr:false, is_hidden:true}, {column_id:18, 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}], index_read_info:{schema_column_count:5, schema_rowkey_cnt:4, rowkey_cnt:6, trans_col_index:4, seq_read_column_count:7, max_col_index:6, is_oracle_mode:false, cols_index:[0, 1, 2, 3, 4, 5, 6], memtable_cols_index:[0, 1, 2, 3, -1, -1, 4], cols_desc:[column_id=21 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=20 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=23 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=32785 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=7 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=8 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=22 {type:“VARCHAR”, collation:“binary”, coercibility:“INVALID”} order=0], datum_utils:{is_oracle_mode:false, rowkey_cnt:6, col_cnt:7, allocator:0x7f9865792530, is_inited:true}, cols_param:null, index_read_info:NULL}}}, col_descs:[column_id=21 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=20 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=23 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=32785 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=18 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0], col_map:{is_inited_:true, use_array_:true, shadow_use_array_:true, has_:true, has_shadow_:true}}, encrypt_meta:[]}, table_rowkey_cids:[], table_rowkey_types:[]}], related_rtdefs:[{ObDASBaseRtDef:{ObDASBaseRtDef:{op_type:2}, timeout_ts:1714443105032586, sql_mode:4194304, prelock:false, tenant_schema_version:1714290189053400, affected_rows:0}, need_fetch_conflict:false, is_duplicated:false, direct_insert_task_id:0}], task_status:1, related_tablet_ids:[{id:101004}], das_task_node:}, ins_ctdef:{ObDASBaseCtDef:{ObDASBaseDef:{op_type:2}, table_id:18446744073709551614, index_tid:319, schema_version:1680595867371272, rowkey_cnt:1, spk_cnt:0, column_ids:[18, 16, 17, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32], column_types:[{type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“TIMESTAMP”, collation:“binary”, coercibility:“NUMERIC”}, {type:“TIMESTAMP”, collation:“binary”, coercibility:“NUMERIC”}, {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“BIGINT UNSIGNED”, collation:“binary”, coercibility:“NUMERIC”}, {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“LONGTEXT”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“LONGTEXT”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}], column_accuracys:[{length:-1, precision:20, scale:0}, {length:-1, precision:25, scale:6}, {length:-1, precision:25, scale:6}, {length:-1, precision:20, scale:0}, {length:-1, precision:20, scale:0}, {length:-1, precision:20, scale:0}, {length:-1, precision:20, scale:0}, {length:-1, precision:20, scale:0}, {length:-1, precision:20, scale:0}, {length:256, precision:-1, scale:-1}, {length:-1, precision:20, scale:0}, {length:-1, precision:20, scale:0}, {length:-1, precision:20, scale:0}, {length:-1, precision:20, scale:0}, {length:536870911, precision:-1, scale:-1}, {length:-1, precision:20, scale:0}, {length:536870911, precision:-1, scale:-1}], old_row_projector:[], new_row_projector:[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16], is_total_quantity_log:1, is_ignore:0, is_batch_stmt:0, tz_info:{id:-1, offset:28800, error_on_overlap_time:false}, table_param:{tenant_schema_version:1714290189053400, data_table:{table_id:319, schema_version:1680595867371272, table_type:0, index_type:13, index_status:8, shadow_rowkey_column_num:0, fulltext_col_id:18446744073709551615, index_name:"", pk_name:"", columns:[{column_id:18, 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}, {column_id:16, 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:{“EXT”:“CURRENT_TIMESTAMP”}, is_nullable_for_write:true, is_nullable_for_read:true, is_gen_col:false, is_virtual_gen_col:false, is_gen_col_udf_expr:false, is_hidden:false}, {column_id:17, 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:{“EXT”:“CURRENT_TIMESTAMP”}, is_nullable_for_write:true, is_nullable_for_read:true, is_gen_col:false, is_virtual_gen_col:false, is_gen_col_udf_expr:false, is_hidden:false}, {column_id:19, 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}, {column_id:20, 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}, {column_id:21, 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}, {column_id:22, 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}, {column_id:23, 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}, {column_id:24, 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}, {column_id:25, meta_type:{type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:256, 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:26, 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}, {column_id:27, meta_type:{type:“BIGINT UNSIGNED”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:20, scale:0}, orig_default_value:{“BIGINT UNSIGNED”:0}, cur_default_value:{“BIGINT UNSIGNED”:0}, 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:28, meta_type:{type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:20, scale:0}, orig_default_value:{“BIGINT”:0}, cur_default_value:{“BIGINT”:0}, 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:{“BIGINT”:0}, cur_default_value:{“BIGINT”:0}, 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:30, meta_type:{type:“LONGTEXT”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:536870911, precision:-1, scale:-1}, orig_default_value:{“NULL”:“NULL”}, cur_default_value:{“NULL”:“NULL”}, is_nullable_for_write:true, is_nullable_for_read:true, is_gen_col:false, is_virtual_gen_col:false, is_gen_col_udf_expr:false, is_hidden:false}, {column_id:31, meta_type:{type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:20, scale:0}, orig_default_value:{“BIGINT”:0}, cur_default_value:{“BIGINT”:0}, 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:32, meta_type:{type:“LONGTEXT”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:536870911, precision:-1, scale:-1}, orig_default_value:{“NULL”:“NULL”}, cur_default_value:{“NULL”:“NULL”}, is_nullable_for_write:true, is_nullable_for_read:true, is_gen_col:false, is_virtual_gen_col:false, is_gen_col_udf_expr:false, is_hidden:false}], read_info:{schema_column_count:17, schema_rowkey_cnt:1, rowkey_cnt:3, trans_col_index:-1, seq_read_column_count:1, max_col_index:18, is_oracle_mode:false, cols_index:[0, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18], memtable_cols_index:[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16], cols_desc:[column_id=18 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=16 {type:“TIMESTAMP”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=17 {type:“TIMESTAMP”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=19 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=20 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=21 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=22 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=23 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=24 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=25 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=26 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=27 {type:“BIGINT UNSIGNED”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=28 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=29 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=30 {type:“LONGTEXT”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=31 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=32 {type:“LONGTEXT”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0], datum_utils:{is_oracle_mode:false, rowkey_cnt:3, col_cnt:19, allocator:0x7f9865792530, is_inited:true}, cols_param:[{column_id:18, 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}, {column_id:16, 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:{“EXT”:“CURRENT_TIMESTAMP”}, is_nullable_for_write:true, is_nullable_for_read:true, is_gen_col:false, is_virtual_gen_col:false, is_gen_col_udf_expr:false, is_hidden:false}, {column_id:17, 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:{“EXT”:“CURRENT_TIMESTAMP”}, is_nullable_for_write:true, is_nullable_for_read:true, is_gen_col:false, is_virtual_gen_col:false, is_gen_col_udf_expr:false, is_hidden:false}, {column_id:19, 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}, {column_id:20, 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}, {column_id:21, 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}, {column_id:22, 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}, {column_id:23, 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}, {column_id:24, 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}, {column_id:25, meta_type:{type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:256, 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:26, 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}, {column_id:27, meta_type:{type:“BIGINT UNSIGNED”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:20, scale:0}, orig_default_value:{“BIGINT UNSIGNED”:0}, cur_default_value:{“BIGINT UNSIGNED”:0}, 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:28, meta_type:{type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:20, scale:0}, orig_default_value:{“BIGINT”:0}, cur_default_value:{“BIGINT”:0}, 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:{“BIGINT”:0}, cur_default_value:{“BIGINT”:0}, 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:30, meta_type:{type:“LONGTEXT”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:536870911, precision:-1, scale:-1}, orig_default_value:{“NULL”:“NULL”}, cur_default_value:{“NULL”:“NULL”}, is_nullable_for_write:true, is_nullable_for_read:true, is_gen_col:false, is_virtual_gen_col:false, is_gen_col_udf_expr:false, is_hidden:false}, {column_id:31, meta_type:{type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:20, scale:0}, orig_default_value:{“BIGINT”:0}, cur_default_value:{“BIGINT”:0}, 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:32, meta_type:{type:“LONGTEXT”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:536870911, precision:-1, scale:-1}, orig_default_value:{“NULL”:“NULL”}, cur_default_value:{“NULL”:“NULL”}, is_nullable_for_write:true, is_nullable_for_read:true, is_gen_col:false, is_virtual_gen_col:false, is_gen_col_udf_expr:false, is_hidden:false}], index_read_info:{schema_column_count:2, schema_rowkey_cnt:1, rowkey_cnt:3, trans_col_index:1, seq_read_column_count:4, max_col_index:3, is_oracle_mode:false, cols_index:[0, 1, 2, 3], memtable_cols_index:[0, -1, -1, 1], cols_desc:[column_id=18 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=7 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=8 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=19 {type:“VARCHAR”, collation:“binary”, coercibility:“INVALID”} order=0], datum_utils:{is_oracle_mode:false, rowkey_cnt:3, col_cnt:4, allocator:0x7f9865792530, is_inited:true}, cols_param:null, index_read_info:NULL}}}, col_descs:[column_id=18 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=16 {type:“TIMESTAMP”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=17 {type:“TIMESTAMP”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=19 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=20 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=21 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=22 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=23 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=24 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=25 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=26 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=27 {type:“BIGINT UNSIGNED”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=28 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=29 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=30 {type:“LONGTEXT”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=31 {type:“BIGINT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=32 {type:“LONGTEXT”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0], col_map:{is_inited_:true, use_array_:true, shadow_use_array_:false, has_:true, has_shadow_:false}}, encrypt_meta:[]}, table_rowkey_cids:[], table_rowkey_types:[]}, ins_rtdef:{ObDASBaseRtDef:{ObDASBaseRtDef:{op_type:2}, timeout_ts:1714443105032586, sql_mode:4194304, prelock:false, tenant_schema_version:1714290189053400, affected_rows:0}, need_fetch_conflict:false, is_duplicated:false, direct_insert_task_id:0}, insert_buffer:{mem_attr:tenant_id=1, label=DASInsertBuffer, ctx_id=0, prio=0, buffer_memory:709, buffer_size:1, datum_store:NULL}}], remote_info:NULL})
rootservice.log:[2024-04-30 09:55:05.212462] WDIAG [SQL.DAS] execute_das_task (ob_data_access_service.cpp:110) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=502][errcode=-5024] failed to execute dist das task(ret=-5024)

AntTech_S9A1W1 · 2024 年4 月 30 日 10:26

…

rootservice.log:[2024-04-30 09:55:05.212520] WDIAG [SERVER] do_query (ob_inner_sql_connection.cpp:648) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=4][errcode=-5024] result set open failed(ret=-5024, executor={ObIExecutor:, sql:" INSERT INTO all_ddl_task_status (task_id, parent_task_id, tenant_id, object_id, schema_version, target_object_id, ddl_type, trace_id, status, task_version, execution_id, ret_code, ddl_stmt_str, message) VALUES (7350, 0, 0, 741294, 1713929435347088, 741294, 502, ‘YB420A0A1625-000616F6F896E2A4-0-0’, 0, 1, -1, 0, ‘’, “0000000000000001018A8180800001BA808080003164726F70207461626C6520656E646F7273656D656E745F696E73757265645F6F626A6563745F6368616E67655F696E666F000100000000000001030101B18080800006696E737572650026656E646F7273656D656E745F696E73757265645F6F626A6563745F6368616E67655F696E666F00000000E18B8CDAD0C485850A0001010000”) “})
rootservice.log:[2024-04-30 09:55:05.212528] WDIAG [SERVER] query (ob_inner_sql_connection.cpp:783) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=7][errcode=-5024] execute failed(ret=-5024, tenant_id=1, executor={ObIExecutor:, sql:” INSERT INTO all_ddl_task_status (task_id, parent_task_id, tenant_id, object_id, schema_version, target_object_id, ddl_type, trace_id, status, task_version, execution_id, ret_code, ddl_stmt_str, message) VALUES (7350, 0, 0, 741294, 1713929435347088, 741294, 502, ‘YB420A0A1625-000616F6F896E2A4-0-0’, 0, 1, -1, 0, ‘’, “0000000000000001018A8180800001BA808080003164726F70207461626C6520656E646F7273656D656E745F696E73757265645F6F626A6563745F6368616E67655F696E666F000100000000000001030101B18080800006696E737572650026656E646F7273656D656E745F696E73757265645F6F626A6563745F6368616E67655F696E666F00000000E18B8CDAD0C485850A0001010000”) "}, retry_cnt=0, local_sys_schema_version=1714290189053400, local_tenant_schema_version=1714290189053400)
rootservice.log:[2024-04-30 09:55:05.212542] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:868) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=11][errcode=-5024] [RETRY] check if need retry(v={force_local_retry:true, stmt_retry_times:0, local_retry_times:0, err:-5024, err:“OB_ERR_PRIMARY_KEY_DUPLICATE”, retry_type:0, client_ret:-5024}, need_retry=false)
rootservice.log:[2024-04-30 09:55:05.212571] INFO [DETECT] maintain_deadlock_info_when_end_stmt (ob_trans_deadlock_adapter.cpp:644) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=13] inner session no need register to deadlock(step=2, ret=0, ret=“OB_SUCCESS”, exec_ctx.get_errcode()=-5024, exec_ctx.get_errcode()=“OB_ERR_PRIMARY_KEY_DUPLICATE”, session={this:0x7f98a394a0d8, id:1, tenant:“sys”, tenant_id:1, effective_tenant:“sys”, effective_tenant_id:1, database:“oceanbase”, user:“root@%”, consistency_level:3, session_state:0, autocommit:true, tx:0x7f98369d2d70}, desc=NULL, is_rollback=true, conflict_txs=[])
rootservice.log:[2024-04-30 09:55:05.212588] INFO [DETECT] maintain_deadlock_info_when_end_stmt (ob_trans_deadlock_adapter.cpp:679) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=17] maintain deadlock info(step=2, ret=0, ret=“OB_SUCCESS”, exec_ctx.get_errcode()=-5024, exec_ctx.get_errcode()=“OB_ERR_PRIMARY_KEY_DUPLICATE”, session={this:0x7f98a394a0d8, id:1, tenant:“sys”, tenant_id:1, effective_tenant:“sys”, effective_tenant_id:1, database:“oceanbase”, user:“root@%”, consistency_level:3, session_state:0, autocommit:true, tx:0x7f98369d2d70}, desc=NULL, is_rollback=true, conflict_txs=[])
rootservice.log:[2024-04-30 09:55:05.212635] INFO [STORAGE.TRANS] abort (ob_trans_part_ctx.cpp:1655) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=13] tx abort(ret=0, reason=4, reason=4, reason=“Unknown error”, this={this:0x7f99e34924d0, trans_id:{txid:2192897514}, tenant_id:1, is_exiting:true, trans_expired_time:1714443105133919, cluster_version:17179934720, trans_need_wait_wrap:{receive_gts_ts:[mts=0], need_wait_interval_us:0}, stc:[mts=0], ctx_create_time:1714442105184725}{ls_id:{id:1}, session_id:1, part_trans_action:4, pending_write:0, exec_info:{state:60, upstream:{id:-1}, participants:[], incremental_participants:[], prev_record_lsn:{lsn:18446744073709551615}, redo_lsns:[], redo_log_no:0, multi_data_source:[], scheduler:“10.10.22.37:2882”, prepare_version:{val:18446744073709551615}, trans_type:0, next_log_entry_no:0, max_applied_log_ts:{val:18446744073709551615}, max_applying_log_ts:{val:18446744073709551615}, max_applying_part_log_no:9223372036854775807, max_submitted_seq_no:0, checksum:0, checksum_scn:{val:0}, max_durable_lsn:{lsn:18446744073709551615}, data_complete:false, is_dup_tx:false, prepare_log_info_arr:[], xid:{gtrid_str:"", bqual_str:"", format_id:1, gtrid_str_.ptr():“data_size:0, data:”, bqual_str_.ptr():“data_size:0, data:”, g_hv:0, b_hv:0}, need_checksum:true, is_sub2pc:false}, sub_state:{flag:64}, is_leaf():false, is_root():false, busy_cbs_.get_size():0, final_log_cb_:{ObTxBaseLogCb:{log_ts:{val:18446744073709551615}, lsn:{lsn:18446744073709551615}, submit_ts:0}, this:0x7f99e3493ce0, is_inited_:true, trans_id:{txid:2192897514}, ls_id:{id:1}, ctx:0x7f99e34924d0, tx_data_guard:{tx_data:NULL}, is_callbacked_:false, mds_range_:{count_:0}, cb_arg_array_:[], first_part_scn_:{val:18446744073709551615}}, ctx_tx_data_:{ctx_mgr_:0x7f99bc804030, tx_data_guard_:{tx_data:{tx_id:{txid:2192897514}, ref_cnt:1, state:“ABORT”, commit_version:{val:18446744073709551615}, start_scn:{val:18446744073709551615}, end_scn:{val:18446744073709551615}, undo_status_list:{head:null, undo_node_cnt:0}}}, tx_commit_data_:{tx_id:{txid:9223372036854775807}, state:0, commit_version:{val:18446744073709551615}, start_scn:{val:18446744073709551615}, end_scn:{val:18446744073709551615}}, read_only_:false}, role_state_:0, start_replay_ts_:{val:18446744073709551615}, is_incomplete_replay_ctx_:false, mt_ctx_:{ObIMvccCtx={alloc_type=0 ctx_descriptor=0 min_table_version=9223372036854775807 max_table_version=0 trans_version={val:4611686018427387903} commit_version={val:18446744073709551615} lock_wait_start_ts=0 replay_compact_version={val:0}} end_code=-6002 tx_status=1 is_readonly=false ref=0 trans_id={txid:2192897514} ls_id=1 callback_alloc_count=1 callback_free_count=1 checksum=0 tmp_checksum=0 checksum_scn={val:0} redo_filled_count=0 redo_sync_succ_count=0 redo_sync_fail_count=0 main_list_length=0 unsynced_cnt=0 unsubmitted_cnt_=0 cb_statistics:[main=3, slave=0, merge=0, tx_end=3, rollback_to=0, fast_commit=0, remove_memtable=0]}, coord_prepare_info_arr_:[], upstream_state:10, retain_cause:-1, 2pc_role:-1, collected:[], ref:1, rec_log_ts:{val:18446744073709551615}, prev_rec_log_ts:{val:18446744073709551615}, lastest_snapshot:{val:18446744073709551615}, state_info_array:[], last_request_ts:1714442105185790})
rootservice.log:[2024-04-30 09:55:05.212749] INFO [STORAGE.TRANS] handle_trans_abort_request (ob_trans_service_v4.cpp:1799) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=109] handle trans abort request(ret=0, abort_req={txMsg:{type:22, cluster_version:17179934720, tenant_id:1, tx_id:{txid:2192897514}, receiver:{id:1}, sender:{id:9223372036854775807}, sender_addr:“10.10.22.37:2882”, epoch:-1, request_id:3, timestamp:1714442105212603, cluster_id:1710839653}, reason:4})
rootservice.log:[2024-04-30 09:55:05.212767] INFO [STORAGE.TRANS] abort_tx_ (ob_trans_service_v4.cpp:570) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=17] abort tx(ret=0, *this={is_inited_:true, tenant_id_:1, this:0x7f99e2404030}, tx={this:0x7f98369d2d70, tx_id:{txid:2192897514}, state:6, addr:“10.10.22.37:2882”, tenant_id:1, session_id:1, assoc_session_id:1, xid:NULL, xa_mode:"", xa_start_addr:“0.0.0.0:0”, access_mode:0, tx_consistency_type:0, isolation:1, snapshot_version:{val:18446744073709551615}, snapshot_scn:0, active_scn:1714442105184908, op_sn:3, alloc_ts:1714442105184725, active_ts:1714442105185790, commit_ts:-1, finish_ts:-1, timeout_us:999949194, lock_timeout_us:-1, expire_ts:1714443105134984, coord_id:{id:-1}, parts:[{id:{id:1}, addr:“10.10.22.37:2882”, epoch:13479, first_scn:1714442105184908, last_scn:1714442105184909, last_touch_ts:1714442105184909}], exec_info_reap_ts:1714442105184908, commit_version:{val:18446744073709551615}, commit_cb:null, cluster_id:1710839653, cluster_version:17179934720, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:false, can_elr:false, cflict_txs:[], abort_cause:4, commit_expire_ts:0, commit_task_.is_registered():false, ref:2}, cause=4)
rootservice.log:[2024-04-30 09:55:05.212795] INFO [STORAGE.TRANS] start_epoch_ (ob_tx_api.cpp:1713) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=27] tx start new epoch(ret=0, tx={this:0x7f98369d2d70, tx_id:{txid:0}, state:1, addr:“10.10.22.37:2882”, tenant_id:1, session_id:1, assoc_session_id:1, xid:NULL, xa_mode:"", xa_start_addr:“0.0.0.0:0”, access_mode:0, tx_consistency_type:0, isolation:1, snapshot_version:{val:18446744073709551615}, snapshot_scn:0, active_scn:0, op_sn:4, alloc_ts:1714442105184725, active_ts:0, commit_ts:0, finish_ts:0, timeout_us:0, lock_timeout_us:-1, expire_ts:9223372036854775807, coord_id:{id:-1}, parts:[], exec_info_reap_ts:0, commit_version:{val:18446744073709551615}, commit_cb:null, cluster_id:1710839653, cluster_version:17179934720, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:false, can_elr:false, cflict_txs:[], abort_cause:0, commit_expire_ts:0, commit_task_.is_registered():false, ref:1})
rootservice.log:[2024-04-30 09:55:05.212821] INFO [SQL.EXE] end_stmt (ob_sql_trans_control.cpp:922) [111498][DDLQueueTh0][T1][YB420A0A1625-000616F6F896E2A4-0-0] [lt=20] end stmt(ret=0, plain_select=false, stmt_type=2, savepoint=1714442105184907, tx_desc={this:0x7f98369d2d70, tx_id:{txid:0}, state:1, addr:“10.10.22.37:2882”, tenant_id:1, session_id:1, assoc_session_id:1, xid:NULL, xa_mode:"", xa_start_addr:“0.0.0.0:0”, access_mode:0, tx_consistency_type:0, isolation:1, snapshot_version:{val:18446744073709551615}, snapshot_scn:0, active_scn:0, op_sn:4, alloc_ts:1714442105184725, active_ts:0, commit_ts:0, finish_ts:0, timeout_us:0, lock_timeout_us:-1, expire_ts:9223372036854775807, coord_id:{id:-1}, parts:[], exec_info_reap_ts:0, commit_version:{val:18446744073709551615}, commit_cb:null, cluster_id:1710839653, cluster_version:17179934720, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:false, can_elr:false, cflict_txs:[], abort_cause:0, commit_expire_ts:0, commit_task_.is_registered():false, ref:1}, trans_result={incomplete:false, parts:[], touched_ls_list:[], cflict_txs:[]}, rollback=true, session={this:0x7f98a394a0d8, id:1, tenant:“sys”, tenant_id:1, effective_tenant:“sys”, effective_tenant_id:1, database:“oceanbase”, user:“root@%”, consistency_level:3, session_state:0, autocommit:true, tx:0x7f98369d2d70}, exec_ctx.get_errcode()=-5024)
rootservice.log:[2024-04-30 09:55:05.213093] WDIAG [RS] insert_record (ob_ddl_task.cpp:2873) [111498][DDLQueueTh0][T0][YB420A0A1625-000616F6F896E2A4-0-0] [lt=7][errcode=-5024] insert ddl task record failed(ret=-5024, sql_string= INSERT INTO __all_ddl_task_status (task_id, parent_task_id, tenant_id, object_id, schema_version, target_object_id, ddl_type, trace_id, status, task_version, execution_id, ret_code, ddl_stmt_str, message) VALUES (7350, 0, 0, 741294, 1713929435347088, 741294, 502, ‘YB420A0A1625-000616F6F896E2A4-0-0’, 0, 1, -1, 0, ‘’, “0000000000000001018A8180800001BA808080003164726F70207461626C6520656E646F7273656D656E745F696E73757265645F6F626A6563745F6368616E67655F696E666F000100000000000001030101B18080800006696E737572650026656E646F7273656D656E745F696E73757265645F6F626A6563745F6368616E67655F696E666F00000000E18B8CDAD0C485850A0001010000”) , record={task_id:7350, parent_task_id:0, ddl_type:502, trace_id:YB420A0A1625-000616F6F896E2A4-0-0, task_status:0, tenant_id:1, object_id:741294, schema_version:1713929435347088, target_object_id:741294, snapshot_version:0, message:"", task_version:1, ret_code:0, execution_id:-1})

singerl · 2024 年4 月 30 日 11:40

duplicate entry 的报错是4.1的已知问题，并发重复发drop table会遇到，只是报错；在4.2及后续版本修复了，Drop/truncate part/table/db without ddl retry task · oceanbase/oceanbase@51bb12a · GitHub

但这个环境看上去是长时间的报错，估计是有删表卡住了，走工单排查下

兹拉坦 · 2024 年4 月 30 日 12:03

已开 L3 工单进行问题排查

兹拉坦 · 2024 年4 月 30 日 15:48

From 研发同学：看上去是有个 ddl_task_status 记录（大概率是删表的）残留了，得分析下现在残留在 ddl_task_status 里的那个 trace 对应的 rs 日志。

先在 sys 租户下执行 select * from oceanbase.__all_virtual_ddl_task_status where object_id = 741294 and target_object_id = 741294; 发一下结果，预期有一行记录。
上面那一行结果里有一个 trace_id 字段，拿着这个 trace_id 字段，捞一下 rootservice 的日志，辛苦把日志发上来。

兹拉坦 · 2024 年4 月 30 日 16:57

From 梦轻：sys 租户独有的问题。

日志：141 rootservice.log.20240430110052964:[2024-04-30 10:07:59.362239] INFO [RS] recover_task (ob_ddl_scheduler.cpp:1566) [666][DDLScanTask][T0][Y0-0000000000000000-0- 0] [lt=11] tenant not primary, skip schedule ddl task(cur_record={task_id:7310, parent_task_id:0, ddl_type:502, trace_id:YB420A0A1625-00061668E11729BE-0-0, task_status:14, tenant_id:1, object_id:741294, schema_version:1713929435347088, target_object_id:741294, snapshot_version:0, message:"", task_version:1, ret_code:0, execution_id:-1})

已知问题，需要升级 420 或者以上就好了
https://github.com/oceanbase/oceanbase/commit/51d7205f5e632a3d685eb11715b78a87d3acec65

先把版本升了，再执行删除表操作。