oceanbase-3.2.4.1安装后初始化启动不了

OceanBase 技术问题
,
#1

【 使用环境 】生产环境 or 测试环境
【 OB or 其他组件 】
【 使用版本 】oceanbase-3.2.4.1
【问题描述】oceanbase-3.2.4.1安装后初始化启动不了，2881 2882端口也未启动
【复现路径】/home/admin/oceanbase/bin/observer -i ens32 -P 2882 -p 2881 -z zone1 -d /home/admin/oceanbase/store/obdemo -r ‘172.16.1.59:2882:2881’ -c 10001 -n obdemo -o “system_memory=30G,datafile_size=50G,config_additional_dir=/observer/1/obdemo/etc3;/observer/log1/obdemo/etc2”
【问题现象及影响】

【附件】
observer.log.rar (7.5 MB)
election.log (951.7 KB)
obesi-daemon.log (139.7 KB)
rootservice.log (1.7 MB)

#3

你好，你提的这个技术问题牵涉到OceanBase企业版范围内的功能细节。建议你通过以下方式寻求帮助：
1.如你所在的企业客户已签署OceanBase企业版销售合同，请你联系客户经理；
2.如你所在的企业客户尚未签署OceanBase企业版销售合同，你可通过OceanBase官网商务咨询页面留下你的联系方式，OceanBase企业版的业务顾问会在一个工作日内与你联系。
https://www.oceanbase.com/contactus?fromPage=https%3A%2F%2Fwww.oceanbase.com%2Fsoftwarecenter-enterprise&dataSources=softwarecenter-enterprise_footercontact_d2022

#4

这里不提供支持是吗

#5
  1. 机器的配置如何? CPU核数和内存大小、磁盘大小等
  2. 参考的是哪里的安装方法？
#6

CPU*8 内存64G 磁盘500g
参数方法，官方的网址https://www.oceanbase.com

#7

-o 后面的参数改一下 cpu_count=16,system_memory=10G,memory_limit=60G

启动成功后就是 bootstrap ，这一步过了就基本成了。

#8

这是修改后的命令
-o “cpu_count=16,system_memory=10G,memory_limit=60G,config_additional_dir=/observer/1/obdemo/etc3;/observer/log1/obdemo/etc2”

#9

需要控制大小就加。我看你原本就写了。

#10

-o “cpu_count=16,system_memory=10G,memory_limit=60G,datafile_size=50G,config_additional_dir=/observer/1/obdemo/etc3;/observer/log1/obdemo/etc2”

现在的错误是：
[2023-10-10 11:01:55.266118] ERROR issue_dba_error (ob_log.cpp:2322) [336760][0][Y0-0000000000000000-0-0] [lt=28] [dc=0][errcode=-4388] Unexpected internal error happen, please checkout the internal errcode(errcode=-4016, file=“ob_log_scan_runnable.cpp”, line_no=685, info=“invalid scan_confirmed_log_cnt”)
[2023-10-10 11:01:55.269571] ERROR issue_dba_error (ob_log.cpp:2322) [336760][0][Y0-0000000000000000-0-0] [lt=2629] [dc=0][errcode=-4388] Unexpected internal error happen, please checkout the internal errcode(errcode=-4016, file=“ob_log_scan_runnable.cpp”, line_no=235, info=“notify_scan_finished_ failed”)
[2023-10-10 11:01:55.269675] ERROR issue_dba_error (ob_log.cpp:2322) [336760][0][Y0-0000000000000000-0-0] [lt=78] [dc=0][errcode=-4388] Unexpected internal error happen, please checkout the internal errcode(errcode=-4016, file=“ob_log_scan_runnable.cpp”, line_no=242, info=“log scan runnable exit error”)
[2023-10-10 11:01:55.269721] ERROR issue_dba_error (ob_log.cpp:2322) [336760][0][Y0-0000000000000000-0-0] [lt=17] [dc=0][errcode=-4388] Unexpected internal error happen, please checkout the internal errcode(errcode=0, file=“ob_log_define.h”, line_no=709, info=“ret = %d BACKTRACE:%s”)

#11

参考这个：https://mp.weixin.qq.com/s/ea-5vH-MMePYNRrzPWIA3Q
重新初始化目录，还有些参数等。

#12

根据你提供的地址，重新初始化，看不到明显的ERROR错误信息，2881 2882端口就是起不来

image
image1554×181 6.99 KB

observer.log一直在打印这些信息

[2023-10-10 11:45:00.784423] WDIAG [SQL] ob_sql.cpp:1971 [478825][0][YB42AC10013B-000607546641BE12-0-0] [lt=5] [dc=0][errcode=-5019] fail to handle physical plan(ret=-5019)
[2023-10-10 11:45:00.784432] WDIAG [SQL] ob_sql.cpp:211 [478825][0][YB42AC10013B-000607546641BE12-0-0] [lt=5] [dc=0][errcode=-5019] 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-10-10 11:45:00.784440] WDIAG [SERVER] ob_inner_sql_connection.cpp:737 [478825][0][YB42AC10013B-000607546641BE12-0-0] [lt=6] [dc=0][errcode=-5019] executor execute failed(ret=-5019)
[2023-10-10 11:45:00.784456] WDIAG [SERVER] ob_inner_sql_connection.cpp:897 [478825][0][YB42AC10013B-000607546641BE12-0-0] [lt=8] [dc=0][errcode=-5019] 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-10-10 11:45:00.784474] WDIAG [SERVER] ob_inner_sql_connection.cpp:900 [478825][0][YB42AC10013B-000607546641BE12-0-0] [lt=12] [dc=0][errcode=-5019] 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-10-10 11:45:00.784486] WDIAG [SERVER] ob_inner_sql_result.cpp:170 [478825][0][YB42AC10013B-000607546641BE12-0-0] [lt=7] [dc=0][errcode=-5019] result set close failed(ret=-5019, need_retry=false)
[2023-10-10 11:45:00.784499] WDIAG [SERVER] ob_inner_sql_result.cpp:155 [478825][0][YB42AC10013B-000607546641BE12-0-0] [lt=11] [dc=0][errcode=-5019] result set close failed(ret=-5019)
[2023-10-10 11:45:00.784507] WDIAG [SERVER] ob_inner_sql_connection.cpp:906 [478825][0][YB42AC10013B-000607546641BE12-0-0] [lt=4] [dc=0][errcode=-5019] failed to close result(close_ret=-5019, ret=-5019)
[2023-10-10 11:45:00.784544] WDIAG [SERVER] ob_inner_sql_connection.cpp:931 [478825][0][YB42AC10013B-000607546641BE12-0-0] [lt=8] [dc=0][errcode=-5019] 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-10-10 11:45:00.784581] WDIAG [SERVER] ob_inner_sql_connection.cpp:953 [478825][0][YB42AC10013B-000607546641BE12-0-0] [lt=21] [dc=0][errcode=-5019] 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-10-10 11:45:00.784593] WDIAG [SERVER] ob_inner_sql_connection.cpp:1444 [478825][0][Y0-0000000000000000-0-0] [lt=6] [dc=0][errcode=-5019] 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)

#13

3.2 重新初始化目录方法：

cd /home/admin/oceanbase 
/bin/rm -rf audit/* etc/*config* log/* run/* store/*/*/*

然后再是 bin/observer 接参数

目录结构一样，ob启动失败