[2024-08-07 15:38:50.571497] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] deallocating sm(sm_id=129494) [2024-08-07 15:38:51.627059] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56884c8a10, client_ip={127.0.0.1:59218}) [2024-08-07 15:38:51.627169] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] vip connect(protocol=6, fd=121, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:59218}, daddr={127.0.0.1:2883}) [2024-08-07 15:38:51.627206] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] client session born(cs_id=794953, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56884c8a10, client_fd=121, client_addr="127.0.0.1:59218", is_proxy_client=false) [2024-08-07 15:38:51.627246] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] Starting new transaction using sm(cs_id=794953, get_transact_count()=0, sm_id=129495) [2024-08-07 15:38:51.627448] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129495) [2024-08-07 15:38:51.627466] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] client will abort soon(sm_id=129495, cs_id=794953, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:59218}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:38:51.627481] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] will deallocate sm(sm_id=129495, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:38:51.627506] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f56884d6bc0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1883, cs_id:794953, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56884c8a10, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56884c8a10, this=0x7f56884d6bc0) [2024-08-07 15:38:51.627607] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] client session destroy(cs_id=794953, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:38:51.627622] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] deallocating sm(sm_id=129495) [2024-08-07 15:38:52.686745] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56886b66c0, client_ip={127.0.0.1:59232}) [2024-08-07 15:38:52.686824] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] vip connect(protocol=6, fd=126, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:59232}, daddr={127.0.0.1:2883}) [2024-08-07 15:38:52.686835] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] client session born(cs_id=794954, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56886b66c0, client_fd=126, client_addr="127.0.0.1:59232", is_proxy_client=false) [2024-08-07 15:38:52.686862] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] Starting new transaction using sm(cs_id=794954, get_transact_count()=0, sm_id=129496) [2024-08-07 15:38:52.687129] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129496) [2024-08-07 15:38:52.687192] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] client will abort soon(sm_id=129496, cs_id=794954, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:59232}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:38:52.687225] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] will deallocate sm(sm_id=129496, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:38:52.687234] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f56884d6bc0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1883, cs_id:794954, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56886b66c0, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56886b66c0, this=0x7f56884d6bc0) [2024-08-07 15:38:52.687305] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] client session destroy(cs_id=794954, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:38:52.687322] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] deallocating sm(sm_id=129496) [2024-08-07 15:38:53.746031] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56884c8a10, client_ip={127.0.0.1:59246}) [2024-08-07 15:38:53.746128] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] vip connect(protocol=6, fd=124, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:59246}, daddr={127.0.0.1:2883}) [2024-08-07 15:38:53.746139] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] client session born(cs_id=794955, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56884c8a10, client_fd=124, client_addr="127.0.0.1:59246", is_proxy_client=false) [2024-08-07 15:38:53.746190] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] Starting new transaction using sm(cs_id=794955, get_transact_count()=0, sm_id=129497) [2024-08-07 15:38:53.746396] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129497) [2024-08-07 15:38:53.746414] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] client will abort soon(sm_id=129497, cs_id=794955, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:59246}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:38:53.746435] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] will deallocate sm(sm_id=129497, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:38:53.746446] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f56884d6bc0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1883, cs_id:794955, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56884c8a10, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56884c8a10, this=0x7f56884d6bc0) [2024-08-07 15:38:53.746569] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] client session destroy(cs_id=794955, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:38:53.746601] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] deallocating sm(sm_id=129497) [2024-08-07 15:38:54.805002] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56886b66c0, client_ip={127.0.0.1:59258}) [2024-08-07 15:38:54.805100] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] vip connect(protocol=6, fd=121, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:59258}, daddr={127.0.0.1:2883}) [2024-08-07 15:38:54.805111] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] client session born(cs_id=794956, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56886b66c0, client_fd=121, client_addr="127.0.0.1:59258", is_proxy_client=false) [2024-08-07 15:38:54.805163] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] Starting new transaction using sm(cs_id=794956, get_transact_count()=0, sm_id=129498) [2024-08-07 15:38:54.805383] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129498) [2024-08-07 15:38:54.805400] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] client will abort soon(sm_id=129498, cs_id=794956, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:59258}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:38:54.805415] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] will deallocate sm(sm_id=129498, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:38:54.805424] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f56884d6bc0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1883, cs_id:794956, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56886b66c0, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56886b66c0, this=0x7f56884d6bc0) [2024-08-07 15:38:54.805518] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] client session destroy(cs_id=794956, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:38:54.805534] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1883][Y0-00007F56886D0980] [lt=0] [dc=0] deallocating sm(sm_id=129498) [2024-08-07 15:38:55.081350] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56884c8a10, client_ip={192.168.18.11:49110}) [2024-08-07 15:38:55.081402] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] vip connect(protocol=6, fd=126, vid=0, vaddr={192.168.18.11:2883}, caddr={192.168.18.11:49110}, daddr={192.168.6.156:2883}) [2024-08-07 15:38:55.081412] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] client session born(cs_id=794957, proxy_sessid=0, is_local_connection=false, client_vc=0x7f56884c8a10, client_fd=126, client_addr="192.168.18.11:49110", is_proxy_client=false) [2024-08-07 15:38:55.081425] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] Starting new transaction using sm(cs_id=794957, get_transact_count()=0, sm_id=129499) [2024-08-07 15:38:55.082821] WDIAG [PROXY] update_system_variable (ob_session_field_mgr.cpp:900) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] fail to get sys var from global set(name=ob_max_read_stale_time, ret=-5044) [2024-08-07 15:38:55.082837] WDIAG [PROXY] update_sys_variable (ob_proxy_session_info.cpp:748) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] fail to update system variable(var_name=ob_max_read_stale_time, ret=-5044) [2024-08-07 15:38:55.084141] INFO [PROXY.ICMD] handle_select_session_variables (ob_dds_config_handler.cpp:222) [1913][Y0-00007F56886546D0] [lt=0] [dc=0] succ to encode_eof_packet [2024-08-07 15:38:55.084434] INFO show_info (ob_concurrency_objpool.cpp:29) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] [08][lib/objectpool/ob_concurrency_objpool.cpp:00638][F] mem_total:161.07M total:2846 free:1 avg:1.0 malloc:2845 obj_cnt_base:64 obj_cnt_per_chunk:64 obj_size:8208 max_chunk_count:1 thread_chunk_count:47 chunk_size:532480 name:ObBufAllocator lbt:0x211c73 0x1ef6e1 0x1ea10c 0x1b9922 0x1b76e6 0x1b7463 0x82c5a9 0x7b80b3 0x7c2255 0x99c2c1 0x99cbce 0x7cbfdd 0x7c5c9d 0x939b83 0x287687 0x288a95 0x243275 0x152f1a6 0x152b0c1 0x729b7f 0x7f56a75f31ca 0x7f56a6edde73 [2024-08-07 15:38:55.084472] INFO show_info (ob_concurrency_objpool.cpp:29) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] [08][lib/objectpool/ob_concurrency_objpool.cpp:00646][-] mem_total:161.07M total:2846 free:1 avg:1.0 malloc:2845 obj_cnt_base:64 obj_cnt_per_chunk:64 obj_size:8208 max_chunk_count:1 thread_chunk_count:47 chunk_size:532480 name:ObBufAllocator lbt:0x211c73 0x1ef6e1 0x1ea0e9 0x1b9922 0x1b76e6 0x1b7463 0x82c5a9 0x7b80b3 0x7c2255 0x99c2c1 0x99cbce 0x7cbfdd 0x7c5c9d 0x939b83 0x287687 0x288a95 0x243275 0x152f1a6 0x152b0c1 0x729b7f 0x7f56a75f31ca 0x7f56a6edde73 [2024-08-07 15:38:55.087071] INFO [PROXY.ICMD] handle_select_session_variables (ob_dds_config_handler.cpp:222) [1914][Y0-00007F56886546D0] [lt=0] [dc=0] succ to encode_eof_packet [2024-08-07 15:38:55.087375] INFO show_info (ob_concurrency_objpool.cpp:29) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] [08][lib/objectpool/ob_concurrency_objpool.cpp:00638][F] mem_total:161.07M total:2846 free:1 avg:1.0 malloc:2845 obj_cnt_base:64 obj_cnt_per_chunk:64 obj_size:8208 max_chunk_count:1 thread_chunk_count:47 chunk_size:532480 name:ObBufAllocator lbt:0x211c73 0x1ef6e1 0x1ea10c 0x1b9922 0x1b76e6 0x1b7463 0x82c5a9 0x7b80b3 0x7c2255 0x99c2c1 0x99cbce 0x7cbfdd 0x7c5c9d 0x939b83 0x287687 0x288a95 0x243275 0x152f1a6 0x152b0c1 0x729b7f 0x7f56a75f31ca 0x7f56a6edde73 [2024-08-07 15:38:55.087412] INFO show_info (ob_concurrency_objpool.cpp:29) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] [08][lib/objectpool/ob_concurrency_objpool.cpp:00646][-] mem_total:161.07M total:2846 free:1 avg:1.0 malloc:2845 obj_cnt_base:64 obj_cnt_per_chunk:64 obj_size:8208 max_chunk_count:1 thread_chunk_count:47 chunk_size:532480 name:ObBufAllocator lbt:0x211c73 0x1ef6e1 0x1ea0e9 0x1b9922 0x1b76e6 0x1b7463 0x82c5a9 0x7b80b3 0x7c2255 0x99c2c1 0x99cbce 0x7cbfdd 0x7c5c9d 0x939b83 0x287687 0x288a95 0x243275 0x152f1a6 0x152b0c1 0x729b7f 0x7f56a75f31ca 0x7f56a6edde73 [2024-08-07 15:38:55.861717] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56886b66c0, client_ip={127.0.0.1:59274}) [2024-08-07 15:38:55.861801] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] vip connect(protocol=6, fd=124, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:59274}, daddr={127.0.0.1:2883}) [2024-08-07 15:38:55.861813] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session born(cs_id=799192, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56886b66c0, client_fd=124, client_addr="127.0.0.1:59274", is_proxy_client=false) [2024-08-07 15:38:55.861866] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] Starting new transaction using sm(cs_id=799192, get_transact_count()=0, sm_id=129500) [2024-08-07 15:38:55.862082] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129500) [2024-08-07 15:38:55.862098] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client will abort soon(sm_id=129500, cs_id=799192, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:59274}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:38:55.862111] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] will deallocate sm(sm_id=129500, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:38:55.862120] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f5687aa43f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1884, cs_id:799192, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56886b66c0, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56886b66c0, this=0x7f5687aa43f0) [2024-08-07 15:38:55.862224] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session destroy(cs_id=799192, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:38:55.862252] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] deallocating sm(sm_id=129500) [2024-08-07 15:38:56.918393] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56884c8030, client_ip={127.0.0.1:59290}) [2024-08-07 15:38:56.918470] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] vip connect(protocol=6, fd=121, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:59290}, daddr={127.0.0.1:2883}) [2024-08-07 15:38:56.918481] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session born(cs_id=799193, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56884c8030, client_fd=121, client_addr="127.0.0.1:59290", is_proxy_client=false) [2024-08-07 15:38:56.918519] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] Starting new transaction using sm(cs_id=799193, get_transact_count()=0, sm_id=129501) [2024-08-07 15:38:56.918754] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129501) [2024-08-07 15:38:56.918785] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client will abort soon(sm_id=129501, cs_id=799193, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:59290}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:38:56.918804] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] will deallocate sm(sm_id=129501, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:38:56.918813] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f5687aa43f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1884, cs_id:799193, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56884c8030, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56884c8030, this=0x7f5687aa43f0) [2024-08-07 15:38:56.918899] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session destroy(cs_id=799193, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:38:56.918917] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] deallocating sm(sm_id=129501) [2024-08-07 15:38:57.370398] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56886b66c0, client_ip={127.0.0.1:59300}) [2024-08-07 15:38:57.370483] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] vip connect(protocol=6, fd=127, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:59300}, daddr={127.0.0.1:2883}) [2024-08-07 15:38:57.370492] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session born(cs_id=799194, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56886b66c0, client_fd=127, client_addr="127.0.0.1:59300", is_proxy_client=false) [2024-08-07 15:38:57.370516] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] Starting new transaction using sm(cs_id=799194, get_transact_count()=0, sm_id=129502) [2024-08-07 15:38:57.372463] INFO [PROXY.SM] state_client_request_read (ob_mysql_sm.cpp:588) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] ObMysqlSM::state_client_request_read(event="VC_EVENT_EOS", sm_id=129502, client_vc=0x7f56886b66c0) [2024-08-07 15:38:57.372478] INFO [PROXY.TXN] bad_request (ob_mysql_transact.cpp:144) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] [ObMysqlTransact::bad_request] parser marked request bad [2024-08-07 15:38:57.372486] WDIAG [PROXY.SM] handle_obproxy_error_transfer (ob_mysql_sm.cpp:9426) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] [setup_error_transfer] Now closing connection(sm_id=129502, client_ip={127.0.0.1:59300}, request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:38:57.372491] INFO [PROXY.SM] setup_error_transfer (ob_mysql_sm.cpp:9324) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] setup_error_transfer, transfer internal buffer and try to disconnect(sql_cmd=241, internal_state=9) [2024-08-07 15:38:57.372497] WDIAG [PROXY] sql_escape (ob_proxy_monitor_utils.cpp:54) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] invalid_argument(sql=NULL, sql_len=0, new_sql=0x7f568fa62b78, new_sql_size=1024, ret=-4002) [2024-08-07 15:38:57.372512] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] will deallocate sm(sm_id=129502, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:38:57.372518] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f5687aa43f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1884, cs_id:799194, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56886b66c0, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56886b66c0, this=0x7f5687aa43f0) [2024-08-07 15:38:57.372572] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session destroy(cs_id=799194, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:38:57.372585] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] deallocating sm(sm_id=129502) [2024-08-07 15:38:57.923061] WDIAG [PROXY.ICMD] handle_select_sql_variables (ob_dds_config_handler.cpp:305) [1913][Y0-00007F56886546D0] [lt=0] [dc=0] invalid select_col(select_col=svr_ip, sql_port, sql=select svr_ip, sql_port from oceanbase.__all_virtual_proxy_schema) [2024-08-07 15:38:57.923112] INFO [PROXY.ICMD] encode_err_packet (ob_internal_cmd_handler.cpp:251) [1913][Y0-00007F56886546D0] [lt=0] [dc=0] succ to encode err packet(errcode=-4016, err_msg="Internal error") [2024-08-07 15:38:57.923116] INFO [PROXY.ICMD] internal_error_callback (ob_internal_cmd_handler.cpp:551) [1913][Y0-00007F56886546D0] [lt=0] [dc=0] succ to encode internal err packet, callback(errcode=-4016) [2024-08-07 15:38:57.923462] INFO show_info (ob_concurrency_objpool.cpp:29) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] [08][lib/objectpool/ob_concurrency_objpool.cpp:00638][F] mem_total:161.07M total:2846 free:1 avg:1.0 malloc:2845 obj_cnt_base:64 obj_cnt_per_chunk:64 obj_size:8208 max_chunk_count:1 thread_chunk_count:47 chunk_size:532480 name:ObBufAllocator lbt:0x211c73 0x1ef6e1 0x1ea10c 0x1b9922 0x1b76e6 0x1b7463 0x82c5a9 0x7b80b3 0x7c2255 0x99c2c1 0x99cbce 0x7cbfdd 0x7c5c9d 0x939b83 0x287687 0x288a95 0x243275 0x152f1a6 0x152b0c1 0x729b7f 0x7f56a75f31ca 0x7f56a6edde73 [2024-08-07 15:38:57.923493] INFO show_info (ob_concurrency_objpool.cpp:29) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] [08][lib/objectpool/ob_concurrency_objpool.cpp:00646][-] mem_total:161.07M total:2846 free:1 avg:1.0 malloc:2845 obj_cnt_base:64 obj_cnt_per_chunk:64 obj_size:8208 max_chunk_count:1 thread_chunk_count:47 chunk_size:532480 name:ObBufAllocator lbt:0x211c73 0x1ef6e1 0x1ea0e9 0x1b9922 0x1b76e6 0x1b7463 0x82c5a9 0x7b80b3 0x7c2255 0x99c2c1 0x99cbce 0x7cbfdd 0x7c5c9d 0x939b83 0x287687 0x288a95 0x243275 0x152f1a6 0x152b0c1 0x729b7f 0x7f56a75f31ca 0x7f56a6edde73 [2024-08-07 15:38:57.924706] INFO [PROXY.ICMD] handle_select_session_variables (ob_dds_config_handler.cpp:222) [1914][Y0-00007F56886546D0] [lt=0] [dc=0] succ to encode_eof_packet [2024-08-07 15:38:57.924996] INFO show_info (ob_concurrency_objpool.cpp:29) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] [08][lib/objectpool/ob_concurrency_objpool.cpp:00638][F] mem_total:161.07M total:2846 free:1 avg:1.0 malloc:2845 obj_cnt_base:64 obj_cnt_per_chunk:64 obj_size:8208 max_chunk_count:1 thread_chunk_count:47 chunk_size:532480 name:ObBufAllocator lbt:0x211c73 0x1ef6e1 0x1ea10c 0x1b9922 0x1b76e6 0x1b7463 0x82c5a9 0x7b80b3 0x7c2255 0x99c2c1 0x99cbce 0x7cbfdd 0x7c5c9d 0x939b83 0x287687 0x288a95 0x243275 0x152f1a6 0x152b0c1 0x729b7f 0x7f56a75f31ca 0x7f56a6edde73 [2024-08-07 15:38:57.925037] INFO show_info (ob_concurrency_objpool.cpp:29) [1883][Y0-00007F56884D08C0] [lt=0] [dc=0] [08][lib/objectpool/ob_concurrency_objpool.cpp:00646][-] mem_total:161.07M total:2846 free:1 avg:1.0 malloc:2845 obj_cnt_base:64 obj_cnt_per_chunk:64 obj_size:8208 max_chunk_count:1 thread_chunk_count:47 chunk_size:532480 name:ObBufAllocator lbt:0x211c73 0x1ef6e1 0x1ea0e9 0x1b9922 0x1b76e6 0x1b7463 0x82c5a9 0x7b80b3 0x7c2255 0x99c2c1 0x99cbce 0x7cbfdd 0x7c5c9d 0x939b83 0x287687 0x288a95 0x243275 0x152f1a6 0x152b0c1 0x729b7f 0x7f56a75f31ca 0x7f56a6edde73 [2024-08-07 15:38:57.975470] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56884c8030, client_ip={127.0.0.1:59306}) [2024-08-07 15:38:57.975557] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] vip connect(protocol=6, fd=124, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:59306}, daddr={127.0.0.1:2883}) [2024-08-07 15:38:57.975567] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session born(cs_id=799195, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56884c8030, client_fd=124, client_addr="127.0.0.1:59306", is_proxy_client=false) [2024-08-07 15:38:57.975606] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] Starting new transaction using sm(cs_id=799195, get_transact_count()=0, sm_id=129503) [2024-08-07 15:38:57.975844] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129503) [2024-08-07 15:38:57.975859] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client will abort soon(sm_id=129503, cs_id=799195, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:59306}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:38:57.975871] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] will deallocate sm(sm_id=129503, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:38:57.975878] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f5687aa43f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1884, cs_id:799195, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56884c8030, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56884c8030, this=0x7f5687aa43f0) [2024-08-07 15:38:57.975959] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session destroy(cs_id=799195, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:38:57.975973] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] deallocating sm(sm_id=129503) [2024-08-07 15:38:59.032651] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56886b66c0, client_ip={127.0.0.1:59318}) [2024-08-07 15:38:59.032741] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] vip connect(protocol=6, fd=121, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:59318}, daddr={127.0.0.1:2883}) [2024-08-07 15:38:59.032752] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session born(cs_id=799196, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56886b66c0, client_fd=121, client_addr="127.0.0.1:59318", is_proxy_client=false) [2024-08-07 15:38:59.032801] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] Starting new transaction using sm(cs_id=799196, get_transact_count()=0, sm_id=129504) [2024-08-07 15:38:59.033005] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129504) [2024-08-07 15:38:59.033023] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client will abort soon(sm_id=129504, cs_id=799196, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:59318}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:38:59.033042] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] will deallocate sm(sm_id=129504, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:38:59.033064] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f5687aa43f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1884, cs_id:799196, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56886b66c0, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56886b66c0, this=0x7f5687aa43f0) [2024-08-07 15:38:59.033203] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session destroy(cs_id=799196, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:38:59.033231] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] deallocating sm(sm_id=129504) [2024-08-07 15:39:00.091582] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56884c8030, client_ip={127.0.0.1:59326}) [2024-08-07 15:39:00.091690] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] vip connect(protocol=6, fd=127, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:59326}, daddr={127.0.0.1:2883}) [2024-08-07 15:39:00.091701] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session born(cs_id=799197, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56884c8030, client_fd=127, client_addr="127.0.0.1:59326", is_proxy_client=false) [2024-08-07 15:39:00.091728] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] Starting new transaction using sm(cs_id=799197, get_transact_count()=0, sm_id=129505) [2024-08-07 15:39:00.091905] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129505) [2024-08-07 15:39:00.091940] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client will abort soon(sm_id=129505, cs_id=799197, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:59326}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:39:00.091954] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] will deallocate sm(sm_id=129505, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:39:00.091964] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f5687aa43f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1884, cs_id:799197, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56884c8030, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56884c8030, this=0x7f5687aa43f0) [2024-08-07 15:39:00.092050] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session destroy(cs_id=799197, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:39:00.092066] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] deallocating sm(sm_id=129505) [2024-08-07 15:39:00.349628] INFO [PROXY.SS] do_io_close (ob_mysql_server_session.cpp:153) [1734][Y0-00007F568C68BF30] [lt=0] [dc=0] server session do_io_close((*this={ss_id:15374, server_sessid:3221604356, server_ip:{192.168.6.154:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7f568f277630, client_session:{this:0x7f56898dd670, is_proxy_mysql_client:true, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1734, cs_id:789745, proxy_sessid:13882353118643159043, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:789745, user_priv_set:512, cluster_name:"ob01", tenant_name:"sys", user_name:"proxyro"}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:2, user_var_version:1, db_name_version:1, last_insert_id_version:0, sess_info_version:39874}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:0, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:0, real_meta_cluster_name:"", safe_read_snapshot:1, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:0, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:3013447, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"192.168.6.156:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"192.168.6.154:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"192.168.6.155:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7f5688c3e8a0, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7f5684b535e0, server_state_version:2, cur_ss:null, bound_ss:0x7f568dc44820, lii_ss:null, cluster_resource:{this:0x7f5680b06080, ref_count:12, is_inited:true, cluster_info_key:{cluster_name:{config_string:"ob01"}, cluster_id:0}, cr_state:"CR_AVAIL", version:2, last_access_time_ns:1723016018537361253, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1723013186783087444, last_rslist_refresh_time_ns:1722933922478734396, server_state_version:2}, client_vc:0x7f5684baeb80, using_ldg:false, trace_stats:NULL}, transact_count:2, server_trans_stat:0, session_info:{cap:3013447, ob_server:, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:2, user_var_version:1, db_name_version:1, last_insert_id_version:0, sess_info_version:39874}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, checksum_switch:1, server_type:1}}, server_vc_=0x7f568f277630, this=0x7f568dc44820) [2024-08-07 15:39:00.349802] INFO [PROXY.SS] do_io_close (ob_mysql_server_session.cpp:190) [1734][Y0-00007F568C68BF30] [lt=0] [dc=0] server session is closing(ss_id=15374, server_sessid=3221604356, server_ip={192.168.6.154:2881}, cs_id=789745, proxy_sessid=13882353118643159043) [2024-08-07 15:39:00.350021] INFO [PROXY.SS] new_connection (ob_mysql_server_session.cpp:106) [1734][Y0-00007F568C68BF30] [lt=0] [dc=0] server session born(ss_id=15375, server_ip={192.168.6.156:2881}, cs_id=789745, proxy_sessid=13882353118643159043, server_type=1) [2024-08-07 15:39:00.351579] INFO [PROXY] handle_capability_flag_var (ob_proxy_session_info_handler.cpp:771) [1734][Y0-00007F568C68BF30] [lt=0] [dc=0] succ to set ob_capability_flag in negotiation(client_cap=0, server_cap=3013447, orig_client_cap=0, orig_server_cap=4062023, client_support_ob_v2=false, server_support_checksum=false, server_support_ob_v2=true, server_support_ob_v2_compress=false, is_auth_request=false) [2024-08-07 15:39:00.353041] INFO [PROXY.TXN] handle_error_resp (ob_mysql_transact.cpp:4640) [1734][Y0-00007F568C68BF30] [lt=0] [dc=0] received reroute error, mayby need reroute((addr={192.168.6.156:2881}, pll_info={pl_attempts:1, lookup_success:true, force_renew_state:0, cached_dummy_entry_renew_state:0, te_name:{cluster_name:"ob01", tenant_name:"sys", database_name:"oceanbase", package_name:"", table_name:"__all_dummy"}, route:{consistency_level:"WEAK", cur_chosen_route_type:"ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL", cur_chosen_server:{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"192.168.6.156:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:true}, cur_chosen_pl:null, valid_count:3, leader_item:{idc_type:"", zone_type:"Invalid", replica:NULL, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:true}, ldc_route:{policy:"MERGE_IDC_ORDER_OPTIMIZED", disable_merge_status_check:false, curr_cursor_index:6, next_index_in_site:1, location:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"192.168.6.156:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:true}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"192.168.6.154:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"192.168.6.155:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7f5688c3e8a0, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}}, is_table_entry_from_remote:false, is_part_entry_from_remote:false, need_use_dup_replica:false, table_entry:0x7f5684b535e0, part_entry:null, dummy_entry:0x7f5684b535e0, skip_leader_item:false}}, state="RESPONSE_ERROR", error_type="REQUEST_REROUTE_ERROR", reroute_info={schema_version:1722924337575888, replica:{server:"192.168.6.154:2881", is_dup_replica:false, role:"LEADER", type:"FULL"}, table_name_buf:"__all_zone"}) [2024-08-07 15:39:00.353098] INFO [PROXY.TXN] handle_error_resp (ob_mysql_transact.cpp:4710) [1734][Y0-00007F568C68BF30] [lt=0] [dc=0] get err pkt from observer, not forward to client, will be consumed soon, and maybe need retry((send_action="SERVER_SEND_REQUEST", state="RESPONSE_ERROR", error_type="REQUEST_REROUTE_ERROR", resp={is_trans_completed:true, is_resp_completed:true, ending_type:2, is_partition_hit:true, has_new_sys_var:false, has_proxy_idc_name_user_var:false, is_server_db_reset:false, reserved_len:0, connection_id:0, scramble_buf:"", is_resultset_resp:false, server_capabilities_lower_.capability:0, ok_packet_action_type:2, last_ok_pkt_len:149, rewritten_last_ok_pkt_len:0, extra_info:{is_exist_sess_info:false, sess_info_count:0, extra_len:0}, error_pkt:field_count:255, errcode:5727, sqlstate:"HY000", message:"SQL request should be rerouted"}) [2024-08-07 15:39:00.353118] INFO [PROXY.TXN] handle_oceanbase_retry_server_connection (ob_mysql_transact.cpp:5631) [1734][Y0-00007F568C68BF30] [lt=0] [dc=0] pre try failed, will retry((retry_status=FOUND_EXISTING_ADDR, attempts now=2, max_connect_attempts=7, old_target_server={192.168.6.156:2881}, retry server={192.168.6.154:2881}, is_first_request=true, is_auth_request=false, is_force_renew=false, force_retry_congested=false, send_action="SERVER_SEND_REQUEST", state="RESPONSE_ERROR", route={consistency_level:"WEAK", cur_chosen_route_type:"ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL", cur_chosen_server:{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"192.168.6.156:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:true}, cur_chosen_pl:null, valid_count:3, leader_item:{idc_type:"", zone_type:"Invalid", replica:NULL, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:true}, ldc_route:{policy:"MERGE_IDC_ORDER_OPTIMIZED", disable_merge_status_check:false, curr_cursor_index:6, next_index_in_site:1, location:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"192.168.6.156:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:true}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"192.168.6.154:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"192.168.6.155:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7f5688c3e8a0, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}}, is_table_entry_from_remote:false, is_part_entry_from_remote:false, need_use_dup_replica:false, table_entry:0x7f5684b535e0, part_entry:null, dummy_entry:0x7f5684b535e0, skip_leader_item:false}, is_reroute_to_coordinator=false, is_in_trans=false, is_internal_routing=true, s.congestion_entry={ref_count:13, this:0x7f568dc7c5e0, zone_state:{ref_count:2, this:0x7f568dc726c0, zone_name:"zone3", region_name:"chengdu", state:"ACTIVE", last_revalidate_time_us:1722933922746622}, server_ip:{192.168.6.156:2881}, server_state:"DETECT_ALIVE", entry_state:"ENTRY_AVAIL", alive_congested:0, last_alive_congested:0, last_revalidate_time_us:1723010409499958, dead_congested:0, detect_congested:0, stat_alive_failures:0, stat_conn_failures:0, cr_version:2, conn_last_fail_time=0, conn_failure_events=0, alive_last_fail_time=0, alive_failure_events=0}) [2024-08-07 15:39:00.353254] INFO [PROXY.SS] do_io_close (ob_mysql_server_session.cpp:153) [1734][Y0-00007F568C68BF30] [lt=0] [dc=0] server session do_io_close((*this={ss_id:15375, server_sessid:3222071238, server_ip:{192.168.6.156:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7f568f277140, client_session:{this:0x7f56898dd670, is_proxy_mysql_client:true, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:false, magic:19132429, conn_decrease:true, current_tid:1734, cs_id:789745, proxy_sessid:13882353118643159043, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:789745, user_priv_set:512, cluster_name:"ob01", tenant_name:"sys", user_name:"proxyro"}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:2, user_var_version:1, db_name_version:1, last_insert_id_version:0, sess_info_version:39876}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:0, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:0, real_meta_cluster_name:"", safe_read_snapshot:1, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:0, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:3013447, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:3, site_start_index_array:[[0]0, [1]3, [2]3, [3]3], item_array:[[0]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"192.168.6.156:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [1]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"192.168.6.154:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}, [2]{idc_type:"SAME_IDC", zone_type:"ReadWrite", replica:{server:"192.168.6.155:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, is_merging:false, is_partition_server:false, is_force_congested:false, is_used:false}], pl:null, ts:0x7f5688c3e8a0, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7f5684b535e0, server_state_version:2, cur_ss:null, bound_ss:0x7f568dc44820, lii_ss:null, cluster_resource:{this:0x7f5680b06080, ref_count:12, is_inited:true, cluster_info_key:{cluster_name:{config_string:"ob01"}, cluster_id:0}, cr_state:"CR_AVAIL", version:2, last_access_time_ns:1723016018537361253, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:1723013186783087444, last_rslist_refresh_time_ns:1722933922478734396, server_state_version:2}, client_vc:0x7f5684baeb80, using_ldg:false, trace_stats:NULL}, transact_count:1, server_trans_stat:0, session_info:{cap:3013447, ob_server:, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:2, user_var_version:1, db_name_version:1, last_insert_id_version:0, sess_info_version:39876}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, checksum_switch:1, server_type:1}}, server_vc_=0x7f568f277140, this=0x7f568dc44820) [2024-08-07 15:39:00.353351] INFO [PROXY.SS] do_io_close (ob_mysql_server_session.cpp:190) [1734][Y0-00007F568C68BF30] [lt=0] [dc=0] server session is closing(ss_id=15375, server_sessid=3222071238, server_ip={192.168.6.156:2881}, cs_id=789745, proxy_sessid=13882353118643159043) [2024-08-07 15:39:00.353788] INFO [PROXY.SS] new_connection (ob_mysql_server_session.cpp:106) [1734][Y0-00007F568C68BF30] [lt=0] [dc=0] server session born(ss_id=15376, server_ip={192.168.6.154:2881}, cs_id=789745, proxy_sessid=13882353118643159043, server_type=1) [2024-08-07 15:39:00.356147] INFO [PROXY] handle_capability_flag_var (ob_proxy_session_info_handler.cpp:771) [1734][Y0-00007F568C68BF30] [lt=0] [dc=0] succ to set ob_capability_flag in negotiation(client_cap=0, server_cap=3013447, orig_client_cap=0, orig_server_cap=4062023, client_support_ob_v2=false, server_support_checksum=false, server_support_ob_v2=true, server_support_ob_v2_compress=false, is_auth_request=false) [2024-08-07 15:39:00.359716] INFO [PROXY.SM] update_cmd_stats (ob_mysql_sm.cpp:10655) [1734][Y0-00007F568C68BF30] [lt=0] [dc=0] Slow Query: ((client_ip={*Not IP address [0]*:0}, server_ip={192.168.6.154:2881}, obproxy_client_port={192.168.6.156:58396}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=proxyro, tenant_name=sys, cluster_name=ob01, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=0, cs_id=789745, proxy_sessid=13882353118643159043, ss_id=15376, server_sessid=3221605438, sm_id=29533, cmd_size_stats={client_request_bytes:162, server_request_bytes:197, server_response_bytes:0, client_response_bytes:528}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=39, client_request_analyze_time_us=36, cluster_resource_create_time_us=0, pl_lookup_time_us=27, pl_process_time_us=37, bl_lookup_time_us=0, bl_process_time_us=0, congestion_control_time_us=19, congestion_process_time_us=1, do_observer_open_time_us=970, server_connect_time_us=411, server_sync_session_variable_time_us=6310, server_send_saved_login_time_us=3140, server_send_use_database_time_us=1458, server_send_session_variable_time_us=0, server_send_session_user_variable_time_us=1711, server_send_all_session_variable_time_us=0, server_send_start_trans_time_us=0, server_send_xa_start_time_us=0, server_send_init_sql_time_us=0, build_server_request_time_us=59, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=3178, server_request_write_time_us=38, server_process_request_time_us=1165, server_response_read_time_us=7, plugin_decompress_response_time_us=7, server_response_analyze_time_us=11, ok_packet_trim_time_us=0, client_response_write_time_us=39, request_total_time_us=10206}, sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ zone, status, 0 AS is_merging, region, idc AS spare4, type AS spare5 FROM oceanbase.DBA_OB_ZONES LIMIT 9223372036854775807, trans_internal_routing_state=not in trans) [2024-08-07 15:39:01.150982] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56886b66c0, client_ip={127.0.0.1:40508}) [2024-08-07 15:39:01.151083] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] vip connect(protocol=6, fd=124, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:40508}, daddr={127.0.0.1:2883}) [2024-08-07 15:39:01.151095] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session born(cs_id=799198, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56886b66c0, client_fd=124, client_addr="127.0.0.1:40508", is_proxy_client=false) [2024-08-07 15:39:01.151148] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] Starting new transaction using sm(cs_id=799198, get_transact_count()=0, sm_id=129506) [2024-08-07 15:39:01.151367] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129506) [2024-08-07 15:39:01.151384] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client will abort soon(sm_id=129506, cs_id=799198, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:40508}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:39:01.151399] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] will deallocate sm(sm_id=129506, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:39:01.151407] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f5687aa43f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1884, cs_id:799198, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56886b66c0, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56886b66c0, this=0x7f5687aa43f0) [2024-08-07 15:39:01.151473] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session destroy(cs_id=799198, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:39:01.151493] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] deallocating sm(sm_id=129506) [2024-08-07 15:39:02.206079] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56884c8030, client_ip={127.0.0.1:40522}) [2024-08-07 15:39:02.206222] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] vip connect(protocol=6, fd=121, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:40522}, daddr={127.0.0.1:2883}) [2024-08-07 15:39:02.206237] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session born(cs_id=799199, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56884c8030, client_fd=121, client_addr="127.0.0.1:40522", is_proxy_client=false) [2024-08-07 15:39:02.206265] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] Starting new transaction using sm(cs_id=799199, get_transact_count()=0, sm_id=129507) [2024-08-07 15:39:02.206475] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129507) [2024-08-07 15:39:02.206495] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client will abort soon(sm_id=129507, cs_id=799199, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:40522}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:39:02.206514] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] will deallocate sm(sm_id=129507, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:39:02.206534] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f5687aa43f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1884, cs_id:799199, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56884c8030, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56884c8030, this=0x7f5687aa43f0) [2024-08-07 15:39:02.206615] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session destroy(cs_id=799199, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:39:02.206632] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] deallocating sm(sm_id=129507) [2024-08-07 15:39:03.259302] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56886b66c0, client_ip={127.0.0.1:40524}) [2024-08-07 15:39:03.259379] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] vip connect(protocol=6, fd=127, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:40524}, daddr={127.0.0.1:2883}) [2024-08-07 15:39:03.259390] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session born(cs_id=799200, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56886b66c0, client_fd=127, client_addr="127.0.0.1:40524", is_proxy_client=false) [2024-08-07 15:39:03.259418] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] Starting new transaction using sm(cs_id=799200, get_transact_count()=0, sm_id=129508) [2024-08-07 15:39:03.259617] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129508) [2024-08-07 15:39:03.259634] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client will abort soon(sm_id=129508, cs_id=799200, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:40524}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:39:03.259649] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] will deallocate sm(sm_id=129508, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:39:03.259657] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f5687aa43f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1884, cs_id:799200, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56886b66c0, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56886b66c0, this=0x7f5687aa43f0) [2024-08-07 15:39:03.259736] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session destroy(cs_id=799200, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:39:03.259752] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] deallocating sm(sm_id=129508) [2024-08-07 15:39:04.316601] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56884c8030, client_ip={127.0.0.1:40526}) [2024-08-07 15:39:04.316726] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] vip connect(protocol=6, fd=124, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:40526}, daddr={127.0.0.1:2883}) [2024-08-07 15:39:04.316749] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session born(cs_id=799201, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56884c8030, client_fd=124, client_addr="127.0.0.1:40526", is_proxy_client=false) [2024-08-07 15:39:04.316778] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] Starting new transaction using sm(cs_id=799201, get_transact_count()=0, sm_id=129509) [2024-08-07 15:39:04.316977] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129509) [2024-08-07 15:39:04.317008] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client will abort soon(sm_id=129509, cs_id=799201, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:40526}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:39:04.317022] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] will deallocate sm(sm_id=129509, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:39:04.317030] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f5687aa43f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1884, cs_id:799201, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56884c8030, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56884c8030, this=0x7f5687aa43f0) [2024-08-07 15:39:04.317119] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session destroy(cs_id=799201, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:39:04.317135] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] deallocating sm(sm_id=129509) [2024-08-07 15:39:05.375322] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56886b66c0, client_ip={127.0.0.1:40534}) [2024-08-07 15:39:05.375435] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] vip connect(protocol=6, fd=121, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:40534}, daddr={127.0.0.1:2883}) [2024-08-07 15:39:05.375452] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session born(cs_id=799202, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56886b66c0, client_fd=121, client_addr="127.0.0.1:40534", is_proxy_client=false) [2024-08-07 15:39:05.375484] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] Starting new transaction using sm(cs_id=799202, get_transact_count()=0, sm_id=129510) [2024-08-07 15:39:05.375707] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129510) [2024-08-07 15:39:05.375721] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client will abort soon(sm_id=129510, cs_id=799202, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:40534}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:39:05.375735] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] will deallocate sm(sm_id=129510, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:39:05.375743] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f5687aa43f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1884, cs_id:799202, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56886b66c0, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56886b66c0, this=0x7f5687aa43f0) [2024-08-07 15:39:05.375804] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session destroy(cs_id=799202, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:39:05.375819] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] deallocating sm(sm_id=129510) [2024-08-07 15:39:06.435089] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56884c8030, client_ip={127.0.0.1:40550}) [2024-08-07 15:39:06.435181] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] vip connect(protocol=6, fd=127, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:40550}, daddr={127.0.0.1:2883}) [2024-08-07 15:39:06.435215] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session born(cs_id=799203, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56884c8030, client_fd=127, client_addr="127.0.0.1:40550", is_proxy_client=false) [2024-08-07 15:39:06.435244] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] Starting new transaction using sm(cs_id=799203, get_transact_count()=0, sm_id=129511) [2024-08-07 15:39:06.435436] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129511) [2024-08-07 15:39:06.435453] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client will abort soon(sm_id=129511, cs_id=799203, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:40550}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:39:06.435468] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] will deallocate sm(sm_id=129511, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:39:06.435486] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f5687aa43f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1884, cs_id:799203, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56884c8030, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56884c8030, this=0x7f5687aa43f0) [2024-08-07 15:39:06.435567] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session destroy(cs_id=799203, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:39:06.435592] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] deallocating sm(sm_id=129511) [2024-08-07 15:39:07.490086] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56886b66c0, client_ip={127.0.0.1:40552}) [2024-08-07 15:39:07.490221] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] vip connect(protocol=6, fd=124, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:40552}, daddr={127.0.0.1:2883}) [2024-08-07 15:39:07.490243] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session born(cs_id=799204, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56886b66c0, client_fd=124, client_addr="127.0.0.1:40552", is_proxy_client=false) [2024-08-07 15:39:07.490273] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] Starting new transaction using sm(cs_id=799204, get_transact_count()=0, sm_id=129512) [2024-08-07 15:39:07.490466] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129512) [2024-08-07 15:39:07.490484] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client will abort soon(sm_id=129512, cs_id=799204, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:40552}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:39:07.490498] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] will deallocate sm(sm_id=129512, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:39:07.490507] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f5687aa43f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1884, cs_id:799204, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56886b66c0, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56886b66c0, this=0x7f5687aa43f0) [2024-08-07 15:39:07.490608] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] client session destroy(cs_id=799204, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:39:07.490625] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1884][Y0-00007F56886D0980] [lt=0] [dc=0] deallocating sm(sm_id=129512) [2024-08-07 15:39:08.547444] INFO [PROXY.NET] accept (ob_mysql_session_accept.cpp:36) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f56884c8030, client_ip={127.0.0.1:40564}) [2024-08-07 15:39:08.547533] INFO [PROXY.NET] do_set_virtual_addr (ob_unix_net_vconnection.cpp:1259) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] vip connect(protocol=6, fd=121, vid=0, vaddr={127.0.0.1:2883}, caddr={127.0.0.1:40564}, daddr={127.0.0.1:2883}) [2024-08-07 15:39:08.547575] INFO [PROXY.CS] new_connection (ob_mysql_client_session.cpp:374) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session born(cs_id=799205, proxy_sessid=0, is_local_connection=true, client_vc=0x7f56884c8030, client_fd=121, client_addr="127.0.0.1:40564", is_proxy_client=false) [2024-08-07 15:39:08.547602] INFO [PROXY.CS] new_transaction (ob_mysql_client_session.cpp:244) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] Starting new transaction using sm(cs_id=799205, get_transact_count()=0, sm_id=129513) [2024-08-07 15:39:08.547821] WDIAG [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:6194) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] ObMysqlSM::tunnel_handler_client(event="VC_EVENT_EOS", sm_id=129513) [2024-08-07 15:39:08.547845] WDIAG [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:8383) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client will abort soon(sm_id=129513, cs_id=799205, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:40564}, server_ip={*Not IP address [0]*:0}, cluster_name=, tenant_name=, user_name=, db=, event="VC_EVENT_EOS", request_cmd="Sleep", sql_cmd="Handshake", sql=OB_MYSQL_COM_HANDSHAKE) [2024-08-07 15:39:08.547859] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:9954) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] will deallocate sm(sm_id=129513, pending_action=NULL, api_.callout_state=0, trans_state_.trace_log= | dropped=0) [2024-08-07 15:39:08.547868] INFO [PROXY.SS] do_io_close (ob_mysql_client_session.cpp:792) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session do_io_close((*this={this:0x7f5687aa43f0, is_proxy_mysql_client:false, is_waiting_trans_first_request:false, need_delete_cluster:false, is_first_dml_sql_got:false, vc_ready_killed:false, active:true, magic:19132429, conn_decrease:true, current_tid:1884, cs_id:799205, proxy_sessid:0, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:4294967295, user_priv_set:-1, cluster_name:"", tenant_name:"", user_name:""}, version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, hash_version:{common_hot_sys_var_version:0, common_sys_var_version:0, mysql_hot_sys_var_version:0, mysql_sys_var_version:0, hot_sys_var_version:0, sys_var_version:0, user_var_version:0, db_name_version:0, last_insert_id_version:0, sess_info_version:0}, val_hash:{common_hot_sys_var_hash:0, common_cold_sys_var_hash:0, mysql_hot_sys_var_hash:0, mysql_cold_sys_var_hash:0, hot_sys_var_hash:0, cold_sys_var_hash:0, user_var_hash:0}, global_vars_version:-1, is_global_vars_changed:false, is_trans_specified:false, is_user_idc_name_set:false, is_read_consistency_set:false, idc_name:"", cluster_id:-1, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:0, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false, obproxy_force_parallel_query_dop:1, ob20_request:{remain_payload_len:0, ob20_request_received_done:false, ob20_header:{ob 20 protocol header:{compressed_len:0, seq:0, non_compressed_len:0}, magic_num:0, header_checksum:0, connection_id:0, request_id:0, pkt_seq:0, payload_len:0, version:0, flag_.flags:0, reserved:0}}, client_cap:0, server_cap:0, last_server_addr:{*Not IP address [0]*:0}, last_server_sess_id:0, init_sql:""}, dummy_ldc:{use_ldc:false, idc_name:"", item_count:0, site_start_index_array:[[0]0, [1]0, [2]0, [3]0], item_array:null, pl:null, ts:null, readonly_exist_status:"READONLY_ZONE_UNKNOWN"}, dummy_entry:null, server_state_version:0, cur_ss:null, bound_ss:null, lii_ss:null, cluster_resource:NULL, client_vc:0x7f56884c8030, using_ldg:false, trace_stats:NULL}, client_vc_=0x7f56884c8030, this=0x7f5687aa43f0) [2024-08-07 15:39:08.547941] INFO [PROXY.CS] destroy (ob_mysql_client_session.cpp:96) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] client session destroy(cs_id=799205, proxy_sessid=0, client_vc=NULL) [2024-08-07 15:39:08.547960] INFO [PROXY.SM] kill_this (ob_mysql_sm.cpp:10073) [1884][Y0-00007F56884D0840] [lt=0] [dc=0] deallocating sm(sm_id=129513)