gs_initdb初始化报错：PANIC: Could not create file "global/pg_dw_meta": Invalid argument 和 gs_ctl 启动报错：gaussDB state is Coredump

/sig install

【标题描述】:
【测试类型：SQL功能/存储功能/接口功能/工具功能/性能/并发/压力长稳/故障注入/安全/资料/编码规范】【测试版本：x.x.x】 
版本：5.0.1
软件包：openGauss-5.0.1-CentOS-64bit.tar.bz2
问题描述

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
 **[root@ai ~]#**  cat /etc/system-release-cpe 
cpe:/o:centos:centos:7

**[root@ai ~]# ** uname -a
Linux ai 3.10.0-514.el7.x86_64 #1 SMP Tue Nov 22 16:42:41 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux

**free -h** 
              total        used        free      shared  buff/cache   available
Mem:          125Gi       4.8Gi       117Gi       2.9Gi       3.2Gi       117Gi
Swap:            0B          0B          0B

【测试环境】(单机/1主x备x级联备):
单机
【被测功能】:
安装：初始化和安装
【测试类型】:
工具功能
【数据库版本】(查询命令: gaussdb -V):
无 没有安装上
【预置条件】:

【操作步骤】(请填写详细的操作步骤):
 **1.导入~/.bashrc 环境变量** 
export GAUSSHOME=/opt/opengauss
export PATH=$GAUSSHOME/bin:$PATH
export LD_LIBRARY_PATH=$GAUSSHOME/lib:$LD_LIBRARY_PATH
export GS_CLUSTER_NAME=dbCluster
ulimit -n 1000000
 **2.生效环境** 
source ~/.bashrc
 ** 3.安装** 
gs_initdb -w tsg@123456 -D /home/open/opengauss/data/single_node --nodename "sgnode" --locale="en_US.UTF-8"
【预期输出】:
成功
【实际输出】:
![输入图片说明](https://foruda.gitee.com/images/1710248283392859755/58ed4306_7812868.png "屏幕截图")
```go
creating directory /home/open/opengauss/data/single_node ... ok
creating subdirectories ... in ordinary occasionok
creating configuration files ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 1024MB
Begin init undo subsystem meta.
[INIT UNDO] Init undo subsystem meta successfully.
creating template1 database in /home/open/opengauss/data/single_node/base/1 ... 2024-03-12 20:48:42.088 [unknown] [unknown] localhost 140270268547392 0[0:0#0]  [BACKEND] WARNING:  macAddr is 8398/712441605, sysidentifier is 550382198/4278540314, randomNum is 1173313562
2024-03-12 20:48:42.116 [unknown] [unknown] localhost 140270268547392 0[0:0#0]  [DBL_WRT] PANIC:  Could not create file "global/pg_dw_meta": Invalid argument
2024-03-12 20:48:42.116 [unknown] [unknown] localhost 140270268547392 0[0:0#0]  [DBL_WRT] BACKTRACELOG:  tid[9902]'s backtrace:
        /home/open/opengauss/bin/gaussdb(+0xe0c84e) [0x55a3df6a084e]
        /home/open/opengauss/bin/gaussdb(_Z9errfinishiz+0x411) [0x55a3df698a81]
        /home/open/opengauss/bin/gaussdb(_Z14dw_create_filePKc+0xf3) [0x55a3e007d503]
        /home/open/opengauss/bin/gaussdb(_Z21dw_generate_meta_fileP21st_dw_batch_meta_file+0x5e) [0x55a3e007d56e]
        /home/open/opengauss/bin/gaussdb(_Z12dw_bootstrapv+0x82) [0x55a3e007d9e2]
        /home/open/opengauss/bin/gaussdb(_Z13BootStrapXLOGv+0xb51) [0x55a3e00ab231]
        /home/open/opengauss/bin/gaussdb(_Z20BootStrapProcessMainiPPc+0x607) [0x55a3df787df7]
        /home/open/opengauss/bin/gaussdb(main+0x7bc) [0x55a3df160d1c]
        /usr/lib/libc.so.6(__libc_start_main+0xe7) [0x7f933840db27]
        /home/open/opengauss/bin/gaussdb(+0x940f57) [0x55a3df1d4f57]
        Use addr2line to get pretty function name and line

could not write to child process: Broken pipe
gs_initdb: removing data directory "/home/open/opengauss/data/single_node"
```
随后通过gdb调试
得到如下信息
```shell
(gdb) set args -w aaa@123456 -D /home/opengauss/opengauss/data/single_node --nodename "sgnode" --locale="en_US.UTF-8"
(gdb) run
Starting program: /home/opengauss/opengauss/bin/gs_initdb -w aaa@123456 -D /home/opengauss/opengauss/data/single_node --nodename "sgnode" --locale="en_US.UTF-8"
warning: File "/lib64/libthread_db-1.0.so" auto-loading has been declined by your `auto-load safe-path' set to "$debugdir:$datadir/auto-load".
To enable execution of this file add
        add-auto-load-safe-path /lib64/libthread_db-1.0.so
line to your configuration file "/home/opengauss/.gdbinit".
To completely disable this security protection add
        set auto-load safe-path /
line to your configuration file "/home/opengauss/.gdbinit".
For more information about this security protection see the
"Auto-loading safe path" section in the GDB manual.  E.g., run from the shell:
        info "(gdb)Auto-loading safe path"
warning: Unable to find libthread_db matching inferior's thread library, thread debugging will not be available.
The files belonging to this database system will be owned by user "opengauss".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

creating directory /home/opengauss/opengauss/data/single_node ... ok
creating subdirectories ... in ordinary occasionok
creating configuration files ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 1024MB
Begin init undo subsystem meta.
[INIT UNDO] Init undo subsystem meta successfully.
creating template1 database in /home/opengauss/opengauss/data/single_node/base/1 ... 2024-03-12 16:01:33.304 [unknown] [unknown] localhost 140736987865408 0[0:0#0]  [BACKEND] WARNING:  macAddr is 8398/712441605, sysidentifier is 550382198/4278565820, randomNum is 2348202940
2024-03-12 16:01:33.320 [unknown] [unknown] localhost 140736987865408 0[0:0#0]  [DBL_WRT] PANIC:  Could not create file "global/pg_dw_meta": Invalid argument
2024-03-12 16:01:33.320 [unknown] [unknown] localhost 140736987865408 0[0:0#0]  [DBL_WRT] BACKTRACELOG:  tid[24625]'s backtrace:
        /home/opengauss/opengauss/bin/gaussdb(+0xe0c84e) [0x55555636084e]
        /home/opengauss/opengauss/bin/gaussdb(_Z9errfinishiz+0x411) [0x555556358a81]
        /home/opengauss/opengauss/bin/gaussdb(_Z14dw_create_filePKc+0xf3) [0x555556d3d503]
        /home/opengauss/opengauss/bin/gaussdb(_Z21dw_generate_meta_fileP21st_dw_batch_meta_file+0x5e) [0x555556d3d56e]
        /home/opengauss/opengauss/bin/gaussdb(_Z12dw_bootstrapv+0x82) [0x555556d3d9e2]
        /home/opengauss/opengauss/bin/gaussdb(_Z13BootStrapXLOGv+0xb51) [0x555556d6b231]
        /home/opengauss/opengauss/bin/gaussdb(_Z20BootStrapProcessMainiPPc+0x607) [0x555556447df7]
        /home/opengauss/opengauss/bin/gaussdb(main+0x7bc) [0x555555e20d1c]
        /usr/lib/libc.so.6(__libc_start_main+0xe7) [0x7fffe2e47b27]
        /home/opengauss/opengauss/bin/gaussdb(+0x940f57) [0x555555e94f57]
        Use addr2line to get pretty function name and line

Program received signal SIGPIPE, Broken pipe.
0x00007ffff683d584 in write () from /usr/lib/libc.so.6
(gdb) bt
#0  0x00007ffff683d584 in write () from /usr/lib/libc.so.6
#1  0x00007ffff67d0e6d in _IO_file_write () from /usr/lib/libc.so.6
#2  0x00007ffff67d016f in ?? () from /usr/lib/libc.so.6
#3  0x00007ffff67d1f99 in _IO_do_write () from /usr/lib/libc.so.6
#4  0x00007ffff67cffb8 in _IO_file_sync () from /usr/lib/libc.so.6
#5  0x00007ffff67c4ded in fflush () from /usr/lib/libc.so.6
#6  0x00005555555633f8 in ?? ()
#7  0x000055555555cc97 in ?? ()
#8  0x00007ffff6779b27 in __libc_start_main () from /usr/lib/libc.so.6
#9  0x000055555555f64c in ?? ()
```

发现不行于是我准备跳过初始化，使用之前生成好的一个data目录模板，包括一些postgresq.conf配置文件：
1.随后我又复制了一个新的模板data 放在了/home/open/opengauss/ 里面 
2.然后运行：
gs_ctl start -D /home/open/opengauss/data/single_node -Z single_node -l /home/open/opengauss/logs/server.logs
报错：启动不起来,页面打印，如图，issues中找到了类似的问题，说是内存不足，但是我这内存还有100多G呢
![](https://foruda.gitee.com/images/1710248824208155446/422d7615_7812868.png "屏幕截图")
```shell
0 LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.

0 LOG:  [Alarm Module]Host Name: localhost

0 LOG:  [Alarm Module]Host IP: localhost. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain <HOST IP>

0 LOG:  [Alarm Module]Cluster Name: dbCluster

0 LOG:  [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57

0 WARNING:  failed to open feature control file, please check whether it exists: FileName=gaussdb.version, Errno=2, Errmessage=No such file or directory.
0 WARNING:  failed to parse feature control file: gaussdb.version.
0 WARNING:  Failed to load the product control file, so gaussdb cannot distinguish product version.
0 LOG:  bbox_dump_path is set to /opt/data/engine_coredump/
2024-03-12 17:21:37.385 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  when starting as multi_standby mode, we couldn't support data replicaton.2024-03-12 17:21:37.411 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.

2024-03-12 17:21:37.411 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host Name: localhost

2024-03-12 17:21:37.411 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host IP: localhost. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain <HOST IP>

2024-03-12 17:21:37.411 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Cluster Name: dbCluster

2024-03-12 17:21:37.411 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57

2024-03-12 17:21:37.425 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  loaded library "security_plugin"
2024-03-12 17:21:37.428 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2024-03-12 17:21:37.428 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2024-03-12 17:21:37.494 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2024-03-12 17:21:37.512 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for backend threads is: 220 MB
2024-03-12 17:21:37.512 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for WAL buffers is: 128 MB
2024-03-12 17:21:37.512 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  Set max backend reserve memory is: 348 MB, max dynamic memory is: 8142 MB2024-03-12 17:21:37.512 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  shared memory 3285 Mbytes, memory context 8490 Mbytes, max process memory 12288 Mbytes
2024-03-12 17:21:37.512 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  shared memory that key is 8897001 is owned by pid 18112
2024-03-12 17:21:37.572 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [CACHE] LOG:  set data cache  size(402653184)
2024-03-12 17:21:37.606 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [SEGMENT_PAGE] LOG:  Segment-page constants: DF_MAP_SIZE: 8156, DF_MAP_BIT_CNT: 65248, DF_MAP_GROUP_EXTENTS: 4175872, IPBLOCK_SIZE: 8168, EXTENTS_PER_IPBLOCK: 1021, IPBLOCK_GROUP_SIZE: 4090, BMT_HEADER_LEVEL0_TOTAL_PAGES: 8323072, BktMapEntryNumberPerBlock: 2038, BktMapBlockNumber: 25, BktBitMaxMapCnt: 512
2024-03-12 17:21:37.626 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  gaussdb: fsync file "/home/opengauss/opengauss/data/single_node/gaussdb.state.temp" success
2024-03-12 17:21:37.626 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1)
2024-03-12 17:21:37.693 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  max_safe_fds = 978, usable_fds = 1000, already_open = 12
bbox_dump_path is set to /opt/data/engine_coredump/
2024-03-12 17:21:37.700 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  the configure file /home/opengauss/opengauss/etc/gscgroup_opengauss.cfg doesn't exist or the size of configure file has changed. Please create it by root user!
2024-03-12 17:21:37.700 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [BACKEND] LOG:  Failed to parse cgroup config file.
2024-03-12 17:21:37.715 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2024-03-12 17:21:37.715 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2024-03-12 17:21:37.715 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2024-03-12 17:21:37.715 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
2024-03-12 17:21:37.718 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2024-03-12 17:21:37.718 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2024-03-12 17:21:37.718 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2024-03-12 17:21:37.718 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
2024-03-12 17:21:37.718 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2024-03-12 17:21:37.718 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2024-03-12 17:21:37.718 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2024-03-12 17:21:37.718 [unknown] [unknown] localhost 140672716415296 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
```

【原因分析】:
1. 这个问题的根因
2. 问题推断过程
3. 还有哪些原因可能造成类似现象
4. 该问题是否有临时规避措施
5. 问题解决方案
6. 预计修复问题时间

【日志信息】(请附上日志文件、截图、coredump信息):

【测试代码】:

openGauss/openGauss-server

内容风险标识

评论 (15)

openGauss/openGauss-server .gitee-modal { width: 500px !important; }

内容风险标识