Event codes

The following table lists the event codes that Vertica logs to the events system tables.

The following table lists the event codes that Vertica logs to the events system tables.

Event Code Event Code Description Description Action
0 Low Disk Space The database is running out of disk space or a disk is failing or there is a I/O hardware failure.

It is imperative that you add more disk space or replace the failing disk or hardware as soon as possible.

Check dmesg to see what caused the problem.

Also, use the DISK_RESOURCE_REJECTIONS system table to determine the types of disk space requests that are being rejected and the hosts on which they are being rejected. See Managing disk space for more information about low disk space.

1 Read Only File System The database does not have write access to the file system for the data or catalog paths. This can sometimes occur if Linux remounts a drive due to a kernel issue. Modify the privileges on the file system to give the database write access.
2 Loss Of K Safety

The database is no longer
K-Safe because there are insufficient nodes functioning within the cluster. Loss of
K-safety causes the database to shut down.

In a four-node cluster, for example, K-safety=1. If one node fails, the fault tolerance is at a critical level. If two nodes fail, the system loses K-safety.

 If a system shuts down due to loss of K-safety, you need to recover the system. See Failure recovery.
3 Current Fault Tolerance at Critical Level One or more nodes in the cluster have failed. If the database loses one more node, it is no longer K-Safe and it shuts down. (For example, a four-node cluster is no longer K-safe if two nodes fail.) Restore any nodes that have failed or been shut down.
4 Too Many ROS Containers Heavy load activity on one or more projections can sometimes generate more ROS containers than the Tuple Mover can handle. Vertica allows up to 1024 ROS containers per projection before it rolls back additional load jobs and returns a ROS pushback error message.

Typically, the Tuple Mover catches up with pending mergeout requests and the Optimizer can resume executing queries on the affected tables (see Mergeout).

If this problem does not resolve quickly, or if it occurs frequently, it is probably related to insufficient RAM allocated to MAXMEMORY in the TM resource pool.

5 WOS Over Flow Deprecated
6 Node State Change The node state has changed. Check the status of the node.
7 Recovery Failure The database was not restored to a functional state after a hardware or software related failure. The reason for recovery failure can vary. See the event description for more information about your specific situation.
8 Recovery Error The database encountered an error while attempting to recover. If the number of recovery errors exceeds Max Tries, the Recovery Failure event is triggered. See Recovery Failure within this table. The reason for a recovery error can vary. See the event description for more information about your specific situation.
9 Recovery Lock Error

A recovering node could not obtain an S lock on the table.

If you have a continuous stream of COPY commands in progress, recovery might not be able to obtain this lock even after multiple re-tries.

 Either momentarily stop the loads or pick a time when the cluster is not busy to restart the node and let recovery proceed.
10 Recovery Projection Retrieval Error Vertica was unable to retrieve information about a projection. The reason for a recovery projection retrieval error can vary. See the event description for more information about your specific situation.
11 Refresh Error The database encountered an error while attempting to refresh. The reason for a refresh error can vary. See the event description for more information about your specific situation.
12 Refresh Lock Error The database encountered a locking error during refresh. The reason for a refresh error can vary. See the event description for more information about your specific situation.
13 Tuple Mover Error Deprecated
14 Timer Service Task Error An error occurred in an internal scheduled task. Internal use only
15 Stale Checkpoint Deprecated
16 CRC Mismatch The Cyclic Redundancy Check returned an error or errors while fetching data. Review the vertica.log file or the SNMP trap utility to review the errors. For more information see Evaluating CRC errors.
20 Cluster Read-only Cluster cannot perform updates due to quorum loss and can only be queried. Restart failed nodes. See Recover from Read-Only Mode.