logger_mysqld.log is HUGE

[castellan]

My logger_mysqld.log file is 119 GB (yes, Gigabytes) and growing. Zimbra is installed on a 250GB hard drive and I'm beginning to eye it nervously.

Any ideas what might be going on?

[brian]

What are the last lines of the log? Unfortunately we don't automatically rotate this log file. If you want to rotate it by hand log in as zimbra and run these.

mv logger_mysqld.log logger_mysqld.log.old
touch logger_mysqld.log
logmysqladmin flush-logs

At this point you can inspect the log (tail -10 logger_mysqld.log) and post the ressults and/or delete it to free up the space.

[castellan]

Turns out I had a corrupt database and the logfile was filling up with errors. I've followed the procedure above as well as running the "zmloggerinit" procedure from elsewhere in the forums to clear up the issue. No more error reports.

[brian]

sorry to hear about the corruption, but good to hear you have everything back up and running.