暂无图片
opengauss启库报错,麻烦各位大佬帮忙看一下谢谢,困扰好久了一直没解决
我来答
分享
信号旗Lube
2020-08-20
opengauss启库报错,麻烦各位大佬帮忙看一下谢谢,困扰好久了一直没解决

安装后就报错启库问题
开始是报错意思是内存参数问题
开始报错.png

[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.


mem.png

日志输出如下
log.png

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条回答
默认
最新
文成

/opt/install/data/db1/postgresql.conf
这个文件贴一下看看

暂无图片 评论
暂无图片 有用 0
信号旗Lube
上传附件:postgresql.conf
暂无图片 评论
暂无图片 有用 0
文成

shared_buffers调整过没?我看还是默认值,可以调小一点

暂无图片 评论
暂无图片 有用 0
信号旗Lube

嗯这个是调整过的,因为之前默认是1GB,现在调整为256MB,max_process_memory这个默认是2G,因为主机的内存比较多我就增大到5G了,这样子的话在启库时没有warning说太大了
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.
shared_buffers这个参数我最小调整到kb的时候还是会warning说太大,很奇怪

暂无图片 评论
暂无图片 有用 0
HELLO

和楼主一样的问题,请问楼主解决了吗?

2022-08-10 17:19:07.490 62f3780b.1 [unknown] 140014643366976 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2022-08-10 17:19:07.490 62f3780b.1 [unknown] 140014643366976 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets

暂无图片 评论
暂无图片 有用 0
种粮大户

我也遇到这个问题,搞不定。

暂无图片 评论
暂无图片 有用 0
杨杨
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏