[2025-02-27 10:12:54.200137] WDIAG [SQL.RESV] resolve_qualified_identifier (ob_dml_resolver.cpp:3251) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=12][errcode=-5217] resolve column ref expr failed(ret=-5217, q_name={database_name:"", table_name:"t2", column:"DEPT_ADRRESSCODE", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", 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_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:0, is_access_root:true})
[2025-02-27 10:12:54.200193] WDIAG report_user_error_msg (ob_dml_resolver.cpp:3337) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=45][errcode=-5217] Unknown column 't2.DEPT_ADRRESSCODE' in 'having clause'
[2025-02-27 10:12:54.200199] WDIAG [SQL.RESV] resolve_sql_expr (ob_dml_resolver.cpp:1778) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=5][errcode=-5217] resolve columns failed(ret=-5217)
[2025-02-27 10:12:54.200205] WDIAG [SQL.RESV] resolve_and_split_sql_expr (ob_dml_resolver.cpp:6843) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=5][errcode=-5217] resolve sql expr failed(ret=-5217)
[2025-02-27 10:12:54.200216] WDIAG [SQL.RESV] resolve_and_split_sql_expr_with_bool_expr (ob_dml_resolver.cpp:6870) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=11][errcode=-5217] resolve_and_split_sql_expr failed(ret=-5217)
[2025-02-27 10:12:54.200223] WDIAG [SQL.RESV] resolve_having_clause (ob_select_resolver.cpp:4778) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=7][errcode=-5217] resolve and split sql expr failed(ret=-5217)
[2025-02-27 10:12:54.200243] WDIAG [SQL.RESV] resolve_normal_query (ob_select_resolver.cpp:1370) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=19][errcode=-5217] fail to exec resolve_having_clause(having)(ret=-5217)
[2025-02-27 10:12:54.200247] WDIAG [SQL.RESV] resolve (ob_select_resolver.cpp:1556) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=4][errcode=-5217] resolve normal query failed(ret=-5217)
[2025-02-27 10:12:54.200256] WDIAG [SQL.RESV] select_stmt_resolver_func (ob_resolver.cpp:190) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=8][errcode=-5217] execute stmt_resolver failed(ret=-5217, parse_tree.type_=3299)
[2025-02-27 10:12:54.200273] WDIAG [SQL] generate_stmt (ob_sql.cpp:3107) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=9][errcode=-5217] failed to resolve(ret=-5217)
[2025-02-27 10:12:54.200282] WDIAG [SQL] generate_physical_plan (ob_sql.cpp:3228) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=8][errcode=-5217] Failed to generate stmt(ret=-5217, result.get_exec_context().need_disconnect()=false)
[2025-02-27 10:12:54.200304] WDIAG [SQL] handle_physical_plan (ob_sql.cpp:5116) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=21][errcode=-5217] Failed to generate plan(ret=-5217, result.get_exec_context().need_disconnect()=false)
[2025-02-27 10:12:54.200311] WDIAG [SQL] handle_text_query (ob_sql.cpp:2817) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=6][errcode=-5217] fail to handle physical plan(ret=-5217)
[2025-02-27 10:12:54.200321] WDIAG [SQL] stmt_query (ob_sql.cpp:232) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=8][errcode=-5217] fail to handle text query(stmt=SELECT left(t2.DEPT_ADRRESSCODE, 4) FROM wstjfx.HZ_NB_YY t2 GROUP BY  left(t2.DEPT_ADRRESSCODE,4) HAVING left(t2.DEPT_ADRRESSCODE,4) is NOT NULL, ret=-5217)
[2025-02-27 10:12:54.200339] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:999) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=9][errcode=-5217] [RETRY] check if need retry(v={force_local_retry:false, stmt_retry_times:0, local_retry_times:0, err_:-5217, err_:"OB_ERR_BAD_FIELD_ERROR", retry_type:0, client_ret:-5217}, need_retry=false)
[2025-02-27 10:12:54.200352] WDIAG [SERVER] do_process (obmp_query.cpp:764) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=12][errcode=-5217] run stmt_query failed, check if need retry(ret=-5217, cli_ret=-5217, retry_ctrl_.need_retry()=0, sql=SELECT left(t2.DEPT_ADRRESSCODE, 4) FROM wstjfx.HZ_NB_YY t2 GROUP BY  left(t2.DEPT_ADRRESSCODE,4) HAVING left(t2.DEPT_ADRRESSCODE,4) is NOT NULL)
[2025-02-27 10:12:54.200366] WDIAG [SERVER] do_process (obmp_query.cpp:890) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=11][errcode=-5217] query failed(ret=-5217, session={this:0xfffc1a507d38, id:3222637313, deser:false, tenant:"jxh", tenant_id:1002, effective_tenant:"jxh", effective_tenant_id:1002, database:"wstjfx", user:"wstjfx@%", consistency_level:3, session_state:2, autocommit:true, tx:0xfffc1521b390}, sql=SELECT left(t2.DEPT_ADRRESSCODE, 4) FROM wstjfx.HZ_NB_YY t2 GROUP BY  left(t2.DEPT_ADRRESSCODE,4) HAVING left(t2.DEPT_ADRRESSCODE,4) is NOT NULL, retry_ctrl_.need_retry()=0)
[2025-02-27 10:12:54.200406] INFO  [SERVER] send_error_packet (obmp_packet_sender.cpp:378) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=15] sending error packet(ob_error=-5217, client error=1054, extra_err_info=NULL, lbt()="0x10af5c04 0xb6d0454 0xb684634 0x104a7a48 0x104982c4 0x10492aa8 0x10491200 0x1048272c 0xb49ce58 0x19da36e8 0xfffd638a88c0 0xfffd637e089c")
[2025-02-27 10:12:54.200453] INFO  [SERVER] send_error_packet (obmp_packet_sender.cpp:580) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=11] dump txn free route audit_record(value=1048581, session->get_sessid()=3222637313, session->get_proxy_sessid()=777236472642366542)
[2025-02-27 10:12:54.200576] WDIAG [SERVER.OMT] process_one (ob_worker_processor.cpp:89) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=8][errcode=-5217] process request fail(ret=-5217)
[2025-02-27 10:12:54.200587] WDIAG [SERVER.OMT] process (ob_worker_processor.cpp:157) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE320-0-0] [lt=9][errcode=-5217] process request fail(ret=-5217)
[root@localhost log]# sed -n "/Y32520AC94C76-00062A5AFA0BE36D-0-0/p" observer.log
[2025-02-27 10:19:14.840416] WDIAG [SQL.RESV] resolve_qualified_identifier (ob_dml_resolver.cpp:3251) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=16][errcode=-5217] resolve column ref expr failed(ret=-5217, q_name={database_name:"", table_name:"t2", column:"DEPT_ADRRESSCODE", dblink_name:"", is_star:false, ref_expr:{item_type:"T_REF_COLUMN", 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_COLUMN", "CNT_COLUMN"], rel_id:[], table_id:18446744073709551615, column_id:18446744073709551615, database_name:"", table_name:"", synonym_name:"", synonym_db_name:"", column_name:"", column_flags:0, enum_set_values:[], is_lob_column:false, is_joined_dup_column:false, is_unpivot_mocked_column:false, is_hidden:false, from_alias_table:false, is_rowkey_column:false, is_unique_key_column:false, is_mul_key_column:false, is_strict_json_column:0, srs_id:18446744073709551615, udt_set_id:0}, parents_expr_info:[], parent_aggr_level:-1, access_idents:[], current_resolve_level:0, is_access_root:true})
[2025-02-27 10:19:14.840465] WDIAG report_user_error_msg (ob_dml_resolver.cpp:3337) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=44][errcode=-5217] Unknown column 't2.DEPT_ADRRESSCODE' in 'having clause'
[2025-02-27 10:19:14.840472] WDIAG [SQL.RESV] resolve_sql_expr (ob_dml_resolver.cpp:1778) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=6][errcode=-5217] resolve columns failed(ret=-5217)
[2025-02-27 10:19:14.840483] WDIAG [SQL.RESV] resolve_and_split_sql_expr (ob_dml_resolver.cpp:6843) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=10][errcode=-5217] resolve sql expr failed(ret=-5217)
[2025-02-27 10:19:14.840494] WDIAG [SQL.RESV] resolve_and_split_sql_expr_with_bool_expr (ob_dml_resolver.cpp:6870) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=10][errcode=-5217] resolve_and_split_sql_expr failed(ret=-5217)
[2025-02-27 10:19:14.840503] WDIAG [SQL.RESV] resolve_having_clause (ob_select_resolver.cpp:4778) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=8][errcode=-5217] resolve and split sql expr failed(ret=-5217)
[2025-02-27 10:19:14.840511] WDIAG [SQL.RESV] resolve_normal_query (ob_select_resolver.cpp:1370) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=8][errcode=-5217] fail to exec resolve_having_clause(having)(ret=-5217)
[2025-02-27 10:19:14.840516] WDIAG [SQL.RESV] resolve (ob_select_resolver.cpp:1556) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=4][errcode=-5217] resolve normal query failed(ret=-5217)
[2025-02-27 10:19:14.840524] WDIAG [SQL.RESV] select_stmt_resolver_func (ob_resolver.cpp:190) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=7][errcode=-5217] execute stmt_resolver failed(ret=-5217, parse_tree.type_=3299)
[2025-02-27 10:19:14.840542] WDIAG [SQL] generate_stmt (ob_sql.cpp:3107) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=10][errcode=-5217] failed to resolve(ret=-5217)
[2025-02-27 10:19:14.840556] WDIAG [SQL] generate_physical_plan (ob_sql.cpp:3228) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=13][errcode=-5217] Failed to generate stmt(ret=-5217, result.get_exec_context().need_disconnect()=false)
[2025-02-27 10:19:14.840566] WDIAG [SQL] handle_physical_plan (ob_sql.cpp:5116) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=9][errcode=-5217] Failed to generate plan(ret=-5217, result.get_exec_context().need_disconnect()=false)
[2025-02-27 10:19:14.840571] WDIAG [SQL] handle_text_query (ob_sql.cpp:2817) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=4][errcode=-5217] fail to handle physical plan(ret=-5217)
[2025-02-27 10:19:14.840580] WDIAG [SQL] stmt_query (ob_sql.cpp:232) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=8][errcode=-5217] fail to handle text query(stmt=SELECT left(t2.DEPT_ADRRESSCODE, 4) FROM wstjfx.HZ_NB_YY t2 GROUP BY  left(t2.DEPT_ADRRESSCODE,4) HAVING left(t2.DEPT_ADRRESSCODE,4) is NOT NULL, ret=-5217)
[2025-02-27 10:19:14.840598] WDIAG [SERVER] after_func (ob_query_retry_ctrl.cpp:999) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=9][errcode=-5217] [RETRY] check if need retry(v={force_local_retry:false, stmt_retry_times:0, local_retry_times:0, err_:-5217, err_:"OB_ERR_BAD_FIELD_ERROR", retry_type:0, client_ret:-5217}, need_retry=false)
[2025-02-27 10:19:14.840611] WDIAG [SERVER] do_process (obmp_query.cpp:764) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=12][errcode=-5217] run stmt_query failed, check if need retry(ret=-5217, cli_ret=-5217, retry_ctrl_.need_retry()=0, sql=SELECT left(t2.DEPT_ADRRESSCODE, 4) FROM wstjfx.HZ_NB_YY t2 GROUP BY  left(t2.DEPT_ADRRESSCODE,4) HAVING left(t2.DEPT_ADRRESSCODE,4) is NOT NULL)
[2025-02-27 10:19:14.840623] WDIAG [SERVER] do_process (obmp_query.cpp:890) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=10][errcode=-5217] query failed(ret=-5217, session={this:0xfffc1a507d38, id:3222637313, deser:false, tenant:"jxh", tenant_id:1002, effective_tenant:"jxh", effective_tenant_id:1002, database:"wstjfx", user:"wstjfx@%", consistency_level:3, session_state:2, autocommit:true, tx:0xfffc1521b390}, sql=SELECT left(t2.DEPT_ADRRESSCODE, 4) FROM wstjfx.HZ_NB_YY t2 GROUP BY  left(t2.DEPT_ADRRESSCODE,4) HAVING left(t2.DEPT_ADRRESSCODE,4) is NOT NULL, retry_ctrl_.need_retry()=0)
[2025-02-27 10:19:14.840660] INFO  [SERVER] send_error_packet (obmp_packet_sender.cpp:378) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=15] sending error packet(ob_error=-5217, client error=1054, extra_err_info=NULL, lbt()="0x10af5c04 0xb6d0454 0xb684634 0x104a7a48 0x104982c4 0x10492aa8 0x10491200 0x1048272c 0xb49ce58 0x19da36e8 0xfffd638a88c0 0xfffd637e089c")
[2025-02-27 10:19:14.840709] INFO  [SERVER] send_error_packet (obmp_packet_sender.cpp:580) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=11] dump txn free route audit_record(value=1048581, session->get_sessid()=3222637313, session->get_proxy_sessid()=777236472642366542)
[2025-02-27 10:19:14.840819] WDIAG [SERVER.OMT] process_one (ob_worker_processor.cpp:89) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=8][errcode=-5217] process request fail(ret=-5217)
[2025-02-27 10:19:14.840829] WDIAG [SERVER.OMT] process (ob_worker_processor.cpp:157) [45044][T1002_L0_G0][T1002][Y32520AC94C76-00062A5AFA0BE36D-0-0] [lt=9][errcode=-5217] process request fail(ret=-5217)