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