SqlExceptionHelper: - SQL Error: 6220 SQL sequence illegal

AntTech_TELDKS · 2025 年7 月 7 日 16:25

ERROR 6220 (HY000) : SQL sequence illegal OceanBase错误码：6220 错误原因：SQL 语句顺序不合法。
排除 update sql 外键不合法，实际是什么东西不合法？

09:08:45,935 node1@server1 pool-1-thread-17 WARN xxxProcess: - Start Tp4Import
09:08:46,004 node1@server1 pool-1-thread-17 WARN StatefulPersistenceContext: - HHH000179: Narrowing proxy to class com.qqqmodel.Test - this operation breaks ==
09:08:46,022 node1@server1 pool-1-thread-17 ERROR BatchingBatch: - HHH000315: Exception executing batch [java.sql.BatchUpdateException: SQL sequence illegal
[10.67.98.90:2882] [2025-07-07 09:08:46.021389] [YB420A43625A-00062F0715BF9AD3-0-0]], SQL: update table_xxx set Status=?, StatusTs=?, PeriodId=? where ConfirmId=?
09:08:46,022 node1@server1 pool-1-thread-17 WARN SqlExceptionHelper: - SQL Error: 6220, SQLState: HY000
09:08:46,022 node1@server1 pool-1-thread-17 ERROR SqlExceptionHelper: - SQL sequence illegal
[10.67.98.90:2882] [2025-07-07 09:08:46.021389] [YB420A43625A-00062F0715BF9AD3-0-0]
09:08:46,022 node1@server1 pool-1-thread-17 ERROR xxxProcess: -
javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute batch
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.6.7.Final.jar:5.6.7.Final]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core-5.6.7.Final.jar:5.6.7.Final]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) ~[hibernate-core-5.6.7.Final.jar:5.6.7.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1411) ~[hibernate-core-5.6.7.Final.jar:5.6.7.Final]
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1394) ~[hibernate-core-5.6.7.Final.jar:5.6.7.Final]
at com.bbbmodel.common.util.HibernateUtil.flush(HibernateUtil.java:508) ~[classes/:?]
at com.bbbmodel.common.util.HibernateUtil.flush(HibernateUtil.java:503) ~[classes/:?]

AntTech_TELDKS · 2025 年7 月 7 日 16:41

sql 也没什么特别的，只是通过主键更新数据

独善其身 · 2025 年7 月 7 日 16:44

这篇日志好像价值不高啊

淇铭 · 2025 年7 月 7 日 18:10

ob的版本发一下具体执行的语句也发一下按照下面的步骤提供trace日志
alter system set enable_rich_error_msg=true;
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]
[root@x.x.x.1 ~]$ grep “YB420BA1CC68-000615A0A8EA5E38-0-0” rootservice.log
[root@x.x.x.1 ~]$ grep “YB420BA1CC68-000615A0A8EA5E38-0-0” observer.log
alter system set enable_rich_error_msg=false;

AntTech_TELDKS · 2025 年7 月 7 日 18:19

OceanBase 4.2.1.10 (r110000072024111216-17254329f8916c159fa250e86b0f4ef467da92c7) (Built Nov 12 2024 16:24:12) 租户mysql模式。日志现在取不到。

AntTech_TELDKS · 2025 年7 月 8 日 10:16

[2025-07-07 09:07:50.988631] WDIAG [STORAGE.TRANS] start_access (ob_trans_part_ctx.cpp:7424) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=13][errcode=-6220] stale access operation(ret=-6220, tx_desc.op_sn=4, last_op_sn=5, this={this:0x7f0f3ce91b50, trans_id:{txid:11323793}, tenant_id:1038, is_exiting:false, trans_expired_time:1751854070944217, cluster_version:17180000522, trans_need_wait_wrap:{receive_gts_ts_:[mts=0], need_wait_interval_us:0}, stc:[mts=0], ctx_create_time:1751850470982133}{ls_id:{id:1002}, session_id:3223276369, part_trans_action:2, pending_write:0, exec_info:{state:10, upstream:{id:-1}, participants:[], incremental_participants:[], prev_record_lsn:{lsn:18446744073709551615}, redo_lsns:[], redo_log_no:0, multi_data_source:[], scheduler:“10.x.x.14:2882”, prepare_version:{val:18446744073709551615, v:3}, trans_type:0, next_log_entry_no:0, max_applied_log_ts:{val:18446744073709551615, v:3}, max_applying_log_ts:{val:18446744073709551615, v:3}, max_applying_part_log_no:9223372036854775807, max_submitted_seq_no:0, checksum:0, checksum_scn:{val:0, v: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:0}, is_leaf():false, is_root():false, busy_cbs_.get_size():0, final_log_cb_:{ObTxBaseLogCb:{base_ts:{val:18446744073709551615, v:3}, log_ts:{val:18446744073709551615, v:3}, lsn:{lsn:18446744073709551615}, submit_ts:0}, this:0x7f0f3ce94b08, is_inited_:true, trans_id:{txid:11323793}, ls_id:{id:1002}, ctx:0x7f0f3ce91b50, tx_data_guard:{tx_data:NULL}, is_callbacked_:false, is_dynamic_:false, mds_range_:{range_array_.count():0, range_array_:[]}, cb_arg_array_:[], first_part_scn_:{val:18446744073709551615, v:3}}, ctx_tx_data_:{ctx_mgr_:0x7f51c0404030, tx_data_guard_:{tx_data:{tx_id:{txid:11323793}, ref_cnt:1, state:“RUNNING”, commit_version:{val:18446744073709551615, v:3}, start_scn:{val:18446744073709551615, v:3}, end_scn:{val:18446744073709551615, v:3}, undo_status_list:{head:null, undo_node_cnt:0{}}}}, read_only_:false}, role_state_:0, start_replay_ts_:{val:18446744073709551615, v:3}, start_recover_ts_:{val:18446744073709551615, v:3}, is_incomplete_replay_ctx_:false, mt_ctx_:{ObIMvccCtx={alloc_type=0 ctx_descriptor=0 min_table_version=1751684108593856 max_table_version=1751684108593856 trans_version={val:4611686018427387903, v:0} commit_version={val:0, v:0} lock_wait_start_ts=0 replay_compact_version={val:0, v:0}} end_code=0 tx_status=0 is_readonly=false ref=0 trans_id={txid:11323793} ls_id=1002 callback_alloc_count=12 callback_free_count=0 checksum=0 tmp_checksum=0 checksum_scn={val:0, v:0} redo_filled_count=0 redo_sync_succ_count=0 redo_sync_fail_count=0 main_list_length=14 unsynced_cnt=12 unsubmitted_cnt_=12 cb_statistics:[main=14, slave=0, merge=0, tx_end=0, rollback_to=0, fast_commit=0, remove_memtable=0]}, coord_prepare_info_arr_:[], upstream_state:10, retain_cause:-1, 2pc_role:-1, collected:[], ref:2, rec_log_ts:{val:18446744073709551615, v:3}, prev_rec_log_ts:{val:18446744073709551615, v:3}, lastest_snapshot:{val:18446744073709551615, v:3}, state_info_array:[], last_request_ts:1751850470984245, block_frozen_memtable:null}, tx_desc={this:0x7f57949c9f20, tx_id:{txid:11323793}, state:3, addr:“10.x.x.14:2882”, tenant_id:1038, session_id:3223276369, assoc_session_id:3221930437, 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, v:3}, snapshot_scn:0, active_scn:1751850470944218, op_sn:4, alloc_ts:1751850470881852, active_ts:1751850470944217, commit_ts:-1, finish_ts:-1, timeout_us:3600000000, lock_timeout_us:1800000000, expire_ts:1751854070944217, coord_id:{id:-1}, parts:[{id:{id:1003}, addr:“10.x.x.14:2882”, epoch:513165850978092, first_scn:1751850470944218, last_scn:1751850470946344, last_touch_ts:0}], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1733986452, cluster_version:17180000522, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:true, can_elr:true, cflict_txs:[], abort_cause:0, commit_expire_ts:-1, commit_task_.is_registered():false, modified_tables:[], ref:2})
[2025-07-07 09:07:50.988811] WDIAG [STORAGE.TRANS] get_write_store_ctx (ob_trans_service_v4.cpp:1131) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=177][errcode=-6220] tx ctx start access fail(ret=-6220, tx_ctx=0x7f0f3ce91b50, ls_id={id:1002}, this={is_inited_:true, tenant_id_:1038, this:0x7f0f3a204030})
[2025-07-07 09:07:50.988826] WDIAG [STORAGE] get_write_store_ctx_guard_ (ob_access_service.cpp:363) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=14][errcode=-6220] can not get write store ctx(ret=-6220, ls_id={id:1002}, snapshot={this:0x7f0f320cd2a8, valid:true, source:1, core:{version:{val:1751850470988059249, v:0}, tx_id:{txid:11323793}, scn:1751850470987557}, uncertain_bound:1751850470988104, snapshot_lsid:{id:-1}, snapshot_ls_role:0, parts:[{left:{id:1003}, right:513165850978092}], committed:false}, tx_desc={this:0x7f57949c9f20, tx_id:{txid:11323793}, state:3, addr:“10.x.x.14:2882”, tenant_id:1038, session_id:3223276369, assoc_session_id:3221930437, 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, v:3}, snapshot_scn:0, active_scn:1751850470944218, op_sn:4, alloc_ts:1751850470881852, active_ts:1751850470944217, commit_ts:-1, finish_ts:-1, timeout_us:3600000000, lock_timeout_us:1800000000, expire_ts:1751854070944217, coord_id:{id:-1}, parts:[{id:{id:1003}, addr:“10.x.x.14:2882”, epoch:513165850978092, first_scn:1751850470944218, last_scn:1751850470946344, last_touch_ts:0}], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1733986452, cluster_version:17180000522, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:true, can_elr:true, cflict_txs:[], abort_cause:0, commit_expire_ts:-1, commit_task_.is_registered():false, modified_tables:[], ref:2})
[2025-07-07 09:07:50.988867] WDIAG [STORAGE] check_write_allowed_ (ob_access_service.cpp:595) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=41][errcode=-6220] get write store ctx failed(ret=-6220, ls_id={id:1002}, dml_param={timeout:1751854070887758, schema_version:1751680142937632, sql_mode:2097152, is_total_quantity_log:true, table_param:{tenant_schema_version:1751734231760008, data_table:{table_id:520263, schema_version:1751680142937632, table_type:3, index_type:13, index_status:8, shadow_rowkey_column_num:0, fulltext_col_id:18446744073709551615, index_name:"", pk_name:"", columns:[{column_id:19, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:17, meta_type:{type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:11, 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:18, meta_type:{type:“DATETIME”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:22, scale:3}, 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:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:8, scale:2}, 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:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:8, scale:2}, 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:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:15, 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:25, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:false}, {column_id:26, meta_type:{type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:64, 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:27, meta_type:{type:“BIT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:1, scale:0}, orig_default_value:{“NULL”:“NULL”}, cur_default_value:{“BIT”: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}], read_info:{schema_column_count:12, schema_rowkey_cnt:1, rowkey_cnt:3, trans_col_index:-1, seq_read_column_count:1, max_col_index:13, is_oracle_mode:false, cols_index:{rowkey_mode:false, for_memtable:false, array:{ObIArray:[0, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13], data:0x7f2e0f513c70, count:12, allocator:0x7f21537066b0, capacity:12, init_cnt:12}}, memtable_cols_index:{rowkey_mode:false, for_memtable:true, array:{ObIArray:[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11], data:0x7f2e0f513cb0, count:12, allocator:0x7f21537066b0, capacity:12, init_cnt:12}}, cols_desc:{ObIArray:[column_id=19 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=16 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=17 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=18 {type:“DATETIME”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=20 {type:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=21 {type:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=22 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=23 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=24 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=25 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=26 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=27 {type:“BIT”, collation:“binary”, coercibility:“NUMERIC”} order=0], data:0x7f2e0f513bd0, count:12, allocator:0x7f21537066b0, capacity:12, init_cnt:12}, datum_utils:{is_oracle_mode:false, rowkey_cnt:3, col_cnt:14, is_inited:true, is_oracle_mode:false}, cols_param:[{column_id:19, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:17, meta_type:{type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:11, 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:18, meta_type:{type:“DATETIME”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:22, scale:3}, 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:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:8, scale:2}, 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:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:8, scale:2}, 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:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:15, 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:25, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:false}, {column_id:26, meta_type:{type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:64, 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:27, meta_type:{type:“BIT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:1, scale:0}, orig_default_value:{“NULL”:“NULL”}, cur_default_value:{“BIT”: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}]}, lob_inrow_threshold:4096}, col_descs:[column_id=19 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=16 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=17 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=18 {type:“DATETIME”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=20 {type:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=21 {type:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=22 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=23 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=24 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=25 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=26 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=27 {type:“BIT”, collation:“binary”, coercibility:“NUMERIC”} order=0], col_map:{is_inited_:true, use_array_:true, shadow_use_array_:false, has_:true, has_shadow_:false}}, tenant_schema_version:1751820837533808, is_ignore:false, prelock:false, encrypt_meta:[], is_batch_stmt:false, write_flag:{is_table_api:0, is_table_lock:0, is_mds:0, is_dml_batch_opt:0, is_insert_up:0, is_write_only_index:0, is_check_row_locked:0}, spec_seq_no:0, snapshot:{this:0x7f0f320cd2a8, valid:true, source:1, core:{version:{val:1751850470988059249, v:0}, tx_id:{txid:11323793}, scn:1751850470987557}, uncertain_bound:1751850470988104, snapshot_lsid:{id:-1}, snapshot_ls_role:0, parts:[{left:{id:1003}, right:513165850978092}], committed:false}, check_schema_version:true}, tx_desc={this:0x7f57949c9f20, tx_id:{txid:11323793}, state:3, addr:“10.x.x.14:2882”, tenant_id:1038, session_id:3223276369, assoc_session_id:3221930437, 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, v:3}, snapshot_scn:0, active_scn:1751850470944218, op_sn:4, alloc_ts:1751850470881852, active_ts:1751850470944217, commit_ts:-1, finish_ts:-1, timeout_us:3600000000, lock_timeout_us:1800000000, expire_ts:1751854070944217, coord_id:{id:-1}, parts:[{id:{id:1003}, addr:“10.x.x.14:2882”, epoch:513165850978092, first_scn:1751850470944218, last_scn:1751850470946344, last_touch_ts:0}], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1733986452, cluster_version:17180000522, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:true, can_elr:true, cflict_txs:[], abort_cause:0, commit_expire_ts:-1, commit_task_.is_registered():false, modified_tables:[], ref:2})
[2025-07-07 09:07:50.989164] WDIAG [STORAGE] update_rows (ob_access_service.cpp:913) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=296][errcode=-6220] fail to check query allowed(ret=-6220, ls_id={id:1002}, tablet_id={id:206410})
[2025-07-07 09:07:50.989174] WDIAG [SQL.DAS] write_rows (ob_das_update_op.cpp:281) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=8][errcode=-6220] update row to partition storage failed(ret=-6220)
[2025-07-07 09:07:50.989180] WDIAG [SQL.DAS] write_tablet (ob_dml_service.h:335) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=5][errcode=-6220] write rows failed(ret=-6220, ls_id_={id:1002}, tablet_id_={id:206410}, ctdef_->table_id_=18446744073709551614, ctdef_->index_tid_=520263)
[2025-07-07 09:07:50.989189] WDIAG [SQL.DAS] open_op (ob_das_update_op.cpp:317) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=8][errcode=-6220] update row to partition storage failed(ret=-6220)
[2025-07-07 09:07:50.989231] WDIAG [SQL.DAS] start_das_task (ob_das_task.cpp:239) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=41][errcode=-6220] open das task op failed(ret=-6220)
[2025-07-07 09:07:50.989238] WDIAG [SQL.DAS] do_local_das_task (ob_data_access_service.cpp:386) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=6][errcode=-6220] start local das task failed(ret=-6220)

AntTech_TELDKS · 2025 年7 月 8 日 10:17

[2025-07-07 09:07:50.989244] WDIAG [SQL.DAS] execute_dist_das_task (ob_data_access_service.cpp:185) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=5][errcode=-6220] do local das task failed(ret=-6220, task_arg={timeout_ts:1751854070987758, ctrl_svr:“10.x.x.10:2882”, runner_svr:“10.x.x.10:2882”, task_ops:[{parent:{tenant_id:1038, task_id:370699585, op_type:3, errcode:-6220, can_part_retry:0, task_started:1, in_part_retry:0, in_stmt_retry:0, need_switch_param:0, trans_desc:{this:0x7f57949c9f20, tx_id:{txid:11323793}, state:3, addr:“10.x.x.14:2882”, tenant_id:1038, session_id:3223276369, assoc_session_id:3221930437, 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, v:3}, snapshot_scn:0, active_scn:1751850470944218, op_sn:4, alloc_ts:1751850470881852, active_ts:1751850470944217, commit_ts:-1, finish_ts:-1, timeout_us:3600000000, lock_timeout_us:1800000000, expire_ts:1751854070944217, coord_id:{id:-1}, parts:[{id:{id:1003}, addr:“10.x.x.14:2882”, epoch:513165850978092, first_scn:1751850470944218, last_scn:1751850470946344, last_touch_ts:0}], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1733986452, cluster_version:17180000522, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:true, can_elr:true, cflict_txs:[], abort_cause:0, commit_expire_ts:-1, commit_task_.is_registered():false, modified_tables:[], ref:2}, snapshot:{this:0x7f0f320d1e18, valid:true, source:1, core:{version:{val:1751850470988059249, v:0}, tx_id:{txid:11323793}, scn:1751850470987557}, uncertain_bound:1751850470988104, snapshot_lsid:{id:-1}, snapshot_ls_role:0, parts:[{left:{id:1003}, right:513165850978092}], committed:false}, tablet_id:{id:206410}, ls_id:{id:1002}, tablet_loc:{tablet_id:{id:206410}, ls_id:{id:1002}, server:“10.x.x.10:2882”, in_retry:0, partition_id:520263, first_level_part_id:18446744073709551615}, related_ctdefs:[{ObDASBaseCtDef:{ObDASBaseDef:{op_type:3}, table_id:18446744073709551614, index_tid:520264, schema_version:1751680110535584, rowkey_cnt:2, spk_cnt:0, column_ids:[16, 19], column_types:[{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“INT”, collation:“binary”, coercibility:“NUMERIC”}], column_accuracys:[{length:-1, precision:11, scale:0}, {length:-1, precision:11, scale:0}], old_row_projector:[1, 0], new_row_projector:[14, 0], is_total_quantity_log:1, is_ignore:0, is_batch_stmt:0, is_insert_up:0, is_table_api:0, tz_info:{id:-1, offset:28800, error_on_overlap_time:false}, table_param:{tenant_schema_version:1751734231760008, data_table:{table_id:520264, schema_version:1751680110535584, table_type:5, index_type:1, index_status:2, shadow_rowkey_column_num:0, fulltext_col_id:18446744073709551615, index_name:“IE1_timesheet_confirm”, pk_name:"", columns:[{column_id:16, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:19, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:2, schema_rowkey_cnt:2, rowkey_cnt:4, trans_col_index:-1, seq_read_column_count:2, max_col_index:1, is_oracle_mode:false, cols_index:{rowkey_mode:false, for_memtable:false, array:{ObIArray:[0, 1], data:0x7f2e0f514a20, count:2, allocator:0x7f21537066b0, capacity:2, init_cnt:2}}, memtable_cols_index:{rowkey_mode:false, for_memtable:true, array:{ObIArray:[0, 1], data:0x7f2e0f514a30, count:2, allocator:0x7f21537066b0, capacity:2, init_cnt:2}}, cols_desc:{ObIArray:[column_id=16 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=19 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0], data:0x7f2e0f514a00, count:2, allocator:0x7f21537066b0, capacity:2, init_cnt:2}, datum_utils:{is_oracle_mode:false, rowkey_cnt:4, col_cnt:4, is_inited:true, is_oracle_mode:false}, cols_param:[{column_id:16, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:19, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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}]}, lob_inrow_threshold:4096}, col_descs:[column_id=16 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=19 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0], col_map:{is_inited_:true, use_array_:true, shadow_use_array_:false, has_:true, has_shadow_:false}}, encrypt_meta:[]}, updated_column_ids:[16]}, {ObDASBaseCtDef:{ObDASBaseDef:{op_type:3}, table_id:18446744073709551614, index_tid:520265, schema_version:1751680110535592, rowkey_cnt:5, spk_cnt:0, column_ids:[22, 23, 24, 17, 19], column_types:[{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, {type:“INT”, collation:“binary”, coercibility:“NUMERIC”}], column_accuracys:[{length:-1, precision:11, scale:0}, {length:-1, precision:11, scale:0}, {length:15, precision:-1, scale:-1}, {length:11, precision:-1, scale:-1}, {length:-1, precision:11, scale:0}], old_row_projector:[6, 7, 8, 2, 0], new_row_projector:[17, 18, 19, 12, 0], is_total_quantity_log:1, is_ignore:0, is_batch_stmt:0, is_insert_up:0, is_table_api:0, tz_info:{id:-1, offset:28800, error_on_overlap_time:false}, table_param:{tenant_schema_version:1751734231760008, data_table:{table_id:520265, schema_version:1751680110535592, table_type:5, index_type:1, index_status:2, shadow_rowkey_column_num:0, fulltext_col_id:18446744073709551615, index_name:“IE2_timesheet_confirm”, pk_name:"", columns:[{column_id:22, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:15, 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:17, meta_type:{type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:11, 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:19, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:5, rowkey_cnt:7, trans_col_index:-1, seq_read_column_count:5, max_col_index:4, is_oracle_mode:false, cols_index:{rowkey_mode:false, for_memtable:false, array:{ObIArray:[0, 1, 2, 3, 4], data:0x7f2e0f515600, count:5, allocator:0x7f21537066b0, capacity:5, init_cnt:5}}, memtable_cols_index:{rowkey_mode:false, for_memtable:true, array:{ObIArray:[0, 1, 2, 3, 4], data:0x7f2e0f515620, count:5, allocator:0x7f21537066b0, capacity:5, init_cnt:5}}, cols_desc:{ObIArray:[column_id=22 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=23 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=24 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=17 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=19 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0], data:0x7f2e0f5155c0, count:5, allocator:0x7f21537066b0, capacity:5, init_cnt:5}, datum_utils:{is_oracle_mode:false, rowkey_cnt:7, col_cnt:7, is_inited:true, is_oracle_mode:false}, cols_param:[{column_id:22, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:15, 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:17, meta_type:{type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:11, 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:19, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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}]}, lob_inrow_threshold:4096}, col_descs:[column_id=22 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=23 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=24 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=17 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=19 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0], col_map:{is_inited_:true, use_array_:true, shadow_use_array_:false, has_:true, has_shadow_:false}}, encrypt_meta:[]}, updated_column_ids:[17, 22, 23, 24]}], related_rtdefs:[{ObDASBaseRtDef:{op_type:3}, timeout_ts:1751854070887758, sql_mode:2097152, prelock:false, tenant_schema_version:1751820837533808, is_for_foreign_key_check:false, affected_rows:0}, {ObDASBaseRtDef:{op_type:3}, timeout_ts:1751854070887758, sql_mode:2097152, prelock:false, tenant_schema_version:1751820837533808, is_for_foreign_key_check:false, affected_rows:0}], task_status:1, related_tablet_ids:[{id:1152921504606853842}, {id:1152921504606853843}], das_task_node:}, upd_ctdef:{ObDASBaseCtDef:{ObDASBaseDef:{op_type:3}, table_id:18446744073709551614, index_tid:520263, schema_version:1751680142937632, rowkey_cnt:1, spk_cnt:0, column_ids:[19, 16, 17, 18, 20, 21, 22, 23, 24, 25, 26, 27], column_types:[{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, {type:“DATETIME”, collation:“binary”, coercibility:“NUMERIC”}, {type:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”}, {type:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”}, {type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, {type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, {type:“BIT”, collation:“binary”, coercibility:“NUMERIC”}], column_accuracys:[{length:-1, precision:11, scale:0}, {length:-1, precision:11, scale:0}, {length:11, precision:-1, scale:-1}, {length:-1, precision:22, scale:3}, {length:-1, precision:8, scale:2}, {length:-1, precision:8, scale:2}, {length:-1, precision:11, scale:0}, {length:-1, precision:11, scale:0}, {length:15, precision:-1, scale:-1}, {length:-1, precision:11, scale:0}, {length:64, precision:-1, scale:-1}, {length:-1, precision:1, scale:0}], old_row_projector:[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11], new_row_projector:[0, 14, 12, 13, 15, 16, 17, 18, 19, 20, 21, 22], is_total_quantity_log:1, is_ignore:0, is_batch_stmt:0, is_insert_up:0, is_table_api:0, tz_info:{id:-1, offset:28800, error_on_overlap_time:false}, table_param:{tenant_schema_version:1751734231760008, data_table:{table_id:520263, schema_version:1751680142937632, table_type:3, index_type:13, index_status:8, shadow_rowkey_column_num:0, fulltext_col_id:18446744073709551615, index_name:"", pk_name:"", columns:[{column_id:19, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:17, meta_type:{type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:11, 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:18, meta_type:{type:“DATETIME”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:22, scale:3}, 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:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:8, scale:2}, 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:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:8, scale:2}, 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:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:15, 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:25, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:false}, {column_id:26, meta_type:{type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:64, 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:27, meta_type:{type:“BIT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:1, scale:0}, orig_default_value:{“NULL”:“NULL”}, cur_default_value:{“BIT”: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}], read_info:{schema_column_count:12, schema_rowkey_cnt:1, rowkey_cnt:3, trans_col_index:-1, seq_read_column_count:1, max_col_index:13, is_oracle_mode:false, cols_index:{rowkey_mode:false, for_memtable:false, array:{ObIArray:[0, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13], data:0x7f2e0f513c70, count:12, allocator:0x7f21537066b0, capacity:12, init_cnt:12}}, memtable_cols_index:{rowkey_mode:false, for_memtable:true, array:{ObIArray:[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11], data:0x7f2e0f513cb0, count:12, allocator:0x7f21537066b0, capacity:12, init_cnt:12}}, cols_desc:{ObIArray:[column_id=19 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=16 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=17 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=18 {type:“DATETIME”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=20 {type:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=21 {type:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=22 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=23 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=24 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=25 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=26 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=27 {type:“BIT”, collation:“binary”, coercibility:“NUMERIC”} order=0], data:0x7f2e0f513bd0, count:12, allocator:0x7f21537066b0, capacity:12, init_cnt:12}, datum_utils:{is_oracle_mode:false, rowkey_cnt:3, col_cnt:14, is_inited:true, is_oracle_mode:false}, cols_param:[{column_id:19, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:17, meta_type:{type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:11, 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:18, meta_type:{type:“DATETIME”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:22, scale:3}, 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:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:8, scale:2}, 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:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:8, scale:2}, 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:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:15, 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:25, meta_type:{type:“INT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:11, 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:false}, {column_id:26, meta_type:{type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”}, order:0, accuracy:{length:64, 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:27, meta_type:{type:“BIT”, collation:“binary”, coercibility:“NUMERIC”}, order:0, accuracy:{length:-1, precision:1, scale:0}, orig_default_value:{“NULL”:“NULL”}, cur_default_value:{“BIT”: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}]}, lob_inrow_threshold:4096}, col_descs:[column_id=19 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=16 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=17 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=18 {type:“DATETIME”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=20 {type:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=21 {type:“DECIMAL”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=22 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=23 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=24 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=25 {type:“INT”, collation:“binary”, coercibility:“NUMERIC”} order=0, column_id=26 {type:“VARCHAR”, collation:“utf8mb4_general_ci”, coercibility:“INVALID”} order=0, column_id=27 {type:“BIT”, collation:“binary”, coercibility:“NUMERIC”} order=0], col_map:{is_inited_:true, use_array_:true, shadow_use_array_:false, has_:true, has_shadow_:false}}, encrypt_meta:[]}, updated_column_ids:[17, 18, 16, 20, 21, 22, 23, 24, 25, 26, 27]}, upd_rtdef:{ObDASBaseRtDef:{op_type:3}, timeout_ts:1751854070887758, sql_mode:2097152, prelock:false, tenant_schema_version:1751820837533808, is_for_foreign_key_check:false, affected_rows:0}, write_buffer:{mem_attr:tenant_id=1038, label=DASUpdateBuffer, ctx_id=0, prio=0, buffer_memory:538, buffer_size:1, datum_store:NULL}}], remote_info:NULL})
[2025-07-07 09:07:50.989632] WDIAG [SQL.DAS] execute_das_task (ob_data_access_service.cpp:111) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=387][errcode=-6220] failed to execute dist das task(ret=-6220)
[2025-07-07 09:07:50.989639] WDIAG [SQL.DAS] execute_all_task (ob_das_ref.cpp:268) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=5][errcode=-6220] failed to execute aggregated das task(ret=-6220, ret=“OB_TRANS_SQL_SEQUENCE_ILLEGAL”, aggregated_task={server:“10.x.x.10:2882”, high_priority_tasks_.get_size():0, tasks_.get_size():0, failed_tasks_.get_size():1, success_tasks_.get_size():0}, async=true)
[2025-07-07 09:07:50.989649] WDIAG [SQL.ENG] submit_all_dml_task (ob_table_modify_op.cpp:1143) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=9][errcode=-6220] execute all dml das task failed(ret=-6220)
[2025-07-07 09:07:50.989655] WDIAG [SQL.ENG] inner_get_next_row (ob_table_modify_op.cpp:1236) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=5][errcode=-6220] failed to submit the remaining dml tasks(ret=-6220)
[2025-07-07 09:07:50.989660] WDIAG [SQL.ENG] get_next_row (ob_operator.cpp:1089) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=4][errcode=-6220] inner get next row failed(ret=-6220, type=25, op=“PHY_UPDATE”, op_id=0)
[2025-07-07 09:07:50.989669] WDIAG [SQL.EXE] get_next_row (ob_execute_result.cpp:147) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=7][errcode=-6220] get next row from operator failed(ret=-6220)
[2025-07-07 09:07:50.989676] WDIAG [SQL] inner_get_next_row (ob_result_set.cpp:411) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=6][errcode=-6220] get next row from exec result failed(ret=-6220)
[2025-07-07 09:07:50.989684] WDIAG [SQL] drive_dml_query (ob_result_set.cpp:1464) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=7][errcode=-6220] do dml query failed(ret=-6220)
[2025-07-07 09:07:50.989689] WDIAG [SQL] open_result (ob_result_set.cpp:214) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=5][errcode=-6220] fail to drive dml query(ret=-6220)
[2025-07-07 09:07:50.989694] WDIAG [SQL] open (ob_result_set.cpp:160) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=5][errcode=-6220] open result set failed(ret=-6220)
[2025-07-07 09:07:50.989702] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:955) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=6][errcode=-6220] [RETRY] check if need retry(v={force_local_retry:false, stmt_retry_times:0, local_retry_times:0, err_:-6220, err_:“OB_TRANS_SQL_SEQUENCE_ILLEGAL”, retry_type:0, client_ret:-6220}, need_retry=false, THIS_WORKER.can_retry()=true, v.ctx_.multi_stmt_item_={is_part_of_multi_stmt:false, seq_num:0, sql:“update table_xxx set Status=‘Withdraw’, StatusTs=‘2025-07-07 09:07:50.109’,PeriodId=51592791 where ConfirmId=22726”, batched_queries:NULL, is_ps_mode:false, ab_cnt:0})

AntTech_TELDKS · 2025 年7 月 8 日 10:17

[2025-07-07 09:07:50.989726] WDIAG [SERVER] response_result (ob_sync_plan_driver.cpp:82) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=23][errcode=-6220] result set open failed, check if need retry(ret=-6220, cli_ret=-6220, retry_ctrl_.need_retry()=0)
[2025-07-07 09:07:50.989750] INFO [DETECT] maintain_deadlock_info_when_end_stmt (ob_trans_deadlock_adapter.cpp:646) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=7] try unregister deadlock detecotr cause conflict array is empty(step=9, ret=0, ret=“OB_SUCCESS”, exec_ctx.get_errcode()=-6220, exec_ctx.get_errcode()=“OB_TRANS_SQL_SEQUENCE_ILLEGAL”, session={this:0x7f57984ca1f8, id:3221930437, deser:false, tenant:“app_t01”, tenant_id:1038, effective_tenant:“app_t01”, effective_tenant_id:1038, database:“testdb”, user:“app_user1@%”, consistency_level:3, session_state:2, autocommit:false, tx:0x7f57949c9f20}, desc={this:0x7f57949c9f20, tx_id:{txid:11323793}, state:3, addr:“10.x.x.14:2882”, tenant_id:1038, session_id:3223276369, assoc_session_id:3221930437, 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, v:3}, snapshot_scn:0, active_scn:1751850470944218, op_sn:4, alloc_ts:1751850470881852, active_ts:1751850470944217, commit_ts:-1, finish_ts:-1, timeout_us:3600000000, lock_timeout_us:1800000000, expire_ts:1751854070944217, coord_id:{id:-1}, parts:[{id:{id:1003}, addr:“10.x.x.14:2882”, epoch:513165850978092, first_scn:1751850470944218, last_scn:1751850470946344, last_touch_ts:0}], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1733986452, cluster_version:17180000522, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:true, can_elr:true, cflict_txs:[], abort_cause:0, commit_expire_ts:-1, commit_task_.is_registered():false, modified_tables:[], ref:2}, is_rollback=true, conflict_txs=[])
[2025-07-07 09:07:50.989787] INFO [DETECT] maintain_deadlock_info_when_end_stmt (ob_trans_deadlock_adapter.cpp:670) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=37] maintain deadlock info(step=9, ret=0, ret=“OB_SUCCESS”, exec_ctx.get_errcode()=-6220, exec_ctx.get_errcode()=“OB_TRANS_SQL_SEQUENCE_ILLEGAL”, session={this:0x7f57984ca1f8, id:3221930437, deser:false, tenant:“app_t01”, tenant_id:1038, effective_tenant:“app_t01”, effective_tenant_id:1038, database:“testdb”, user:“app_user1@%”, consistency_level:3, session_state:2, autocommit:false, tx:0x7f57949c9f20}, desc={this:0x7f57949c9f20, tx_id:{txid:11323793}, state:3, addr:“10.x.x.14:2882”, tenant_id:1038, session_id:3223276369, assoc_session_id:3221930437, 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, v:3}, snapshot_scn:0, active_scn:1751850470944218, op_sn:4, alloc_ts:1751850470881852, active_ts:1751850470944217, commit_ts:-1, finish_ts:-1, timeout_us:3600000000, lock_timeout_us:1800000000, expire_ts:1751854070944217, coord_id:{id:-1}, parts:[{id:{id:1003}, addr:“10.x.x.14:2882”, epoch:513165850978092, first_scn:1751850470944218, last_scn:1751850470946344, last_touch_ts:0}], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1733986452, cluster_version:17180000522, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:true, can_elr:true, cflict_txs:[], abort_cause:0, commit_expire_ts:-1, commit_task_.is_registered():false, modified_tables:[], ref:2}, is_rollback=true, conflict_txs=[])
[2025-07-07 09:07:50.989818] INFO [STORAGE.TRANS] rollback_savepoint_ (ob_tx_api.cpp:1417) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=28] empty rollback participant set(tx={this:0x7f57949c9f20, tx_id:{txid:11323793}, state:3, addr:“10.x.x.14:2882”, tenant_id:1038, session_id:3223276369, assoc_session_id:3221930437, 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, v:3}, snapshot_scn:0, active_scn:1751850470944218, op_sn:5, alloc_ts:1751850470881852, active_ts:1751850470944217, commit_ts:-1, finish_ts:-1, timeout_us:3600000000, lock_timeout_us:1800000000, expire_ts:1751854070944217, coord_id:{id:-1}, parts:[{id:{id:1003}, addr:“10.x.x.14:2882”, epoch:513165850978092, first_scn:1751850470944218, last_scn:1751850470946344, last_touch_ts:0}], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1733986452, cluster_version:17180000522, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:true, can_elr:true, cflict_txs:[], abort_cause:0, commit_expire_ts:-1, commit_task_.is_registered():false, modified_tables:[], ref:2}, savepoint=1751850470986358)
[2025-07-07 09:07:50.989859] INFO [SQL.EXE] end_stmt (ob_sql_trans_control.cpp:1170) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=38] end stmt(ret=0, plain_select=false, stmt_type=5, savepoint=1751850470986358, tx_desc={this:0x7f57949c9f20, tx_id:{txid:11323793}, state:3, addr:“10.x.x.14:2882”, tenant_id:1038, session_id:3223276369, assoc_session_id:3221930437, 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, v:3}, snapshot_scn:0, active_scn:1751850470944218, op_sn:6, alloc_ts:1751850470881852, active_ts:1751850470944217, commit_ts:-1, finish_ts:-1, timeout_us:3600000000, lock_timeout_us:1800000000, expire_ts:1751854070944217, coord_id:{id:-1}, parts:[{id:{id:1003}, addr:“10.x.x.14:2882”, epoch:513165850978092, first_scn:1751850470944218, last_scn:1751850470946344, last_touch_ts:0}], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1733986452, cluster_version:17180000522, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:true, can_elr:true, cflict_txs:[], abort_cause:0, commit_expire_ts:-1, commit_task_.is_registered():false, modified_tables:[], ref:2}, trans_result={incomplete:false, parts:[], touched_ls_list:[], cflict_txs:[]}, rollback=true, need_rollback=true, session={this:0x7f57984ca1f8, id:3221930437, deser:false, tenant:“app_t01”, tenant_id:1038, effective_tenant:“app_t01”, effective_tenant_id:1038, database:“testdb”, user:“app_user1@%”, consistency_level:3, session_state:2, autocommit:false, tx:0x7f57949c9f20}, exec_ctx.get_errcode()=-6220)
[2025-07-07 09:07:50.989893] WDIAG [SERVER] response_result (ob_sync_plan_driver.cpp:92) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=31][errcode=-6220] close result set fail(cret=-6220)
[2025-07-07 09:07:50.989906] INFO [SERVER] send_error_packet (obmp_packet_sender.cpp:319) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=5] sending error packet(ob_error=-6220, client error=-6220, extra_err_info=NULL, lbt()=“0x1388db15 0xaca65c0 0xac52ce2 0x558f6f7 0x554da20 0x5546296 0x55391ca 0x552223c 0xa95df64 0x13b4953f 0x7f625ab39d0b 0x7f625aa7bb00”)
[2025-07-07 09:07:50.989961] INFO [SERVER] send_error_packet (obmp_packet_sender.cpp:502) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=10] dump txn free route audit_record(value=131109, session->get_sessid()=3221930437, session->get_proxy_sessid()=1591583046065423594)
[2025-07-07 09:07:50.989972] WDIAG [SERVER] do_process (obmp_query.cpp:808) [2460160][T1038_L0_G0][T1038][YB420A43625A-00062F07716C655D-0-0] [lt=9][errcode=-6220] execute query fail(ret=-6220, timeout_timestamp=1751854070987758)

AntTech_TELDKS · 2025 年7 月 8 日 10:28

ob日志1.txt (57.4 KB)

淇铭 · 2025 年7 月 8 日 15:20

上面的日志是不同节点的日志信息么？你更新的时候有列值互换么其单表更新是自左到右依次完成的

AntTech_TELDKS · 2025 年7 月 8 日 16:59

日志是同个节点同一个trace_id。update sql没有交换字段。java.sql.BatchUpdate 前后有多个sql,都是按主键 select/insert/update的简单sql，但是总是在上面提到那个update sql报错 6220 。
stale access operation(ret=-6220, tx_desc.op_sn=4, last_op_sn=5, …) 这句不知道什么意思

淇铭 · 2025 年7 月 8 日 17:12

更新的语句能发出来么？

AntTech_TELDKS · 2025 年7 月 8 日 18:23

update table_xxx set Status=?, StatusTs=?, PeriodId=?, … where ConfirmId=?

淇铭 · 2025 年7 月 9 日 13:35

找一条数据提供一下执行计划保存在文本里提供一下
explain extended update table_xxx set Status=?, StatusTs=?, PeriodId=?, … where ConfirmId=?

AntTech_TELDKS · 2025 年7 月 9 日 16:43

目前只是生产库才能重现到，测试库一样的数据库版本不能重现。

|ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)|

|0 |DISTRIBUTED UPDATE| |1 |37 |
|1 |└─TABLE GET |timesheet_confirm|1 |5 |

Outputs & filters:

0 - output(nil), filter(nil)
table_columns([{timesheet_confirm: ({timesheet_confirm: (timesheet_confirm.ConfirmId, timesheet_confirm.ResId, timesheet_confirm.Status, timesheet_confirm.StatusTS,
timesheet_confirm.TotalHour, timesheet_confirm.ConfirmHour, timesheet_confirm.TimeSheetPeriodId, timesheet_confirm.GroupObjId, timesheet_confirm.GroupObjType,
timesheet_confirm.WorkCategoryId, timesheet_confirm.PeriodName, timesheet_confirm.IsAlert4Reject)})}]),
update([timesheet_confirm.Status=column_conv(VARCHAR,utf8mb4_general_ci,length:11,NOT NULL,‘Withdraw’)], [timesheet_confirm.StatusTS=column_conv(DATETIME,
PS:(22,3),NOT NULL,cast(‘2025-07-07 09:07:50.109’, DATETIME(-1, -1)))], [timesheet_confirm.ResId=column_conv(INT,PS:(11,0),NOT NULL,cast(-134083, INT(-1,
0)))], [timesheet_confirm.TotalHour=column_conv(DECIMAL,PS:(8,2),NOT NULL,43.1)], [timesheet_confirm.ConfirmHour=column_conv(DECIMAL,PS:(8,2),NOT NULL,
43.1)], [timesheet_confirm.TimeSheetPeriodId=column_conv(INT,PS:(11,0),NOT NULL,cast(51592791, INT(-1, 0)))], [timesheet_confirm.GroupObjId=column_conv(INT,
PS:(11,0),NOT NULL,cast(526258, INT(-1, 0)))], [timesheet_confirm.GroupObjType=column_conv(VARCHAR,utf8mb4_general_ci,length:15,NOT NULL,‘Proj’)], [timesheet_confirm.WorkCategoryId=column_conv(INT,
PS:(11,0),NULL,cast(NULL, INT(-1, 0)))], [timesheet_confirm.PeriodName=column_conv(VARCHAR,utf8mb4_general_ci,length:64,NULL,‘2025年6月第四周（6.23~6.29）’)],
[timesheet_confirm.IsAlert4Reject=column_conv(BIT,PS:(1,0),NOT NULL,cast(0, BIT(-1, -1)))])
1 - output([timesheet_confirm.ConfirmId], [timesheet_confirm.Status], [timesheet_confirm.StatusTS], [timesheet_confirm.ResId], [timesheet_confirm.TotalHour],
[timesheet_confirm.ConfirmHour], [timesheet_confirm.TimeSheetPeriodId], [timesheet_confirm.GroupObjId], [timesheet_confirm.GroupObjType], [timesheet_confirm.WorkCategoryId],
[timesheet_confirm.PeriodName], [timesheet_confirm.IsAlert4Reject]), filter(nil), rowset=16
access([timesheet_confirm.ConfirmId], [timesheet_confirm.Status], [timesheet_confirm.StatusTS], [timesheet_confirm.ResId], [timesheet_confirm.TotalHour],
[timesheet_confirm.ConfirmHour], [timesheet_confirm.TimeSheetPeriodId], [timesheet_confirm.GroupObjId], [timesheet_confirm.GroupObjType], [timesheet_confirm.WorkCategoryId],
[timesheet_confirm.PeriodName], [timesheet_confirm.IsAlert4Reject]), partitions(p0)
is_index_back=false, is_global_index=false,
range_key([timesheet_confirm.ConfirmId]), range[22726 ; 22726],
range_cond([timesheet_confirm.ConfirmId = 22726])

淇铭 · 2025 年7 月 9 日 17:08

这个计划是生产库的执行计划么

淇铭 · 2025 年7 月 9 日 17:48

你现在提供是ip是10这个机器上的日志 14这个机器的日志能提供一下么？在查一下这个信息
select * from oceanbase.gv$ob_sql_audit where ret_code=’-6220’ order by REQUEST_TIME desc\G;
select * from oceanbase.gv$ob_sql_audit where trace_id=‘YB420A43625A-00062F07716C655D-0-0’ order by REQUEST_TIME desc\G;

淇铭 · 2025 年7 月 10 日 14:27

你好，你提的这个技术问题牵涉到OceanBase企业版范围内的功能细节；针对此类问题，建议你通过以下方式寻求帮助：

如你所在的企业客户已签署OceanBase企业版销售合同，请你联系客户经理；
如你所在的企业客户尚未签署OceanBase企业版销售合同，你可通过OceanBase官网商务咨询页面留下你的联系方式，OceanBase企业版的业务顾问会在一个工作日内与你联系。

另外，我们欢迎你使用社区版，并在论坛/社群中分享你对社区版本的想法、经验和问题，与其他社区成员共同交流。

SqlExceptionHelper: - SQL Error: 6220 SQL sequence illegal

目前只是生产库才能重现到，测试库一样的数据库版本不能重现。

|ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)|

|0 |DISTRIBUTED UPDATE| |1 |37 | |1 |└─TABLE GET |timesheet_confirm|1 |5 |

Outputs & filters:

|0 |DISTRIBUTED UPDATE| |1 |37 |
|1 |└─TABLE GET |timesheet_confirm|1 |5 |