[2024-11-01 10:26:00.566846] WDIAG [SQL.RESV] resolve_impl (ob_create_routine_resolver.cpp:923) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=12][errcode=-4016] fail to exec analyze_router_sql(crt_routine_arg)(ret=-4016) [2024-11-01 10:26:00.566854] WDIAG [SQL.RESV] resolve (ob_create_routine_resolver.cpp:975) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8][errcode=-4016] failed to resolve routine info(ret=-4016) [2024-11-01 10:26:00.566861] WDIAG [SQL.RESV] resolve_impl (ob_create_routine_resolver.cpp:1025) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=7][errcode=-4016] failed to resolve sp body(ret=-4016) [2024-11-01 10:26:00.566869] WDIAG [SQL.RESV] resolve (ob_create_routine_resolver.cpp:990) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8][errcode=-4016] fail to exec resolve_impl(parse_tree, crt_routine_arg)(ret=-4016) [2024-11-01 10:26:00.566878] WDIAG [SQL.RESV] resolve_trigger_body (ob_trigger_resolver.cpp:789) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8][errcode=-4016] resolve trigger procedure failed(parse_tree->children_[0]->type_=3865, ret=-4016) [2024-11-01 10:26:00.566888] WDIAG [SQL.RESV] resolve_simple_dml_trigger (ob_trigger_resolver.cpp:368) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8][errcode=-4016] fail to exec resolve_trigger_body(*parse_node.children_[is_ora ? 4 : 3], trigger_arg)(ret=-4016) [2024-11-01 10:26:00.566897] WDIAG [SQL.RESV] resolve_trigger_source (ob_trigger_resolver.cpp:269) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=9][errcode=-4016] fail to exec resolve_simple_dml_trigger(*parse_node.children_[1], trigger_arg)(ret=-4016) [2024-11-01 10:26:00.566905] WDIAG [SQL.RESV] resolve_create_trigger_stmt (ob_trigger_resolver.cpp:160) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=7][errcode=-4016] fail to exec resolve_trigger_source(*parse_node.children_[is_ora ? 0 : 1], trigger_arg)(ret=-4016) [2024-11-01 10:26:00.566912] WDIAG [SQL.RESV] resolve (ob_trigger_resolver.cpp:42) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=6][errcode=-4016] fail to exec resolve_create_trigger_stmt(parse_tree, stmt->get_trigger_arg())(ret=-4016) [2024-11-01 10:26:00.566920] WDIAG [SQL.RESV] stmt_resolver_func (ob_resolver.cpp:168) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=7][errcode=-4016] execute stmt_resolver failed(ret=-4016, parse_tree.type_=4255) [2024-11-01 10:26:00.566955] WDIAG [SQL] generate_stmt (ob_sql.cpp:2866) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=12][errcode=-4016] failed to resolve(ret=-4016) [2024-11-01 10:26:00.566993] WDIAG [SQL] generate_physical_plan (ob_sql.cpp:2987) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=11][errcode=-4016] Failed to generate stmt(ret=-4016, result.get_exec_context().need_disconnect()=false) [2024-11-01 10:26:00.567014] WDIAG [SQL] handle_physical_plan (ob_sql.cpp:4796) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=19][errcode=-4016] Failed to generate plan(ret=-4016, result.get_exec_context().need_disconnect()=false) [2024-11-01 10:26:00.567037] WDIAG [SQL] handle_text_query (ob_sql.cpp:2571) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=9][errcode=-4016] fail to handle physical plan(ret=-4016) [2024-11-01 10:26:00.567047] WDIAG [SQL] stmt_query (ob_sql.cpp:222) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8][errcode=-4016] fail to handle text query(stmt=CREATE TRIGGER `trigger_update_table_test` AFTER UPDATE ON `table_test` FOR EACH ROW BEGIN DECLARE str VARCHAR(2000) DEFAULT ''; IF old.review_status != new.review_status THEN SET str = ''; END IF; END, ret=-4016) [2024-11-01 10:26:00.567085] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:947) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=18][errcode=-4016] [RETRY] check if need retry(v={force_local_retry:false, stmt_retry_times:0, local_retry_times:0, err_:-4016, err_:"OB_ERR_UNEXPECTED", retry_type:0, client_ret:-4016}, need_retry=false, THIS_WORKER.can_retry()=true, v.ctx_.multi_stmt_item_={is_part_of_multi_stmt:false, seq_num:0, sql:"CREATE TRIGGER `trigger_update_table_test` AFTER UPDATE ON `table_test` FOR EACH ROW BEGIN DECLARE str VARCHAR(2000) DEFAULT ''; IF old.review_status != new.review_status THEN SET str = ''; END IF; END", batched_queries:NULL, is_ps_mode:false, ab_cnt:0}) [2024-11-01 10:26:00.567130] WDIAG [SERVER] do_process (obmp_query.cpp:757) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=44][errcode=-4016] run stmt_query failed, check if need retry(ret=-4016, cli_ret=-4016, retry_ctrl_.need_retry()=0, sql=CREATE TRIGGER `trigger_update_table_test` AFTER UPDATE ON `table_test` FOR EACH ROW BEGIN DECLARE str VARCHAR(2000) DEFAULT ''; IF old.review_status != new.review_status THEN SET str = ''; END IF; END) [2024-11-01 10:26:00.567150] WDIAG [SERVER] do_process (obmp_query.cpp:882) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=10][errcode=-4016] query failed(ret=-4016, session={this:0x7f95c2030e58, id:3221489747, deser:false, tenant:"sys", tenant_id:1, effective_tenant:"sys", effective_tenant_id:1, database:"bsm_dev", user:"chenjg@%", consistency_level:3, session_state:2, autocommit:true, tx:0x7f95fb91c400}, sql=CREATE TRIGGER `trigger_update_table_test` AFTER UPDATE ON `table_test` FOR EACH ROW BEGIN DECLARE str VARCHAR(2000) DEFAULT ''; IF old.review_status != new.review_status THEN SET str = ''; END IF; END, retry_ctrl_.need_retry()=0) [2024-11-01 10:26:00.524730] INFO eloop_run (eloop.c:127) [24066][pnio1][T0][Y0-0000000000000000-0-0] [lt=75] PNIO [ratelimit] time: 1730427960524727, bytes: 917883409, bw: 0.003273 MB/s, add_ts: 1000926, add_bytes: 3435 [2024-11-01 10:26:00.524730] INFO eloop_run (eloop.c:127) [24066][pnio1][T0][Y0-0000000000000000-0-0] [lt=75] PNIO [ratelimit] time: 1730427960524727, bytes: 917883409, bw: 0.003273 MB/s, add_ts: 1000926, add_bytes: 3435 [2024-11-01 10:26:00.524730] INFO eloop_run (eloop.c:127) [24066][pnio1][T0][Y0-0000000000000000-0-0] [lt=75] PNIO [ratelimit] time: 1730427960524727, bytes: 917883409, bw: 0.003273 MB/s, add_ts: 1000926, add_bytes: 3435 [2024-11-01 10:26:00.524790] INFO eloop_run (eloop.c:136) [24066][pnio1][T0][Y0-0000000000000000-0-0] [lt=44] PNIO print mem cache info mem_freelists_str:0,0,0,0,0,0,0,0,0,, mod_report:DEFAULT:6,318,024 SERVER_CTX_CHUNK: 48,888 SERVER_RESP_CHUNK: 32,592 CLIENT_REQ_CHUNK: 32,592 CLIENT_CB_CHUNK: 48,888 PKTS_INBUF: 130,984 PKTC_INBUF: 130,984 [2024-11-01 10:26:00.532781] INFO [COMMON] compute_tenant_wash_size (ob_kvcache_store.cpp:1154) [24014][KVCacheWash][T0][Y0-0000000000000000-0-0] [lt=30] Wash compute wash size(is_wash_valid=true, sys_total_wash_size=173735936, global_cache_size=54099968, tenant_max_wash_size=0, tenant_min_wash_size=0, tenant_ids_=[500, 508, 509, 1]) [2024-11-01 10:26:00.533214] INFO [COMMON] wash (ob_kvcache_store.cpp:341) [24014][KVCacheWash][T0][Y0-0000000000000000-0-0] [lt=50] Wash time detail, (compute_wash_size_time=200, refresh_score_time=72, wash_time=9) [2024-11-01 10:26:00.533265] INFO [COMMON] clean_garbage_node (ob_kvcache_map.cpp:636) [24014][KVCacheWash][T0][Y0-0000000000000000-0-0] [lt=30] Cache wash clean map node details(ret=0, clean_node_count=0, clean_time=18, clean_start_pos=1572850, clean_num=31457) [2024-11-01 10:26:00.565622] INFO [SHARE.SCHEMA] gen_package_source_simple (ob_trigger_info.cpp:535) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8] TRIGGER(spec_source=PACKAGE `trigger_update_table_test` PROCEDURE before_row(IN OLD `bsm_dev`.`table_test`%ROWTYPE, INOUT NEW `bsm_dev`.`table_test`%ROWTYPE); PROCEDURE after_row(IN OLD `bsm_dev`.`table_test`%ROWTYPE, IN NEW `bsm_dev`.`table_test`%ROWTYPE); END; , body_source=PACKAGE BODY `trigger_update_table_test` PROCEDURE before_row(IN OLD `bsm_dev`.`table_test`%ROWTYPE, INOUT NEW `bsm_dev`.`table_test`%ROWTYPE) BEGIN END; PROCEDURE after_row(IN OLD `bsm_dev`.`table_test`%ROWTYPE, IN NEW `bsm_dev`.`table_test`%ROWTYPE) BEGIN BEGIN DECLARE str VARCHAR(2000) DEFAULT ''; IF old.review_status != new.review_status THEN SET str = ''; END IF; END; END; END; ) [2024-11-01 10:26:00.565622] INFO [SHARE.SCHEMA] gen_package_source_simple (ob_trigger_info.cpp:535) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8] TRIGGER(spec_source=PACKAGE `trigger_update_table_test` PROCEDURE before_row(IN OLD `bsm_dev`.`table_test`%ROWTYPE, INOUT NEW `bsm_dev`.`table_test`%ROWTYPE); PROCEDURE after_row(IN OLD `bsm_dev`.`table_test`%ROWTYPE, IN NEW `bsm_dev`.`table_test`%ROWTYPE); END; , body_source=PACKAGE BODY `trigger_update_table_test` PROCEDURE before_row(IN OLD `bsm_dev`.`table_test`%ROWTYPE, INOUT NEW `bsm_dev`.`table_test`%ROWTYPE) BEGIN END; PROCEDURE after_row(IN OLD `bsm_dev`.`table_test`%ROWTYPE, IN NEW `bsm_dev`.`table_test`%ROWTYPE) BEGIN BEGIN DECLARE str VARCHAR(2000) DEFAULT ''; IF old.review_status != new.review_status THEN SET str = ''; END IF; END; END; END; ) [2024-11-01 10:26:00.566386] WDIAG [LIB.CHARSET] aggregate_collation (ob_charset.cpp:2045) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=73][errcode=-4016] invalid collation level or type(ret=-4016, collation_level1=7, collation_type1=45, collation_level2=7, collation_type2=45) [2024-11-01 10:26:00.566427] WDIAG [SQL.ENG] calc_cmp_type2 (ob_expr_operator.cpp:2047) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=39][errcode=-4016] aggregate charset failed(type1={meta:{type:"ENUM", collation:"utf8mb4_general_ci", coercibility:"INVALID"}, accuracy:{length:4, precision:-1, scale:-1}, flag:0, calc_type:{type:"ENUM", collation:"utf8mb4_general_ci", coercibility:"INVALID"}}, type2={meta:{type:"ENUM", collation:"utf8mb4_general_ci", coercibility:"INVALID"}, accuracy:{length:4, precision:-1, scale:-1}, flag:0, calc_type:{type:"ENUM", collation:"utf8mb4_general_ci", coercibility:"INVALID"}}, type.get_calc_meta()={type:"VARCHAR", collation:"invalid_type", coercibility:"INVALID"}) [2024-11-01 10:26:00.566465] WDIAG [SQL.ENG] calc_result_type2 (ob_expr_operator.cpp:2233) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=37][errcode=-4016] fail to exec deduce_cmp_type(*this, type, type1, type2, type_ctx)(ret=-4016) [2024-11-01 10:26:00.566477] WDIAG [SQL.RESV] calc_result_type (ob_raw_expr_deduce_type.cpp:431) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=11][errcode=-4016] calc result type2 failed(ret=-4016) [2024-11-01 10:26:00.566486] WDIAG [SQL.RESV] visit (ob_raw_expr_deduce_type.cpp:716) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8][errcode=-4016] fail calc result type(ret=-4016) [2024-11-01 10:26:00.566495] WDIAG [SQL.RESV] postorder_accept (ob_raw_expr.cpp:509) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8][errcode=-4016] visit failed(ret=-4016, type=116, name="T_OP_NE") [2024-11-01 10:26:00.566506] WDIAG [SQL.RESV] deduce_type (ob_raw_expr.cpp:398) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=11][errcode=-4016] fail to deduce(ret=-4016) [2024-11-01 10:26:00.566514] WDIAG [SQL.RESV] formalize (ob_raw_expr.cpp:417) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=7][errcode=-4016] failed to deduce type(*this={item_type:"T_OP_NE", result_type:{meta:{type:"", collation:"binary", coercibility:"NUMERIC"}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST_EXPR", "UNKNOWN"], rel_id:[], children:[{item_type:"T_OBJ_ACCESS_REF", result_type:{meta:{type:"ENUM", collation:"utf8mb4_general_ci", coercibility:"INVALID"}, accuracy:{length:4, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST_EXPR", "UNKNOWN"], rel_id:[], children:[]}, {item_type:"T_OBJ_ACCESS_REF", result_type:{meta:{type:"ENUM", collation:"utf8mb4_general_ci", coercibility:"INVALID"}, accuracy:{length:4, precision:-1, scale:-1}, flag:0, calc_type:{type:"NULL", collation:"invalid_type", coercibility:"INVALID"}}, expr_info:["IS_CONST_EXPR", "UNKNOWN"], rel_id:[], children:[]}]}) [2024-11-01 10:26:00.566582] WDIAG [PL] formalize_expr (ob_pl_resolver.cpp:9618) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=67][errcode=-4016] fail to exec expr.formalize(&resolve_ctx_.session_info_)(ret=-4016) [2024-11-01 10:26:00.566591] WDIAG [PL] resolve_expr (ob_pl_resolver.cpp:9747) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=9][errcode=-4016] fail to exec formalize_expr(*expr)(ret=-4016) [2024-11-01 10:26:00.566656] WDIAG [PL] resolve_then (ob_pl_resolver.cpp:4308) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=63][errcode=-4016] failed to resolve expr(expr_node=0x7f95edffa968, ret=-4016) [2024-11-01 10:26:00.566678] WDIAG [PL] resolve_if (ob_pl_resolver.cpp:4094) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=21][errcode=-4016] failed to resolve then(ret=-4016) [2024-11-01 10:26:00.566687] WDIAG [PL] resolve (ob_pl_resolver.cpp:369) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=7][errcode=-4016] failed to resolve pl stmt(parse_tree->type_=3891, parse_tree=0x7f95edffb6b8, stmt=0x7f95c20d0d50, ret=-4016) [2024-11-01 10:26:00.566717] WDIAG [PL] resolve_stmt_list (ob_pl_resolver.cpp:15909) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=23][errcode=-4016] fail to exec ({ int ret = OB_SUCCESS; bool is_overflow = false; if ((__builtin_expect(!!(::oceanbase::common::OB_SUCCESS != (ret = (check_stack_overflow(is_overflow, STACK_RESERVED_SIZE)))),!!0))) { } else if (!is_overflow) { ret = resolve(node->children_[1]->children_[i], func); } else { std::function f = [&]() { int ret = OB_SUCCESS; try { in_try_stmt = true; ret = resolve(node->children_[1]->children_[i], func); in_try_stmt = false; } catch (OB_BASE_EXCEPTION &except) { ret = except.get_errno(); in_try_stmt = false; } return ret; }; int(*func_) (void*) = [](void *arg) { return (*(decltype(f)*)(arg))(); }; void * arg_ = &f; ret = call_with_new_stack(arg_, func_); } ret; })(ret=-4016) [2024-11-01 10:26:00.566727] WDIAG [PL] resolve (ob_pl_resolver.cpp:318) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8][errcode=-4016] failed to resolve stmt list(parse_tree->type_=3877, ret=-4016) [2024-11-01 10:26:00.566736] WDIAG [PL] resolve (ob_pl_resolver.cpp:543) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8][errcode=-4016] fail to exec ({ int ret = OB_SUCCESS; bool is_overflow = false; if ((__builtin_expect(!!(::oceanbase::common::OB_SUCCESS != (ret = (check_stack_overflow(is_overflow, STACK_RESERVED_SIZE)))),!!0))) { } else if (!is_overflow) { ret = resolve(parse_tree->children_[i], func); } else { std::function f = [&]() { int ret = OB_SUCCESS; try { in_try_stmt = true; ret = resolve(parse_tree->children_[i], func); in_try_stmt = false; } catch (OB_BASE_EXCEPTION &except) { ret = except.get_errno(); in_try_stmt = false; } return ret; }; int(*func_) (void*) = [](void *arg) { return (*(decltype(f)*)(arg))(); }; void * arg_ = &f; ret = call_with_new_stack(arg_, func_); } ret; })(ret=-4016) [2024-11-01 10:26:00.566746] WDIAG [PL] simple_resolve (ob_pl_router.cpp:242) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=9][errcode=-4016] failed to analyze pl body(routine_info_={tenant_id:1, database_id:18446744073709551615, package_id:18446744073709551615, owner_id:507014, routine_id:18446744073709551615, routine_name:"trigger_update_table_test", overload:0, subprogram_id:0, schema_version:-1, routine_type:1, flag:0, priv_user:"chenjg@%", comp_flag:0, exec_env:"281018368,45,45,45,2,", routine_body:"PROCEDURE `trigger_update_table_test`(IN OLD `bsm_dev`.`table_test`%ROWTYPE, IN NEW `bsm_dev`.`table_test`%ROWTYPE) BEGIN DECLARE str VARCHAR(2000) DEFAULT ''; IF old.review_status != new.review_status THEN SET str = ''; END IF; END", comment:"", route_sql:"", type_id:-1, routine_params:[{tenant_id:1, routine_id:18446744073709551615, sequence:1, subprogram_id:0, param_position:1, param_level:0, param_name:"OLD", schema_version:-1, param_type:{meta:{type:"EXT", collation:"invalid_type", coercibility:"INVALID"}, accuracy:{length:-1, precision:-1, scale:-1}, charset:2, is_binary_collation:false, is_zero_fill:false}, flag:17, default_value:"", type_owner:546240, type_name:"table_test", type_subname:"", extended_type_info:[]}, {tenant_id:1, routine_id:18446744073709551615, sequence:2, subprogram_id:0, param_position:2, param_level:0, param_name:"NEW", schema_version:-1, param_type:{meta:{type:"EXT", collation:"invalid_type", coercibility:"INVALID"}, accuracy:{length:-1, precision:-1, scale:-1}, charset:2, is_binary_collation:false, is_zero_fill:false}, flag:17, default_value:"", type_owner:546240, type_name:"table_test", type_subname:"", extended_type_info:[]}]}, ret=-4016) [2024-11-01 10:26:00.566815] WDIAG [PL] analyze (ob_pl_router.cpp:120) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=65][errcode=-4016] resolve error with error code(ret=-4016) [2024-11-01 10:26:00.566828] WDIAG [SQL.RESV] analyze_router_sql (ob_create_routine_resolver.cpp:99) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8][errcode=-4016] failed to analyze route sql(route_sql=, ret=-4016) [2024-11-01 10:26:00.566846] WDIAG [SQL.RESV] resolve_impl (ob_create_routine_resolver.cpp:923) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=12][errcode=-4016] fail to exec analyze_router_sql(crt_routine_arg)(ret=-4016) [2024-11-01 10:26:00.566854] WDIAG [SQL.RESV] resolve (ob_create_routine_resolver.cpp:975) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8][errcode=-4016] failed to resolve routine info(ret=-4016) [2024-11-01 10:26:00.566861] WDIAG [SQL.RESV] resolve_impl (ob_create_routine_resolver.cpp:1025) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=7][errcode=-4016] failed to resolve sp body(ret=-4016) [2024-11-01 10:26:00.566869] WDIAG [SQL.RESV] resolve (ob_create_routine_resolver.cpp:990) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8][errcode=-4016] fail to exec resolve_impl(parse_tree, crt_routine_arg)(ret=-4016) [2024-11-01 10:26:00.566878] WDIAG [SQL.RESV] resolve_trigger_body (ob_trigger_resolver.cpp:789) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8][errcode=-4016] resolve trigger procedure failed(parse_tree->children_[0]->type_=3865, ret=-4016) [2024-11-01 10:26:00.566888] WDIAG [SQL.RESV] resolve_simple_dml_trigger (ob_trigger_resolver.cpp:368) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8][errcode=-4016] fail to exec resolve_trigger_body(*parse_node.children_[is_ora ? 4 : 3], trigger_arg)(ret=-4016) [2024-11-01 10:26:00.566897] WDIAG [SQL.RESV] resolve_trigger_source (ob_trigger_resolver.cpp:269) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=9][errcode=-4016] fail to exec resolve_simple_dml_trigger(*parse_node.children_[1], trigger_arg)(ret=-4016) [2024-11-01 10:26:00.566905] WDIAG [SQL.RESV] resolve_create_trigger_stmt (ob_trigger_resolver.cpp:160) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=7][errcode=-4016] fail to exec resolve_trigger_source(*parse_node.children_[is_ora ? 0 : 1], trigger_arg)(ret=-4016) [2024-11-01 10:26:00.566912] WDIAG [SQL.RESV] resolve (ob_trigger_resolver.cpp:42) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=6][errcode=-4016] fail to exec resolve_create_trigger_stmt(parse_tree, stmt->get_trigger_arg())(ret=-4016) [2024-11-01 10:26:00.566920] WDIAG [SQL.RESV] stmt_resolver_func (ob_resolver.cpp:168) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=7][errcode=-4016] execute stmt_resolver failed(ret=-4016, parse_tree.type_=4255) [2024-11-01 10:26:00.566955] WDIAG [SQL] generate_stmt (ob_sql.cpp:2866) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=12][errcode=-4016] failed to resolve(ret=-4016) [2024-11-01 10:26:00.566993] WDIAG [SQL] generate_physical_plan (ob_sql.cpp:2987) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=11][errcode=-4016] Failed to generate stmt(ret=-4016, result.get_exec_context().need_disconnect()=false) [2024-11-01 10:26:00.567014] WDIAG [SQL] handle_physical_plan (ob_sql.cpp:4796) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=19][errcode=-4016] Failed to generate plan(ret=-4016, result.get_exec_context().need_disconnect()=false) [2024-11-01 10:26:00.567037] WDIAG [SQL] handle_text_query (ob_sql.cpp:2571) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=9][errcode=-4016] fail to handle physical plan(ret=-4016) [2024-11-01 10:26:00.567047] WDIAG [SQL] stmt_query (ob_sql.cpp:222) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=8][errcode=-4016] fail to handle text query(stmt=CREATE TRIGGER `trigger_update_table_test` AFTER UPDATE ON `table_test` FOR EACH ROW BEGIN DECLARE str VARCHAR(2000) DEFAULT ''; IF old.review_status != new.review_status THEN SET str = ''; END IF; END, ret=-4016) [2024-11-01 10:26:00.567085] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:947) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=18][errcode=-4016] [RETRY] check if need retry(v={force_local_retry:false, stmt_retry_times:0, local_retry_times:0, err_:-4016, err_:"OB_ERR_UNEXPECTED", retry_type:0, client_ret:-4016}, need_retry=false, THIS_WORKER.can_retry()=true, v.ctx_.multi_stmt_item_={is_part_of_multi_stmt:false, seq_num:0, sql:"CREATE TRIGGER `trigger_update_table_test` AFTER UPDATE ON `table_test` FOR EACH ROW BEGIN DECLARE str VARCHAR(2000) DEFAULT ''; IF old.review_status != new.review_status THEN SET str = ''; END IF; END", batched_queries:NULL, is_ps_mode:false, ab_cnt:0}) [2024-11-01 10:26:00.567130] WDIAG [SERVER] do_process (obmp_query.cpp:757) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=44][errcode=-4016] run stmt_query failed, check if need retry(ret=-4016, cli_ret=-4016, retry_ctrl_.need_retry()=0, sql=CREATE TRIGGER `trigger_update_table_test` AFTER UPDATE ON `table_test` FOR EACH ROW BEGIN DECLARE str VARCHAR(2000) DEFAULT ''; IF old.review_status != new.review_status THEN SET str = ''; END IF; END) [2024-11-01 10:26:00.567150] WDIAG [SERVER] do_process (obmp_query.cpp:882) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=10][errcode=-4016] query failed(ret=-4016, session={this:0x7f95c2030e58, id:3221489747, deser:false, tenant:"sys", tenant_id:1, effective_tenant:"sys", effective_tenant_id:1, database:"bsm_dev", user:"chenjg@%", consistency_level:3, session_state:2, autocommit:true, tx:0x7f95fb91c400}, sql=CREATE TRIGGER `trigger_update_table_test` AFTER UPDATE ON `table_test` FOR EACH ROW BEGIN DECLARE str VARCHAR(2000) DEFAULT ''; IF old.review_status != new.review_status THEN SET str = ''; END IF; END, retry_ctrl_.need_retry()=0) [2024-11-01 10:26:00.567194] INFO [SERVER] send_error_packet (obmp_packet_sender.cpp:319) [24645][T1_L0_G0][T1][YB42C0A8022A-0006259A480D82E1-0-0] [lt=31] sending error packet(ob_error=-4016, client error=-4016, extra_err_info=NULL, lbt()="0x1259a7d5 0xa15c8b0 0xa10ad10 0x4d31092 0x4d262e9 0x4d192ea 0x4d0235c 0x9e15f34 0x1286b05f 0x7f9640cb9ea5 0x7f96409e2b0d")