一、环境准备
1、操作系统与数据库版本
此次安装使用oracle linux8.6，数据库版本安装包选择3.0对应操作系统euler22.10版本(PanWeiDB_V2.0-S3.0.1_B01-install-bclinux_euler22.10-x86_64-no_mot.tar.gz)
选择较高版本操纵系统可以方便后续学习
[root@ol8601 ~]# cat /etc/os-release NAME="Oracle Linux Server" VERSION="8.6" ID="ol" ID_LIKE="fedora" VARIANT="Server" VARIANT_ID="server" VERSION_ID="8.6" PLATFORM_ID="platform:el8" PRETTY_NAME="Oracle Linux Server 8.6" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:oracle:linux:8:6:server" HOME_URL="https://linux.oracle.com/" BUG_REPORT_URL="https://bugzilla.oracle.com/" ORACLE_BUGZILLA_PRODUCT="Oracle Linux 8" ORACLE_BUGZILLA_PRODUCT_VERSION=8.6 ORACLE_SUPPORT_PRODUCT="Oracle Linux" ORACLE_SUPPORT_PRODUCT_VERSION=8.6复制
2、依赖包安装
[root@ol8601 ~]# yum install -y zlib-devel libaio libuuid readline-devel krb5-libs libicu libxslt tcl perl openldap pam openssl-devel libxml2 bzip2 上次元数据过期检查：8:19:35 前，执行于 2025年04月05日 星期六 17时04分13秒。 软件包 zlib-devel-1.2.11-25.el8.x86_64 已安装。 软件包 libaio-0.3.112-1.el8.x86_64 已安装。 软件包 libuuid-2.32.1-46.0.1.el8.x86_64 已安装。 软件包 readline-devel-7.0-10.el8.x86_64 已安装。 软件包 krb5-libs-1.18.2-31.0.1.el8_10.x86_64 已安装。 软件包 libicu-60.3-2.el8_1.x86_64 已安装。 软件包 libxslt-1.1.32-6.0.1.el8.x86_64 已安装。 软件包 tcl-1:8.6.8-2.el8.x86_64 已安装。 软件包 perl-4:5.26.3-422.el8.x86_64 已安装。 软件包 openldap-2.4.46-21.el8_10.x86_64 已安装。 软件包 pam-1.3.1-36.0.1.el8_10.x86_64 已安装。 软件包 openssl-devel-1:1.1.1k-14.el8_6.x86_64 已安装。 软件包 libxml2-2.9.7-19.el8_10.x86_64 已安装。 软件包 bzip2-1.0.6-28.el8_10.x86_64 已安装。 依赖关系解决。 无需任何处理。 完毕！复制
3、设置资源限制
[root@ol8601 ~]# cat /etc/security/limits.conf # End of file omm soft nproc unlimited omm hard nproc unlimited omm soft stack unlimited omm hard stack unlimited omm soft core unlimited omm hard core unlimited omm soft memlock unlimited omm hard memlock unlimited omm soft nofile 10240000 omm hard nofile 10240000复制
这些参数根据虚拟机实际能力配置，文件数量限制此处过大，后面导致无法su - omm切换用户
4、设置主机名与Hosts文件
这个地方不设置也行，后续预安装也会添加
[root@ol8601 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 172.16.220.100 ol8601 172.16.220.101 ol8602复制
二、预安装数据库
1、上传并解压安装包
[root@ol8601 ~]# chown omm:omm /soft -R复制
[root@ol8601 soft]# su - omm su: 无法打开会话：拒绝权限复制
无法切换用户，检查安全日志
[root@ol8601 home]# tail /var/log/secure Apr 6 01:45:39 ol8601 useradd[3798]: new user: name=omm, UID=1101, GID=1101, home=/home/omm, shell=/bin/bash Apr 6 01:45:46 ol8601 passwd[3813]: pam_unix(passwd:chauthtok): password changed for omm Apr 6 01:45:46 ol8601 passwd[3813]: gkr-pam: couldn't update the login keyring password: no old password was entered Apr 6 01:45:51 ol8601 su[3819]: pam_limits(su-l:session): Could not set limit for 'nofile': 不允许的操作 Apr 6 01:45:51 ol8601 su[3819]: pam_unix(su-l:session): session opened for user omm by root(uid=0) Apr 6 01:47:18 ol8601 su[3847]: pam_limits(su-l:session): Could not set limit for 'nofile': 不允许的操作 Apr 6 01:47:18 ol8601 su[3847]: pam_unix(su-l:session): session opened for user omm by root(uid=0) Apr 6 01:47:24 ol8601 sudo[3850]: root : TTY=pts/0 ; PWD=/home ; USER=root ; COMMAND=list Apr 6 01:50:45 ol8601 su[3965]: pam_unix(su-l:session): session opened for user omm by root(uid=0) Apr 6 01:52:00 ol8601 su[3965]: pam_unix(su-l:session): session closed for user omm复制
检查日志发现无法设置nofile，删除/etc/security/limits.conf 设置即可，实际上是nofile设置太大
[omm@ol8601 soft]$ tar -zxvf PanWeiDB_V2.0-S3.0.1_B01-install-bclinux_euler22.10-x86_64-no_mot.tar.gz 4 drwxr-xr-x 5 omm omm 4096 4月 6 03:51 . 0 drwxr-xr-x 3 omm omm 97 4月 6 03:33 .. 8 -rwxr-xr-x 1 omm omm 8184 10月 1 2024 checkcpucycle 4 -rw-rw-r-- 1 omm omm 8 10月 1 2024 CM_VERSION 4 drwxrwxr-x 16 omm omm 4096 4月 6 03:34 lib 0 drwxr-xr-x 9 omm omm 111 4月 6 03:52 libcgroup 4 -rwx------ 1 omm omm 65 4月 6 03:38 PanWeiDB-2.0.UNKNOWN-openEuler-64bit.sha256 239480 -rwx------ 1 omm omm 245226147 4月 6 03:37 PanWeiDB-2.0.UNKNOWN-openEuler-64bit.tar.bz2 251244 -rwx------ 1 omm omm 257273019 4月 6 03:51 PanWeiDB-Package-bak_d086caf.tar.gz 6988 -rwx------ 1 omm omm 7155689 10月 1 2024 PanWeiDB_V2.0-S3.0.1_B01-linux-64bit-cm.tar.gz 4 -rwx------ 1 omm omm 65 10月 1 2024 PanWeiDB_V2.0-S3.0.1_B01-linux-64bit-om.sha256 11728 -rwx------ 1 omm omm 12006790 10月 1 2024 PanWeiDB_V2.0-S3.0.1_B01-linux-64bit-om.tar.gz 4 -rwx------ 1 omm omm 65 10月 1 2024 PanWeiDB_V2.0-S3.0.1_B01-linux-64bit-pwpatch.sha256 401240 -rwx------ 1 omm omm 410869132 10月 1 2024 PanWeiDB_V2.0-S3.0.1_B01-linux-64bit-pwpatch.tar.gz 4 -rwx------ 1 omm omm 65 10月 1 2024 PanWeiDB_V2.0-S3.0.1_B01-linux-64bit.sha256 239480 -rwx------ 1 omm omm 245226147 10月 1 2024 PanWeiDB_V2.0-S3.0.1_B01-linux-64bit.tar.bz2 4 drwx------ 11 omm omm 4096 4月 6 03:51 script 22164 -rwx------ 1 omm omm 22695601 10月 1 2024 Symbols.tar.gz 4 -rwx------ 1 omm omm 65 10月 1 2024 upgrade_sql.sha256 644 -rwx------ 1 omm omm 655655 10月 1 2024 upgrade_sql.tar.gz 4 -rwx------ 1 omm omm 40 9月 29 2024 version.cfg复制
2、配置XML文件
创建 cluster_config.xml，包含以下关键配置：
<?xml version="1.0" encoding="utf-8"?> <ROOT> <CLUSTER> <PARAM name="clusterName" value="panweidb" /> <PARAM name="nodeNames" value="ol8601"/> <PARAM name="gaussdbAppPath" value="/database/panweidb/app" /> <PARAM name="gaussdbLogPath" value="/database/panweidb/log" /> <PARAM name="tmpMppdbPath" value="/database/panweidb/tmp"/> <PARAM name="gaussdbToolPath" value="/database/panweidb/tool" /> <PARAM name="corePath" value="/database/panweidb/corefile"/> <PARAM name="backIp1s" value="172.16.220.100"/> </CLUSTER> <DEVICELIST> <DEVICE sn="ol8601"> <PARAM name="name" value="ol8601"/> <PARAM name="azName" value="AZ1"/> <PARAM name="azPriority" value="1"/> <PARAM name="backIp1" value="172.16.220.100"/> <PARAM name="sshIp1" value="172.16.220.100"/> <PARAM name="dataNum" value="1"/> <PARAM name="dataPortBase" value="17700"/> <PARAM name="dataNode1" value="/database/panweidb/data"/> </DEVICE> </DEVICELIST> </ROOT>复制
3、预安装环境配置
预安装使用root用户，因为可能会创建目录、检查操作系统参数。同时也将各种配置任务直接交给xml配置文件，省去很多人工配置
[root@ol8601 script]$ ./gs_preinstall -U omm -G omm -X /opt/panweidb/cluster_config.xml Traceback (most recent call last): File "/soft/script/os_platform/rhel_platform.py", line 198, in getCurrentPlatForm dist_name.lower(), version[0:3])) Exception: [GAUSS-51900] : The current OS is not supported. The current system is: redhat8.6 During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/soft/script/os_platform/UserPlatform.py", line 64, in __init__ self.userPlatform.getCurrentPlatForm() File "/soft/script/os_platform/rhel_platform.py", line 200, in getCurrentPlatForm raise Exception(str(e)) Exception: [GAUSS-51900] : The current OS is not supported. The current system is: redhat8.6 During handling of the above exception, another exception occurred: Traceback (most recent call last): File "./gs_preinstall", line 57, in <module> from gspylib.common.Common import DefaultValue File "/soft/script/gspylib/common/Common.py", line 104, in <module> from os_platform.UserPlatform import g_Platform File "/soft/script/os_platform/UserPlatform.py", line 69, in <module> g_Platform = UserPlatform().userPlatform File "/soft/script/os_platform/UserPlatform.py", line 66, in __init__ raise Exception(str(excep)) Exception: [GAUSS-51900] : The current OS is not supported. The current system is: redhat8.6复制
操作系统不兼容
修改/soft/script/os_platform/common.py 在SUPPORT_RHEL7X_VERSION_LIST列表中加入“8.6”即可
# RedhatX platform SUPPORT_RHEL_SERIES_PLATFORM_LIST = [REDHAT, CENTOS, "kylin", "asianux"] SUPPORT_RHEL6X_VERSION_LIST = ["6.4", "6.5", "6.6", "6.7", "6.8", "6.9", "10"] SUPPORT_RHEL7X_VERSION_LIST = ["7.0", "7.1", "7.2", "7.3", "7.4", "7.5", "7.6", "7.7", "7.8", "7.9", "10"] SUPPORT_RHEL8X_VERSION_LIST = ["8.0", "8.1", "8.2", "8.3", "8.4", "8.5" ,"8.6"]复制
[root@ol8601 script]$ ./gs_preinstall -U omm -G omm -X cluster_config.xml Parsing the configuration file. Successfully parsed the configuration file. Installing the tools on the local node. [GAUSS-50201] : The /soft/tar/script/os_platform/./../../PanWeiDB-2.0.UNKNOWN-openEuler-64bit.tar.bz2 does not exist.复制
无法识别安装包文件，那就按照他要求的给造一下，哄骗过去即可
[root@ol8601 tar]$ cp PanWeiDB_V2.0-S3.0.1_B01-linux-64bit.tar.bz2 PanWeiDB-2.0.UNKNOWN-openEuler-64bit.tar.bz2 [root@ol8601 tar]$ cp PanWeiDB_V2.0-S3.0.1_B01-linux-64bit.sha256 PanWeiDB-2.0.UNKNOWN-openEuler-64bit.sha256复制
[root@ol8601 script]# ./gs_preinstall -U omm -G omm -X cluster_config.xml Parsing the configuration file. Successfully parsed the configuration file. Installing the tools on the local node. Successfully installed the tools on the local node. Setting host ip env Successfully set host ip env. Are you sure you want to create the user[omm] (yes/no)? yes Preparing SSH service. Successfully prepared SSH service. Checking OS software. Successfully check os software. Checking OS version. Successfully checked OS version. Creating cluster's path. Successfully created cluster's path. Set and check OS parameter. Setting OS parameters. Successfully set OS parameters. Warning: Installation environment contains some warning messages. Please get more details by "/soft/tar/script/gs_checkos -i A -h ol8601 -X /soft/tar/script/cluster_config.xml --detail". Set and check OS parameter completed. Preparing CRON service. Successfully prepared CRON service. Setting user environmental variables. Successfully set user environmental variables. Setting the dynamic link library. Successfully set the dynamic link library. Setting Core file Successfully set core path. Setting pssh path Successfully set pssh path. Setting Cgroup. Successfully set Cgroup. Set ARM Optimization. No need to set ARM Optimization. Fixing server package owner. Setting finish flag. Successfully set finish flag. Preinstallation succeeded.复制
预安装过程完成
5、执行数据库安装
su - omm [omm@ol8601 script]$ ./gs_install -X cluster_config.xml Parsing the configuration file. Successfully checked gs_uninstall on every node. 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 /database/panweidb/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. Warning: The license file does not exist, so there is no need to copy it to the home directory. Configuring pg_hba on all nodes. Configuration is completed. Using omm:omm to install database. Using installation program path : /database/panweidb/app_d086caf $GAUSSHOME points to /database/panweidb/app_d086caf, no need to create symbolic link. Traceback (most recent call last): File "/database/panweidb/tool/script/local/Install.py", line 816, in <module> functionDict[g_opts.action]() File "/database/panweidb/tool/script/local/Install.py", line 747, in startCluster dn.start(self.time_out) File "/database/panweidb/tool/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. [2025-04-06 03:56:04.989][24004][][gs_ctl]: gs_ctl started,数据目录是 /database/panweidb/data [2025-04-06 03:56:05.127][24004][][gs_ctl]: 等待服务端进程启动 ... 。0 日志: [Alarm Module]无法读取环境变量GAUSS_WARNING_TYPE。 0 日志: [Alarm Module]主机名：ol8601 0 日志: [Alarm Module]主机IP: ol8601. 直接拷贝主机名以防当/etc/hosts中不包含<HOST IP>时花费10秒来调用'gethostbyname' 0 日志: [Alarm Module]集群名称：panweidb 0 日志: [Alarm Module]在AlarmItem文件中有无效数据！读取告警英文名称失败！行：57 0 警告: 未能打开特性控制文件，请检查它是否存在:FileName=gaussdb.version, Errno=2, Errmessage=没有那个文件或目录。 0 警告: 未能解析特性控制文件: gaussdb.version 0 警告: 未能加载产品控制文件，因此gaussdb无法区分产品版本。 0 [BACKEND] 日志: the config file /database/panweidb/data/postgresql.conf verify start. 2025-04-06 03:56:05.569 67f18ad5.10000 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: the config file /database/panweidb/data/postgresql.conf verify success. 2025-04-06 03:56:05.571 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 01000 0 [BACKEND] 警告: 加载许可证时发生错误, 错误码: 2, 错误信息: 无法向如下目录写入内容 /etc/panweidb/license 2025-04-06 03:56:05.571 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: base_page_saved_interval is 400, ori is 400。 2025-04-06 03:56:05.571 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 DB010 0 [REDO] 日志: 恢复并行，cpu计数=2，最大=4，实际=2 2025-04-06 03:56:05.571 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 DB010 0 [REDO] 日志: ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4 gaussdb.state不存在，并且跳过设置，因为它是可选的。2025-04-06 03:56:05.587 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: [Alarm Module]无法读取环境变量GAUSS_WARNING_TYPE。 2025-04-06 03:56:05.587 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: [Alarm Module]主机名：ol8601 2025-04-06 03:56:05.587 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: [Alarm Module]主机IP: ol8601. 直接拷贝主机名以防当/etc/hosts中不包含<HOST IP>时花费10秒来调用'gethostbyname' 2025-04-06 03:56:05.587 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: [Alarm Module]集群名称：panweidb 2025-04-06 03:56:05.587 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: [Alarm Module]在AlarmItem文件中有无效数据！读取告警英文名称失败！行：57 2025-04-06 03:56:05.591 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: 已加载的库 "security_plugin" 2025-04-06 03:56:05.593 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 01000 0 [BACKEND] 警告: 无法创建任何HA TCP/IP套接字 2025-04-06 03:56:05.593 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 01000 0 [BACKEND] 警告: 无法创建任何HA TCP/IP套接字 2025-04-06 03:56:05.595 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0. 2025-04-06 03:56:05.597 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: 为后台线程保留的内存为: 340 MB 2025-04-06 03:56:05.597 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: 为WAL缓冲区保留的内存为: 320 MB 2025-04-06 03:56:05.597 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: 设置最大后端预留内存是：660 MB，max_dynamic_memory是：809 MB 2025-04-06 03:56:05.597 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 42809 0 [BACKEND] 致命错误: 内存的值超出限制，数据库未能启动，max_process_memory(6144MB) 必须设置大于 2GB + cstore_buffers(512MB) + (udf_memory_limit(200MB) - UDF_DEFAULT_MEMORY(200MB)) + shared_buffers(1024MB) + preserved memory(3798MB) = 7382MB, 减小 shared_buffers, max_pred_locks_per_transaction, max_connection, wal_buffers等参数的值可以帮助减小preserved memory的大小 2025-04-06 03:56:05.803 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: FiniNuma allocIndex: 0. [2025-04-06 03:56:06.140][24004][][gs_ctl]: waitpid 24007 失败, 退出状态为 256, 结果为 2 [2025-04-06 03:56:06.140][24004][][gs_ctl]: 已停止等待 [2025-04-06 03:56:06.140][24004][][gs_ctl]: 无法开启服务器 检查日志输出。 [GAUSS-51607] : Failed to start instance. Error: Please check the gs_ctl log for failure details. [2025-04-06 03:56:04.989][24004][][gs_ctl]: gs_ctl started,数据目录是 /database/panweidb/data [2025-04-06 03:56:05.127][24004][][gs_ctl]: 等待服务端进程启动 ... 。0 日志: [Alarm Module]无法读取环境变量GAUSS_WARNING_TYPE。 0 日志: [Alarm Module]主机名：ol8601 0 日志: [Alarm Module]主机IP: ol8601. 直接拷贝主机名以防当/etc/hosts中不包含<HOST IP>时花费10秒来调用'gethostbyname' 0 日志: [Alarm Module]集群名称：panweidb 0 日志: [Alarm Module]在AlarmItem文件中有无效数据！读取告警英文名称失败！行：57 0 警告: 未能打开特性控制文件，请检查它是否存在:FileName=gaussdb.version, Errno=2, Errmessage=没有那个文件或目录。 0 警告: 未能解析特性控制文件: gaussdb.version 0 警告: 未能加载产品控制文件，因此gaussdb无法区分产品版本。 0 [BACKEND] 日志: the config file /database/panweidb/data/postgresql.conf verify start. 2025-04-06 03:56:05.569 67f18ad5.10000 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: the config file /database/panweidb/data/postgresql.conf verify success. 2025-04-06 03:56:05.571 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 01000 0 [BACKEND] 警告: 加载许可证时发生错误, 错误码: 2, 错误信息: 无法向如下目录写入内容 /etc/panweidb/license 2025-04-06 03:56:05.571 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: base_page_saved_interval is 400, ori is 400。 2025-04-06 03:56:05.571 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 DB010 0 [REDO] 日志: 恢复并行，cpu计数=2，最大=4，实际=2 2025-04-06 03:56:05.571 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 DB010 0 [REDO] 日志: ConfigRecoveryParallelism, true_max_recovery_parallelism:4, max_recovery_parallelism:4 gaussdb.state不存在，并且跳过设置，因为它是可选的。2025-04-06 03:56:05.587 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: [Alarm Module]无法读取环境变量GAUSS_WARNING_TYPE。 2025-04-06 03:56:05.587 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: [Alarm Module]主机名：ol8601 2025-04-06 03:56:05.587 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: [Alarm Module]主机IP: ol8601. 直接拷贝主机名以防当/etc/hosts中不包含<HOST IP>时花费10秒来调用'gethostbyname' 2025-04-06 03:56:05.587 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: [Alarm Module]集群名称：panweidb 2025-04-06 03:56:05.587 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: [Alarm Module]在AlarmItem文件中有无效数据！读取告警英文名称失败！行：57 2025-04-06 03:56:05.591 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: 已加载的库 "security_plugin" 2025-04-06 03:56:05.593 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 01000 0 [BACKEND] 警告: 无法创建任何HA TCP/IP套接字 2025-04-06 03:56:05.593 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 01000 0 [BACKEND] 警告: 无法创建任何HA TCP/IP套接字 2025-04-06 03:56:05.595 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0. 2025-04-06 03:56:05.597 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: 为后台线程保留的内存为: 340 MB 2025-04-06 03:56:05.597 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: 为WAL缓冲区保留的内存为: 320 MB 2025-04-06 03:56:05.597 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: 设置最大后端预留内存是：660 MB，max_dynamic_memory是：809 MB 2025-04-06 03:56:05.597 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 42809 0 [BACKEND] 致命错误: 内存的值超出限制，数据库未能启动，max_process_memory(6144MB) 必须设置大于 2GB + cstore_buffers(512MB) + (udf_memory_limit(200MB) - UDF_DEFAULT_MEMORY(200MB)) + shared_buffers(1024MB) + preserved memory(3798MB) = 7382MB, 减小 shared_buffers, max_pred_locks_per_transaction, max_connection, wal_buffers等参数的值可以帮助减小preserved memory的大小 2025-04-06 03:56:05.803 67f18ad5.1 [unknown] 140552677028672 [unknown] 0 dn_6001 00000 0 [BACKEND] 日志: FiniNuma allocIndex: 0. [2025-04-06 03:56:06.140][24004][][gs_ctl]: waitpid 24007 失败, 退出状态为 256, 结果为 2 [2025-04-06 03:56:06.140][24004][][gs_ctl]: 已停止等待 [2025-04-06 03:56:06.140][24004][][gs_ctl]: 无法开启服务器 检查日志输出。复制
安装完成但是没能启动，原因是虚拟机内存不足，尔默认数据库配置文件中有些参数设置很大导致，可以修改提示中说的cstore_buffers、shared_buffers、max_connection、max_connection参数，同时保证max_process_memory大于2GB + cstore_buffers(512MB) + (udf_memory_limit(200MB) - UDF_DEFAULT_MEMORY(200MB)) + shared_buffers(1024MB) + preserved memory(3798MB)之和即可。修改完成后数据库成功启动
[root@ol8601 ~]# su - omm [omm@ol8601 ~]$ gsql -r gsql ((PanWeiDB_V2.0-S3.0.1_B01) compiled at 2024-09-29 20:26:30 commit d086caf ) 非SSL连接（安全性要求高时，建议使用SSL连接） 输入 "help" 来获取帮助信息。 postgres=#复制
最后修改时间：2025-04-05 22:44:12
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
评论
目录
