Error 115 in using gpload
I am running gpload from a Win 64 machine to load data into a Greenplum database.
I am running into the following error code 115.
Here are the logs -
2012-02-15 15:15:04|INFO|gpload session started 2012-02-15 15:15:04
2012-02-15 15:15:05|INFO|started gpfdist -p 8000 -P 16000 -f "./output.txt" -t 30
2012-02-15 15:18:15|ERROR|ERROR: connection with gpfdist failed for gpfdist://IN164298:8000/./output.txt. effective url: http://10.65.6.161:8000/./output.txt. error code = 115 (Operation now in progress) (seg0 slice1 gp-single-host:50000 pid=21075)
encountered while running INSERT INTO testtable ("col1","col2","col3","col4") SELECT "col1","col2","col3","col4" FROM ext_gpload20120215_151504_4984
2012-02-15 15:18:16|INFO|rows Inserted = 0
2012-02-15 15:18:16|INFO|rows Updated = 0
2012-02-15 15:18:16|INFO|data formatting errors = 0
2012-02-15 15:18:16|INFO|gpload failed
I am unable to find any info on Error code 115 in the documentation (gpload guide as well as Administration guide). Can someone please help me understand why this is failing?
One particular thing I've noted, the IP address mentioned in the logs (10.65.6.161) isn't that of my machine, though the machine name (IN164298) is right. How does gpload resolve this?
May be you can check host file entry ?
If you're talking about configuring Greenplum host to accept connections from this machine, already done
No, it is authentication method.I am referring to system kernel parameter like shmmax in sysctl.conf on linux.Check pre-requisites on document for OS.
Also, provide tables structure and coloumn on which u are creating index.
No /etc/hosts entry on both m/c.
Also check (ping)
•Network access to and from all hosts in your Greenplum Database array (master and segments).
•Network access to and from the hosts where the data to be loaded resides (ETL servers)
Tags for this Thread