暂无图片
分享
O
OceanBase社区传送门
2023-09-21
observer初始化失败

【 使用环境 】生产环境 or 测试环境
【 OB or 其他组件 】
【 使用版本 】3.1.4
【问题描述】observer 单机初始化,没有observer进程,查看日志也没有错误提示
初始化操作
bin/observer -i ens32 -p 2881 -P 2882 -z zone1 -d ~/oceanbase/store -r ‘172.16.1.69:2882:2881’ -c 1 -n obdemo -o “memory_limit=8G,cache_wash_threshold=1G,min_full_resource_pool_memory=268435456,system_memory=3G,memory_chunk_cache_size=128M,cpu_count=8,net_thread_count=4,datafile_size=20G,stack_size=1536K"
【复现路径】问题出现前后相关操作
【问题现象及影响】
出现进程,然后几十秒后进程自动停止。
【附件】
[2023-09-20 11:05:33.188944] WARN [STORAGE.TRANS] getClock (ob_clock_generator.h:65) [27071][0][Y0-0000000000000000] [lt=13] [dc=0] clock generator not inited
[2023-09-20 11:05:33.193885] WARN [COMMON] load_from_file (ob_io_benchmark.cpp:240) [27071][0][Y0-0000000000000000] [lt=7] [dc=0] the io bench result file not exist!
[2023-09-20 11:05:33.193895] WARN [COMMON] init (ob_io_benchmark.cpp:782) [27071][0][Y0-0000000000000000] [lt=9] [dc=0] Fail to load io benchmark result, (ret=-4027)
[2023-09-20 11:05:33.193899] WARN [SERVER] init_io (ob_server.cpp:1108) [27071][0][Y0-0000000000000000] [lt=3] [dc=0] init io benchmark fail, (ret=-4027)
[2023-09-20 11:05:33.193912] WARN [SERVER.OMT] init_cgroup_root_dir
 (ob_cgroup_ctrl.cpp:540) [27071][0][Y0-0000000000000000] [lt=3] [dc=0] no cgroup directory found. disable cgroup support(cgroup_path=“cgroup”, ret=-4027)
[2023-09-20 11:05:33.193917] WARN [SERVER.OMT] init (ob_cgroup_ctrl.cpp:52) [27071][0][Y0-0000000000000000] [lt=3] [dc=0] init cgroup dir failed(ret=-4027, root_cgroup
=“cgroup”)
[2023-09-20 11:05:33.193921] WARN [COMMON] get_instance (memory_dump.cpp:91) [27071][0][Y0-0000000000000000] [lt=2] [dc=0] memory dump not init
[2023-09-20 11:05:33.510218] WARN [SERVER] get_network_speed_from_config_file (ob_server.cpp:1815) [27071][0][Y0-0000000000000000] [lt=11] [dc=0] NIC Config file doesn’t exist, auto detecting(nic_rate_path=“etc/nic.rate.config”, ret=-4027)
[2023-09-20 11:05:33.513337] WARN [COMMON] get_all_tenant_id (ob_tenant_mgr.cpp:581) [27122][100][Y0-0000000000000000] [lt=13] [dc=0] tenant manager not init(ret=-4006)
[2023-09-20 11:05:33.513359] WARN [COMMON] compute_tenant_wash_size (ob_kvcache_store.cpp:659) [27122][100][Y0-0000000000000000] [lt=20] [dc=0] Fail to get all tenant ids, (ret=-4006)
[2023-09-20 11:05:33.729541] WARN [COMMON] get_all_tenant_id (ob_tenant_mgr.cpp:581) [27122][100][Y0-0000000000000000] [lt=10] [dc=0] tenant manager not init(ret=-4006)
[2023-09-20 11:05:33.729566] WARN [COMMON] compute_tenant_wash_size (ob_kvcache_store.cpp:659) [27122][100][Y0-0000000000000000] [lt=23] [dc=0] Fail to get all tenant ids, (ret=-4006)
[2023-09-20 11:05:33.947448] WARN [COMMON] get_all_tenant_id (ob_tenant_mgr.cpp:581) [27122][100][Y0-0000000000000000] [lt=12] [dc=0] tenant manager not init(ret=-4006)
[2023-09-20 11:05:33.947480] WARN [COMMON] compute_tenant_wash_size (ob_kvcache_store.cpp:659) [27122][100][Y0-0000000000000000] [lt=30] [dc=0] Fail to get all tenant ids, (ret=-4006)
[2023-09-20 11:05:33.974699] WARN [SHARE.SCHEMA] check_formal_guard (ob_schema_getter_guard.cpp:7103) [27255][362][Y0-0000000000000000] [lt=22] [dc=0] local schema_version is not formal, try again(ret=-5627, schema_version=1)
[2023-09-20 11:05:33.974730] WARN [STORAGE] runTimerTask (ob_build_index_scheduler.cpp:1649) [27255][362][Y0-0000000000000000] [lt=28] [dc=0] schema_guard is not formal(ret=-5627)
[2023-09-20 11:05:34.011620] WARN [SQL.RESV] resolve_table_relation_recursively (ob_dml_resolver.cpp:6639) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=3] [dc=0] synonym not exist(tenant_id=1, database_id=1099511627777, table_name=__all_root_table, ret=-5019)
[2023-09-20 11:05:34.011626] WARN [SQL.RESV] resolve_table_relation_factor_normal (ob_dml_resolver.cpp:6515) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=5] [dc=0] fail to resolve table relation recursively(tenant_id=1, ret=-5019)
[2023-09-20 11:05:34.011630] WARN [SQL.RESV] resolve_table_relation_factor (ob_dml_resolver.cpp:6295) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=3] [dc=0] resolve table relation factor failed(ret=-5019)
[2023-09-20 11:05:34.011638] WARN [SHARE.SCHEMA] get_dblink_user (ob_schema_getter_guard.cpp:6554) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=5] [dc=0] dblink user name is empty(tenant_id=1, dblink_name=__all_root_table)
[2023-09-20 11:05:34.011642] WARN [SQL.RESV] get_dblink_user (ob_schema_checker.cpp:1303) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=3] [dc=0] failed to get dblink id(ret=-4016, tenant_id=1, dblink_name=all_root_table)
[2023-09-20 11:05:34.011646] WARN [SQL.RESV] resolve_dblink_with_synonym (ob_dml_resolver.cpp:6339) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=4] [dc=0] fail to exec schema_checker
->get_dblink_user(tenant_id, tmp_table_name, tmp_db_name, *allocator
)(ret=-4016)
[2023-09-20 11:05:34.011649] WARN [SQL.RESV] resolve_table_relation_factor (ob_dml_resolver.cpp:6300) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=3] [dc=0] try synonym with dblink failed(ret=-4016)
[2023-09-20 11:05:34.011659] WARN [SQL.RESV] inner_resolve_sys_view (ob_dml_resolver.cpp:950) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=3] [dc=0] fail to resolve table(ret=-5019)
[2023-09-20 11:05:34.011662] WARN [SQL.RESV] resolve_table_relation_factor_wrapper (ob_dml_resolver.cpp:983) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=3] [dc=0] fail to resolve sys view(ret=-5019)
[2023-09-20 11:05:34.011699] WARN resolve_basic_table (ob_dml_resolver.cpp:1076) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=3] [dc=0] Table 'oceanbase.all_root_table’ doesn’t exist
[2023-09-20 11:05:34.011708] WARN [SQL.RESV] resolve_basic_table (ob_select_resolver.cpp:3369) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=8] [dc=0] resolve base or alias table factor failed(ret=-5019)
[2023-09-20 11:05:34.011711] WARN [SQL.RESV] resolve_table (ob_dml_resolver.cpp:1301) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=2] [dc=0] resolve basic table failed(ret=-5019)
[2023-09-20 11:05:34.011714] WARN [SQL.RESV] resolve_from_clause (ob_select_resolver.cpp:3176) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=2] [dc=0] fail to exec resolve_table(*table_node, table_item)(ret=-5019)
[2023-09-20 11:05:34.011717] WARN [SQL.RESV] resolve_normal_query (ob_select_resolver.cpp:781) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=3] [dc=0] fail to exec resolve_from_clause(parse_tree.children
[PARSE_SELECT_FROM])(ret=-5019)
[2023-09-20 11:05:34.011721] WARN [SQL.RESV] resolve (ob_select_resolver.cpp:934) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=3] [dc=0] resolve normal query failed(ret=-5019)
[2023-09-20 11:05:34.011728] WARN [SQL.RESV] select_stmt_resolver_func (ob_resolver.cpp:142) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=3] [dc=0] execute stmt_resolver failed(ret=-5019, parse_tree.type
=3035)
[2023-09-20 11:05:34.011758] WARN [SQL] generate_stmt (ob_sql.cpp:1440) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=7] [dc=0] failed to resolve(ret=-5019)
[2023-09-20 11:05:34.011767] WARN [SQL] generate_physical_plan (ob_sql.cpp:1528) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=7] [dc=0] Failed to generate stmt(ret=-5019, result.get_exec_context().need_disconnect()=false)
[2023-09-20 11:05:34.011774] WARN [SQL] handle_physical_plan (ob_sql.cpp:3228) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=3] [dc=0] Failed to generate plan(ret=-5019, result.get_exec_context().need_disconnect()=false)
[2023-09-20 11:05:34.011778] WARN [SQL] handle_text_query (ob_sql.cpp:1209) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=3] [dc=0] fail to handle physical plan(ret=-5019)
[2023-09-20 11:05:34.011783] WARN [SQL] stmt_query (ob_sql.cpp:171) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=2] [dc=0] fail to handle text query(stmt=SELECT * FROM __all_root_table WHERE tenant_id = 1 AND table_id = 1099511628002 AND partition_id = 0 ORDER BY tenant_id, table_id, partition_id, svr_ip, svr_port, ret=-5019)
[2023-09-20 11:05:34.011788] WARN [SERVER] do_query (ob_inner_sql_connection.cpp:674) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=4] [dc=0] executor execute failed(ret=-5019)
[2023-09-20 11:05:34.011810] WARN [SERVER] query (ob_inner_sql_connection.cpp:824) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=14] [dc=0] execute failed(ret=-5019, executor={ObIExecutor:, sql:“SELECT * FROM __all_root_table WHERE tenant_id = 1 AND table_id = 1099511628002 AND partition_id = 0 ORDER BY tenant_id, table_id, partition_id, svr_ip, svr_port”}, retry_cnt=0)
[2023-09-20 11:05:34.011824] WARN [SERVER] query (ob_inner_sql_connection.cpp:827) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=7] [dc=0] failed to process retry(tmp_ret=-5019, ret=-5019, executor={ObIExecutor:, sql:“SELECT * FROM __all_root_table WHERE tenant_id = 1 AND table_id = 1099511628002 AND partition_id = 0 ORDER BY tenant_id, table_id, partition_id, svr_ip, svr_port”}, retry_cnt=0)
[2023-09-20 11:05:34.011841] WARN [SERVER] inner_close (ob_inner_sql_result.cpp:152) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=6] [dc=0] result set close failed(ret=-5019, need_retry=false)
[2023-09-20 11:05:34.011849] WARN [SERVER] force_close (ob_inner_sql_result.cpp:136) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=5] [dc=0] result set close failed(ret=-5019)
[2023-09-20 11:05:34.011852] WARN [SERVER] query (ob_inner_sql_connection.cpp:833) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=2] [dc=0] failed to close result(close_ret=-5019, ret=-5019)
[2023-09-20 11:05:34.011888] WARN [SERVER.OMT] get_tenant_config_with_lock (ob_tenant_config_mgr.cpp:280) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=3] [dc=0] failed to get tenant config(fallback_tenant_id=1, ret=-4201)
[2023-09-20 11:05:34.011897] WARN [SERVER] collect_query_response_time (ob_query_response_time.cpp:141) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=7] [dc=0] time collector of the tenant does not exist(tenant_id=1, time=0, ret=-4201)
[2023-09-20 11:05:34.011908] WARN [SERVER.OMT] get_tenant_ctx_with_tenant_lock (ob_multi_tenant.cpp:64) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=3] [dc=0] get tenant from omt failed(ret=-5150, tenant_id=1)
[2023-09-20 11:05:34.011915] WARN [SHARE] ObTenantSpaceFetcher (ob_context.cpp:176) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=6] [dc=0] get tenant ctx failed(ret=-5150, tenant_id=1)
[2023-09-20 11:05:34.011923] WARN [SERVER] query (ob_inner_sql_connection.cpp:861) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=5] [dc=0] failed to process record(executor={ObIExecutor:, sql:“SELECT * FROM all_root_table WHERE tenant_id = 1 AND table_id = 1099511628002 AND partition_id = 0 ORDER BY tenant_id, table_id, partition_id, svr_ip, svr_port"}, record_ret=-5019, ret=-5019)
[2023-09-20 11:05:34.011936] WARN [SERVER] query (ob_inner_sql_connection.cpp:877) [27408][666][YB42AC100145-000605C1A60FA80F] [lt=10] [dc=0] failed to process final(executor={ObIExecutor:, sql:"SELECT * FROM all_root_table WHERE tenant_id = 1 AND table_id = 1099511628002 AND partition_id = 0 ORDER BY tenant_id, table_id, partition_id, svr_ip, svr_port"}, aret=-5019, ret=-5019)
[2023-09-20 11:05:34.011949] WARN [SERVER] execute_read (ob_inner_sql_connection.cpp:1330) [27408][666][Y0-0000000000000000] [lt=5] [dc=0] execute sql failed(ret=-5019, tenant_id=1, sql="SELECT * FROM all_root_table WHERE tenant_id = 1 AND table_id = 1099511628002 AND partition_id = 0 ORDER BY tenant_id, table_id, partition_id, svr_ip, svr_port")
[2023-09-20 11:05:34.011963] WARN [COMMON.MYSQLP] read (ob_mysql_proxy.cpp:290) [27408][666][Y0-0000000000000000] [lt=11] [dc=0] query failed(ret=-5019, conn=0x7ff2296a3950, start=1695179134008565, sql="SELECT * FROM all_root_table WHERE tenant_id = 1 AND table_id = 1099511628002 AND partition_id = 0 ORDER BY tenant_id, table_id, partition_id, svr_ip, svr_port")
[2023-09-20 11:05:34.011984] WARN [SHARE] fetch_partition_info (ob_partition_table_proxy.cpp:1411) [27408][666][Y0-0000000000000000] [lt=10] [dc=0] execute sql failed(ret=-5019, cluster_id=-1, sql="SELECT * FROM all_root_table WHERE tenant_id = 1 AND table_id = 1099511628002 AND partition_id = 0 ORDER BY tenant_id, table_id, partition_id, svr_ip, svr_port")
[2023-09-20 11:05:34.012061] WARN [SHARE.PT] get_partition_info (ob_persistent_partition_table.cpp:838) [27408][666][Y0-0000000000000000] [lt=7] [dc=0] get partition table failed(ret=-5019, cluster_id=-1, table_id={value:1099511628002, first:1, second:226}, partition_id=0, filter_flag_replica=true)
[2023-09-20 11:05:34.012074] WARN [SHARE.PT] get (ob_persistent_partition_table.cpp:71) [27408][666][Y0-0000000000000000] [lt=9] [dc=0] get_partition_info failed(cluster_id=-1, table_id={value:1099511628002, first:1, second:226}, partition_id=0, filter_flag_replica=true, ret=-5019)
[2023-09-20 11:05:34.012082] WARN [SHARE.PT] get (ob_partition_table_operator.cpp:145) [27408][666][Y0-0000000000000000] [lt=3] [dc=0] get partition info failed(ret=-5019, table_id={value:1099511628002, first:1, second:226}, partition_id=0)
[2023-09-20 11:05:34.012092] WARN [SHARE.PT] partition_table_fetch_location (ob_partition_location_cache.cpp:411) [27408][666][Y0-0000000000000000] [lt=8] [dc=0] Partition Operator get failed(cluster_id=-1, table_id={value:1099511628002, first:1, second:226}, partition_id=0, ret=-5019)
[2023-09-20 11:05:34.012098] WARN [SHARE.PT] fetch_location (ob_partition_location_cache.cpp:620) [27408][666][Y0-0000000000000000] [lt=4] [dc=0] fetch location through partition table operator failed(cluster_id=1, table_id={value:1099511628002, first:1, second:226}, partition_id=0, ret=-5019)
[2023-09-20 11:05:34.012131] WARN [SHARE.PT] renew_location (ob_partition_location_cache.cpp:3385) [27408][666][Y0-0000000000000000] [lt=6] [dc=0] fetch location failed(ret=-5019, table_id={value:1099511628002, first:1, second:226}, partition_id=0, expire_renew_time=0, cost=3578, lbt()=“0x9a98e9e 0x2a703d6 0x2aa61e7 0x2aa83c0 0x2aa9f7f 0x8ba70a0 0x8ba904e 0x8ba84dd 0x8ba817c 0x8ba8d0d 0x2ca95d4 0x2cabf02 0x9820da5 0x981f792 0x981c24f”)
[2023-09-20 11:05:34.012153] WARN [SHARE.PT] get (ob_partition_location_cache.cpp:2437) [27408][666][Y0-0000000000000000] [lt=8] [dc=0] renew location failed(ret=-5019, table_id={value:1099511628002, first:1, second:226}, partition_id=0, expire_renew_time_new=0, filter_not_readable_replica=true, lbt()=“0x9a98e9e 0x2aa63a0 0x2aa83c0 0x2aa9f7f 0x8ba70a0 0x8ba904e 0x8ba84dd 0x8ba817c 0x8ba8d0d 0x2ca95d4 0x2cabf02 0x9820da5 0x981f792 0x981c24f”)
[2023-09-20 11:05:34.012161] WARN [SHARE.PT] get (ob_partition_location_cache.cpp:2594) [27408][666][Y0-0000000000000000] [lt=5] [dc=0] get partition location failed(ret=-5019, partition={tid:1099511628002, partition_id:0, part_cnt:0}, expire_renew_time=0)
[2023-09-20 11:05:34.012168] WARN [SHARE.PT] get_strong_leader (ob_partition_location_cache.cpp:2698) [27408][666][Y0-0000000000000000] [lt=5] [dc=0] get failed(partition={tid:1099511628002, partition_id:0, part_cnt:0}, force_renew=false, expire_renew_time=0, ret=-5019)
[2023-09-20 11:05:34.012177] WARN [STORAGE.TRANS] get_cluster_service_master
 (ob_tenant_weak_read_service.cpp:253) [27408][666][Y0-0000000000000000] [lt=6] [dc=0] get tenant weak read cluster service partition leader from location cache fail(ret=-5019, ret=“OB_TABLE_NOT_EXIST”, pkey={tid:1099511628002, partition_id:0, part_cnt:0}, force_renew=false)
[2023-09-20 11:05:34.012187] WARN [STORAGE.TRANS] post_cluster_heartbeat_rpc
 (ob_tenant_weak_read_service.cpp:662) [27408][666][Y0-0000000000000000] [lt=4] [dc=0] get cluster service master fail(ret=-5019, ret=“OB_TABLE_NOT_EXIST”, tenant_id
=1, cluster_service_pkey={tid:1099511628002, partition_id:0, part_cnt:0})
[2023-09-20 11:05:34.012198] WARN [STORAGE.TRANS] process_cluster_heartbeat_rpc_cb (ob_tenant_weak_read_service.cpp:392) [27408][666][Y0-0000000000000000] [lt=5] [dc=0] tenant weak read service cluster heartbeat RPC fail(rcode={code:-5019, msg:“post cluster heartbeat rpc failed, tenant_id=1”, warnings:[]}, tenant_id
=1, dst=“172.16.1.69:2882”, cluster_service_pkey={tid:1099511628002, partition_id:0, part_cnt:0})
[2023-09-20 11:05:34.012237] WARN [STORAGE.TRANS] do_cluster_heartbeat
 (ob_tenant_weak_read_service.cpp:616) [27408][666][Y0-0000000000000000] [lt=7] [dc=0] post cluster heartbeat rpc fail(ret=-5019, ret=“OB_TABLE_NOT_EXIST”, tenant_id
=1, local_server_version=0, valid_part_count=0, total_part_count=0, generate_timestamp=1695179134008512)
[2023-09-20 11:05:34.012246] WARN [STORAGE.TRANS] do_cluster_heartbeat
 (ob_tenant_weak_read_service.cpp:630) [27408][666][Y0-0000000000000000] [lt=5] [dc=0] tenant weak read service do cluster heartbeat fail(ret=-5019, ret=“OB_TABLE_NOT_EXIST”, tenant_id
=1, last_post_cluster_heartbeat_tstamp
=0, cluster_heartbeat_interval
=50000, cluster_service_pkey={tid:1099511628002, partition_id:0, part_cnt:0}, cluster_service_master=“0.0.0.0”)
[2023-09-20 11:05:34.013739] WARN [STORAGE] get_partition (ob_partition_meta_redo_module.cpp:683) [27408][666][Y0-0000000000000000] [lt=8] [dc=0] get pg key error(ret=-4225, pkey={tid:1099511628002, partition_id:0, part_cnt:0}, pg_key={tid:18446744073709551615, partition_id:-1, part_idx:268435455, subpart_idx:268435455})
[2023-09-20 11:05:34.013770] WARN [STORAGE] get_partition (ob_partition_meta_redo_module.cpp:660) [27408][666][Y0-0000000000000000] [lt=10] [dc=0] fail to get partition(ret=-4225, pkey={tid:1099511628002, partition_id:0, part_cnt:0}, common::lbt()=“0x9a98e9e 0x7cbe777 0x8b9c00c 0x8ba0198 0x8ba8267 0x8ba8d0d 0x2ca95d4 0x2cabf02 0x9820da5 0x981f792 0x981c24f”)
[2023-09-20 11:05:34.013820] WARN [SQL.RESV] resolve_table_relation_recursively (ob_dml_resolver.cpp:6639) [27192][240][YB42AC100145-000605C1A61FA810] [lt=11] [dc=0] synonym not exist(tenant_id=1, database_id=1099511627777, table_name=__all_root_table, ret=-5019)
[2023-09-20 11:05:34.013835] WARN [SQL.RESV] resolve_table_relation_factor_normal (ob_dml_resolver.cpp:6515) [27192][240][YB42AC100145-000605C1A61FA810] [lt=13] [dc=0] fail to resolve table relation recursively(tenant_id=1, ret=-5019)
[2023-09-20 11:05:34.013848] WARN [SQL.RESV] resolve_table_relation_factor (ob_dml_resolver.cpp:6295) [27192][240][YB42AC100145-000605C1A61FA810] [lt=12] [dc=0] resolve table relation factor failed(ret=-5019)
[2023-09-20 11:05:34.013861] WARN [SHARE.SCHEMA] get_dblink_user (ob_schema_getter_guard.cpp:6554) [27192][240][YB42AC100145-000605C1A61FA810] [lt=8] [dc=0] dblink user name is empty(tenant_id=1, dblink_name=__all_root_table)
[2023-09-20 11:05:34.013874] WARN [SQL.RESV] get_dblink_user (ob_schema_checker.cpp:1303) [27192][240][YB42AC100145-000605C1A61FA810] [lt=11] [dc=0] failed to get dblink id(ret=-4016, tenant_id=1, dblink_name=all_root_table)
[2023-09-20 11:05:34.013885] WARN [SQL.RESV] resolve_dblink_with_synonym (ob_dml_resolver.cpp:6339) [27192][240][YB42AC100145-000605C1A61FA810] [lt=10] [dc=0] fail to exec schema_checker
->get_dblink_user(tenant_id, tmp_table_name, tmp_db_name, *allocator
)(ret=-4016)
[2023-09-20 11:05:34.013891] WARN [SQL.RESV] resolve_table_relation_factor (ob_dml_resolver.cpp:6300) [27192][240][YB42AC100145-000605C1A61FA810] [lt=5] [dc=0] try synonym with dblink failed(ret=-4016)
[2023-09-20 11:05:34.013904] WARN [SQL.RESV] inner_resolve_sys_view (ob_dml_resolver.cpp:950) [27192][240][YB42AC100145-000605C1A61FA810] [lt=10] [dc=0] fail to resolve table(ret=-5019)
[2023-09-20 11:05:34.013916] WARN [SQL.RESV] resolve_table_relation_factor_wrapper (ob_dml_resolver.cpp:983) [27192][240][YB42AC100145-000605C1A61FA810] [lt=11] [dc=0] fail to resolve sys view(ret=-5019)
[2023-09-20 11:05:34.013976] WARN resolve_basic_table (ob_dml_resolver.cpp:1076) [27192][240][YB42AC100145-000605C1A61FA810] [lt=4] [dc=0] Table 'oceanbase.all_root_table’ doesn’t exist
[2023-09-20 11:05:34.013989] WARN [SQL.RESV] resolve_basic_table (ob_select_resolver.cpp:3369) [27192][240][YB42AC100145-000605C1A61FA810] [lt=12] [dc=0] resolve base or alias table factor failed(ret=-5019)
[2023-09-20 11:05:34.013995] WARN [SQL.RESV] resolve_table (ob_dml_resolver.cpp:1301) [27192][240][YB42AC100145-000605C1A61FA810] [lt=5] [dc=0] resolve basic table failed(ret=-5019)
[2023-09-20 11:05:34.014006] WARN [SQL.RESV] resolve_from_clause (ob_select_resolver.cpp:3176) [27192][240][YB42AC100145-000605C1A61FA810] [lt=10] [dc=0] fail to exec resolve_table(*table_node, table_item)(ret=-5019)
[2023-09-20 11:05:34.014006] WARN [SQL.RESV] resolve_from_clause (ob_select_resolver.cpp:3176) [27192][240][YB42AC100145-000605C1A61FA810] [lt=10] [dc=0] fail to exec resolve_table(*table_node, table_item)(ret=-5019)
[2023-09-20 11:05:34.014012] WARN [SQL.RESV] resolve_normal_query (ob_select_resolver.cpp:781) [27192][240][YB42AC100145-000605C1A61FA810] [lt=5] [dc=0] fail to exec resolve_from_clause(parse_tree.children
[PARSE_SELECT_FROM])(ret=-5019)
[2023-09-20 11:05:34.014018] WARN [SQL.RESV] resolve (ob_select_resolver.cpp:934) [27192][240][YB42AC100145-000605C1A61FA810] [lt=4] [dc=0] resolve normal query failed(ret=-5019)
[2023-09-20 11:05:34.014030] WARN [SQL.RESV] select_stmt_resolver_func (ob_resolver.cpp:142) [27192][240][YB42AC100145-000605C1A61FA810] [lt=9] [dc=0] execute stmt_resolver failed(ret=-5019, parse_tree.type
=3035)
[2023-09-20 11:05:34.014054] WARN [SQL] generate_stmt (ob_sql.cpp:1440) [27192][240][YB42AC100145-000605C1A61FA810] [lt=10] [dc=0] failed to resolve(ret=-5019)
[2023-09-20 11:05:34.014067] WARN [SQL] generate_physical_plan (ob_sql.cpp:1528) [27192][240][YB42AC100145-000605C1A61FA810] [lt=11] [dc=0] Failed to generate stmt(ret=-5019, result.get_exec_context().need_disconnect()=false)
[2023-09-20 11:05:34.014074] WARN [SQL] handle_physical_plan (ob_sql.cpp:3228) [27192][240][YB42AC100145-000605C1A61FA810] [lt=5] [dc=0] Failed to generate plan(ret=-5019, result.get_exec_context().need_disconnect()=false)
[2023-09-20 11:05:34.014086] WARN [SQL] handle_text_query (ob_sql.cpp:1209) [27192][240][YB42AC100145-000605C1A61FA810] [lt=11] [dc=0] fail to handle physical plan(ret=-5019)
[2023-09-20 11:05:34.014093] WARN [SQL] stmt_query (ob_sql.cpp:171) [27192][240][YB42AC100145-000605C1A61FA810] [lt=5] [dc=0] fail to handle text query(stmt= SELECT * FROM __all_root_table WHERE (tenant_id, table_id, partition_id) IN ( (1, 1099511628002, 0) ) ORDER BY tenant_id, table_id, partition_id, svr_ip, svr_port, ret=-5019)
[2023-09-20 11:05:34.014112] WARN [SERVER] do_query (ob_inner_sql_connection.cpp:674) [27192][240][YB42AC100145-000605C1A61FA810] [lt=18] [dc=0] executor execute failed(ret=-5019)
[2023-09-20 11:05:34.014123] WARN [SERVER] query (ob_inner_sql_connection.cpp:824) [27192][240][YB42AC100145-000605C1A61FA810] [lt=5] [dc=0] execute failed(ret=-5019, executor={ObIExecutor:, sql:” SELECT * FROM __all_root_table WHERE (tenant_id, table_id, partition_id) IN ( (1, 1099511628002, 0) ) ORDER BY tenant_id, table_id, partition_id, svr_ip, svr_port”}, retry_cnt=0)
[2023-09-20 11:05:34.014139] WARN [SERVER] query (ob_inner_sql_connection.cpp:827) [27192][240][YB42AC100145-000605C1A61FA810] [lt=11] [dc=0] failed to process retry(tmp_ret=-5019, ret=-5019, executor={ObIExecutor:, sql:" SELECT * FROM __all_root_table WHERE (tenant_id, table_id, partition_id) IN ( (1, 1099511628002, 0) ) ORDER BY tenant_id, table_id, partition_id, svr_ip, svr_port"}, retry_cnt=0)
[2023-09-20 11:05:34.014154] WARN [SERVER] inner_close (ob_inner_sql_result.cpp:152) [27192][240][YB42AC100145-000605C1A61FA810] [lt=10] [dc=0] result set close failed(ret=-5019, need_retry=false)


收藏
分享
2条回答
默认
最新
O
OceanBase社区传送门
2023-09-21

改两个参数:

  • system_memory=1G
  • cpu_count=16
  • 重新启动
暂无图片 评论
暂无图片 有用 0
打赏 0
O
OceanBase社区传送门
2023-09-21
问题已关闭:
暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏