合 GreenPlum安装gpcc报错rsync: [sender] write error: Broken pipe (32)
👉 本文共约289个字，系统预计阅读时间或需2分钟。
现象
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 39 40 41 | [gpadmin@mdw ~]$ cd /soft [gpadmin@mdw soft]$ cd greenplum-cc-web-6.10.0-gp6-rhel7-x86_64/ [gpadmin@mdw greenplum-cc-web-6.10.0-gp6-rhel7-x86_64]$ ./gpccinstall-6.10.0 -W Password for GPDB user gpmon: Where would you like to install Greenplum Command Center? (Default=/usr/local) Greenplum Command Center will be installed in /usr/local/greenplum-cc-6.10.0 What would you like to name this installation of Greenplum Command Center? (Default=gpcc) What port would you like the gpcc webserver to use? (Default=28080) Would you like to enable SSL/TLS? Yy/Nn (Default=Y) n ******************************************************************************** * WARNING: Your connections to GPCC will be insecure. * ******************************************************************************** Please choose a display language (Default=English) 1. English 2. Chinese 3. Korean 4. Russian 5. Japanese 2 INSTALLATION IN PROGRESS... RunCommandOnEachHost failed on host: smdw, packet_write_wait: Connection to 192.2.169.16 port 22: Broken pipe rsync: [sender] write error: Broken pipe (32) rsync error: unexplained error (code 255) at io.c(820) [sender=3.1.2] %!(EXTRA string=command: , string=rsync -e "ssh -o StrictHostKeyChecking=no" /tmp/gpcc.tar.gz smdw:/tmp) Error when copying binary to smdw packet_write_wait: Connection to 192.2.169.16 port 22: Broken pipe rsync: [sender] write error: Broken pipe (32) rsync error: unexplained error (code 255) at io.c(820) [sender=3.1.2] Error when copying binary to mdw Error when copying binary to sdw1 Error when copying binary to sdw4 Error when copying binary to sdw2 Error when copying binary to sdw3 CopyBinaryToHost error: RunCommandOnEachHost failure happened |
分析
可能网络原因，导致smdw不能拷贝数据，所以先移除smdw，等安装完成后再添加smdw。
解决
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 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 | [gpadmin@mdw greenplum-cc-web-6.10.0-gp6-rhel7-x86_64]$ gpinitstandby -r 20240118:12:18:21:3329494 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------ 20240118:12:18:21:3329494 gpinitstandby:mdw:gpadmin-[INFO]:-Warm master standby removal parameters 20240118:12:18:21:3329494 gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------ 20240118:12:18:21:3329494 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master hostname = mdw 20240118:12:18:21:3329494 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master data directory = /data/gpadmindata/gpmaster/gpseg-1 20240118:12:18:21:3329494 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum master port = 5432 20240118:12:18:21:3329494 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master hostname = smdw 20240118:12:18:21:3329494 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master port = 5432 20240118:12:18:21:3329494 gpinitstandby:mdw:gpadmin-[INFO]:-Greenplum standby master data directory = /data/gpadmindata/gpmaster/gpseg-1 Do you want to continue with deleting the standby master? Yy|Nn (default=N): > y 20240118:12:18:24:3329494 gpinitstandby:mdw:gpadmin-[INFO]:-Removing standby master from catalog... 20240118:12:18:24:3329494 gpinitstandby:mdw:gpadmin-[INFO]:-Database catalog updated successfully. 20240118:12:18:24:3329494 gpinitstandby:mdw:gpadmin-[INFO]:-Stopping standby master on smdw 20240118:12:18:25:3329494 gpinitstandby:mdw:gpadmin-[INFO]:-Removing data directory on standby master... 20240118:12:18:27:3329494 gpinitstandby:mdw:gpadmin-[INFO]:-Successfully removed standby master [gpadmin@mdw greenplum-cc-web-6.10.0-gp6-rhel7-x86_64]$ ./gpccinstall-6.10.0 -W Password for GPDB user gpmon: Where would you like to install Greenplum Command Center? (Default=/usr/local) Greenplum Command Center will be installed in /usr/local/greenplum-cc-6.10.0 What would you like to name this installation of Greenplum Command Center? (Default=gpcc) What port would you like the gpcc webserver to use? (Default=28080) Would you like to enable SSL/TLS? Yy/Nn (Default=Y) n ******************************************************************************** * WARNING: Your connections to GPCC will be insecure. * ******************************************************************************** Please choose a display language (Default=English) 1. English 2. Chinese 3. Korean 4. Russian 5. Japanese 2 INSTALLATION IN PROGRESS... ******************************************************************************** * * * INSTALLATION IS ALMOST COMPLETED * * * * The last step is to update the metrics_collector extension, which needs to * * restart the Greenplum Database cluster. Please proceed to $GPCC_HOME and * * follow the instructions in this file: * * * * update-extension.txt * * * * Some new features may not be available before the update is done. * * * * To use GPCC with the old metrics_collector extension, source gpcc_path.sh * * and run 'gpcc start'. * * * ******************************************************************************** [gpadmin@mdw greenplum-cc-web-6.10.0-gp6-rhel7-x86_64]$ |
本质原因
若22端口的网络有限制，则也不建议使用22端口进行scp连接，类似报错packet_write_wait: Connection to 192.21.169.16 port 22: Broken pipe：
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
