observer.log.20241119145735554:[2024-11-19 14:57:11.414233] WDIAG [STORAGE] pushdown_operator (ob_integer_base_diff_decoder.cpp:264) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=13][errcode=-4007] Failed on EQ / NE operator(ret=-4007, col_ctx={obj_meta:{type:"INT UNSIGNED", collation:"binary", coercibility:"NUMERIC"}, micro_block_header:{magic:1005, version:2, header_size:104, header_checksum:-17758, column_count:5, rowkey_column_count:5, has_column_checksum:1, row_count:8070, row_store_type:1, opt:0, var_column_count:0, row_offset:18130, original_length:322800, max_merged_trans_version:0, data_length:18026, data_zlength:18026, data_checksum:4016190951, column_checksums:null, single_version_rows:0, contain_uncommitted_rows:0, is_last_row_last_flag:0, is_valid():true}, col_header:{version:0, type:4, attr:5, obj_type:9, extend_value_offset:0, offset:49, length:6}, allocator:0x7f870c4cac30, ref_decoder:null, ref_ctx:null})
observer.log.20241119145735554:[2024-11-19 14:57:11.658400] WDIAG [SQL] common_string_number (ob_datum_cast.cpp:1171) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=11][errcode=-5114] string_number failed(ret=-5114, in_type=22, out_type=15, cast_mode=352, in_str=276ATMA27F25-A717363942)
observer.log.20241119145735554:[2024-11-19 14:57:11.658416] WDIAG [SQL] string_number (ob_datum_cast.cpp:2825) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=15][errcode=-5114] fail to exec common_string_number(expr, ObString(child_res->len_, child_res->ptr_), tmp_alloc, nmb)(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658420] WDIAG [SQL.ENG] eval (ob_expr_frame_info.cpp:637) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=4][errcode=-5114] fail to exec rt_exprs_.at(expr_idx_).eval(*temp_expr_ctx, res_datum)(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658425] WDIAG [SQL.REWRITE] get_result_value (ob_query_range.cpp:6014) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=4][errcode=-5114] failed to eval temp expr(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658430] WDIAG [SQL.REWRITE] get_result_value_with_rowid (ob_query_range.cpp:6039) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=5][errcode=-5114] get param value failed(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658433] WDIAG [SQL.REWRITE] get_single_key_value (ob_query_range.cpp:7026) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=2][errcode=-5114] get result value failed(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658435] WDIAG [SQL.REWRITE] gen_simple_scan_range (ob_query_range.cpp:6903) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=2][errcode=-5114] get single key value failed(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658438] WDIAG [SQL.REWRITE] direct_get_tablet_ranges (ob_query_range.cpp:6820) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=3][errcode=-5114] fail to exec gen_simple_scan_range(allocator, exec_ctx, ranges, all_single_value_ranges, dtc_params)(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658443] WDIAG [SQL.REWRITE] get_tablet_ranges (ob_query_range.cpp:6655) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=5][errcode=-5114] get tablet ranges without deep copy failed(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658446] WDIAG [SQL.OPT] extract_pre_query_range (ob_sql_utils.cpp:2499) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=2][errcode=-5114] failed to get tablet ranges(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658449] WDIAG [SQL.ENG] prepare_single_scan_range (ob_table_scan_op.cpp:1128) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=2][errcode=-5114] failed to extract pre query ranges(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658454] WDIAG [SQL.ENG] prepare_batch_scan_range (ob_table_scan_op.cpp:1051) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=4][errcode=-5114] prepare single scan range failed(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658457] WDIAG [SQL.ENG] local_iter_rescan (ob_table_scan_op.cpp:1595) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=2][errcode=-5114] fail to prepare scan param(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658460] WDIAG [SQL.ENG] inner_rescan (ob_table_scan_op.cpp:1525) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=2][errcode=-5114] failed to get next row(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658462] WDIAG [SQL.ENG] rescan (ob_operator.cpp:810) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=2][errcode=-5114] failed to inner rescan(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658466] WDIAG [SQL.ENG] rescan_right (ob_group_join_buffer.cpp:473) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=3][errcode=-5114] rescan right failed(ret=-5114, ret="OB_INVALID_NUMERIC", i=0, right_cnt_=1)
observer.log.20241119145735554:[2024-11-19 14:57:11.658473] WDIAG [SQL.ENG] batch_fill_group_buffer (ob_group_join_buffer.cpp:654) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=6][errcode=-5114] rescan right failed(ret=-5114, ret="OB_INVALID_NUMERIC")
observer.log.20241119145735554:[2024-11-19 14:57:11.658477] WDIAG [SQL.ENG] group_get_left_batch (ob_nested_loop_join_op.cpp:784) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=3][errcode=-5114] batch fill group buffer failed(ret=-5114, ret="OB_INVALID_NUMERIC")
observer.log.20241119145735554:[2024-11-19 14:57:11.658482] WDIAG [SQL.ENG] get_left_batch (ob_nested_loop_join_op.cpp:630) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=5][errcode=-5114] fail to get left batch(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658485] WDIAG [SQL.ENG] inner_get_next_batch (ob_nested_loop_join_op.cpp:1025) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=3][errcode=-5114] fail to get left batch(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658488] WDIAG [SQL.ENG] get_next_batch (ob_operator.cpp:1190) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=2][errcode=-5114] get next batch failed(ret=-5114, eval_ctx={batch_idx:0, batch_size:256, max_batch_size:256, frames_:0x7f870c406c30}, id=1, op_name="PHY_NESTED_LOOP_JOIN")
observer.log.20241119145735554:[2024-11-19 14:57:11.658496] WDIAG [SQL.ENG] get_next_row (ob_operator.cpp:1531) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=8][errcode=-5114] get next batch failed(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658499] WDIAG [SQL.ENG] get_next_row_vectorizely (ob_operator.cpp:1459) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=3][errcode=-5114] Failed to get_next_row vectorizedly(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658503] WDIAG [SQL.ENG] get_next_row_from_child (ob_table_modify_op.cpp:1151) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=3][errcode=-5114] fail to get next row(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658508] WDIAG [SQL.ENG] inner_get_next_row (ob_table_modify_op.cpp:1172) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=4][errcode=-5114] fail to get next row(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658511] WDIAG [SQL.ENG] get_next_row (ob_operator.cpp:1084) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=2][errcode=-5114] inner get next row failed(ret=-5114, type=25, op="PHY_UPDATE", op_id=0)
observer.log.20241119145735554:[2024-11-19 14:57:11.658517] WDIAG [SQL.EXE] get_next_row (ob_execute_result.cpp:147) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=5][errcode=-5114] get next row from operator failed(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658520] WDIAG [SQL] inner_get_next_row (ob_result_set.cpp:411) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=3][errcode=-5114] get next row from exec result failed(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658525] WDIAG [SQL] drive_dml_query (ob_result_set.cpp:1448) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=5][errcode=-5114] do dml query failed(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658528] WDIAG [SQL] open_result (ob_result_set.cpp:214) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=3][errcode=-5114] fail to drive dml query(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658531] WDIAG [SQL] open (ob_result_set.cpp:160) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=3][errcode=-5114] open result set failed(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658544] WDIAG [SERVER] response_result (ob_async_plan_driver.cpp:63) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=4][errcode=-5114] failed to do result set open(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.658551] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:947) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=6][errcode=-5114] [RETRY] check if need retry(v={force_local_retry:false, stmt_retry_times:0, local_retry_times:0, err_:-5114, err_:"OB_INVALID_NUMERIC", retry_type:0, client_ret:-5114}, need_retry=false, THIS_WORKER.can_retry()=true, v.ctx_.multi_stmt_item_={is_part_of_multi_stmt:false, seq_num:0, sql:"update /*test112*/
observer.log.20241119145735554:[2024-11-19 14:57:11.659366] INFO  [DETECT] maintain_deadlock_info_when_end_stmt (ob_trans_deadlock_adapter.cpp:646) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=9] try unregister deadlock detecotr cause conflict array is empty(step=9, ret=0, ret="OB_SUCCESS", exec_ctx.get_errcode()=-5114, exec_ctx.get_errcode()="OB_INVALID_NUMERIC", session={this:0x7f86b34777d8, id:3221724009, deser:false, tenant:"mengxuan", tenant_id:1002, effective_tenant:"mengxuan", effective_tenant_id:1002, database:"trade_online", user:"mengxuan_admin@%", consistency_level:2, session_state:2, autocommit:true, tx:0x7f79f8ee5220}, desc={this:0x7f79f8ee5220, tx_id:{txid:17229229302}, state:1, addr:"172.26.49.129:2882", tenant_id:1002, session_id:3221724009, assoc_session_id:3221724009, 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:0, op_sn:2, alloc_ts:1731999431371259, active_ts:-1, commit_ts:-1, finish_ts:-1, timeout_us:86400000000, lock_timeout_us:-1, expire_ts:9223372036854775807, coord_id:{id:-1}, parts:[], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1714618933, cluster_version:17180000520, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:false, 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=[])
observer.log.20241119145735554:[2024-11-19 14:57:11.659412] INFO  [DETECT] maintain_deadlock_info_when_end_stmt (ob_trans_deadlock_adapter.cpp:670) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=45] maintain deadlock info(step=9, ret=0, ret="OB_SUCCESS", exec_ctx.get_errcode()=-5114, exec_ctx.get_errcode()="OB_INVALID_NUMERIC", session={this:0x7f86b34777d8, id:3221724009, deser:false, tenant:"mengxuan", tenant_id:1002, effective_tenant:"mengxuan", effective_tenant_id:1002, database:"trade_online", user:"mengxuan_admin@%", consistency_level:2, session_state:2, autocommit:true, tx:0x7f79f8ee5220}, desc={this:0x7f79f8ee5220, tx_id:{txid:17229229302}, state:1, addr:"172.26.49.129:2882", tenant_id:1002, session_id:3221724009, assoc_session_id:3221724009, 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:0, op_sn:2, alloc_ts:1731999431371259, active_ts:-1, commit_ts:-1, finish_ts:-1, timeout_us:86400000000, lock_timeout_us:-1, expire_ts:9223372036854775807, coord_id:{id:-1}, parts:[], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1714618933, cluster_version:17180000520, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:false, 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=[])
observer.log.20241119145735554:[2024-11-19 14:57:11.659430] INFO  [SQL.EXE] end_stmt (ob_sql_trans_control.cpp:1170) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=16] end stmt(ret=0, plain_select=false, stmt_type=5, savepoint=1731999431392380, tx_desc={this:0x7f79f8ee5220, tx_id:{txid:17229229302}, state:1, addr:"172.26.49.129:2882", tenant_id:1002, session_id:3221724009, assoc_session_id:3221724009, 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:0, op_sn:3, alloc_ts:1731999431371259, active_ts:-1, commit_ts:-1, finish_ts:-1, timeout_us:86400000000, lock_timeout_us:-1, expire_ts:9223372036854775807, coord_id:{id:-1}, parts:[], exec_info_reap_ts:0, commit_version:{val:18446744073709551615, v:3}, commit_times:0, commit_cb:null, cluster_id:1714618933, cluster_version:17180000520, flags_.SHADOW:false, flags_.INTERRUPTED:false, flags_.BLOCK:false, flags_.REPLICA:false, 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:0x7f86b34777d8, id:3221724009, deser:false, tenant:"mengxuan", tenant_id:1002, effective_tenant:"mengxuan", effective_tenant_id:1002, database:"trade_online", user:"mengxuan_admin@%", consistency_level:2, session_state:2, autocommit:true, tx:0x7f79f8ee5220}, exec_ctx.get_errcode()=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.659467] WDIAG [SERVER] response_result (ob_async_plan_driver.cpp:92) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=2][errcode=-5114] result set open failed, let's leave process(). EndTransCb will clean this mess(ret=-5114, cli_ret=-5114, cret=-5114, retry_ctrl_.need_retry()=0)
observer.log.20241119145735554:[2024-11-19 14:57:11.659509] INFO  [SERVER] send_error_packet (obmp_packet_sender.cpp:319) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=7] sending error packet(ob_error=-5114, client error=-5114, extra_err_info=NULL, lbt()="0x12435d5c 0xa09c250 0xa04c414 0xa04804f 0x4ce6176 0x4cdc885 0x4ccf77a 0x4cb91d4 0x9d57514 0x127054b0 0x7f9be5e8eea5 0x7f9be5bb7b0d")
observer.log.20241119145735554:[2024-11-19 14:57:11.659544] INFO  [SERVER] send_error_packet (obmp_packet_sender.cpp:502) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=7] dump txn free route audit_record(value=1048581, session->get_sessid()=3221724009, session->get_proxy_sessid()=12400260054841030800)
observer.log.20241119145735554:[2024-11-19 14:57:11.659553] WDIAG [SERVER] response_result (obmp_query.cpp:1273) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=8][errcode=-5114] fail response async result(ret=-5114)
observer.log.20241119145735554:[2024-11-19 14:57:11.659562] WDIAG [SERVER] do_process (obmp_query.cpp:808) [24822][T1002_L0_G0][T1002][YB42AC1A3181-0006209F1C5DC7F6-0-0] [lt=5][errcode=-5114] execute query fail(ret=-5114, timeout_timestamp=1732099431392970)