评估 CRC 错误

在每次提取数据磁盘以进行查询处理时，Vertica 都会评估每个 ROS 数据块中的 CRC 值。如果在提取数据时出现 CRC 错误，则会将以下信息写入 vertica.log 文件：

CRC Check Failure Details:File Name:
File Offset:
Compressed size in file:
Memory Address of Read Buffer:
Pointer to Compressed Data:
Memory Contents:

事件管理器也会收到关于 CRC 错误的通知，因此您可以使用 SNMP 陷阱来捕获 CRC 错误：

"CRC mismatch detected on file <file_path>. File may be corrupted. Please check hardware and drivers."

如果您从 vsql、ODBC 或 JDBC 运行查询，则查询会返回 FileColumnReader ERROR。此消息指出特定块的 CRC 与给定记录不匹配，如下所示：

hint: Data file may be corrupt.  Ensure that all hardware (disk and memory) is working properly.
Possible solutions are to delete the file <pathname> while the node is down, and then allow the node
to recover, or truncate the table data.code: ERRCODE_DATA_CORRUPTED