401 Star 1.3K Fork 1.5K

GVPopenGauss / openGauss-server

 / 详情

不带om手工配置主从流复制数据库启动失败报ssl认证问题

已完成
任务
创建于  
2020-07-22 09:39

[opengauss@db1 opendata]$ gs_ctl start -D /gaussdata/opendata/ -M primary

[2020-07-22 09:37:20.783][590913][][gs_ctl]: gs_ctl started,datadir is -D "/gaussdata/opendata"
[2020-07-22 09:37:20.875][590913][][gs_ctl]: waiting for server to start...
.0 LOG: [Alarm Module]ERROR: environment variable $GAUSSHOME is not set!

0 LOG: [Alarm Module]ERROR: environment variable $GAUSSHOME is not set!

0 WARNING: not found GAUSSHOME enviroment variable.
0 [BACKEND] LOG: Begin to start openGauss Database.
2020-07-22 09:37:21.056 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] LOG: [Alarm Module]ERROR: environment variable $GAUSSHOME is not set!

2020-07-22 09:37:21.056 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] LOG: [Alarm Module]ERROR: environment variable $GAUSSHOME is not set!

2020-07-22 09:37:21.056 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] LOG: Transparent encryption disabled.
2020-07-22 09:37:21.056 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] WARNING: get environment of GAUSSHOME failed.

2020-07-22 09:37:21.057 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] WARNING: get environment of GAUSSHOME failed.

2020-07-22 09:37:21.057 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] WARNING: get environment of GAUSSHOME failed.

2020-07-22 09:37:21.057 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] WARNING: get environment of GAUSSHOME failed.

2020-07-22 09:37:21.057 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] WARNING: No explicit IP is configured for listen_addresses GUC.
2020-07-22 09:37:21.057 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] LOG: InitNuma numaNodeNum: 1 numa_distribute_mode: none inheritThreadPool: 0.
2020-07-22 09:37:21.057 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] WARNING: Failed to initialize the memory protect for g_instance.attr.attr_storage.cstore_buffers (512 Mbytes) or shared memory (10633 Mbytes) is larger.
2020-07-22 09:37:21.554 [unknown] [unknown] localhost 139749391085312 0 0 [CACHE] LOG: set data cache size(402653184)
2020-07-22 09:37:21.576 [unknown] [unknown] localhost 139749391085312 0 0 [CACHE] LOG: set metadata cache size(134217728)
2020-07-22 09:37:21.633 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] LOG: gaussdb: fsync file "/gaussdata/opendata/gaussdb.state.temp" success
2020-07-22 09:37:21.633 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] LOG: create gaussdb state file success: db state(STARTING_STATE), server mode(Primary)
2020-07-22 09:37:21.660 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] WARNING: get environment of GAUSSHOME failed.

2020-07-22 09:37:21.660 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] LOG: max_safe_fds = 975, usable_fds = 1000, already_open = 15
2020-07-22 09:37:21.662 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] WARNING: environment variable $GAUSSHOME is not set!
2020-07-22 09:37:21.662 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] LOG: Success to start openGauss Database, please press any key to exit...
[2020-07-22 09:37:21.876][590913][][gs_ctl]: waitpid 590926 failed, exitstatus is 256, ret is 2

[2020-07-22 09:37:21.876][590913][][gs_ctl]: stopped waiting
[2020-07-22 09:37:21.876][590913][][gs_ctl]: could not start server
[2020-07-22 09:37:21.876][590913][][gs_ctl]: Examine the log output.

pg_log日志如下:感觉是加了-M primary启动时会启动复制线程,复制线程需要ssl认证,认证失败了,我这个是不带om的安装,部署两个单机然后手工配的主备同步,这样ssl是不是有问题,该如何处理?

2020-07-22 09:37:21.734 [unknown] [unknown] localhost 139737761310464 0 0 [BACKEND] LOG: start local next csn from checkpoint 1916
2020-07-22 09:37:21.734 [unknown] [unknown] localhost 139737761310464 0 0 [BACKEND] LOG: startup csnlog without extend at xid:7790, pageno:7
2020-07-22 09:37:21.734 [unknown] [unknown] localhost 139737761310464 0 0 [BACKEND] LOG: database system was not properly shut down; automatic recovery in progress
2020-07-22 09:37:21.735 [unknown] [unknown] localhost 139737761310464 0 0 [BACKEND] LOG: [Pgstat] remove statfiles in pg_stat_tmp/pgstat.stat, global/pgstat.stat
2020-07-22 09:37:21.735 [unknown] [unknown] localhost 139737761310464 0 0 [BACKEND] LOG: redo minRecoveryPoint at 0/0; backupStartPoint at 0/0; backupEndRequired FALSE
2020-07-22 09:37:21.735 [unknown] [unknown] localhost 139737761310464 0 0 [BACKEND] LOG: redo starts at 0/1F9DA30
2020-07-22 09:37:21.735 [unknown] [unknown] localhost 139737761310464 0 0 [BACKEND] LOG: set knl_g_set_is_local_redo_finish to false when starting redo
2020-07-22 09:37:21.735 [unknown] [unknown] localhost 139737761310464 0 0 [BACKEND] LOG: invalid record length at 0/1F9DB38: wanted 32, got 0
2020-07-22 09:37:21.737 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] LOG: gaussdb: fsync file "/gaussdata/opendata/gaussdb.state.temp" success
2020-07-22 09:37:21.737 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] LOG: update gaussdb state file: db state(NORMAL_STATE), server mode(Primary)
2020-07-22 09:37:21.740 [unknown] [unknown] localhost 139737671137024 0 0 [BACKEND] LOG: checkpointer started, CheckPointTimeout is 60
2020-07-22 09:37:21.740 [unknown] [unknown] localhost 139737618667264 0 0 [INCRE_CKPT] LOG: pagewriter started, thread id is 0
2020-07-22 09:37:21.740 [unknown] [unknown] localhost 139737601885952 0 0 [INCRE_CKPT] LOG: pagewriter started, thread id is 1
2020-07-22 09:37:21.741 [unknown] [unknown] localhost 139737576703744 0 0 [BACKEND] LOG: remote service is starting...
2020-07-22 09:37:21.741 [unknown] [unknown] localhost 139737576703744 0 0 [REMOTE] WARNING: Failed to get environment variable: "GAUSSHOME". Please check and make sure it is configured!
2020-07-22 09:37:21.741 [unknown] [unknown] localhost 139737576703744 0 0 [REMOTE] FATAL: Can not start remote service without ssl certificate. Check ssl certificate or adjust remote_read_mode.
2020-07-22 09:37:21.741 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] LOG: remote service process (ThreadId 139737576703744) was terminated by signal 1: Hangup

2020-07-22 09:37:21.742 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] LOG: terminating any other active server processes
2020-07-22 09:37:21.742 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] LOG: remote service process (ThreadId 139737576703744) exited with exit code 0
2020-07-22 09:37:21.742 [unknown] [unknown] localhost 139749391085312 0 0 [BACKEND] LOG: the server process exits

不加-M primary启动时可以正常启动的。

评论 (4)

张小海 创建了任务
张小海 关联仓库设置为openGauss/openGauss-server
展开全部操作日志

Hey @张小海, Welcome to openGauss Community.
All of the projects in openGauss Community are maintained by @opengauss-bot.
That means the developers can comment below every pull request or issue to trigger Bot Commands.
Please follow instructions at https://gitee.com/opengauss/community/blob/master/contributors/command.en.md to find the details.

张小海 修改了描述
张小海 修改了描述

Hey @张小海 did you resolve this issue?

opengauss-bot 添加了
 
kind/bug
标签

您好,这是因为远程读功能开关默认参数是authentication,表示开启远程读功能,但要进行证书认证。
remote_read_mode设置为off或者non_authentication即可。

remote_read_mode
参数说明:远程读功能开关。读取主机上的页面失败时可以从备机上读取对应的页面。
取值范围:枚举类型
 off表示关闭远程读功能
 non_authentication表示开启远程读功能,但不进行证书认证
 authentication表示开启远程读功能,但要进行证书认证
默认值:authentication

zhangxubo 任务状态待办的 修改为进行中
zhangxubo 添加了
 
sig/om
标签
zhangxubo 移除了
 
sig/om
标签
zhangxubo 添加了
 
sig/storageengine
标签
蒲甫安 任务状态进行中 修改为已完成
蒲甫安 添加协作者吴岳川

登录 后才可以发表评论

状态
负责人
项目
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
预计工期 (小时)
参与者(4)
5622128 opengauss bot 1581905080 5227357 xiangxinyong 1578982846
C++
1
https://gitee.com/opengauss/openGauss-server.git
git@gitee.com:opengauss/openGauss-server.git
opengauss
openGauss-server
openGauss-server

搜索帮助