maria-discuss team mailing list archive

[Alex Yurchenko <alexey.yurchenko@xxxxxxxxxxxxx>]

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