centos7安装启动失败

【标题描述】:centos7安装启动失败
【测试类型：SQL功能/存储功能/接口功能/工具功能/性能/并发/压力长稳/故障注入/安全/资料/编码规范】【测试版本：x.x.x】 安装

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):

【测试环境】(单机/1主x备x级联备):centos7

【被测功能】:安装

【测试类型】:安装

【数据库版本】(查询命令: gaussdb -V):5.0.0

【预置条件】:

【操作步骤】(请填写详细的操作步骤):
1. xxx
2. xxx

【预期输出】:

【实际输出】:
[gauss@localhost simpleInstall]$ sh install.sh -w 1234.abc
[step 1]: check parameter
[step 2]: check install env and os setting
[step 3]: change_gausshome_owner
[step 4]: set environment variables

/home/gauss/.bashrc: line 16: ulimit: open files: cannot modify limit: Operation not permitted
[step 6]: init datanode
The files belonging to this database system will be owned by user "gauss".
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 /opt/gauss/data/single_node ... ok
creating subdirectories ... in ordinary occasionok
creating configuration files ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32MB
Begin init undo subsystem meta.
[INIT UNDO] Init undo subsystem meta successfully.
creating template1 database in /opt/gauss/data/single_node/base/1 ... 2023-10-18 15:39:06.158 [unknown] [unknown] localhost 139984692048384 0[0:0#0]  [BACKEND] WARNING:  macAddr is 12/704326757, sysidentifier is 797179/744857010, randomNum is 3019546034
ok
initializing pg_authid ... ok
setting password ... ok
initializing dependencies ... ok
loading PL/pgSQL server-side language ... ok
creating system views ... ok
creating performance views ... ok
loading system objects' descriptions ... ok
creating collations ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
initialize global configure for bucketmap length ... ok
creating information schema ... ok
loading foreign-data wrapper for distfs access ... ok
loading foreign-data wrapper for log access ... ok
loading hstore extension ... ok
loading foreign-data wrapper for MOT access ... ok
loading security plugin ... ok
update system tables ... ok
creating snapshots catalog ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
freezing database template0 ... ok
freezing database template1 ... ok
freezing database postgres ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run gs_initdb.

Success. You can now start the database server of single node using:

gaussdb -D /opt/gauss/data/single_node --single_node
or
    gs_ctl start -D /opt/gauss/data/single_node -Z single_node -l logfile

[step 7]: start datanode
[2023-10-18 15:39:21.733][2463][][gs_ctl]: gs_ctl started,datadir is /opt/gauss/data/single_node
[2023-10-18 15:39:21.859][2463][][gs_ctl]: waiting for server to start...
.0 LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.

0 LOG:  [Alarm Module]Host Name: localhost.localdomain

0 LOG:  [Alarm Module]Host IP: localhost.localdomain. 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.
2023-10-18 15:39:21.985 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  when starting as multi_standby mode, we couldn't support data replicaton.
2023-10-18 15:39:21.985 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  base_page_saved_interval is 400, ori is 400.
gaussdb.state does not exist, and skipt setting since it is optional.2023-10-18 15:39:21.996 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.

2023-10-18 15:39:21.996 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host Name: localhost.localdomain

2023-10-18 15:39:21.996 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host IP: localhost.localdomain. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain <HOST IP>

2023-10-18 15:39:21.996 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Cluster Name: dbCluster

2023-10-18 15:39:21.996 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57

2023-10-18 15:39:21.999 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  loaded library "security_plugin"
2023-10-18 15:39:22.001 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2023-10-18 15:39:22.001 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2023-10-18 15:39:22.003 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2023-10-18 15:39:22.003 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for backend threads is: 220 MB
2023-10-18 15:39:22.003 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for WAL buffers is: 128 MB
2023-10-18 15:39:22.003 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  Set max backend reserve memory is: 348 MB, max dynamic memory is: 11069 MB
2023-10-18 15:39:22.003 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  shared memory 358 Mbytes, memory context 11417 Mbytes, max process memory 12288 Mbytes
2023-10-18 15:39:22.023 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [CACHE] LOG:  set data cache  size(402653184)
2023-10-18 15:39:22.057 [unknown] [unknown] localhost 140061508436480 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
2023-10-18 15:39:22.080 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  gaussdb: fsync file "/opt/gauss/data/single_node/gaussdb.state.temp" success
2023-10-18 15:39:22.080 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1)
2023-10-18 15:39:22.080 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  max_safe_fds = 976, usable_fds = 1000, already_open = 14
2023-10-18 15:39:22.082 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  user configure file is not found, it will be created.
2023-10-18 15:39:22.088 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  the configure file /opt/gauss/etc/gscgroup_gauss.cfg doesn't exist or the size of configure file has changed. Please create it by root user!
2023-10-18 15:39:22.088 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [BACKEND] LOG:  Failed to parse cgroup config file.
2023-10-18 15:39:22.125 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2023-10-18 15:39:22.125 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2023-10-18 15:39:22.126 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2023-10-18 15:39:22.126 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
2023-10-18 15:39:22.127 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2023-10-18 15:39:22.127 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2023-10-18 15:39:22.127 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2023-10-18 15:39:22.127 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
2023-10-18 15:39:22.127 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2023-10-18 15:39:22.127 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2023-10-18 15:39:22.127 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2023-10-18 15:39:22.127 [unknown] [unknown] localhost 140061508436480 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
[2023-10-18 15:39:22.865][2463][][gs_ctl]: waitpid 2466 failed, exitstatus is 0, ret is 2

[2023-10-18 15:39:22.865][2463][][gs_ctl]: stopped waiting
[2023-10-18 15:39:22.865][2463][][gs_ctl]: could not start server
Examine the log output.
import sql file
Would you like to create a demo database (yes/no)? yes
Load demoDB failed, you can check load.log for more details.
【原因分析】:
1. 这个问题的根因
2. 问题推断过程
3. 还有哪些原因可能造成类似现象
4. 该问题是否有临时规避措施
5. 问题解决方案
6. 预计修复问题时间

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

【测试代码】:

> [gauss@localhost bin]$ gaussdb -D /opt/gauss/data/single_node
> 0 LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.
> 
> 0 LOG:  [Alarm Module]Host Name: localhost.localdomain 
> 
> 0 LOG:  [Alarm Module]Host IP: localhost.localdomain. 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.
> popen failure: Cannot allocate memory
> 0 FATAL:  gaussdb: could not locate matching openGauss executable

@cmsj

从这两行看，是服务器内存不够了， 可以检查下内存怎么样
```
popen failure: Cannot allocate memory
0 FATAL: gaussdb: could not locate matching openGauss executable
```

通过日志分析是内存不够，并非代码问题，2023-11-24发起公示，没有疑问，将于2023-11-30关闭该问题单

GVP openGauss/openGauss-server

内容风险标识

评论 (6)

GVPopenGauss/openGauss-server

内容风险标识