2022-10-09
安装Mogdb 2.0.1 报错
系统Centos 7.9 安装mogdb 2.0.1版本时报错如下 求大佬请教
[omm@node1 om]$ gs_install -X /opt/software/mogdb/clusterconfig.xml --gsinit-parameter="--locale=en_US.UTF-8" --gsinit-parameter="--encoding=UTF-8"
Parsing the configuration file.
Check preinstall on every node.
Successfully checked preinstall on every node.
Creating the backup directory.
Last time end with Start cluster.
Continue this step.
Successfully created the backup directory.
begin deploy..
[GAUSS-51400] : Failed to execute the command: source /home/omm/.bashrc;python3 '/data/mogdb/tools/script/local/Install.py' -t start_cluster -U omm:dbgrp -X /opt/software/mogdb/clusterconfig.xml -R /data/mogdb/app -c dbCluster -l /var/log/mogdb/omm/om/gs_local.log --alarm=/opt/huawei/snas/bin/snas_cm_cmd --time_out=300 .Error:
Using omm:dbgrp to install database.
Using installation program path : /data/mogdb/app_f892ccb7
$GAUSSHOME points to /data/mogdb/app_f892ccb7, no need to create symbolic link.
Traceback (most recent call last):
File "/data/mogdb/tools/script/local/Install.py", line 680, in <module>
functionDict[g_opts.action]()
File "/data/mogdb/tools/script/local/Install.py", line 611, in startCluster
dn.start(self.time_out)
File "/data/mogdb/tools/script/local/../gspylib/component/Kernel/Kernel.py", line 107, in start
"failure details." + "\n" + output)
Exception: [GAUSS-51607] : Failed to start instance. Error: Please check the gs_ctl log for failure details.
[2022-10-09 10:45:13.297][530][][gs_ctl]: gs_ctl started,datadir is /data/mogdb/data/db1
[2022-10-09 10:45:13.612][530][][gs_ctl]: waiting for server to start...
.0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
0 LOG: [Alarm Module]Host Name: node1
0 LOG: [Alarm Module]Host IP: 192.168.55.79
0 LOG: [Alarm Module]Cluster Name: dbCluster
0 LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 52
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: SSE4.2 is not supported, disable codegen.
0 WARNING: bbox_dump_path is set to /data/mogdb/corefile/
2022-10-09 10:45:14.191 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 DB010 0 [REDO] LOG: Recovery parallelism, cpu count = 8, max = 4, actual = 4
2022-10-09 10:45:14.191 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 DB010 0 [REDO] LOG: ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4
2022-10-09 10:45:14.191 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
2022-10-09 10:45:14.191 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Host Name: node1
2022-10-09 10:45:14.191 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Host IP: 192.168.55.79
2022-10-09 10:45:14.191 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Cluster Name: dbCluster
2022-10-09 10:45:14.192 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 52
2022-10-09 10:45:14.192 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Transparent encryption disabled.
2022-10-09 10:45:14.200 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: loaded library "security_plugin"
2022-10-09 10:45:14.203 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2022-10-09 10:45:14.209 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2022-10-09 10:45:14.210 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: reserved memory for backend threads is: 340 MB
2022-10-09 10:45:14.210 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: reserved memory for WAL buffers is: 320 MB
2022-10-09 10:45:14.210 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Set max backend reserve memory is: 660 MB, max dynamic memory is: 4305 MB
2022-10-09 10:45:14.210 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: shared memory 4250 Mbytes, memory context 4965 Mbytes, max process memory 10240 Mbytes
2022-10-09 10:45:15.027 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [CACHE] LOG: set data cache size(805306368)
2022-10-09 10:45:15.117 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [CACHE] LOG: set metadata cache size(268435456)
2022-10-09 10:45:15.926 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: mogdb: fsync file "/data/mogdb/data/db1/gaussdb.state.temp" success
2022-10-09 10:45:15.926 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Normal)
2022-10-09 10:45:15.961 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: max_safe_fds = 979, usable_fds = 1000, already_open = 11
bbox_dump_path is set to /data/mogdb/corefile/
2022-10-09 10:45:15.969 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: the configure file /data/mogdb/app/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user!
2022-10-09 10:45:15.969 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Failed to parse cgroup config file.
.[2022-10-09 10:45:22.030][530][][gs_ctl]: gaussDB state is Coredump
[2022-10-09 10:45:22.031][530][][gs_ctl]: stopped waiting
[2022-10-09 10:45:22.031][530][][gs_ctl]: could not start server
Examine the log output.
[GAUSS-51607] : Failed to start instance. Error: Please check the gs_ctl log for failure details.
[2022-10-09 10:45:13.297][530][][gs_ctl]: gs_ctl started,datadir is /data/mogdb/data/db1
[2022-10-09 10:45:13.612][530][][gs_ctl]: waiting for server to start...
.0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
0 LOG: [Alarm Module]Host Name: node1
0 LOG: [Alarm Module]Host IP: 192.168.55.79
0 LOG: [Alarm Module]Cluster Name: dbCluster
0 LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 52
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: SSE4.2 is not supported, disable codegen.
0 WARNING: bbox_dump_path is set to /data/mogdb/corefile/
2022-10-09 10:45:14.191 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 DB010 0 [REDO] LOG: Recovery parallelism, cpu count = 8, max = 4, actual = 4
2022-10-09 10:45:14.191 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 DB010 0 [REDO] LOG: ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4
2022-10-09 10:45:14.191 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
2022-10-09 10:45:14.191 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Host Name: node1
2022-10-09 10:45:14.191 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Host IP: 192.168.55.79
2022-10-09 10:45:14.191 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Cluster Name: dbCluster
2022-10-09 10:45:14.192 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 52
2022-10-09 10:45:14.192 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Transparent encryption disabled.
2022-10-09 10:45:14.200 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: loaded library "security_plugin"
2022-10-09 10:45:14.203 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2022-10-09 10:45:14.209 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2022-10-09 10:45:14.210 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: reserved memory for backend threads is: 340 MB
2022-10-09 10:45:14.210 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: reserved memory for WAL buffers is: 320 MB
2022-10-09 10:45:14.210 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Set max backend reserve memory is: 660 MB, max dynamic memory is: 4305 MB
2022-10-09 10:45:14.210 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: shared memory 4250 Mbytes, memory context 4965 Mbytes, max process memory 10240 Mbytes
2022-10-09 10:45:15.027 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [CACHE] LOG: set data cache size(805306368)
2022-10-09 10:45:15.117 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [CACHE] LOG: set metadata cache size(268435456)
2022-10-09 10:45:15.926 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: mogdb: fsync file "/data/mogdb/data/db1/gaussdb.state.temp" success
2022-10-09 10:45:15.926 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Normal)
2022-10-09 10:45:15.961 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: max_safe_fds = 979, usable_fds = 1000, already_open = 11
bbox_dump_path is set to /data/mogdb/corefile/
2022-10-09 10:45:15.969 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: the configure file /data/mogdb/app/etc/gscgroup_omm.cfg doesn't exist or the size of configure file has changed. Please create it by root user!
2022-10-09 10:45:15.969 634235b9.1 [unknown] 140636577056512 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Failed to parse cgroup config file.
.[2022-10-09 10:45:22.030][530][][gs_ctl]: gaussDB state is Coredump
[2022-10-09 10:45:22.031][530][][gs_ctl]: stopped waiting
[2022-10-09 10:45:22.031][530][][gs_ctl]: could not start server
Examine the log output.
复制
我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
回答交流
Markdown
请输入正文
提交
相关推荐
gs_ctl 建立一主一备关系时有警告信息,能够建立成功。但断电重启后备库启动失败
回答 3
无法读取和解析控制文件,应该是损害,重新部署恢复
MogDB 慢sql没有记录到STATEMENT_HISTORY表中,日志文件中也未收集
回答 3
已采纳
enableresourcetrack这个参数是不是off了?
mogdb配置Oracle的dblink如何实现
回答 1
pg一般是用FDW来实现dblink功能。
MogHA 中的node.conf 支持IPv6配置吗?
回答 3
已采纳
您好,ipv6目前可能还不支持,我给开发人员反馈一下这个需求。
缺少指令集umi2 怎么办?ptk方式安装无法进行
回答 1
https://blog.csdn.net/weixin39198406/article/details/119515531手动添加umi能否解决呢,试过么
Mogdb 3.0 docker run 很慢,整个过程要15分钟
回答 6
已采纳
我用你的这条dockerrun命令测的时间,creatingtemplate1到gsctlstart只需要10秒,应该与特定的环境有关creatingtemplate1databasein/var/l
opengauss3.1.0 做数据库主备,能指定数据库吗?
回答 2
已采纳
主备存在的意义就是要让主备数据完全一致,当主库发生故障时备库可以接管服务。同步单个数据库或者表是类似“OGG”的功能,目前是两个实例也就是两个不同的单节点数据库来通过发布订阅功能进行同步。
在UOS-20系统的虚拟机上以ptk的方式安装MogDB报错 请大佬指教
回答 2
暂无文字回复
MogDB3.0.1的手动安装主备集群与标准安装的主备集群有什么不同吗,为什么手动安装的主备无法执行gs-om 命令呢
回答 3
gsom是可以单独安装配置的,但操作有点麻烦。建议使用PTK部署,会帮你把gsom也装好的
mogdb select RATIO_TO_REPORT ERROR: compressed data is corrupt
回答 1
临时将RATIOTOREPORT改成了CONNECTCOUNT/SUM(CONNECTCOUNT)OVER()规避了这个bugSELECTHOSTIP,CONNECTCOUNT,ROUND(100CO