合 GreenPlum添加standby master报错Error initializing standby master ExecutionError non-zero rc 2
👉 本文共约48个字，系统预计阅读时间或需1分钟。
现象
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 | [gpadmin@mdw gppkg]$ gpinitstandby -s smdw -S /opt/greenplum/data/master/gpseg-1 -P 5432 20240117:19:33:36:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Validating environment and parameters for standby initialization... 20240117:19:33:36:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Checking for data directory /opt/greenplum/data/master/gpseg-1 on m 20240117:19:33:37:1575213 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------ 20240117:19:33:37:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master initialization parameters 20240117:19:33:37:1575213 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------ 20240117:19:33:37:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master hostname = mdw 20240117:19:33:37:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master data directory = /data/gpadmindata/gpmaster/ 20240117:19:33:37:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master port = 5432 20240117:19:33:37:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master hostname = smdw 20240117:19:33:37:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master port = 5432 20240117:19:33:37:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master data directory = /opt/greenplum/data/maste 20240117:19:33:37:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum update system catalog = On Do you want to continue with standby master initialization? Yy|Nn (default=N): > y 20240117:19:33:40:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Syncing Greenplum Database extensions to standby 20240117:19:33:41:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-The following packages will be installed on smdw: MetricsCollector-ppkg 20240117:19:33:41:1575213 gpinitstandby:mdw:gpadmin-[WARNING]:-Syncing of Greenplum Database extensions has failed. 20240117:19:33:41:1575213 gpinitstandby:mdw:gpadmin-[WARNING]:-Please run gppkg --clean after successful standby initialization 20240117:19:33:41:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Adding standby master to catalog... 20240117:19:33:41:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Database catalog updated successfully. 20240117:19:33:41:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Updating pg_hba.conf file... 20240117:19:33:41:1575213 gpinitstandby:mdw:gpadmin-[ERROR]:-Failed to update pg_hba.conf file on master. 20240117:19:33:41:1575213 gpinitstandby:mdw:gpadmin-[ERROR]:-Failed to create standby 20240117:19:33:41:1575213 gpinitstandby:mdw:gpadmin-[WARNING]:-Trying to rollback changes that have been made... 20240117:19:33:41:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Rolling back catalog change... 20240117:19:33:41:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Removing standby master from catalog... 20240117:19:33:41:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Database catalog updated successfully. 20240117:19:33:41:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Restoring pg_hba.conf file... mv: cannot stat ‘/data/gpadmindata/gpmaster/gpseg-1/pg_hba.conf.gpinitstandby.bak’: No such file or directory 20240117:19:33:42:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Cleaning up pg_hba.conf backup files... 20240117:19:33:43:1575213 gpinitstandby:mdw:gpadmin-[INFO]:-Backup files of pg_hba.conf cleaned up successfully. 20240117:19:33:43:1575213 gpinitstandby:mdw:gpadmin-[ERROR]:-Error initializing standby master: ExecutionError: 'non-zero rc: 2 StrictHostKeyChecking=no -o ServerAliveInterval=60 smdw ". /opt/gpadmin/greenplum/greenplum-db-6.13.0/greenplum_path.sh; /sbin/in/grep -v \"127.0.0\"|/bin/awk '{print \$2}'|/bin/cut -d: -f2"' cmd had rc=255 completed=True halted=False stdout='' stderr='Connection reset by 192.2.169.16 port 22 ' [gpadmin@mdw gppkg]$ ^C [gpadmin@mdw gppkg]$ |
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
