Inserting into Empty Table after Running analyze_statistics Creates a Corrupted File
Amaksh
Vertica Employee Employee
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.
1