← Back to team overview

maria-discuss team 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.

  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