[Openstack-operators] MySQL Binary Log Overflow

Kyle Robertson kyle at wei.com
Mon Nov 2 16:50:48 UTC 2015

Hello Everybody!

I am experimenting with a small Openstack cloud, and I have encountered a problem on multiple occasions where the MySQL database on one of my controllers fails to purge old mysql-bin.$NUMBER binary log files. These log files (among others) end up completely filling the root OS directory, causing any writes to the database to fail. I cannot log into mysql to purge the log files due to the following error: 

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have checked, and the socket file definitely does not exist. I can remove the logs by hand, but any attempts to restart the database afterwards fail due to the above error. Has anybody encountered this problem before and could anybody point me towards a solution?


Kyle Robertson
Cloud Architecture Intern
kyle at wei.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20151102/db81a674/attachment.html>

More information about the OpenStack-operators mailing list