Look for an option called "socket" in your my.cnf which will point you to
the correct location of the socket file.

On 2 November 2015 at 22:20, Kyle Robertson <[email protected]> wrote:

> 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?
>
> Thanks!
>
> Kyle Robertson
> Cloud Architecture Intern
> [email protected]
> 603-566-4761
>
>
>
>
>
>
>
> _______________________________________________
> OpenStack-operators mailing list
> [email protected]
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
>
>


-- 
You can't be normal and expect abnormal returns - Jeffrey Pfeffer
------------------------------------------
http://code.deepinspace.net
------------------------------------------
_______________________________________________
OpenStack-operators mailing list
[email protected]
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

Reply via email to