Saturday, March 17, 2007

Sai Inspires backups and hard disk space

From PB: Found that sai inspires messages have not been sent for the day - 9th March. Restarted mysqld and httpd (mysqld failed to start). tail /var/log/mysqld/mysqld.log showed [ERROR] Can't start server: can't create PID file: No space left on device. /var was full. Moving apachebounces cleared up nearly 2 GB, restarted mysqld... it started. But sending messages with processqueue still failed, with [ERROR] /usr/sbin/mysqld: Can't open file: 'phplist_bounce.MYI' (errno: 145). tail /var/log/mysqld/mysqld.log showed [ERROR] /usr/sbin/mysqld: Can't open file: 'query_log.MYI and so on. Googling gave solution http://www.redrook.com/faqs/mysql-error-cant-open-file-something.myd-errno-145.php
REPAIR TABLE TableName

So, logging in to the
mysql -u root -p 
prompt, did that, and issue solved.

No comments:

Post a Comment