Skip to main content

VerticaCopyStream appears to be hanging or waiting indefenitly

  • August 29, 2016
  • 1 reply
  • 8 views

HPE

Hi,

 

VerticaCopyStream appears to be hanging or waiting indefenitly in start/execute method calls when using IO stream.

 

In my case I am using PipedIOStream(PipedInputStream & PipedOutputStream) to stream the data from my program to vertica continously. Interestingly, the program is working fine if I close the Out stream; so it looks like Vertica calls waits till the stream to be closed to consume data. I even tried flushing the stream; but not of any help.

 

Regards,

Abhilash R

1 reply

victor_dileo
  • New Participant
  • August 30, 2016

I'll take a shot in the dark here...

 

Experienced "hanging" behavior when COPYing into Vertica from AWS S3 via a third-party tool called S3FS.

S3FS tries to make AWS S3 look like a conventional file system, and it succeeds but only to a degree.

 

When doing huge loads S3FS choked from all the multi-threading, making it look superficially like COPY was hanging. To be clear, the problem was S3FS, not Vertica's COPY.

 

Perhaps your scenario bears some resemblance to this?