栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 系统运维 > 运维 > Linux

openGauss数据库备库重启报错,有没有解决方案呢

Linux 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

openGauss数据库备库重启报错,有没有解决方案呢

[root@centos7 ~]# ps -ef|grep db
dbus        657      1  0 May29 ?        00:00:00 /usr/bin/dbus-daemon --system --address=systemd: --nofork --nopidfile --systemd-activation
omm        2631      1  0 00:06 ?        00:00:00 ssh-agent -a /home/omm/gaussdb_tmp/gauss_socket_tmp
omm        8814      1  5 00:12 ?        00:01:23 /opt/huawei/install/app/bin/gaussdb -D /opt/huawei/install/data/dn -M standby
root       9990   1270  0 00:36 pts/0    00:00:00 grep --color=auto db
[root@centos7 ~]# 
[root@centos7 ~]# 
[root@centos7 ~]# su - omm
Last login: Mon May 30 00:07:13 CST 2022
[omm@backup ~]$ 
[omm@backup ~]$ gs_om -t restart

Stopping cluster.
=========================================

Successfully stopped cluster.
=========================================

End stop cluster.

Starting cluster.
=========================================

[SUCCESS] master
2022-05-30 00:37:40.693 6293a154.1 [unknown] 139718431734848 [unknown] 0 dn_6001_6002 01000  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets

2022-05-30 00:37:40.695 6293a154.1 [unknown] 139718431734848 [unknown] 0 dn_6001_6002 01000  0 [BACKEND] WARNING:  Failed to initialize the memory protect for g_instance.attr.attr_storage.cstore_buffers (1024 Mbytes) or shared memory (4456 Mbytes) is larger.
=========================================

[GAUSS-53600]: Can not start the database, the cmd is source /home/omm/.bashrc; python3 '/opt/huawei/install/om/script/local/StartInstance.py' -U omm -R /opt/huawei/install/app -t 300 --security-mode=off,  Error:
[FAILURE] backup:
[GAUSS-51607] : Failed to start instance. Error: Please check the gs_ctl log for failure details.
[2022-05-30 00:37:42.934][11008][][gs_ctl]: gs_ctl started,datadir is /opt/huawei/install/data/dn 
[2022-05-30 00:37:42.988][11008][][gs_ctl]: waiting for server to start...
.0 LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.

0 LOG:  [Alarm Module]Host Name: backup 

0 LOG:  [Alarm Module]Host IP: 10.0.0.35 

0 LOG:  [Alarm Module]Cluster Name: openGauss 

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/huawei/corefile/
2022-05-30 00:37:43.077 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 DB010  0 [REDO] LOG:  Recovery parallelism, cpu count = 2, max = 4, actual = 2
2022-05-30 00:37:43.077 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 DB010  0 [REDO] LOG:  ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4
2022-05-30 00:37:43.085 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 00000  0 [BACKEND] LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.

2022-05-30 00:37:43.085 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 00000  0 [BACKEND] LOG:  [Alarm Module]Host Name: backup 

2022-05-30 00:37:43.085 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 00000  0 [BACKEND] LOG:  [Alarm Module]Host IP: 10.0.0.35 

2022-05-30 00:37:43.085 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 00000  0 [BACKEND] LOG:  [Alarm Module]Cluster Name: openGauss 

2022-05-30 00:37:43.086 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 00000  0 [BACKEND] LOG:  [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57

2022-05-30 00:37:43.090 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 00000  0 [BACKEND] LOG:  loaded library "security_plugin"
2022-05-30 00:37:43.092 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 01000  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2022-05-30 00:37:43.093 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 00000  0 [BACKEND] LOG:  InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2022-05-30 00:37:43.093 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 01000  0 [BACKEND] WARNING:  Failed to initialize the memory protect for g_instance.attr.attr_storage.cstore_buffers (1024 Mbytes) or shared memory (4456 Mbytes) is larger.
2022-05-30 00:37:43.135 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 00000  0 [CACHE] LOG:  set data cache  size(805306368)
2022-05-30 00:37:43.159 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 00000  0 [CACHE] LOG:  set metadata cache  size(268435456)
2022-05-30 00:37:43.371 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 00000  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
2022-05-30 00:37:43.401 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 00000  0 [BACKEND] LOG:  gaussdb: fsync file "/opt/huawei/install/data/dn/gaussdb.state.temp" success
2022-05-30 00:37:43.401 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 00000  0 [BACKEND] LOG:  create gaussdb state file success: db state(STARTING_STATE), server mode(Standby), connection index(1)
2022-05-30 00:37:43.429 6293a157.1 [unknown] 140172905978944 [unknown] 0 dn_6001_6002 00000  0 [BACKEND] LOG:  max_safe_fds = 974, usable_fds = 1000, already_open = 16
bbox_dump_path is set to /opt/huawei/corefile/
.[2022-05-30 00:37:44.991][11008][][gs_ctl]: waitpid 11011 failed, exitstatus is 256, ret is 2

[2022-05-30 00:37:44.991][11008][][gs_ctl]: stopped waiting
[2022-05-30 00:37:44.991][11008][][gs_ctl]: could not start server
Examine the log output..
[omm@backup ~]$ 
[omm@backup ~]$ 
[omm@backup ~]$ gs_om -t status --details
[GAUSS-50000] : Unrecognized parameter: --details.
[omm@backup ~]$ 
[omm@backup ~]$ gs_om -t status --detail
[   Cluster State   ]

cluster_state   : Degraded
redistributing  : No
current_az      : AZ_ALL

[  Datanode State   ]

    node  node_ip         port      instance                            state

---------------------------------------------------------------------------------------------

1  master 10.0.0.34       15400      6001 /opt/huawei/install/data/dn   P Primary Normal
2  backup 10.0.0.35       15400      6002 /opt/huawei/install/data/dn   S Down    Manually stopped
[omm@backup ~]$ 

刚开始正常状态的截图

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/945805.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号