暂无图片
openeuler+opengauss数据库报错,求解答
我来答
分享
手机用户2213
2024-04-26
openeuler+opengauss数据库报错,求解答

openeuler系统安装的opengauss数据库。
openeuler版本:23.09

opengauss版本:2.1.0

安装openeuler系统时勾选自带文件的opengauss数据库,用了一段时间后突然报错。

用top查看资源进程时发现gaussdb的进程直接给cpu拉满了,查询后发现startup无法成功执行,卡在这里导致资源过高,用kill结束进程后重新执行gs_ctl  start就报错

现在服务启动不起来,执行gs_ctl  start 命令后报错,可以帮忙看下问题吗?代码如下:


[opengauss@localhost ~]$ gs_ctl start -D /var/lib/opengauss/data


[2024-04-26 14:59:32.710][5829][][gs_ctl]: gs_ctl started,datadir is /var/lib/opengauss/data

[2024-04-26 14:59:32.733][5829][][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: 127.0.0.1


0 LOG:  [Alarm Module]Get ENV GS_CLUSTER_NAME failed!


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


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.

The core dump path is an invalid directory

2024-04-26 06:59:32.778 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  when starting as multi_standby mode, we couldn't support data replicaton.

2024-04-26 06:59:32.778 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.


2024-04-26 06:59:32.778 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host Name: localhost.localdomain


2024-04-26 06:59:32.778 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host IP: 127.0.0.1


2024-04-26 06:59:32.778 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Get ENV GS_CLUSTER_NAME failed!


2024-04-26 06:59:32.778 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 55


2024-04-26 06:59:32.784 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  loaded library "security_plugin"

2024-04-26 06:59:32.785 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets

2024-04-26 06:59:32.790 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] WARNING:  No explicit IP is configured for listen_addresses GUC.

2024-04-26 06:59:32.790 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.

2024-04-26 06:59:32.791 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for backend threads is: 220 MB

2024-04-26 06:59:32.791 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for WAL buffers is: 128 MB

2024-04-26 06:59:32.791 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  Set max backend reserve memory is: 348 MB, max dynamic memory is: 23791 MB

2024-04-26 06:59:32.791 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  shared memory 420 Mbytes, memory context 24139 Mbytes, max process memory 24576 Mbytes

2024-04-26 06:59:32.822 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [CACHE] LOG:  set data cache  size(12582912)

2024-04-26 06:59:32.822 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [CACHE] LOG:  set metadata cache  size(4194304)

2024-04-26 06:59:33.089 [unknown] [unknown] localhost 140392033302784 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-04-26 06:59:33.110 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  gaussdb: fsync file "/var/lib/opengauss/data/gaussdb.state.temp" success

2024-04-26 06:59:33.110 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  create gaussdb state file success: db state(STARTING_STATE), server mode(Normal)

2024-04-26 06:59:33.135 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  max_safe_fds = 980, usable_fds = 1000, already_open = 10

The core dump path is an invalid directory

2024-04-26 06:59:33.138 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  the configure file /usr/local/opengauss/etc/gscgroup_opengauss.cfg doesn't exist or the size of configure file has changed. Please create it by root user!

2024-04-26 06:59:33.138 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [BACKEND] LOG:  Failed to parse cgroup config file.

2024-04-26 06:59:33.141 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!

2024-04-26 06:59:33.141 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A

2024-04-26 06:59:33.141 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.

2024-04-26 06:59:33.141 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.

2024-04-26 06:59:33.142 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!

2024-04-26 06:59:33.142 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A

2024-04-26 06:59:33.142 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.

2024-04-26 06:59:33.142 [unknown] [unknown] localhost 140392033302784 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.

[2024-04-26 14:59:33.737][5829][][gs_ctl]:  gaussDB state is Coredump


[2024-04-26 14:59:33.737][5829][][gs_ctl]: stopped waiting

[2024-04-26 14:59:33.737][5829][][gs_ctl]: could not start server

Examine the log output

我来答
添加附件
收藏
分享
问题补充
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏