Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3325

LP:818149 - Incompatibility with Percona Xtrabackup

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      Using Maria DB 5.2.7 + Percona Xtrabackup 1.6.2-274 I was unable to backup data (see below).

      Errors:
      root@ubuntu /tmp > /usr/bin/innobackupex --defaults-file='/etc/mysql/my.cnf' --password='*****************' --user='root' --host='localhost' --port='3306' --socket='/var/run/mysqld/mysqld.sock' /backup/db_full

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

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

      110729 10:45:41 innobackupex: Starting mysql with options: --defaults-file='/etc/mysql/my.cnf' --password='******************' --user='root' --host='localhost' --port='3306' --socket='/var/run/mysqld/mysqld.sock' --unbuffered –
      110729 10:45:41 innobackupex: Connected to database with mysql child process (pid=7070)
      110729 10:45:47 innobackupex: Connection to database server closed
      IMPORTANT: Please check that the backup run completes successfully.
      At the end of a successful backup run innobackupex
      prints "completed OK!".

      innobackupex: Using mysql Ver 14.16 Distrib 5.2.7-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
      innobackupex: Using mysql server version This software comes with ABSOLUTELY NO WARRANTY. This is free software,

      innobackupex:: Warning: Ignored unrecognized line 2 in options : 'xtrabackup: Error: Please set parameter 'datadir'
      '
      innobackupex: fatal error: no 'mysqld' group in MySQL options
      innobackupex: fatal error: OR no 'datadir' option in group 'mysqld' in MySQL options

      I was able to fix the problem thanks to the suggestion of Wlad on Freenode/#mariadb.

      The fix is as follows:

      In /etc/mysql/my.cnf change "[server]" to "[mysqld]"

      Wlad also indicated this issue caused other software to not work such as sql workbench.

      Please consider changing this in the future to avoid compatibility issues with other software that expects "[mysqld]".

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            wlad Vladislav Vaintroub added a comment -

            Re: Incompatibility with Percona Xtrabackup
            Changed my.cnf templates to have [mysqld] section instead of [server] for better compatibility with existing 3rd party tools.

            Show
            wlad Vladislav Vaintroub added a comment - Re: Incompatibility with Percona Xtrabackup Changed my.cnf templates to have [mysqld] section instead of [server] for better compatibility with existing 3rd party tools.
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 818149

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 818149

              People

              • Assignee:
                wlad Vladislav Vaintroub
                Reporter:
                mariadb_user mariadb_user
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: