CODEWITHSUNDEEP
postgresqlgreenplumexternal-tables
MohaMed
MohaMed

Reputation: 84

ERROR: connection with gpfdist failed ; error code = 4 (Interrupted system call);

Recently we did upgrade from GPDB 4.3 to GPDB 6.x, now I'm testing the new version , I got the error below when I'm reading from external table, I'm stuck and I can't find out a solution:

ERROR: connection with gpfdist failed for "gpfdist://XXX.XXX.XXX.XXX:8090//REFILL/.gz", effective url: "http://XXX.XXX.XXX.XXX:8090//REFILL/.gz": error code = 4 (Interrupted system call); (seg0 slice1 xxx.xx.xx.x:6000 pid=752074) SQL state: 08006

Upvotes: 1

Views: 588

Answers (2)

Anilkumar Nandala
Anilkumar Nandala

Reputation: 41

It seems you have not specified file name correctly. You just specified .gz

Upvotes: 0

waqar shahbaz
waqar shahbaz

Reputation: 34

It seems with the new upgrade the following settings might have changed.

  1. GPFdist path.
  2. Check the port on which gpfdist is running.

Upvotes: 0

Related Questions