[2024-05-10 10:34:08.755195] WDIAG [SQL.RESV] resolve_table_relation_factor (ob_dml_resolver.cpp:8242) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=36][errcode=0] resolve dblink name(has_dblink_node=false, dblink_name=, is_reverse_link=false) [2024-05-10 10:34:08.763261] WDIAG [SHARE.SCHEMA] check_param_valid_ (ob_schema_struct.cpp:6464) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=36][errcode=-5019] local index not exist(ret=-5019, ret="OB_TABLE_NOT_EXIST", table_id=524584) [2024-05-10 10:34:08.763289] WDIAG [SHARE.SCHEMA] get_tablet_and_object_id (ob_schema_struct.cpp:6545) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=27][errcode=-5019] fail to check param(ret=-5019, ret="OB_TABLE_NOT_EXIST", table_schema={simple_table_schema:{tenant_id:1006, database_id:523564, tablegroup_id:18446744073709551615, table_id:524584, association_table_id:18446744073709551615, in_offline_ddl_white_list:false, table_name:"__idx_524579_index_paymenCode", session_id:0, index_type:1, table_type:5, 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, mv_container_table_flag:0, mv_available_flag:0}, tablespace_id:18446744073709551615, data_table_id:524579, name_casemode:-1, schema_version:1715225024287928, 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:2, duplicate_scope:0, encryption:"", encrypt_key:"", master_key_id:18446744073709551615, sub_part_template_flags:0, get_tablet_id():{id:1152921504606863885}, max_dependency_version:-1, object_status:1, is_force_view:false, truncate_version:-1}, max_used_column_id:162, sess_active_time:0, rowkey_column_num:2, index_column_num:1, 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:2, 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:[], base_table_ids:[], rowkey_info:{columns:[{length:50, column_id:71, type:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"}, order:0, fulltext_flag:false, spatial_flag_:false}, {length:0, column_id:1, type:{type:"BIGINT UNSIGNED", collation:"binary", coercibility:"NUMERIC"}, order:0, fulltext_flag:false, spatial_flag_:false}], capacity:2}, partition_key_info:{columns:null, capacity:0}, column_cnt:2, table_dop:1, constraints:null, column_array:[{tenant_id:1006, table_id:524584, column_id:1, schema_version:1714115629329384, rowkey_position:2, index_position:0, order_in_rowkey:0, tbl_part_key_pos:0, meta_type:{type:"BIGINT UNSIGNED", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, is_nullable:false, is_zero_fill:false, is_autoincrement:false, is_hidden:true, charset_type:1, on_update_current_timestamp:false, orig_default_value:{"NULL":"NULL"}, cur_default_value:{"NULL":"NULL"}, column_name:"__pk_increment", comment:"", column_flags:0, extended_type_info:[cnt:0], prev_column_id:71, next_column_id:0, sequence_id:9223372036854775807, encoding_type:9223372036854775807, srs_id:18446744073709551584, udt_set_id:0, sub_type:0, skip_index_attr:{pack:0, min_max:0, sum:0}, lob_chunk_size:262144, column_ref_idxs:NULL, local_session_vars_:{}}, {tenant_id:1006, table_id:524584, column_id:71, schema_version:1714115629329384, rowkey_position:1, index_position:1, order_in_rowkey:0, tbl_part_key_pos:0, meta_type:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"}, accuracy:{length:50, precision:-1, scale:-1}, is_nullable:true, is_zero_fill:false, is_autoincrement:false, is_hidden:false, charset_type:2, on_update_current_timestamp:false, orig_default_value:{"NULL":"NULL"}, cur_default_value:{"NULL":"NULL"}, column_name:"payment_code", comment:"", column_flags:0, extended_type_info:[cnt:0], prev_column_id:0, next_column_id:1, sequence_id:9223372036854775807, encoding_type:9223372036854775807, srs_id:18446744073709551584, udt_set_id:0, sub_type:0, skip_index_attr:{pack:0, min_max:0, sum:0}, lob_chunk_size:262144, column_ref_idxs:NULL, local_session_vars_:{}}], aux_vp_tid_array:[], define_user_id:18446744073709551615, aux_lob_meta_tid:18446744073709551615, aux_lob_piece_tid:18446744073709551615, name_generated_type:1, lob_inrow_threshold:4096, is_column_store_supported:true, max_used_column_group_id:1000, column_group_cnt:1, column_group_array:[{column_group_id:1, column_group_name:"__co_default", column_group_type:0, schema_version:1714115629329384, block_size:16384, compressor_type:6, row_store_type:1, column_id_cnt:2, column_id_arr_capacity:2}], mlog_tid:18446744073709551615, auto_increment_cache_size:0}, related_table=0x7f850a548a30) [2024-05-10 10:34:08.763428] WDIAG [SQL.DAS] get_tablet_and_object_id (ob_das_location_router.cpp:242) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=137][errcode=-5019] fail to get tablet_id and object_id(ret=-5019, ret="OB_TABLE_NOT_EXIST", table_schema={simple_table_schema:{tenant_id:1006, database_id:523564, tablegroup_id:18446744073709551615, table_id:524584, association_table_id:18446744073709551615, in_offline_ddl_white_list:false, table_name:"__idx_524579_index_paymenCode", session_id:0, index_type:1, table_type:5, 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, mv_container_table_flag:0, mv_available_flag:0}, tablespace_id:18446744073709551615, data_table_id:524579, name_casemode:-1, schema_version:1715225024287928, 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:2, duplicate_scope:0, encryption:"", encrypt_key:"", master_key_id:18446744073709551615, sub_part_template_flags:0, get_tablet_id():{id:1152921504606863885}, max_dependency_version:-1, object_status:1, is_force_view:false, truncate_version:-1}, max_used_column_id:162, sess_active_time:0, rowkey_column_num:2, index_column_num:1, 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:2, 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:[], base_table_ids:[], rowkey_info:{columns:[{length:50, column_id:71, type:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"}, order:0, fulltext_flag:false, spatial_flag_:false}, {length:0, column_id:1, type:{type:"BIGINT UNSIGNED", collation:"binary", coercibility:"NUMERIC"}, order:0, fulltext_flag:false, spatial_flag_:false}], capacity:2}, partition_key_info:{columns:null, capacity:0}, column_cnt:2, table_dop:1, constraints:null, column_array:[{tenant_id:1006, table_id:524584, column_id:1, schema_version:1714115629329384, rowkey_position:2, index_position:0, order_in_rowkey:0, tbl_part_key_pos:0, meta_type:{type:"BIGINT UNSIGNED", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, is_nullable:false, is_zero_fill:false, is_autoincrement:false, is_hidden:true, charset_type:1, on_update_current_timestamp:false, orig_default_value:{"NULL":"NULL"}, cur_default_value:{"NULL":"NULL"}, column_name:"__pk_increment", comment:"", column_flags:0, extended_type_info:[cnt:0], prev_column_id:71, next_column_id:0, sequence_id:9223372036854775807, encoding_type:9223372036854775807, srs_id:18446744073709551584, udt_set_id:0, sub_type:0, skip_index_attr:{pack:0, min_max:0, sum:0}, lob_chunk_size:262144, column_ref_idxs:NULL, local_session_vars_:{}}, {tenant_id:1006, table_id:524584, column_id:71, schema_version:1714115629329384, rowkey_position:1, index_position:1, order_in_rowkey:0, tbl_part_key_pos:0, meta_type:{type:"VARCHAR", collation:"utf8mb4_general_ci", coercibility:"INVALID"}, accuracy:{length:50, precision:-1, scale:-1}, is_nullable:true, is_zero_fill:false, is_autoincrement:false, is_hidden:false, charset_type:2, on_update_current_timestamp:false, orig_default_value:{"NULL":"NULL"}, cur_default_value:{"NULL":"NULL"}, column_name:"payment_code", comment:"", column_flags:0, extended_type_info:[cnt:0], prev_column_id:0, next_column_id:1, sequence_id:9223372036854775807, encoding_type:9223372036854775807, srs_id:18446744073709551584, udt_set_id:0, sub_type:0, skip_index_attr:{pack:0, min_max:0, sum:0}, lob_chunk_size:262144, column_ref_idxs:NULL, local_session_vars_:{}}], aux_vp_tid_array:[], define_user_id:18446744073709551615, aux_lob_meta_tid:18446744073709551615, aux_lob_piece_tid:18446744073709551615, name_generated_type:1, lob_inrow_threshold:4096, is_column_store_supported:true, max_used_column_group_id:1000, column_group_cnt:1, column_group_array:[{column_group_id:1, column_group_name:"__co_default", column_group_type:0, schema_version:1714115629329384, block_size:16384, compressor_type:6, row_store_type:1, column_id_cnt:2, column_id_arr_capacity:2}], mlog_tid:18446744073709551615, auto_increment_cache_size:0}) [2024-05-10 10:34:08.763501] WDIAG [SQL.DAS] get_non_partition_tablet_id (ob_das_location_router.cpp:415) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=71][errcode=-5019] fail to exec get_tablet_and_object_id(PARTITION_LEVEL_ZERO, OB_INVALID_ID, range, tablet_ids, out_part_ids)(ret=-5019) [2024-05-10 10:34:08.763508] WDIAG [SQL.OPT] calculate_tablet_ids (ob_table_location.cpp:1674) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=7][errcode=-5019] fail to exec tablet_mapper.get_non_partition_tablet_id(tablet_ids, partition_ids)(ret=-5019) [2024-05-10 10:34:08.763515] WDIAG [SQL.PC] build_related_tablet_info (ob_plan_cache_util.cpp:375) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=7][errcode=-5019] calculate tablet ids failed(ret=-5019) [2024-05-10 10:34:08.763521] WDIAG [SQL.OPT] build_location_related_tablet_ids (ob_log_plan.cpp:12643) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=5][errcode=-5019] rebuild related tablet info failed(ret=-5019) [2024-05-10 10:34:08.763528] WDIAG [SQL.OPT] do_post_plan_processing (ob_log_plan.cpp:12043) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=7][errcode=-5019] build location related tablet ids failed(ret=-5019) [2024-05-10 10:34:08.763535] WDIAG [SQL.OPT] generate_plan (ob_log_plan.cpp:11753) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=6][errcode=-5019] failed to post plan processing(ret=-5019) [2024-05-10 10:34:08.763540] WDIAG [SQL.OPT] optimize (ob_optimizer.cpp:64) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=5][errcode=-5019] failed to perform optimization(ret=-5019) [2024-05-10 10:34:08.763547] WDIAG [SQL] optimize_stmt (ob_sql.cpp:3554) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=5][errcode=-5019] Failed to optimize logical plan(ret=-5019) [2024-05-10 10:34:08.763556] WDIAG [SQL] generate_plan (ob_sql.cpp:3189) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=8][errcode=-5019] Failed to optimizer stmt(ret=-5019) [2024-05-10 10:34:08.763567] WDIAG [SQL] generate_physical_plan (ob_sql.cpp:2995) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=5][errcode=-5019] failed to generateplan(ret=-5019) [2024-05-10 10:34:08.763578] WDIAG [SQL] handle_physical_plan (ob_sql.cpp:4811) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=8][errcode=-5019] Failed to generate plan(ret=-5019, result.get_exec_context().need_disconnect()=false) [2024-05-10 10:34:08.763586] WDIAG [SQL] handle_text_query (ob_sql.cpp:2560) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=6][errcode=-5019] fail to handle physicalplan(ret=-5019) [2024-05-10 10:34:08.763594] WDIAG [SQL] stmt_query (ob_sql.cpp:227) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=6][errcode=-5019] fail to handle text query(stmt=UPDATE ele_payment SET billaccount_name = "英德西牛江坝村(微小M)(无线)1" WHERE payment_code = "JFZDPT-GD-20240423-12314", ret=-5019) [2024-05-10 10:34:08.763617] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:979) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=10][errcode=-5019] [RETRY] check if need retry(v={force_local_retry:false, stmt_retry_times:0, local_retry_times:0, err_:-5019, err_:"OB_TABLE_NOT_EXIST", retry_type:0, client_ret:-5019}, need_retry=false) [2024-05-10 10:34:08.763632] WDIAG [SERVER] do_process (obmp_query.cpp:760) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=14][errcode=-5019] run stmt_query failed, check if need retry(ret=-5019, cli_ret=-5019, retry_ctrl_.need_retry()=0, sql=UPDATE ele_payment SET billaccount_name = "英德西牛江坝村(微小M)(无线)1" WHERE payment_code = "JFZDPT-GD-20240423-12314") [2024-05-10 10:34:08.763646] WDIAG [SERVER] do_process (obmp_query.cpp:884) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=8][errcode=-5019] query failed(ret=-5019, session={this:0x7f6db4ddde98, id:3222318428, deser:false, tenant:"ncms_ah", tenant_id:1006, effective_tenant:"ncms_ah", effective_tenant_id:1006, database:"ncms_gd", user:"root@%", consistency_level:3, session_state:2, autocommit:true, tx:null}, sql=UPDATE ele_payment SET billaccount_name = "英德西牛江坝村(微小M)(无线)1" WHERE payment_code = "JFZDPT-GD-20240423-12314", retry_ctrl_.need_retry()=0) [2024-05-10 10:34:08.763674] INFO [SERVER] send_error_packet (obmp_packet_sender.cpp:366) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=21] sending error packet(ob_error=-5019, client error=1146, extra_err_info=NULL, lbt()="0x5d0f8ac 0xab4c110 0xaaf8605 0x5791808 0x5784bfb 0x577db5f 0x576f048 0xa980fb4 0x164058ce 0x7f86519442de 0x7f8651675e83") [2024-05-10 10:34:08.763726] INFO [SERVER] send_error_packet (obmp_packet_sender.cpp:549) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=12] dump txn free route audit_record(value=5, session->get_sessid()=3222318428, session->get_proxy_sessid()=791739223630922006) [2024-05-10 10:34:08.763782] WDIAG [SQL.PC] common_free (ob_lib_cache_object_manager.cpp:141) [1463542][T1006_L0_G0][T1006][YB420AFCD2A3-00061676D46CD593-0-0] [lt=12][errcode=0] set logical del time(cache_obj->get_logical_del_time()=20543710189698, cache_obj->added_lc()=false, cache_obj->get_object_id()=135181, cache_obj->get_tenant_id()=1006, lbt()="0x5d0f8ac 0xdfccd24 0x579bf8f 0x578e54d 0x5784bfb 0x577db5f 0x576f048 0xa980fb4 0x164058ce 0x7f86519442de 0x7f8651675e83")