•  
Results 1 to 5 of 5

Thread: Error 115 in using gpload

  1. #1
    Join Date
    Jan 2012
    Posts
    6

    Question Error 115 in using gpload

    Hi,

    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?

  2. #2
    Join Date
    Dec 2009
    Posts
    12

    Default

    May be you can check host file entry ?

  3. #3
    Join Date
    Jan 2012
    Posts
    6

    Default

    If you're talking about configuring Greenplum host to accept connections from this machine, already done

  4. #4
    Join Date
    Dec 2009
    Posts
    12

    Default

    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.

    Abhi

  5. #5
    Join Date
    Dec 2009
    Posts
    12

    Default

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •