Not the answer you need?
Register and ask your own question!

Socket file isn't created after reboot.

porunovporunov ContributorCurrent User Role Beginner
Hello,

Sometimes when node is shutdown not gracefully (power off). After boot it automatically starts a mysql. But a node state becomes:
Active: activating (start-post).

It doesn't changes and mysql doesn't work.

# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

The file /var/lib/mysql/mysql.sock isn't exists! Why it happens and how to start a node properly after crash failure (Other two nodes isn't crashed and works properly but the crashed node have a problem)? Crashed node can't connect to the working nodes. The can be connected together only if I stop all nodes and start them.

Sincerely,
Alexandr

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    Sounds like some mistake in the configuration file - can you attach my.cnf from all nodes? Please attach also this node error log, it should explain why the node cannot connect the cluster peers. And it won't create the socket file before it can properly join the other nodes, as the Galera connectivity is being established before the main MySQL is initialized.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.