The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

COPY: Error occurred during ZLIB decompression. ZLIB error code: -3, Message: invalid block type

karthikkarthik Vertica Customer

Hi,
We are sending a copy command from our application its using gzip direct and we see the below error: Can you please help us how to troubleshoot this further? We are using vertica 8.1.1

2020-10-09T04:11:23.718+02:00 Copy transfer error on node 192.168.133.153: Connection timed out (T)
2020-10-09T04:11:23.718+02:00 Vertica error: 58030
2020-10-09T04:11:23.718+02:00 Vertica error: /data/qb_workspaces/jenkins2/ReleaseBuilds/Grader/REL-9_2_1-x_grader/build/vertica/EE/UDL/Decompressors.cpp
2020-10-09T04:11:23.718+02:00 Vertica error: 93
2020-10-09T04:11:23.718+02:00 Vertica error: COPY: Error occurred during ZLIB decompression. ZLIB error code: -3, Message: invalid block type
2020-10-09T04:11:23.718+02:00 Vertica error: process
2020-10-09T04:11:23.718+02:00 Vertica error: ERROR
Thanks,
Karthik S

Answers

  • Bryan_HBryan_H Vertica Employee Administrator

    This usually means a block in the GZIP data was corrupted. It looks like there is an upstream error where a connection timed out, which means incomplete data was received. Incomplete data or truncated file might have caused the GZIP error.
    If the source is a file, check the file integrity with "gzip -t " or the test function of a GUI tool like 7Zip, and retry the COPY statement.

  • karthikkarthik Vertica Customer

    Thanks Bryan. This helped. In our case, we have identified a frequent disconnect between our application and vertica cluster. We are looking further into it.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file