Announcement

Announcement Module
Collapse
No announcement yet.

Unable to backup MariaDB 10.0.3

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Unable to backup MariaDB 10.0.3

    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:
    Code:
    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
    https://mariadb.atlassian.net/browse/MDEV-4650

    It's also described there:
    http://anothermysqldba.blogspot.com/...fedora-17.html

    Check it please and if you have a similar case then a workaround is:
    - run mysql_upgrade
    - restart mysql

    Comment

    Working...
    X