【赵渝强老师】高斯数据库(openGauss)的服务器日志文件

简介: 本文详解openGauss数据库集群初始化后的物理存储结构,并重点介绍如何使用`gs_ctl -l`指定日志文件,捕获启动、运行、关闭全流程关键日志,附操作步骤、命令示例及典型日志解析。

b478.png

openGauss数据库集群初始化时,会创建数据目录,一般通过环境变量 $PGDATA 进行引用。数据库初始化完成后,该目录下会生成各类子目录与配置文件。下面展示了openGauss的物理存储结构:

image.png



使用 gs_ctl 启动实例时,如果不使用 -l 参数指定服务器日志文件,报错信息会直接打印到前台终端。

-l 参数用于指定服务器日志输出文件,日志中记录数据库实例启动、运行、关闭全流程关键信息。

视频讲解如下:


操作步骤

1. 启动 openGauss(指定日志文件)

# 启动openGauss,-D 指定数据目录,-l 指定服务器日志输出文件
[postgres@openGauss gaussdb]$ bin/gs_ctl -D data/single_node/ -l logfile start

2. 查看完整服务器日志

# 读取日志文件完整内容
[postgres@openGauss gaussdb]$ cat logfile

日志输出样例

0 LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.
0 LOG:  [Alarm Module]Host Name: openGauss 
0 LOG:  [Alarm Module]Host IP: openGauss. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain <HOST IP>
0 LOG:  [Alarm Module]Cluster Name: dbCluster 
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.
The core dump path is an invalid directory
2026-10-20 10:35:16.008 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  when starting as multi_standby mode, we couldn't support data replicaton.
2026-10-20 10:35:16.008 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  base_page_saved_interval is 400, ori is 400.
2026-10-20 10:35:16.059 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]can not read GAUSS_WARNING_TYPE env.
2026-10-20 10:35:16.059 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host Name: openGauss 
2026-10-20 10:35:16.059 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Host IP: openGauss. Copy hostname directly in case of taking 10s to use 'gethostbyname' when /etc/hosts does not contain <HOST IP>
2026-10-20 10:35:16.059 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Cluster Name: dbCluster 
2026-10-20 10:35:16.059 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  [Alarm Module]Invalid data in AlarmItem file! Read alarm English name failed! line: 57
2026-10-20 10:35:16.068 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  loaded library "security_plugin"
2026-10-20 10:35:16.072 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2026-10-20 10:35:16.072 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2026-10-20 10:35:16.074 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2026-10-20 10:35:16.077 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for backend threads is: 220 MB
2026-10-20 10:35:16.077 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  reserved memory for WAL buffers is: 128 MB
2026-10-20 10:35:16.077 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  Set max backend reserve memory is: 348 MB, max dynamic memory is: 8121 MB
2026-10-20 10:35:16.077 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  shared memory 3306 Mbytes, memory context 8469 Mbytes, max process memory 12288 Mbytes
2026-10-20 10:35:17.215 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [CACHE] LOG:  set data cache  size(402653184)
2026-10-20 10:35:18.078 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  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
2026-10-20 10:35:18.903 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  gaussdb: fsync file "/home/postgres/training/gaussdb/data/single_node/gaussdb.state.temp" success
2026-10-20 10:35:18.903 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  create gaussdb state file success: db state(STARTING_STATE), server mode(Normal), connection index(1)
2026-10-20 10:35:18.932 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  max_safe_fds = 976, usable_fds = 1000, already_open = 14
The core dump path is an invalid directory
2026-10-20 10:35:18.951 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  the configure file /home/postgres/training/gaussdb/etc/gscgroup_postgres.cfg doesn't exist or the size of configure file has changed. Please create it by root user!
2026-10-20 10:35:18.952 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [BACKEND] LOG:  Failed to parse cgroup config file.
2026-10-20 10:35:19.400 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2026-10-20 10:35:19.400 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2026-10-20 10:35:19.400 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2026-10-20 10:35:19.400 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
2026-10-20 10:35:19.411 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2026-10-20 10:35:19.411 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2026-10-20 10:35:19.411 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2026-10-20 10:35:19.411 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
2026-10-20 10:35:19.412 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [EXECUTOR] WARNING:  Failed to obtain environment value $GAUSSLOG!
2026-10-20 10:35:19.412 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [EXECUTOR] DETAIL:  N/A
2026-10-20 10:35:19.412 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [EXECUTOR] CAUSE:  Incorrect environment value.
2026-10-20 10:35:19.412 [unknown] [unknown] localhost 140094202825152 0[0:0#0]  0 [EXECUTOR] ACTION:  Please refer to backend log for more details.
相关文章
|
23天前
|
弹性计算 JSON 运维
云主机上跑本地记忆库的四个运维习惯
本文总结云主机部署七层记忆库(meow-memory)的四大关键运维习惯:①开启并手动验证备份机制;②监控磁盘使用率与DB周增速;③核对UTC/北京时间下dream峰时窗口落点;④升级前在快照环境演练。强调“安静运行即风险”,重实操、可验证、防静默失效。(239字)
96 0
|
1月前
|
编解码 人工智能 弹性计算
租用GPU服务器如何收费?来看看阿里云GPU服务器,怎么样?可以吧!
阿里云GPU云服务器(EGS)支持包年包月、按量付费、抢占式实例三种计费模式,适配AI训练/推理、视频转码、图形渲染及科学仿真等场景;提供T4/A10/L20/V100等多款GPU规格,价格因配置、地域及时长而异,推荐按业务负载精准选型。(239字)
|
3月前
|
存储 弹性计算 人工智能
阿里云服务器多少钱一年?轻量、ECS、GPU服务器配置价格表,个人、企业及学生活动整理
2026年阿里云服务器优惠价出炉:轻量应用服务器低至38元/年(2核2G+200M峰值带宽),ECS云服务器99元/年起(2核2G),企业级2核4G+5M带宽仅199元/年;香港轻量25元/月起,GPU实例月付1681元起。全地域覆盖,新老用户同价,续费不涨价。阿里云官方活动:https://t.aliyun.com/U/OTnSAH
608 0
|
23天前
|
人工智能 安全 测试技术
AI 驱动的自主开发平台 Qoder CN 实战:融合专家多智能体、安全沙箱、Hook 扩展及 CLI 命令与应用案例
Qoder CN依托Quest2.0任务引擎、专家团多智能体协同、Repowiki工程知识库、终端沙箱安全隔离、Hook扩展机制,完成从简单代码补全向工程级自主开发工作台的跨越。提供原生IDE、主流IDE插件、CLI命令行多形态接入,兼容多款主流大模型,兼顾个人开发者与企业团队的研发场景。 在实际项目落地,优先使用Quest做中等规模工程任务,搭配Repowiki沉淀项目知识;开启沙箱保障终端执行安全;根据任务复杂度切换不同基座模型,做好Credits资源告警;AI产出代码坚持人工复核。借助整套工具链,可以把大量重复编码、
284 4
|
11月前
|
存储 关系型数据库 数据库
【赵渝强老师】PostgreSQL锁的类型
PostgreSQL通过表级锁和行级锁实现并发控制,结合MVCC机制保障数据一致性。锁模式多样,粒度精细,可有效避免事务冲突,提升并发性能。
476 0
【赵渝强老师】PostgreSQL锁的类型
|
7月前
|
关系型数据库 MySQL Java
【赵渝强老师】MySQL数据库的分库与分表
Mycat是一款开源分布式数据库中间件,支持MySQL等主流数据库,提供分库分表、读写分离、逻辑库/表抽象等功能。本文详解其核心概念(如分片表、ER表、全局序列号)、安装部署(JDK配置、服务启停)及实战配置(schema.xml/rule.xml),并演示基于三节点MySQL的分片数据路由与查询。
461 31
|
7月前
|
网络协议 Java 数据格式
【赵渝强老师】Docker容器的跨节点通信
本文详解Docker容器跨主机通信的三种方案,重点介绍基于Overlay网络的实现:通过ZooKeeper注册中心配置Docker集群,创建overlay网络,使不同主机上的容器能用虚拟IP直接互通,并提供完整部署步骤与验证方法。(239字)
599 3
|
10月前
|
SQL 存储 分布式计算
【赵渝强老师】基于Hudi的大数据湖仓一体架构
Apache Hudi(Hadoop Upserts Delete and Incremental)是开源的流式数据湖平台,支持事务、高效upsert/delete、增量处理、多引擎SQL读写(Spark/Flink/Trino等),自动管理小文件与压缩,兼容云存储,助力构建湖仓一体架构。
1251 3
|
10月前
|
SQL Oracle 关系型数据库
【赵渝强老师】Oracle多租户容器数据库
Oracle 12c引入多租户容器数据库(CDB),支持在一个数据库服务器上管理多个可插拔数据库(PDB),提升资源利用率,降低成本。CDB由根容器、PDB种子和多个PDB组成,可通过DBCA或SQL脚本创建,实现高效数据库整合与运维。
719 2
|
10月前
|
SQL 数据库 OceanBase
【赵渝强老师】OceanBase的配置文件与配置项
OceanBase集群中,OBServer节点需预创建etc、log、run、store等目录,store下还需clog、slog、sstable子目录。etc存放配置文件,etc2/3为自动备份目录,配置项分集群与租户级,通过SHOW PARAMETERS查看,支持模糊查询。
616 4