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:
Type the following command:
/opt/vertica/bin/admintools -t logrotate -d <db name> -r <HowOften> -k <number of weeks>
/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.