maria-discuss team mailing list archive
Mailing list archive
Re: Synchronization down after reboot
On 2013-10-23 18:37, Guillaume Hilt wrote:
I fixed the issue bu replicating the mysql folder of the first node to
the others nodes.
I think the problem was caused one evening when all the node were
rebooted at the same time (the hypervisor hosting them was halted) and
didn't had time to send unregister from the other nodes.
Le 22/10/2013 10:46, Guillaume Hilt a écrit :
Oct 22 10:19:32 dev-sql-001 mysqld: WSREP_SST: [ERROR] innobackupex
finished with error: 1. Check /var/lib/mysql//innobackup.backup.log
/var/lib/mysql//innobackup.backup.log on node1 :
131022 10:19:32 innobackupex: Connecting to MySQL server with DSN
'dbi:mysql:;mysql_read_default_file=/etc/mysql/my.cnf;mysql_read_default_group=xtrabackup;mysql_socket=/var/run/mysqld/mysqld.sock' as 'root' (using password: YES).
innobackupex: Error: Failed to connect to MySQL server: DBI
connect(';mysql_read_default_file=/etc/mysql/my.cnf;mysql_read_default_group=xtrabackup;mysql_socket=/var/run/mysqld/mysqld.sock','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /usr//bin/innobackupex line 2902
Well, you seem to have broken privileges for xtrabackup. Either you
changed the password, or changed privileges, or... Unless you fix those
you're likely to hit the same problem next time a node will need SST.
Codership Oy, www.codership.com
Skype: alexey.yurchenko, Phone: +358-400-516-011