Skip to main content

How to resolve ERROR 4534 which I get during export?

  • Jan 31, 2014 6:36 PM UTC
  • 5 replies
  • 23 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
  • Jan 31, 2014 6:49 PM UTC

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
  • Mar 17, 2014 8:08 PM UTC
One customer is getting this error when exporting/importing from 6.1.3 to 7.0, does same solution apply?

Anuj_Adhikari
  • New Participant
  • Jul 5, 2014 10:39 AM UTC
I am also facing same error on upgrading from 6.1 to 7.0 version

rthota
  • Participating Frequently
  • May 30, 2017 5:34 AM UTC

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
  • Jun 1, 2017 8:53 AM UTC