LOG_ROTATE_EVENTS

Lists the rotation events from do_logrotate_local.

Lists the rotation events from DO_LOGROTATE_LOCAL.

Column Name	Data Type	Description
`NODE_NAME`	VARCHAR	The name of the node from which logs were rotated.
`SUCCESS`	BOOLEAN	Whether the call to DO_LOGROTATE_LOCAL succeeded.
`MAX_SIZE`	INTEGER	The size, in bytes, set for LogRotateMaxSize.
`MAX_AGE`	INTEGER	The age, in days, set for LogRotateMaxAge.
`LOG_FILE`	VARCHAR	The path of the original log file.
`NEED_ROTATION`	BOOLEAN	Whether the `LOG_FILE` needed to be rotated.
`MESSAGE`	VARCHAR	The actions performed by DO_LOGROTATE_LOCAL for `LOG_FILE`.

Example

To view all successful rotation events:

=> SELECT * FROM log_rotate_events WHERE need_rotation='t' AND success='t';
-[ RECORD 1 ]-+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------
node_name     | v_vmart_node0001
success       | t
max_size      | 104857600
max_age       | 7
log_file      | /scratch_b/VMart/v_vmart_node0001_catalog/vertica.log
need_rotation | t
message       | /scratch_b/VMart/v_vmart_node0001_catalog/vertica.log was rotated to /scratch_b/VMart/v_vmart_node0001_catalog/vertica.log.2023-12-08-15-18-26-965729-05.gz due to force rotation
-[ RECORD 2 ]-+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------
node_name     | v_vmart_node0001
success       | t
max_size      | 104857600
max_age       | 7
log_file      | /scratch_b/VMart/v_vmart_node0001_catalog/UDxLogs/UDxFencedProcesses.log
need_rotation | t
message       | /scratch_b/VMart/v_vmart_node0001_catalog/UDxLogs/UDxFencedProcesses.log was rotated to /scratch_b/VMart/v_vmart_node0001_catalog/UDxLogs/UDxFencedProcesses.log.2023-12-15-13-18-27-23141-05.gz due to force rotation