My vertica.log keeps growing in size

Document ID : KB000031680
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem: The /catalog/drdata/v_drdata_node0001_catalog/vertica.log log keeps growing and fills up the space in the partition. The vertica database is down as there is no more space left in the partition.

Cause: The log rotation is not enabled for vertica.log

Solution: Log in to the database server for Data Repository as the database administrator user. Type the following command:

su - dradmin

Type the following command:

/opt/vertica/bin/admintools -t logrotate -d <db name> -r <HowOften> -k <number of weeks>

Example

/opt/vertica/bin/admintools -t logrotate -d drdata -r daily -k 3
  • -d indicates the database name.
  • -r indicates how often to rotate the logs (daily, weekly, monthly).
  • -k indicates the number of weeks to keep the log.

Data Repository log rotation is now set up to occur daily, and only three weeks of log files are maintained.

These steps are mentioned in the installation guide and therefore can be done just after vertica installation.