How to resolve ERROR 4534 which I get during export?

abhishek_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?

Abhishek_Rana

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

One customer is getting this error when exporting/importing from 6.1.3 to 7.0, does same solution apply? 

Anuj_Adhikari

I am also facing same error on upgrading from 6.1 to 7.0 version

rthota

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

This issue may have to do with network compressions
Check this doc:
https://my.vertica.com/kb/Copying-Data-Between-Similar-Vertica-Clusters/Content/BestPractices/Copying-Data-Between-Similar-Vertica-Clusters.htm

and
https://my.vertica.com/kb/Understanding-HPE-Vertica-Import-and-Export/Content/BestPractices/Understanding-HPE-Vertica-Import-and-Export.htm