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.phpREPAIR TABLE TableName
So, logging in to the
mysql -u root -p
prompt, did that, and issue solved.
No comments:
Post a Comment