Error when COPY data

sumanthota2014 · Post by **sumanthota2014** » Wed Sep 17, 2014 11:47 am

While copying data from one cluster to the other, I get the below error for segmented tables. For unsegmented tables, data is copied without any issues...
What could be the problem?

Code: Select all

dbadmin=> COPY s100.ttab1 FROM VERTICA VMart.s100.ttab1 DIRECT;

ERROR 4054: [vmart] NetworkSend on v_vmart_node0005: failed to open connection to node v_vmart_node0002 (socket error: Connection timed out)

NorbertKrupa · Post by **NorbertKrupa** » Wed Sep 17, 2014 1:21 pm

Are both clusters on the same subnet (SELECT * FROM network_interfaces)? If yes, you may need to increase the time out.

Error when COPY data

Error when COPY data

Re: Error when COPY data