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.
Guillaume Hilt
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 (20131022 10:19:32.662) ... /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. -- Alexey Yurchenko, Codership Oy, www.codership.com Skype: alexey.yurchenko, Phone: +358-400-516-011