2020-08-20
opengauss启库报错,麻烦各位大佬帮忙看一下谢谢,困扰好久了一直没解决
安装后就报错启库问题
开始是报错意思是内存参数问题

[2020-08-20 15:13:07.914][25847][][gs_ctl]: gs_ctl started,datadir is -D "/opt/install/data/db1"
[2020-08-20 15:13:08.048][25847][][gs_ctl]: waiting for server to start...
.0 [BACKEND] LOG: Begin to start openGauss Database.
2020-08-20 07:13:08.330 5f3e2284.1 [unknown] 140215614840576 [unknown] 0 dn_6001 DB001 0 [REDO] LOG: Recovery parallelism, cpu count = 10, max = 4, actual = 4
2020-08-20 07:13:08.330 5f3e2284.1 [unknown] 140215614840576 [unknown] 0 dn_6001 DB001 0 [REDO] LOG: ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4
2020-08-20 07:13:08.344 5f3e2284.1 [unknown] 140215614840576 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Transparent encryption disabled.
2020-08-20 07:13:08.367 5f3e2284.1 [unknown] 140215614840576 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2020-08-20 07:13:08.369 5f3e2284.1 [unknown] 140215614840576 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2020-08-20 07:13:08.369 5f3e2284.1 [unknown] 140215614840576 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: Failed to initialize the memory protect for g_instance.attr.attr_storage.cstore_buffers (131072 Mbytes) or shared memory (2110 Mbytes) is larger.
2020-08-20 07:13:09.531 5f3e2284.1 [unknown] 140215614840576 [unknown] 0 dn_6001 00000 0 [CACHE] LOG: set data cache size(135291469824)
2020-08-20 07:13:10.084 5f3e2284.1 [unknown] 140215614840576 [unknown] 0 dn_6001 00000 0 [CACHE] LOG: set metadata cache size(2147483648)
2020-08-20 07:13:10.826 5f3e2284.1 [unknown] 140215614840576 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: gaussdb: fsync file "/opt/install/data/db1/gaussdb.state.temp" success
2020-08-20 07:13:10.826 5f3e2284.1 [unknown] 140215614840576 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Normal)
2020-08-20 07:13:10.852 5f3e2284.1 [unknown] 140215614840576 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: max_safe_fds = 978, usable_fds = 1000, already_open = 12
2020-08-20 07:13:10.859 5f3e2284.1 [unknown] 140215614840576 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Success to start openGauss Database, please press any key to exit...
.[2020-08-20 15:13:11.866][25847][][gs_ctl]: waitpid 25857 failed, exitstatus is 4, ret is 2
[2020-08-20 15:13:11.867][25847][][gs_ctl]: stopped waiting
[2020-08-20 15:13:11.867][25847][][gs_ctl]: could not start server
[2020-08-20 15:13:11.867][25847][][gs_ctl]: Examine the log output.
在将内存参数设置为如下参数后,启库输出无报错,但是实力还是没起来,查看了一圈日志,唯一发现pg_log里面有有用的日志输出
pg_ctl命令输出
[2020-08-20 15:13:32.650][25884][][gs_ctl]: gs_ctl started,datadir is -D "/opt/install/data/db1"
[2020-08-20 15:13:32.765][25884][][gs_ctl]: waiting for server to start...
.0 [BACKEND] LOG: Begin to start openGauss Database.
2020-08-20 07:13:33.023 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 DB001 0 [REDO] LOG: Recovery parallelism, cpu count = 10, max = 4, actual = 4
2020-08-20 07:13:33.023 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 DB001 0 [REDO] LOG: ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4
2020-08-20 07:13:33.040 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Transparent encryption disabled.
2020-08-20 07:13:33.060 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2020-08-20 07:13:33.062 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2020-08-20 07:13:33.062 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: shared memory 1857 Mbytes, memory context 3134 Mbytes, max process memory 5120 Mbytes
2020-08-20 07:13:33.062 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Initilize the memory protect with Process Chunks number 3134, change bits 20
2020-08-20 07:13:33.213 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 00000 0 [CACHE] LOG: set data cache size(100663296)
2020-08-20 07:13:33.225 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 00000 0 [CACHE] LOG: set metadata cache size(33554432)
2020-08-20 07:13:33.949 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: gaussdb: fsync file "/opt/install/data/db1/gaussdb.state.temp" success
2020-08-20 07:13:33.949 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Normal)
2020-08-20 07:13:33.974 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: max_safe_fds = 978, usable_fds = 1000, already_open = 12
2020-08-20 07:13:33.979 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Success to start openGauss Database, please press any key to exit...
.[2020-08-20 15:13:34.984][25884][][gs_ctl]: waitpid 25894 failed, exitstatus is 4, ret is 2
[2020-08-20 15:13:34.984][25884][][gs_ctl]: stopped waiting
[2020-08-20 15:13:34.984][25884][][gs_ctl]: could not start server
[2020-08-20 15:13:34.984][25884][][gs_ctl]: Examine the log output.

日志输出如下

2020-08-20 07:13:33.982 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: start create thread!
2020-08-20 07:13:33.982 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: create thread end!
2020-08-20 07:13:33.982 5f3e229c.1 [unknown] 140608463027968 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not fork new process for connection due to PMstate PM_STARTUP
2020-08-20 07:13:33.984 5f3e229d.10000 [unknown] 140606131136256 dn_6001 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]alarm checker started.
2020-08-20 07:13:33.985 5f3e229d.10000 [unknown] 140606114354944 dn_6001 0 dn_6001 00000 0 [BACKEND] LOG: reaper backend started.
2020-08-20 15:13:33.987 [MOT] <TID:25919/-----> <SID:-----/-----> [WARNING] <JitExec> SSE4.2 is not supported, disable codegen.
2020-08-20 15:13:33.987 [MOT] <TID:25919/-----> <SID:-----/-----> [INFO] <JitExec> Using TVM on LLVM natively unsupported platform
2020-08-20 15:13:33.987 [MOT] <TID:25919/-----> <SID:-----/-----> [INFO] <Configuration> Configuring total memory for relative memory values to: 5120 MB
2020-08-20 15:13:33.987 [MOT] <TID:25919/-----> <SID:-----/-----> [INFO] <System> Startup: Loading configuration from /opt/install/data/db1/mot.conf
2020-08-20 15:13:33.988 [MOT] <TID:25919/-----> <SID:-----/-----> [INFO] <Configuration> Loaded max_mot_global_memory: 80% from total = 4096 MB
2020-08-20 15:13:33.988 [MOT] <TID:25919/-----> <SID:-----/-----> [INFO] <Configuration> Loaded max_mot_local_memory: 15% from total = 768 MB
2020-08-20 15:13:33.988 [MOT] <TID:25919/-----> <SID:-----/-----> [INFO] <Configuration> Loading max_connections from envelope into MOTEngine: 5000
2020-08-20 15:13:33.988 [MOT] <TID:25919/-----> <SID:-----/-----> [INFO] <Configuration> Configuring asynchronous redo-log handler due to synchronous_commit=off
2020-08-20 15:13:33.988 [MOT] <TID:25919/-----> <SID:-----/-----> [WARNING] <Configuration> Adjusting MOT memory limits: global = 2586 MB, local = 486 MB, session large store = 0 MB, to
tal = 3072 MB
2020-08-20 15:13:33.989 [MOT] <TID:25919/-----> <SID:-----/-----> [INFO] <Memory> Global Memory Limit is configured to: 0 MB --> 2586 MB
2020-08-20 15:13:33.989 [MOT] <TID:25919/-----> <SID:-----/-----> [INFO] <Memory> Local Memory Limit is configured to: 0 MB --> 486 MB
2020-08-20 15:13:33.989 [MOT] <TID:25919/-----> <SID:-----/-----> [INFO] <Memory> Session Memory Limit is configured to: 0 KB --> 0 KB (maximum 5000 sessions)
2020-08-20 15:13:33.989 [MOT] <TID:25919/-----> <SID:-----/-----> [INFO] <Memory> Configured automatic chunk allocation policy to 'LOCAL' on single node machine
但是看log也没有明显的err报错
主机的内存也挺多的
total used free shared buff/cache available
Mem: 12137304 173052 9998148 544840 1966104 9724872
Swap: 0 0 0
[root@opengauss script]#
我来答
添加附件
收藏
分享
问题补充
7条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

评论
