安装华为GaussDB 100 报错GS-00001 : Failed to allocate 4592381952 bytes for sga

安装华为GaussDB 100执行python install.py报错instance startup failed
详细如下：

[2019-10-16 10:06:58] Successfully Initialize zenith instance.
[2019-10-16 10:06:58] Creating database.
[2019-10-16 10:07:02] Instance start log output:starting instance(nomount)
instance startup failed
.
[2019-10-16 10:07:02] Begin roll back...
[2019-10-16 10:07:02] Roll back type: 5
[2019-10-16 10:07:02] Using user profile: /home/omm/.bashrc
[2019-10-16 10:07:02] Begin to backup log cmd: cp -r /opt/gaussdb/data/log /opt/gaussdb/log
[2019-10-16 10:07:02] Error:The detail log for CREATE_DB_FAILED: /opt/gaussdb/log
[2019-10-16 10:07:02] kill process cmd: su - omm -c "proc_pid_list=\`ps ux | grep /opt/gaussdb/data$ | grep -v grep | awk '{print \$2}'\` && (if [ X\"\$proc_pid_list\" != X\"\" ]; then echo \"\$proc_pid_list\" | xargs kill -9 ; exit 0; fi)"
[2019-10-16 10:07:02] Roll back: process killed.
[2019-10-16 10:07:02] Roll back: remove /opt/gaussdb/app
[2019-10-16 10:07:02] Roll back: remove /opt/gaussdb/data
[2019-10-16 10:07:02] Begin clean user environment variables...
[2019-10-16 10:07:02] Begin gen regular string...
[2019-10-16 10:07:02] End gen regular string
[2019-10-16 10:07:02] Begin gen regular string...
[2019-10-16 10:07:02] End gen regular string
[2019-10-16 10:07:02] Begin gen regular string...
[2019-10-16 10:07:02] End gen regular string
[2019-10-16 10:07:02] Clean environment variables cmd: sed -i "/^\s*export\s*GSDB_DATA=.*$/d" "/home/omm/.bashrc"
[2019-10-16 10:07:02] Clean environment variables cmd: sed -i "/^\s*export\s*PATH=.*\/opt\/gaussdb\/app\/bin.*:\$PATH$/d" "/home/omm/.bashrc"
[2019-10-16 10:07:02] Clean environment variables cmd: sed -i "/^\s*export\s*LD_LIBRARY_PATH=.*\/opt\/gaussdb\/app\/lib.*:.*\/opt\/gaussdb\/app\/add-ons.*:\$LD_LIBRARY_PATH$/d" "/home/omm/.bashrc"
[2019-10-16 10:07:02] Clean environment variables cmd: sed -i "/^\s*export\s*GSDB_HOME=.*$/d" "/home/omm/.bashrc"
[2019-10-16 10:07:02] End clean user environment variables...
[2019-10-16 10:07:02] Roll back: profile is updated
[2019-10-16 10:07:02] End roll back
[2019-10-16 10:07:02] Error: Can not get instance '/opt/gaussdb/data' process pid,The detailed information: 'instance startup failed '

通过日志发现GS-00001 : Failed to allocate 4592381952 bytes for sga

[root@pr7 run]# cat zengine.rlog 
UTC+8 2019-10-16 10:06:59.035|ZENGINE|00000|77309415427|INFO>[LOG] file '/opt/gaussdb/data/log/zenith_alarm.log' is added [srv_param.c:488]
UTC+8 2019-10-16 10:06:59.035|ZENGINE|00000|4099|INFO>[LOG] file '/opt/gaussdb/data/log/run/zengine.rlog' is added [cm_log.c:643]
UTC+8 2019-10-16 10:06:59.042|ZENGINE|00000|4099|INFO>[PARAM] LSNR_ADDR            = 127.0.0.1,192.168.56.102
UTC+8 2019-10-16 10:06:59.042|ZENGINE|00000|4099|INFO>[PARAM] LSNR_PORT            = 1888
UTC+8 2019-10-16 10:06:59.042|ZENGINE|00000|4099|INFO>[PARAM] DATA_BUFFER_SIZE     = 2G
UTC+8 2019-10-16 10:06:59.042|ZENGINE|00000|4099|INFO>[PARAM] SHARED_POOL_SIZE     = 1G
UTC+8 2019-10-16 10:06:59.042|ZENGINE|00000|4099|INFO>[PARAM] LOG_BUFFER_SIZE      = 64M
UTC+8 2019-10-16 10:06:59.042|ZENGINE|00000|4099|INFO>[PARAM] LOG_BUFFER_COUNT     = 8
UTC+8 2019-10-16 10:06:59.042|ZENGINE|00000|4099|INFO>[PARAM] TEMP_BUFFER_SIZE     = 1G
UTC+8 2019-10-16 10:06:59.042|ZENGINE|00000|4099|INFO>[PARAM] SESSIONS             = 1500
UTC+8 2019-10-16 10:06:59.042|ZENGINE|00000|4099|INFO>[PARAM] DBWR_PROCESSES       = 8
UTC+8 2019-10-16 10:06:59.042|ZENGINE|00000|4099|INFO>[PARAM] INSTANCE_NAME        = zenith
UTC+8 2019-10-16 10:06:59.042|ZENGINE|00000|4099|INFO>[PARAM] ENABLE_SYSDBA_LOGIN  = TRUE
UTC+8 2019-10-16 10:06:59.042|ZENGINE|00000|206158434307|INFO>starting instance(nomount)
UTC+8 2019-10-16 10:06:59.042|ZENGINE|00000|4099|ERROR>GS-00001 : Failed to allocate 4592381952 bytes for sga [srv_sga.c:170]
UTC+8 2019-10-16 10:06:59.042|ZENGINE|00000|4099|ERROR>failed to create sga
UTC+8 2019-10-16 10:06:59.042|ZENGINE|00000|4099|ERROR>Instance Startup Failed
[root@pr7 run]# pwd
/opt/gaussdb/log/run

于是通过-c命令指定了几个关键内存大小。

-C DATA_BUFFER_SIZE=200M
-C SHARED_POOL_SIZE=100M
-C TEMP_BUFFER_SIZE=100M

详细的安装命令如下：

python install.py -U omm:dbgrp -R /opt/gaussdb/app -D /opt/gaussdb/data -C  LSNR_ADDR=127.0.0.1,192.168.56.102 -C LSNR_PORT=1888 -C DATA_BUFFER_SIZE=200M -C SHARED_POOL_SIZE=100M -C TEMP_BUFFER_SIZE=100M