Greenplum集群搭建碰到问题Failed to start Master instance in admin mode解决方案

最近搭建Greenplum集群时候碰到一个问题,磨蹭半天,终于解决了,在这里给大家分享一波,

首先就是Failed to start Master instance in admin mode,在启动greenplum集群的时候会碰到这个问题,于是根据报错的日志,进入到相应的日志文件里面去看,发现内容是这些

2023-05-08 11:31:07.890921 CST,,,p53097,th1908979840,,,,0,,,seg-1,,,,,"LOG","00000","registering background worker ""sweeper process""",,,,,,,,"RegisterBackgroundWorker","bgworker.c",774,
2023-05-08 11:31:08.019380 CST,,,p53097,th1908979840,,,,0,,,seg-1,,,,,"LOG","00000","redirecting log output to logging collector process",,"Future log output will appear in directory ""pg_log"".",,,,,,"SysLogger_Start","syslogger.c",984,
2023-05-08 11:31:58.026149 CST,,,p53154,th738269312,,,,0,,,seg-1,,,,,"LOG","00000","registering background worker ""sweeper process""",,,,,,,,"RegisterBackgroundWorker","bgworker.c",774,
2023-05-08 11:31:58.153285 CST,,,p53154,th738269312,,,,0,,,seg-1,,,,,"LOG","00000","redirecting log output to logging collector process",,"Future log output will appear in directory ""pg_log"".",,,,,,"SysLogger_Start","syslogger.c",984,
2023-05-08 11:43:27.709824 CST,,,p53789,th-1058158464,,,,0,,,seg-1,,,,,"LOG","00000","registering background worker ""sweeper process""",,,,,,,,"RegisterBackgroundWorker","bgworker.c",774,
2023-05-08 11:43:27.835219 CST,,,p53789,th-1058158464,,,,0,,,seg-1,,,,,"LOG","00000","redirecting log output to logging collector process",,"Future log output will appear in directory ""pg_log"".",,,,,,"SysLogger_Start","syslogger.c",984,
2023-05-08 11:43:29.408262 CST,,,p53829,th1251334272,,,,0,,,seg-1,,,,,"LOG","00000","registering background worker ""ftsprobe process""",,,,,,,,"RegisterBackgroundWorker","bgworker.c",774,
2023-05-08 11:43:29.408637 CST,,,p53829,th1251334272,,,,0,,,seg-1,,,,,"LOG","00000","registering background worker ""dtx recovery process""",,,,,,,,"RegisterBackgroundWorker","bgworker.c",774,
2023-05-08 11:43:29.408996 CST,,,p53829,th1251334272,,,,0,,,seg-1,,,,,"LOG","00000","registering background worker ""sweeper process""",,,,,,,,"RegisterBackgroundWorker","bgworker.c",774,
2023-05-08 11:43:29.413419 CST,,,p53829,th1251334272,,,,0,,,seg-1,,,,,"LOG","00000","Query info metrics collector initialized",,,,,,,,"_PG_init","metrics_collector.c",453,
2023-05-08 11:43:29.413739 CST,,,p53829,th1251334272,,,,0,,,seg-1,,,,,"LOG","00000","registering background worker ""metrics collector launcher""",,,,,,,,"RegisterBackgroundWorker","bgworker.c",774,
2023-05-08 11:43:29.564314 CST,,,p53829,th1251334272,,,,0,,,seg-1,,,,,"LOG","00000","redirecting log output to logging collector process",,"Future log output will appear in directory ""pg_log"".",,,,,,"SysLogger_Start","syslogger.c",984,

看到这个其实根本看不出来是个什么鬼,GP不知道咋个搞的,真实的错误文件是同级目录的如下csv文件,离谱吧,这个神操作绝了

[gpadmin@htsp157 pg_log]$ ll
total 88
-rw------- 1 gpadmin gpadmin 18791 May  8 10:10 gpdb-2023-05-08_094436.csv
-rw------- 1 gpadmin gpadmin  9823 May  8 10:10 gpdb-2023-05-08_094449.csv
-rw------- 1 gpadmin gpadmin 10087 May  8 10:10 gpdb-2023-05-08_094450.csv
-rw------- 1 gpadmin gpadmin   376 May  8 11:23 gpdb-2023-05-08_112348.csv
-rw------- 1 gpadmin gpadmin   378 May  8 11:31 gpdb-2023-05-08_113108.csv
-rw------- 1 gpadmin gpadmin   376 May  8 11:31 gpdb-2023-05-08_113158.csv
-rw------- 1 gpadmin gpadmin 10346 May  8 11:43 gpdb-2023-05-08_114327.csv
-rw------- 1 gpadmin gpadmin  6145 May  8 11:43 gpdb-2023-05-08_114329.csv
-r-------- 1 gpadmin gpadmin   105 May  8 11:43 gp_era
-rw------- 1 gpadmin gpadmin  6289 May  8 11:43 startup.log

然后找到对应数据库启动的时间点,进去查看,我这次的问题是这个

找到问题点之后,OK,根据相应的方案解决就OK了 

  • 2
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
你可以按照以下步骤来搭建和安装GreenPlum集群: 1. 确保你的环境满足要求: - 操作系统:Linux(如CentOS、Ubuntu等) - 硬件要求:至少3台服务器,每台至少16GB内存和100GB可用空间 2. 下载GreenPlum软件包: - 访问GreenPlum官方网站(https://greenplum.org/)下载最新版本的GreenPlum软件包。 3. 安装依赖软件: - 在你的所有服务器上安装依赖软件,包括SSH、Python、Java以及其他必要的软件和库。 4. 配置SSH免密登录: - 在所有服务器上配置SSH免密登录,以便服务器之间可以互相访问。 5. 在每台服务器上设置主机名: - 打开终端并编辑`/etc/hostname`文件,将每台服务器的主机名设置为唯一的名称。 6. 创建一个用户组和用户: - 在所有服务器上创建一个用户组和一个用于安装和管理GreenPlum的用户。 7. 将GreenPlum软件包复制到所有服务器上: - 将下载的GreenPlum软件包复制到所有服务器上,并解压缩到一个目录中。 8. 配置GreenPlum集群: - 在一个服务器上编辑`greenplum_path/gpconfigs/gpinitsystem_config`文件,根据你的需求进行配置。 9. 初始化GreenPlum集群: - 在一个服务器上执行以下命令来初始化GreenPlum集群: ``` $ source greenplum_path/greenplum_path.sh $ gpinitsystem -c greenplum_path/gpconfigs/gpinitsystem_config -h hostfile ``` 10. 启动GreenPlum集群: - 在一个服务器上执行以下命令来启动GreenPlum集群: ``` $ gpstart -a ``` 11. 验证GreenPlum集群: - 在任意服务器上执行以下命令来验证GreenPlum集群是否正常运行: ``` $ psql -d postgres ``` 12. 添加额外的节点(可选): - 如果你想要添加额外的节点到GreenPlum集群中,你可以编辑`greenplum_path/gpconfigs/gpinitsystem_config`文件,然后重复步骤9和10。 这些是GreenPlum集群搭建和安装的大致步骤,请根据实际情况进行调整。注意,在实际操作中可能会有其他细节和注意事项,请参考GreenPlum官方文档或其他相关资源以获取更详细的信息。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值