Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Inserting into Empty Table after Running analyze_statistics Creates a Corrupted File

Issue and solution from @Hibiki

When analyze_statistics is executed after creating a new table and inserting data into the table, the following error is displayed:

ERROR: FileColumnReader: block /mnt/ebs/vertica/verticadb/v_verticadb_node0004_data/679/02a08290683dce017ea998e972cf1b2200d000013a345bef_0.gt @ 262979 's CRC af1e33af858ce01a

The issue occurred in an environment virtualized by KVM but there was no impact to upgrade the kernel on the guest OS. The cause for this issue we assume is that, the storage does not send back the bits that Vertica wrote to it and instead sends zeros.

The issue was resolved after the kernel was upgraded to 5.4.x on the host. Kernel version 4.19.x has this issue and it has already been fixed in 5.4.x.

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.