[2024-02-02 16:01:56.633246] INFO [PROXY.SOCK] ob_connection.cpp:367 [4070][Y0-0] [lt=28] [dc=0] connection accepted(client={10.0.3.219:38632}, server={0.0.0.0:2883}, accepted_fd=44, listen_fd=41) [2024-02-02 16:01:56.633337] INFO [PROXY.NET] ob_mysql_session_accept.cpp:37 [4050][Y0-7F59026363A0] [lt=2] [dc=0] [ObMysqlSessionAccept:main_event] accepted connection(netvc=0x7f5902626120, client_ip={10.0.3.219:38632}) [2024-02-02 16:01:56.633384] INFO [PROXY.CS] ob_mysql_client_session.cpp:332 [4050][Y0-7F59026363A0] [lt=26] [dc=0] client session born(cs_id=109, proxy_sessid=0, is_local_connection=false, client_vc=0x7f5902626120, client_fd=44, client_addr="10.0.3.219:38632") [2024-02-02 16:01:56.633408] INFO [PROXY.CS] ob_mysql_client_session.cpp:210 [4050][Y0-7F59026363A0] [lt=16] [dc=0] Starting new transaction using sm(cs_id=109, get_transact_count()=0, sm_id=109) [2024-02-02 16:01:56.633415] INFO [PROXY.SM] ob_mysql_sm.cpp:460 [4050][Y0-7F59026363A0] [lt=2] [dc=0] the request already in buffer, continue to handle it(buffer len=0, is_auth_rquest=true) [2024-02-02 16:01:56.633545] INFO [PROXY] ob_resource_pool_processor.cpp:1961 [4050][Y0-7F59026363A0] [lt=3] [dc=0] can not find cluster resource, maybe it has not been created yet(cluster_info_key={cluster_name:{config_string:"obdemo"}, cluster_id:0}, ret=-4018) [2024-02-02 16:01:56.633560] INFO [PROXY] ob_resource_pool_processor.cpp:2031 [4050][Y0-7F59026363A0] [lt=15] [dc=0] fail to acuqire avail cluster resource in local, will schedule task to create and init new cluster resource(cluster_name=obdemo, cluster_id=0) [2024-02-02 16:01:56.633567] INFO [PROXY] ob_resource_pool_processor.cpp:967 [4050][Y0-7F59026363A0] [lt=3] [dc=0] ObClusterResourceCreateCont::main_handler(event="CLUSTER_RESOURCE_CREATE_EVENT", init_status=0, cluster_name=obdemo, cluster_id=0, data=0x7f590a9b2a00) [2024-02-02 16:01:56.633572] INFO [PROXY] ob_resource_pool_processor.cpp:2102 [4050][Y0-7F59026363A0] [lt=3] [dc=0] will create new cluster resource(cluster_name=obdemo, cluster_id=0, cr_version=40) [2024-02-02 16:01:56.633629] INFO [PROXY] ob_route_utils.cpp:954 [4050][Y0-7F59026363A0] [lt=4] [dc=0] update sys tenant __all_dummy succ((cluster_name=obdemo, tmp_entry={{this:0x7f590a89e660, ref_count:2, cr_version:0, cr_id:0, create_time_us:1706860916633625, last_valid_time_us:1706860916633566, last_access_time_us:1706860916633566, last_update_time_us:0, schema_version:0, tenant_version:0, time_for_expired:0, state:"AVAIL"}, this:0x7f590a89e660, is_inited:true, is_dummy_entry:true, is_entry_from_rslist:false, is_empty_entry_allowed:false, is_need_force_flush:false, has_dup_replica:false, cr_id:0, name:{cluster_name:"obdemo", tenant_name:"sys", database_name:"oceanbase", package_name:"", table_name:"__all_dummy"}, table_id:1099511627911, table_type:"UNKNOWN", part_num:1, replica_num:3, buf_len:29, buf_start:0x7f590a89e760, tenant_servers:{this:0x7f590a8aa770, is_inited:true, server_count:3, replica_count:3, partition_count:1, next_partition_idx:0, server_array:0x7f590382e200, server_array_:[[0]{server:"10.0.3.223:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [1]{server:"10.0.3.225:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [2]{server:"10.0.3.221:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}]}}) [2024-02-02 16:01:56.633659] INFO [PROXY] ob_resource_pool_processor.cpp:810 [4050][Y0-7F59026363A0] [lt=29] [dc=0] will add INIT_SS_INFO task(this=0x7f5903827a90, cluster_name=obdemo, cluster_id=0) [2024-02-02 16:01:56.633674] INFO [PROXY.CS] ob_mysql_client_session.cpp:507 [4050][Y0-7F59026363A0] [lt=2] [dc=0] proxy mysql client session born(cs_id=2147483758) [2024-02-02 16:01:56.633686] INFO [PROXY.CS] ob_mysql_client_session.cpp:332 [4050][Y0-7F59026363A0] [lt=10] [dc=0] client session born(cs_id=2147483758, proxy_sessid=0, is_local_connection=true, client_vc=0x7f59025e4630, client_fd=0, client_addr="0.0.0.0") [2024-02-02 16:01:56.633694] INFO [PROXY.CS] ob_mysql_client_session.cpp:210 [4050][Y0-7F59026363A0] [lt=3] [dc=0] Starting new transaction using sm(cs_id=2147483758, get_transact_count()=0, sm_id=110) [2024-02-02 16:01:56.633706] INFO [PROXY.SM] ob_mysql_sm.cpp:460 [4050][Y0-7F59026363A0] [lt=10] [dc=0] the request already in buffer, continue to handle it(buffer len=0, is_auth_rquest=true) [2024-02-02 16:01:56.633743] INFO [PROXY.CS] ob_mysql_client_session.cpp:1563 [4050][Y0-7F59026363A0] [lt=1] [dc=0] base servers has not added, treat all tenant server as ok(tenant_server={this:0x7f590a8aa770, is_inited:true, server_count:3, replica_count:3, partition_count:1, next_partition_idx:0, server_array:0x7f590382e200, server_array_:[[0]{server:"10.0.3.223:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [1]{server:"10.0.3.225:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [2]{server:"10.0.3.221:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}]}, ret=0) [2024-02-02 16:01:56.633872] INFO [PROXY.SS] ob_mysql_server_session.cpp:108 [4050][Y0-7F59026363A0] [lt=14] [dc=0] server session born(ss_id=101, server_ip={10.0.3.221:2881}, cs_id=2147483758, proxy_sessid=0, server_type=1) [2024-02-02 16:01:56.634265] INFO [PROXY.TXN] ob_mysql_transact.cpp:3426 [4050][Y0-7F59026363A0] [lt=14] [dc=0] succ to set proxy_sessid(cs_id=2147483758, proxy_sessid=53, server_ip={10.0.3.221:2881}, ss_id=101, server_sessid=3221651829, is_proxy_mysql_client=true, ss_fd=45, client_addr="10.0.3.219:28726") [2024-02-02 16:01:56.635111] INFO [PROXY] ob_proxy_session_info_handler.cpp:716 [4050][Y0-7F59026363A0] [lt=13] [dc=0] succ to set ob_capability_flag(client_cap=6991, server_cap=6991, orgin_cap=6991, support_checksum=true, is_auth_request=true) [2024-02-02 16:01:56.635124] INFO [PROXY] ob_proxy_session_info_handler.cpp:738 [4050][Y0-7F59026363A0] [lt=12] [dc=0] succ to set checksum_switch(enable_transmission_checksum=1, old_switch=1, is_auth_request=true) [2024-02-02 16:01:56.635136] INFO [PROXY] ob_session_field_mgr.cpp:1226 [4050][Y0-7F59026363A0] [lt=3] [dc=0] user variable not exist(name=_min_cluster_version, ret=-4018) [2024-02-02 16:01:56.635169] INFO [PROXY.CS] ob_mysql_client_session.cpp:1563 [4050][Y0-7F59026363A0] [lt=4] [dc=0] base servers has not added, treat all tenant server as ok(tenant_server={this:0x7f590a8aa770, is_inited:true, server_count:3, replica_count:3, partition_count:1, next_partition_idx:0, server_array:0x7f590382e200, server_array_:[[0]{server:"10.0.3.223:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [1]{server:"10.0.3.225:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [2]{server:"10.0.3.221:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}]}, ret=0) [2024-02-02 16:01:56.635198] INFO [PROXY.SS] ob_mysql_server_session.cpp:145 [4050][Y0-7F59026363A0] [lt=23] [dc=0] server session do_io_close((*this={ss_id:101, server_sessid:3221651829, server_ip:{10.0.3.221:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7f59025f8080, client_session:{this:0x7f5903e2c910, 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:4050, cs_id:2147483758, proxy_sessid:53, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147483758, user_priv_set:-1, cluster_name:"obdemo", 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:0, user_var_version:1, db_name_version:1, last_insert_id_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}, 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:0, real_meta_cluster_name:"", safe_read_snapshot:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false}, 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:"10.0.3.223: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:"10.0.3.225: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:"10.0.3.221: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:0x7f590a8aa770, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7f590a89e660, server_state_version:0, cur_ss:null, bound_ss:0x7f59025f8950, lii_ss:null, cluster_resource:{this:0x7f590a5f0080, ref_count:5, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcloud"}, cluster_id:0}, cr_state:"CR_BORN", version:1, last_access_time_ns:0, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:0, last_rslist_refresh_time_ns:0, server_state_version:0, dummy_entry:NULL}, client_vc:0x7f59025e4630, using_ldg:false, trace_stats:NULL}, transact_count:1, server_trans_stat:0, session_info:{cap:6991, ob_server:"0.0.0.0", 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:1, db_name_version:1, last_insert_id_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}, checksum_switch:1, server_type:1}}, server_vc_=0x7f59025f8080, this=0x7f59025f8950) [2024-02-02 16:01:56.635240] INFO [PROXY.SS] ob_mysql_server_session.cpp:179 [4050][Y0-7F59026363A0] [lt=40] [dc=0] server session is closing(ss_id=101, server_sessid=3221651829, server_ip={10.0.3.221:2881}, cs_id=2147483758, proxy_sessid=53) [2024-02-02 16:01:56.635304] INFO [PROXY.SS] ob_mysql_server_session.cpp:108 [4050][Y0-7F59026363A0] [lt=3] [dc=0] server session born(ss_id=102, server_ip={10.0.3.221:2881}, cs_id=2147483758, proxy_sessid=53, server_type=1) [2024-02-02 16:01:56.636543] INFO [PROXY.TXN] ob_mysql_transact.cpp:2380 [4050][Y0-7F59026363A0] [lt=12] [dc=0] global vars changed(cur_global_vars_version=0, snapshot_global_vars_version=-1) [2024-02-02 16:01:56.636558] INFO [PROXY] ob_proxy_session_info_handler.cpp:716 [4050][Y0-7F59026363A0] [lt=14] [dc=0] succ to set ob_capability_flag(client_cap=6991, server_cap=6991, orgin_cap=6991, support_checksum=true, is_auth_request=false) [2024-02-02 16:01:56.637639] INFO [PROXY.SM] ob_mysql_sm.cpp:7575 [4050][Y0-7F59026363A0] [lt=3] [dc=0] Slow Query: ((client_ip={*Not IP address [0]*:0}, server_ip={10.0.3.221:2881}, server_trace_id=, route_type=ROUTE_TYPE_NONPARTITION_UNMERGE_LOCAL, user_name=proxyro, tenant_name=sys, cluster_name=obdemo, logic_database_name=, logic_tenant_name=, ob_proxy_protocol=2, cs_id=2147483758, proxy_sessid=53, ss_id=102, server_sessid=3221651828, sm_id=110, cmd_size_stats={client_request_bytes:25, server_request_bytes:60, server_response_bytes:11, client_response_bytes:11}, cmd_time_stats={client_transaction_idle_time_us=0, client_request_read_time_us=14, client_request_analyze_time_us=14, cluster_resource_create_time_us=0, pl_lookup_time_us=0, pl_process_time_us=0, congestion_control_time_us=0, congestion_process_time_us=0, do_observer_open_time_us=120, server_connect_time_us=51, server_sync_session_variable_time_us=1725, server_send_saved_login_time_us=938, server_send_use_database_time_us=356, server_send_session_variable_time_us=430, server_send_all_session_variable_time_us=0, server_send_last_insert_id_time_us=0, server_send_start_trans_time_us=0, build_server_request_time_us=20, plugin_compress_request_time_us=0, prepare_send_request_to_server_time_us=2215, server_request_write_time_us=27, server_process_request_time_us=227, server_response_read_time_us=2, plugin_decompress_response_time_us=0, server_response_analyze_time_us=1, ok_packet_trim_time_us=2, client_response_write_time_us=8, request_total_time_us=2483}, sql=SET @@autocommit = 1) [2024-02-02 16:01:56.637699] INFO [PROXY.CS] ob_mysql_client_session.cpp:1563 [4050][Y0-7F59026363A0] [lt=10] [dc=0] base servers has not added, treat all tenant server as ok(tenant_server={this:0x7f590a8aa770, is_inited:true, server_count:3, replica_count:3, partition_count:1, next_partition_idx:0, server_array:0x7f590382e200, server_array_:[[0]{server:"10.0.3.223:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [1]{server:"10.0.3.225:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [2]{server:"10.0.3.221:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}]}, ret=0) [2024-02-02 16:01:56.637720] INFO [PROXY.CS] ob_mysql_transact.cpp:4925 [4050][Y0-7F59026363A0] [lt=17] [dc=0] succ to global variable proxy_route_policy(policy=) [2024-02-02 16:01:56.638347] WARN [PROXY.SM] print_mysql_complete_log (ob_mysql_sm.cpp:3956) [4050][Y0-7F59026363A0] [lt=39] [dc=0] finishing mysql tunnel((sm_id=110, cs_id=2147483758, proxy_sessid=53, ss_id=102, server_sessid=3221651828, client_ip={*Not IP address [0]*:0}, server_ip={10.0.3.221:2881}, server_trace_id=, proxy_user_name=proxyro@sys#obdemo, database_name=oceanbase, is_flow_controlled=false, cpu_flow_control_count=0, memory_flow_control_count=0, sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ *, zs.status AS zone_status, ss.status AS server_status FROM oceanbase.__all_virtual_zone_stat zs, oceanbase.__all_virtual_proxy_server_stat ss WHERE zs.zone=ss.zone AND ss.svr_port > 0 LIMIT 9223372036854775807;, sql_cmd="Query", result={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:75, rewritten_last_ok_pkt_len:0, error_pkt:field_count:255, errcode:1146, sqlstate:"42S02", message:"Table 'oceanbase.__all_virtual_zone_stat' doesn't exist"}) [2024-02-02 16:01:56.638370] INFO [PROXY.SS] ob_mysql_server_session.cpp:145 [4050][Y0-7F59026363A0] [lt=16] [dc=0] server session do_io_close((*this={ss_id:102, server_sessid:3221651828, server_ip:{10.0.3.221:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7f59025f8370, client_session:{this:0x7f5903e2c910, is_proxy_mysql_client:true, is_waiting_trans_first_request:true, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:false, magic:19132429, conn_decrease:true, current_tid:4050, cs_id:2147483758, proxy_sessid:53, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147483758, user_priv_set:-1, cluster_name:"obdemo", 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:0, user_var_version:1, db_name_version:1, last_insert_id_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}, 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:true, 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:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false}, 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:"10.0.3.225: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:"10.0.3.223: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:"10.0.3.221: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:0x7f590a8aa770, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7f590a89e660, server_state_version:0, cur_ss:null, bound_ss:0x7f59025f8950, lii_ss:null, cluster_resource:{this:0x7f590a5f0080, ref_count:5, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcloud"}, cluster_id:0}, cr_state:"CR_BORN", version:1, last_access_time_ns:0, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:0, last_rslist_refresh_time_ns:0, server_state_version:0, dummy_entry:NULL}, client_vc:0x7f59025e4630, using_ldg:false, trace_stats:NULL}, transact_count:2, server_trans_stat:0, session_info:{cap:6991, ob_server:"0.0.0.0", 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:1, db_name_version:1, last_insert_id_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}, checksum_switch:1, server_type:1}}, server_vc_=0x7f59025f8370, this=0x7f59025f8950) [2024-02-02 16:01:56.638439] INFO [PROXY.SS] ob_mysql_server_session.cpp:179 [4050][Y0-7F59026363A0] [lt=60] [dc=0] server session is closing(ss_id=102, server_sessid=3221651828, server_ip={10.0.3.221:2881}, cs_id=2147483758, proxy_sessid=53) [2024-02-02 16:01:56.638460] WARN [PROXY] get_resultset_fetcher (ob_client_utils.cpp:244) [4050][Y0-7F59026363A0] [lt=11] [dc=0] fail to execute sql(ret=-1146) [2024-02-02 16:01:56.638480] WARN [PROXY] next (ob_client_utils.cpp:223) [4050][Y0-7F59026363A0] [lt=20] [dc=0] fail to get rs_fetcher(ret=-1146) [2024-02-02 16:01:56.638486] WARN [PROXY] finish_task (ob_resource_pool_processor.cpp:590) [4050][Y0-7F59026363A0] [lt=5] [dc=0] fail to get server state info(ret=-1146) [2024-02-02 16:01:56.638493] WARN [PROXY] handle_event_complete (ob_async_common_task.cpp:150) [4050][Y0-7F59026363A0] [lt=6] [dc=0] fail to do finish task(task_name="server_state_info_init_task", ret=-1146) [2024-02-02 16:01:56.638498] WARN [PROXY] main_handler (ob_async_common_task.cpp:59) [4050][Y0-7F59026363A0] [lt=5] [dc=0] fail to handle event complete(ret=-1146) [2024-02-02 16:01:56.638506] INFO [PROXY] ob_resource_pool_processor.cpp:967 [4050][Y0-7F59026363A0] [lt=6] [dc=0] ObClusterResourceCreateCont::main_handler(event="ASYNC_TASK_DONE_EVENT", init_status=4, cluster_name=obdemo, cluster_id=0, data=0x11662280) [2024-02-02 16:01:56.638509] INFO [PROXY] ob_resource_pool_processor.cpp:1068 [4050][Y0-7F59026363A0] [lt=3] [dc=0] local rs list cannot work, try to get newest rs list(init_status=4) [2024-02-02 16:01:56.638511] INFO [PROXY] ob_resource_pool_processor.cpp:785 [4050][Y0-7F59026363A0] [lt=1] [dc=0] will add INIT_RS task(this=0x7f5903827a90, cluster_name=obdemo, cluster_id=0) [2024-02-02 16:01:56.638559] INFO [PROXY] ob_resource_pool_processor.cpp:967 [4050][Y0-7F59026363A0] [lt=1] [dc=0] ObClusterResourceCreateCont::main_handler(event="ASYNC_TASK_DONE_EVENT", init_status=1, cluster_name=obdemo, cluster_id=0, data=0x116540e0) [2024-02-02 16:01:56.638570] INFO [PROXY] ob_resource_pool_processor.cpp:810 [4050][Y0-7F59026363A0] [lt=11] [dc=0] will add INIT_SS_INFO task(this=0x7f5903827a90, cluster_name=obdemo, cluster_id=0) [2024-02-02 16:01:56.638593] INFO [PROXY.CS] ob_mysql_client_session.cpp:1563 [4050][Y0-7F59026363A0] [lt=2] [dc=0] base servers has not added, treat all tenant server as ok(tenant_server={this:0x7f590a8aa770, is_inited:true, server_count:3, replica_count:3, partition_count:1, next_partition_idx:0, server_array:0x7f590382e200, server_array_:[[0]{server:"10.0.3.223:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [1]{server:"10.0.3.225:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}, [2]{server:"10.0.3.221:2881", is_dup_replica:false, role:"FOLLOWER", type:"FULL"}]}, ret=0) [2024-02-02 16:01:56.638609] INFO [PROXY.CS] ob_mysql_transact.cpp:4925 [4050][Y0-7F59026363A0] [lt=14] [dc=0] succ to global variable proxy_route_policy(policy=) [2024-02-02 16:01:56.638668] INFO [PROXY.SS] ob_mysql_server_session.cpp:108 [4050][Y0-7F59026363A0] [lt=2] [dc=0] server session born(ss_id=103, server_ip={10.0.3.221:2881}, cs_id=2147483758, proxy_sessid=53, server_type=1) [2024-02-02 16:01:56.639717] INFO [PROXY] ob_proxy_session_info_handler.cpp:716 [4050][Y0-7F59026363A0] [lt=12] [dc=0] succ to set ob_capability_flag(client_cap=6991, server_cap=6991, orgin_cap=6991, support_checksum=true, is_auth_request=false) [2024-02-02 16:01:56.640952] WARN [PROXY.SM] print_mysql_complete_log (ob_mysql_sm.cpp:3956) [4050][Y0-7F59026363A0] [lt=26] [dc=0] finishing mysql tunnel((sm_id=110, cs_id=2147483758, proxy_sessid=53, ss_id=103, server_sessid=3221651830, client_ip={*Not IP address [0]*:0}, server_ip={10.0.3.221:2881}, server_trace_id=, proxy_user_name=proxyro@sys#obdemo, database_name=oceanbase, is_flow_controlled=false, cpu_flow_control_count=0, memory_flow_control_count=0, sql=SELECT /*+READ_CONSISTENCY(WEAK)*/ *, zs.status AS zone_status, ss.status AS server_status FROM oceanbase.__all_virtual_zone_stat zs, oceanbase.__all_virtual_proxy_server_stat ss WHERE zs.zone=ss.zone AND ss.svr_port > 0 LIMIT 9223372036854775807;, sql_cmd="Query", result={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:75, rewritten_last_ok_pkt_len:0, error_pkt:field_count:255, errcode:1146, sqlstate:"42S02", message:"Table 'oceanbase.__all_virtual_zone_stat' doesn't exist"}) [2024-02-02 16:01:56.640981] INFO [PROXY.SS] ob_mysql_server_session.cpp:145 [4050][Y0-7F59026363A0] [lt=21] [dc=0] server session do_io_close((*this={ss_id:103, server_sessid:3221651830, server_ip:{10.0.3.221:2881}, is_inited:true, magic:19136237, state:2, server_vc:0x7f59025ec770, client_session:{this:0x7f5903e2c910, is_proxy_mysql_client:true, is_waiting_trans_first_request:true, need_delete_cluster:false, is_first_dml_sql_got:true, vc_ready_killed:false, active:false, magic:19132429, conn_decrease:true, current_tid:4050, cs_id:2147483758, proxy_sessid:53, session_info:{is_inited:true, priv_info:{has_all_privilege:false, cs_id:2147483758, user_priv_set:-1, cluster_name:"obdemo", 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:0, user_var_version:1, db_name_version:1, last_insert_id_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}, 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:true, 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:0, syncing_safe_read_snapshot:0, route_policy:1, proxy_route_policy:3, user_identity:4, global_vars_version:-1, is_read_only_user:false, is_request_follower_user:false}, 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:"10.0.3.221: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:"10.0.3.223: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:"10.0.3.225: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:0x7f590a8aa770, readonly_exist_status:"READONLY_ZONE_NOT_EXIST"}, dummy_entry:0x7f590a89e660, server_state_version:0, cur_ss:null, bound_ss:0x7f59025f8950, lii_ss:null, cluster_resource:{this:0x7f590a5f0080, ref_count:5, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obcloud"}, cluster_id:0}, cr_state:"CR_BORN", version:1, last_access_time_ns:0, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:0, last_rslist_refresh_time_ns:0, server_state_version:0, dummy_entry:NULL}, client_vc:0x7f59025e4630, using_ldg:false, trace_stats:NULL}, transact_count:1, server_trans_stat:0, session_info:{cap:6991, ob_server:"0.0.0.0", 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:1, db_name_version:1, last_insert_id_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}, checksum_switch:1, server_type:1}}, server_vc_=0x7f59025ec770, this=0x7f59025f8950) [2024-02-02 16:01:56.641022] INFO [PROXY.SS] ob_mysql_server_session.cpp:179 [4050][Y0-7F59026363A0] [lt=38] [dc=0] server session is closing(ss_id=103, server_sessid=3221651830, server_ip={10.0.3.221:2881}, cs_id=2147483758, proxy_sessid=53) [2024-02-02 16:01:56.641031] WARN [PROXY] get_resultset_fetcher (ob_client_utils.cpp:244) [4050][Y0-7F59026363A0] [lt=2] [dc=0] fail to execute sql(ret=-1146) [2024-02-02 16:01:56.641046] WARN [PROXY] next (ob_client_utils.cpp:223) [4050][Y0-7F59026363A0] [lt=15] [dc=0] fail to get rs_fetcher(ret=-1146) [2024-02-02 16:01:56.641051] WARN [PROXY] finish_task (ob_resource_pool_processor.cpp:590) [4050][Y0-7F59026363A0] [lt=5] [dc=0] fail to get server state info(ret=-1146) [2024-02-02 16:01:56.641058] WARN [PROXY] handle_event_complete (ob_async_common_task.cpp:150) [4050][Y0-7F59026363A0] [lt=6] [dc=0] fail to do finish task(task_name="server_state_info_init_task", ret=-1146) [2024-02-02 16:01:56.641064] WARN [PROXY] main_handler (ob_async_common_task.cpp:59) [4050][Y0-7F59026363A0] [lt=5] [dc=0] fail to handle event complete(ret=-1146) [2024-02-02 16:01:56.641069] INFO [PROXY] ob_resource_pool_processor.cpp:967 [4050][Y0-7F59026363A0] [lt=4] [dc=0] ObClusterResourceCreateCont::main_handler(event="ASYNC_TASK_DONE_EVENT", init_status=4, cluster_name=obdemo, cluster_id=0, data=0x11662280) [2024-02-02 16:01:56.641075] INFO [PROXY] ob_resource_pool_processor.cpp:1196 [4050][Y0-7F59026363A0] [lt=4] [dc=0] cluster resource create complete(created_cr={this:0x7f590a74c580, ref_count:3, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obdemo"}, cluster_id:0}, cr_state:"CR_INIT_FAILED", version:40, last_access_time_ns:0, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:0, last_rslist_refresh_time_ns:1706860916638445986, server_state_version:0, dummy_entry:NULL}, pending_list_count=0) [2024-02-02 16:01:56.641080] INFO [PROXY] ob_resource_pool_processor.cpp:1637 [4050][Y0-7F59026363A0] [lt=4] [dc=0] ObClusterResource will destroy, and wait to be free(this={this:0x7f590a74c580, ref_count:0, is_inited:true, cluster_info_key:{cluster_name:{config_string:"obdemo"}, cluster_id:0}, cr_state:"CR_INIT_FAILED", version:40, last_access_time_ns:0, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:0, last_rslist_refresh_time_ns:1706860916638445986, server_state_version:0, dummy_entry:NULL}) [2024-02-02 16:01:56.641086] INFO [PROXY] ob_mysql_proxy.h:172 [4050][Y0-7F59026363A0] [lt=2] [dc=0] client pool will be destroyed(client_pool={this:0x7f590a7a6340, ref_count:4, is_inited:true, stop:false, mc_count:2, cluster_resource:0x7f590a5f0080}) [2024-02-02 16:01:56.641103] INFO [PROXY] ob_congestion_manager.cpp:103 [4050][Y0-7F59026363A0] [lt=12] [dc=0] ObCongestionManager will destroy(this={this:0x7f590a74d680, is_inited:true, is_base_servers_added:false, is_congestion_enabled:true, zone_count:0, config:{ref_count:1, this:0x7f590a7ba660, conn_failure_threshold:5, alive_failure_threshold:5, fail_window_sec:120, retry_interval_sec:20, min_keep_congestion_interval_sec:20}}) [2024-02-02 16:01:56.641119] INFO [PROXY] ob_resource_pool_processor.cpp:1595 [4050][Y0-7F59026363A0] [lt=7] [dc=0] the cluster resource will free(this={this:0x7f590a74c580, ref_count:0, is_inited:false, cluster_info_key:{cluster_name:{config_string:"obdemo"}, cluster_id:0}, cr_state:"CR_DEAD", version:40, last_access_time_ns:0, deleting_completed_thread_num:0, fetch_rslist_task_count:0, fetch_idc_list_task_count:0, last_idc_list_refresh_time_ns:0, last_rslist_refresh_time_ns:1706860916638445986, server_state_version:0, dummy_entry:NULL}) [2024-02-02 16:01:56.641132] INFO [PROXY] ob_congestion_manager.cpp:103 [4050][Y0-7F59026363A0] [lt=11] [dc=0] ObCongestionManager will destroy(this={this:0x7f590a74d680, is_inited:false, is_base_servers_added:false, is_congestion_enabled:true, zone_count:0, config:NULL}) [2024-02-02 16:01:56.641179] INFO [PROXY] ob_resource_pool_processor.cpp:967 [4050][Y0-7F59026363A0] [lt=2] [dc=0] ObClusterResourceCreateCont::main_handler(event="CLUSTER_RESOURCE_INFORM_OUT_EVENT", init_status=4, cluster_name=obdemo, cluster_id=0, data=0x7f590a9b2b80) [2024-02-02 16:01:56.641190] WARN [PROXY.SM] state_get_cluster_resource (ob_mysql_sm.cpp:1490) [4050][Y0-7F59026363A0] [lt=10] [dc=0] data is NULL(sm_id=109, ret=-4152) [2024-02-02 16:01:56.641196] WARN [PROXY.TXN] handle_error_jump (ob_mysql_transact.cpp:65) [4050][Y0-7F59026363A0] [lt=6] [dc=0] [ObMysqlTransact::handle_error_jump] [2024-02-02 16:01:56.641204] WARN [PROXY.SM] setup_error_transfer (ob_mysql_sm.cpp:6508) [4050][Y0-7F59026363A0] [lt=7] [dc=0] [setup_error_transfer] Now closing connection(sm_id=109, request_cmd="Sleep", sql_cmd="Login", sql=OB_MYSQL_COM_LOGIN) [2024-02-02 16:01:56.641215] INFO [PROXY] ob_mysql_client_pool.cpp:135 [4056][Y0-7F590A7BCC80] [lt=2] [dc=0] all mysql client has been scheduled to destroy self(deleted_count=2) [2024-02-02 16:01:56.641223] INFO [PROXY] ob_client_vc.cpp:587 [4056][Y0-7F590A7BDCC0] [lt=6] [dc=0] mysql client active timeout(active_timeout_ms=0, next_action=5, info={user_name:"proxyro@sys#obdemo:0", database_name:"oceanbase", request_param:{sql:"", is_deep_copy:false, current_idc_name:"", is_user_idc_name_set:false, need_print_trace_stat:false}}) [2024-02-02 16:01:56.641231] INFO [PROXY.SM] ob_mysql_sm.cpp:512 [4056][Y0-7F590A7BDCC0] [lt=6] [dc=0] ObMysqlSM::state_client_request_read(event="VC_EVENT_EOS", sm_id=110, client_vc=0x7f59025e4630) [2024-02-02 16:01:56.641234] INFO [PROXY.CS] ob_mysql_client_session.cpp:89 [4050][Y0-7F59026363A0] [lt=2] [dc=0] client session destroy(cs_id=109, proxy_sessid=0, client_vc=NULL) [2024-02-02 16:01:56.641237] INFO [PROXY.TXN] ob_mysql_transact.cpp:78 [4056][Y0-7F590A7BDCC0] [lt=5] [dc=0] [ObMysqlTransact::bad_request] parser marked request bad [2024-02-02 16:01:56.641239] WARN [PROXY.SM] setup_error_transfer (ob_mysql_sm.cpp:6508) [4056][Y0-7F590A7BDCC0] [lt=2] [dc=0] [setup_error_transfer] Now closing connection(sm_id=110, request_cmd="Sleep", sql_cmd="End", sql=) [2024-02-02 16:01:56.641243] INFO [PROXY.SM] ob_mysql_sm.cpp:7038 [4050][Y0-7F59026363A0] [lt=2] [dc=0] deallocating sm(sm_id=109) [2024-02-02 16:01:56.641247] INFO [PROXY.CS] ob_mysql_client_session.cpp:89 [4056][Y0-7F590A7BDCC0] [lt=5] [dc=0] client session destroy(cs_id=2147483758, proxy_sessid=53, client_vc=NULL) [2024-02-02 16:01:56.641258] INFO [PROXY.SM] ob_mysql_sm.cpp:7038 [4056][Y0-7F590A7BDCC0] [lt=5] [dc=0] deallocating sm(sm_id=110) [2024-02-02 16:01:56.641263] INFO [PROXY] ob_client_vc.cpp:1056 [4056][Y0-7F590A7BDCC0] [lt=2] [dc=0] mysql client will kill self(this=0x7f590a7b3a20) [2024-02-02 16:01:56.641268] INFO [PROXY] ob_client_vc.cpp:587 [4056][Y0-7F590A7BDD00] [lt=3] [dc=0] mysql client active timeout(active_timeout_ms=0, next_action=1, info={user_name:"proxyro@sys#obdemo:0", database_name:"oceanbase", request_param:{sql:"", is_deep_copy:false, current_idc_name:"", is_user_idc_name_set:false, need_print_trace_stat:false}}) [2024-02-02 16:01:56.641270] INFO [PROXY] ob_client_vc.cpp:1056 [4056][Y0-7F590A7BDD00] [lt=2] [dc=0] mysql client will kill self(this=0x7f590a7b3ce0) [2024-02-02 16:01:56.641271] INFO [PROXY] ob_mysql_client_pool.cpp:203 [4056][Y0-7F590A7BDD00] [lt=1] [dc=0] client pool will be free(this={this:0x7f590a7a6340, ref_count:0, is_inited:false, stop:true, mc_count:2, cluster_resource:0x7f590a5f0080})