最近搭建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了