opengauss数据库初始化报错：
[GAUSS-51607] : Failed to start instance. Error: Please check the gs_ctl log for failure details.
SSE4.2 is not supported, disable codegen.
[omm@hostname ~]$ ${PG_INSTALL}/script/gs_install -X ${PG_INSTALL}/cluster_config.xml
Parsing the configuration file.
Check preinstall on every node.
Successfully checked preinstall on every node.
Creating the backup directory.
Successfully created the backup directory.
begin deploy..
Installing the cluster.
begin prepare Install Cluster..
Checking the installation environment on all nodes.
begin install Cluster..
Installing applications on all nodes.
Successfully installed APP.
begin init Instance..
encrypt cipher and rand files for database.
Please enter password for database:
Please repeat for database:
begin to create CA cert files
The sslcert will be generated in /opt/huawei/install/app/share/sslcert/om
NO cm_server instance, no need to create CA for CM.
Non-dss_ssl_enable, no need to create CA for DSS
Cluster installation is completed.
Configuring.
Deleting instances from all nodes.
Successfully deleted instances from all nodes.
Checking node configuration on all nodes.
Initializing instances on all nodes.
Updating instance configuration on all nodes.
Check consistence of memCheck and coresCheck on database nodes.
Configuring pg_hba on all nodes.
Configuration is completed.
Using omm:dbgrp to install database.
Using installation program path : /opt/huawei/install/app_a07d57c3
$GAUSSHOME points to /opt/huawei/install/app_a07d57c3, no need to create symbolic link.
Traceback (most recent call last):
File "/opt/huawei/install/om/script/local/Install.py", line 812, in
functionDict[g_opts.action]()
File "/opt/huawei/install/om/script/local/Install.py", line 743, in startCluster
dn.start(self.time_out)
File "/opt/huawei/install/om/script/local/../gspylib/component/Kernel/Kernel.py", line 106, in start
"failure details." + "\n" + output)
Exception: [GAUSS-51607] : Failed to start instance. Error: Please check the gs_ctl log for failure details.
[2024-02-22 16:20:22.156][74570][][gs_ctl]: gs_ctl started,datadir is /data/huawei/pgdata
[2024-02-22 16:20:22.205][74570][][gs_ctl]: waiting for server to start...
.0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
0 LOG: [Alarm Module]Host Name: hostname
0 LOG: [Alarm Module]Host IP: hostname. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain
0 LOG: [Alarm Module]Cluster Name: obsdb
0 LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 58
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 LOG: bbox_dump_path is set to /opt/huawei/corefile/
2024-02-22 16:20:22.303 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 DB010 0 [REDO] LOG: Recovery parallelism, cpu count = 8, max = 4, actual = 4
2024-02-22 16:20:22.303 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 DB010 0 [REDO] LOG: ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4
gaussdb.state does not exist, and skipt setting since it is optional.2024-02-22 16:20:22.309 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
2024-02-22 16:20:22.309 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Host Name: hostname
2024-02-22 16:20:22.309 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Host IP: hostname. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain
2024-02-22 16:20:22.309 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Cluster Name: obsdb
2024-02-22 16:20:22.310 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 58
2024-02-22 16:20:22.312 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: loaded library "security_plugin"
2024-02-22 16:20:22.314 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2024-02-22 16:20:22.314 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2024-02-22 16:20:22.318 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2024-02-22 16:20:22.318 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: reserved memory for backend threads is: 340 MB
2024-02-22 16:20:22.318 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: reserved memory for WAL buffers is: 320 MB
2024-02-22 16:20:22.318 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Set max backend reserve memory is: 660 MB, max dynamic memory is: 4085 MB
2024-02-22 16:20:22.318 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: shared memory 4470 Mbytes, memory context 4745 Mbytes, max process memory 10240 Mbytes
2024-02-22 16:20:22.318 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: shared memory that key is 26000001 is owned by pid 67897
2024-02-22 16:20:22.478 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [CACHE] LOG: set data cache size(805306368)
2024-02-22 16:20:22.938 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 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
2024-02-22 16:20:23.006 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: gaussdb: fsync file "/data/huawei/pgdata/gaussdb.state.temp" success
2024-02-22 16:20:23.006 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1)
2024-02-22 16:20:23.031 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: max_safe_fds = 974, usable_fds = 1000, already_open = 16
bbox_dump_path is set to /opt/huawei/corefile/
2024-02-22 16:20:23.033 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: user configure file is not found, it will be created.
[2024-02-22 16:20:28.212][74570][][gs_ctl]: gaussDB state is Coredump
[2024-02-22 16:20:28.212][74570][][gs_ctl]: stopped waiting
[2024-02-22 16:20:28.212][74570][][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.
[2024-02-22 16:20:22.156][74570][][gs_ctl]: gs_ctl started,datadir is /data/huawei/pgdata
[2024-02-22 16:20:22.205][74570][][gs_ctl]: waiting for server to start...
.0 LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
0 LOG: [Alarm Module]Host Name: hostname
0 LOG: [Alarm Module]Host IP: hostname. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain
0 LOG: [Alarm Module]Cluster Name: obsdb
0 LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 58
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 LOG: bbox_dump_path is set to /opt/huawei/corefile/
2024-02-22 16:20:22.303 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 DB010 0 [REDO] LOG: Recovery parallelism, cpu count = 8, max = 4, actual = 4
2024-02-22 16:20:22.303 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 DB010 0 [REDO] LOG: ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4
gaussdb.state does not exist, and skipt setting since it is optional.2024-02-22 16:20:22.309 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]can not read GAUSS_WARNING_TYPE env.
2024-02-22 16:20:22.309 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Host Name: hostname
2024-02-22 16:20:22.309 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Host IP: hostname. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain
2024-02-22 16:20:22.309 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Cluster Name: obsdb
2024-02-22 16:20:22.310 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 58
2024-02-22 16:20:22.312 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: loaded library "security_plugin"
2024-02-22 16:20:22.314 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2024-02-22 16:20:22.314 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2024-02-22 16:20:22.318 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2024-02-22 16:20:22.318 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: reserved memory for backend threads is: 340 MB
2024-02-22 16:20:22.318 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: reserved memory for WAL buffers is: 320 MB
2024-02-22 16:20:22.318 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: Set max backend reserve memory is: 660 MB, max dynamic memory is: 4085 MB
2024-02-22 16:20:22.318 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: shared memory 4470 Mbytes, memory context 4745 Mbytes, max process memory 10240 Mbytes
2024-02-22 16:20:22.318 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: shared memory that key is 26000001 is owned by pid 67897
2024-02-22 16:20:22.478 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [CACHE] LOG: set data cache size(805306368)
2024-02-22 16:20:22.938 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 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
2024-02-22 16:20:23.006 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: gaussdb: fsync file "/data/huawei/pgdata/gaussdb.state.temp" success
2024-02-22 16:20:23.006 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1)
2024-02-22 16:20:23.031 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: max_safe_fds = 974, usable_fds = 1000, already_open = 16
bbox_dump_path is set to /opt/huawei/corefile/
2024-02-22 16:20:23.033 65d703c6.1 [unknown] 139631325077760 [unknown] 0 dn_6001 00000 0 [BACKEND] LOG: user configure file is not found, it will be created.
[2024-02-22 16:20:28.212][74570][][gs_ctl]: gaussDB state is Coredump
[2024-02-22 16:20:28.212][74570][][gs_ctl]: stopped waiting
[2024-02-22 16:20:28.212][74570][][gs_ctl]: could not start server
Examine the log output.
问题原因：缺少CPU指令集
云平台虚拟机(ECS)不支持opengauss需要的CPU指令集，运营商调整虚拟机的CPU模式为直通模式之后成功部署
[omm@hostname ~]$ lscpu
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 8
On-line CPU(s) list: 0-7
Thread(s) per core: 1
Core(s) per socket: 8
座： 1
NUMA 节点： 1
厂商 ID： GenuineIntel
CPU 系列： 15
型号： 6
型号名称： Intel(R) Xeon(R) Gold 5218 CPU @ 2.30GHz
步进： 3
CPU MHz： 2294.592
BogoMIPS： 4589.18
超管理器厂商： KVM
虚拟化类型： 完全
L1d 缓存： 32K
L1i 缓存： 32K
L2 缓存： 4096K
L3 缓存： 16384K
NUMA 节点0 CPU： 0-7
Flags: fpu de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx lm constant_tsc nopl xtopology eagerfpu pni cx16 x2apic hypervisor lahf_lm
[omm@hostname ~]$
