Environment

• Pivotal Greenplum Database (GPDB) 4.3.6.0
• HAWQ Database 1.3.1.0

Symptom

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

Cause

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

Resolution

This issue is being tracked in an internal bug reference MPP-25682. GPDB upgrades prior to version 3.3 in 4.3.6.1 and this will also be fixed in the next release of HAWQ.