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 in the Administrator's Guide.

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