Skip to main content

How to resolve ERROR 4534 which I get during export?

  • January 31, 2014
  • 5 replies
  • 21 views

abhishek_1
Forum|alt.badge.img+1
While exporting I came through the mentioned error: vsql:export_test.sql:2: ERROR 4534: Receive on v_ebi_node0001: Message receipt from v_shr1_vrt_dev_node0001 failed [Message too large (805306368 > 131072)] How to resolve it?

5 replies

Abhishek_Rana
Forum|alt.badge.img
  • Participating Frequently
  • January 31, 2014

The issue/bug can be related to a mismatch of the buffersize for an export and import which is addressed in V6.0SP2. 

One way to verify that, this was the bug was to run an explain plan query against their db. Issue the following commands 

dbadmin=> \o | grep -i 'buffersize' 
dbadmin=> explain local verbose EXPORT TO VERTICA cig_ssc.monitor.QUERY_REQUESTS as select * from monitor.QUERY_REQUESTS;
dbadmin=> \o 

This should display some information for you.

Check the output for 

2[label = "Export\nExport for BufferSize and then also
3[label = "Import\nImport for Buffersize.

The value for the Buffersize is a mismatch between the export and import.
The solutions is to either apply SP2  on both clusters or to export smaller chunks / selections.

wei_wang
  • New Participant
  • March 17, 2014
One customer is getting this error when exporting/importing from 6.1.3 to 7.0, does same solution apply?

Anuj_Adhikari
  • New Participant
  • July 5, 2014
I am also facing same error on upgrading from 6.1 to 7.0 version

rthota
  • Participating Frequently
  • May 30, 2017

Hi , we are using the version 8.0.1-3. facing the same issue .

@v_agoda_dw_node0006: V1001/4534: Receive on v_agoda_dw_node0006: Message receipt from v_agoda_dw_node0004 failed [canceled]


ckotsidimos
Forum|alt.badge.img+1
  • Participating Frequently
  • June 1, 2017