信号旗YPA 2020-08-18 15:42 采纳率: 0%
浏览 1283

opengauss启库报错，无明显报错仅仅有内存的warning

1.环境为centos7

2.启库报错，内存相关参数只有warning，但是一直是起不来，也没有其他报错

[omm@gausstest db1]$ gs_ctl start -D '/opt/install/data/db1'
[2020-08-18 07:37:10.567][22077][][gs_ctl]: gs_ctl started,datadir is -D "/opt/install/data/db1"  
[2020-08-18 07:37:10.652][22077][][gs_ctl]: waiting for server to start...
.0 [BACKEND] LOG:  Begin to start openGauss Database.
2020-08-18 07:37:10.842 5f3b8526.1 [unknown] 140475576839936 [unknown] 0 dn_6001 DB001 0 [REDO] LOG:  Recovery parallelism, cpu count = 4, max = 4, actual = 4
2020-08-18 07:37:10.842 5f3b8526.1 [unknown] 140475576839936 [unknown] 0 dn_6001 DB001 0 [REDO] LOG:  ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4
2020-08-18 07:37:10.843 5f3b8526.1 [unknown] 140475576839936 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG:  Transparent encryption disabled.
2020-08-18 07:37:10.856 5f3b8526.1 [unknown] 140475576839936 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2020-08-18 07:37:10.857 5f3b8526.1 [unknown] 140475576839936 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG:  InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2020-08-18 07:37:10.857 5f3b8526.1 [unknown] 140475576839936 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING:  Failed to initialize the memory protect for g_instance.attr.attr_storage.cstore_buffers (16 Mbytes) or shared memory (1408 Mbytes) is larger.
2020-08-18 07:37:10.940 5f3b8526.1 [unknown] 140475576839936 [unknown] 0 dn_6001 00000 0 [CACHE] LOG:  set data cache  size(12582912)
2020-08-18 07:37:10.941 5f3b8526.1 [unknown] 140475576839936 [unknown] 0 dn_6001 00000 0 [CACHE] LOG:  set metadata cache  size(4194304)
2020-08-18 07:37:11.402 5f3b8526.1 [unknown] 140475576839936 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG:  gaussdb: fsync file "/opt/install/data/db1/gaussdb.state.temp" success
2020-08-18 07:37:11.402 5f3b8526.1 [unknown] 140475576839936 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG:  create gaussdb state file success: db state(STARTING_STATE), server mode(Normal)
2020-08-18 07:37:11.427 5f3b8526.1 [unknown] 140475576839936 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG:  max_safe_fds = 978, usable_fds = 1000, already_open = 12
2020-08-18 07:37:11.431 5f3b8526.1 [unknown] 140475576839936 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG:  Success to start openGauss Database, please press any key to exit...
[2020-08-18 07:37:11.654][22077][][gs_ctl]:  waitpid 22087 failed, exitstatus is 4, ret is 2

[2020-08-18 07:37:11.654][22077][][gs_ctl]: stopped waiting
[2020-08-18 07:37:11.654][22077][][gs_ctl]: could not start server
[2020-08-18 07:37:11.654][22077][][gs_ctl]: Examine the log output.
[omm@gausstest db1]$

内存看着都是够的，还请各位大佬帮忙看看谢谢啦！

[omm@gausstest db1]$ free
total used free shared buff/cache available
Mem: 8009396 129544 5932676 535608 1947176 6131132
Swap: 0 0 0
[omm@gausstest db1]$

最新进度通过调整配置文件的内存相关参数，启库无报错但是实例还是起不来，有大佬知道还有啥办法可以排查的吗？下面有配置文件中内存配置信息
[omm@opengauss ~]$ gs_ctl start -D '/opt/install/data/db1'
[2020-08-20 14:25:18.428][24699][][gs_ctl]: gs_ctl started,datadir is -D "/opt/install/data/db1"

[2020-08-20 14:25:18.565][24699][][gs_ctl]: waiting for server to start...
.0 [BACKEND] LOG: Begin to start openGauss Database.
2020-08-20 06:25:18.868 5f3e174e.1 [unknown] 140648021761792 [unknown] 0 dn_6001 DB001 0 [REDO] LOG: Recovery parallelism, cpu count = 10, max = 4, actual = 4
2020-08-20 06:25:18.868 5f3e174e.1 [unknown] 140648021761792 [unknown] 0 dn_6001 DB001 0 [REDO] LOG: ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4
2020-08-20 06:25:18.882 5f3e174e.1 [unknown] 140648021761792 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Transparent encryption disabled.
2020-08-20 06:25:18.907 5f3e174e.1 [unknown] 140648021761792 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2020-08-20 06:25:18.910 5f3e174e.1 [unknown] 140648021761792 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2020-08-20 06:25:18.910 5f3e174e.1 [unknown] 140648021761792 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: shared memory 1220 Mbytes, memory context 2859 Mbytes, max process memory 4096 Mbytes
2020-08-20 06:25:18.910 5f3e174e.1 [unknown] 140648021761792 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Initilize the memory protect with Process Chunks number 2859, change bits 20
2020-08-20 06:25:19.007 5f3e174e.1 [unknown] 140648021761792 [unknown] 0 dn_6001 00000 0 [CACHE] LOG: set data cache size(12582912)
2020-08-20 06:25:19.009 5f3e174e.1 [unknown] 140648021761792 [unknown] 0 dn_6001 00000 0 [CACHE] LOG: set metadata cache size(4194304)
2020-08-20 06:25:19.700 5f3e174e.1 [unknown] 140648021761792 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: gaussdb: fsync file "/opt/install/data/db1/gaussdb.state.temp" success
2020-08-20 06:25:19.701 5f3e174e.1 [unknown] 140648021761792 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Normal)
2020-08-20 06:25:19.728 5f3e174e.1 [unknown] 140648021761792 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: max_safe_fds = 978, usable_fds = 1000, already_open = 12
2020-08-20 06:25:19.734 5f3e174e.1 [unknown] 140648021761792 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Success to start openGauss Database, please press any key to exit...
.[2020-08-20 14:25:20.740][24699][][gs_ctl]: waitpid 24709 failed, exitstatus is 4, ret is 2

[2020-08-20 14:25:20.740][24699][][gs_ctl]: stopped waiting
[2020-08-20 14:25:20.740][24699][][gs_ctl]: could not start server
[2020-08-20 14:25:20.740][24699][][gs_ctl]: Examine the log output.
[omm@opengauss ~]$
图片说明

最新更新
调整了max_process_memory参数后，gs_ctl启动无报错，但是pglog里面有输出，但是也看不太出有啥报错
图片说明

如下是内存配置参数
图片说明

  • 写回答

4条回答 默认 最新

  • ygpGoogle 2020-08-18 16:08
    关注

    [BACKEND] WARNING: Failed to initialize the memory protect for g_instance.attr.attr_storage.cstore_buffers (16 Mbytes) or shared memory (1408 Mbytes) is larger.这明显有个failed，g_instance.attr.attr_storage.cstore_buffers这个参数里g表示gauss数据库,instance是实例,attr是属性，这个参数大概就是说你高斯数据库实例的属性里面有个存储属性里的核心缓冲区大小有问题，然后sharedxxx这个参数是说你分片大小有问题，你就去高斯数据库的配置文件里找这俩参数调大小。

    评论

报告相同问题？

悬赏问题

  • ¥30 关于#微信#的问题：微信实名不绑卡 可以实现吗 有没有专家 可以解决
  • ¥15 (标签-考研|关键词-set)
  • ¥15 求修改代码，图书管理系统
  • ¥15 请问有没求偏多标签数据集yeast,reference,recreation,scene,health数据集。
  • ¥15 传感网应用开发单片机实训
  • ¥15 Delphi 关于sAlphaImageList使用问题
  • ¥15 寻找将CAJ格式文档转txt文本的方案
  • ¥15 shein测试开发会问些啥我是写java的
  • ¥15 关于#单片机#的问题：我有个课程项目设计，我想在STM32F103veTX单片机，M3主控模块上设计一个程序，在Keil uVision5（C语言）上代码该怎么编译？（嫌钱少我可以加钱，急急急）
  • ¥15 opnet仿真网络协议遇到问题