COPY: Error occurred during ZLIB decompression. ZLIB error code: -3, Message: invalid block type
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
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.
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.