Skip to main content
Question

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

  • October 14, 2020
  • 2 replies
  • 9 views
karthik
Forum|alt.badge.img+1

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

    2 replies

    Bryan_H
    Forum|alt.badge.img+2
    • Bryan_H
    • Participating Frequently
    • October 14, 2020

    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.

    karthik
    Forum|alt.badge.img+1
    • karthik
    • Author
    • Participating Frequently
    • October 15, 2020

    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.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement