- Pivotal Greenplum Database (GPDB) 220.127.116.11
- HAWQ Database 18.104.22.168
gpssh fails on the same host in the host list every time but passwordless ssh works when using "ssh" manually. This issue may impact gpssh, gpscp, gpssh-exkeys utilities
[gpadmin@mdw ~]$ gpssh -f hostfile -vvv uname -n [ERROR] unable to login to sdw8 hint: use gpssh-exkeys to setup public-key authentication between hosts =>
In som,e cases you might see odd behavior where command outputs do not return the expected results
=> echo 123 [hdw3.phd.local] [hdw2.phd.local] 123 => echo 456 [hdw3.phd.local] 123 [hdw2.phd.local] 456
gpssh uses pxexpect version 2.1. In software only deployments of HAWQ/GPDB pexpect is not able to properly buffer information from the pseudo tty interface used by SSH
This issue is being tracked in an internal bug reference MPP-25682. GPDB upgrades prior to version 3.3 in 22.214.171.124 and this will also be fixed in the next release of HAWQ.