Unable to backup MariaDB 10.0.3

MySQL & MariaDB Percona XtraBackup
1

I’m currently testing MariaDB 10.0.3 on my personal server. After building xtrabackup for innodb56 and running innobackupex --compress --incremental /directory I’ve got following errors:

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Ireland Ltd 2009-2012. All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

130616 10:33:40 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: NO).
130616 10:33:40 innobackupex: Connected to MySQL server
DBD::mysql::db selectall_hashref failed: Failed to load replication slave GTID position from table mysql.gtid_slave_pos at /usr/bin/innobackupex line 1431.
innobackupex: Error:
Error executing 'SHOW VARIABLES': DBD::mysql::db selectall_hashref failed: Failed to load replication slave GTID position from table mysql.gtid_slave_pos at /usr/bin/innobackupex line 1431.

Login credentials are specified in ~/.my.cnf, so I guess it’s not the issue. Any ideas?

2

Hi Barthalion,

Did you upgrade your MariaDB version recently?
There is known “SHOW VARIABLES” bug in MariaDB 10.0.3
[URL]https://mariadb.atlassian.net/browse/MDEV-4650[/URL]

It’s also described there:
[url]http://anothermysqldba.blogspot.com/2013/06/mariadb-1003-alpha-install-on-fedora-17.html[/url]

Check it please and if you have a similar case then a workaround is:

  • run mysql_upgrade
  • restart mysql