[MDEV-9708] innobackupex: Error: Unsupported server version 10.1.12-MariaDB-1~jessie Created: 2016-03-10  Updated: 2016-03-11  Resolved: 2016-03-11

Status: Closed
Project: MariaDB Server
Component/s: Packaging
Affects Version/s: 10.1.12
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Matyashov Andrey Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

OS: Debian 8.3 (jessie)
Server: 10.1.12-MariaDB-1~jessie
xtrabackup: 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
innobackupex: v1.5.1-xtrabackup

Attachments: File innobackupex.patch    

 Description   

root@mariadb-01:~# /usr/bin/innobackupex --version
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.

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

root@mariadb-01:~# xtrabackup --version
xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )

root@mariadb-01:~# /usr/bin/innobackupex --no-version-check --user=root --password=MY_PASSWORD --socket=/var/run/mysqld/mysqld.sock --galera-info --stream=xbstream /tmp/tmp.iR1tuzvbYx --defaults-file=/etc/mysql/my.cnf

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.

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

160310 13:07:18 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).
160310 13:07:18 innobackupex: Connected to MySQL server
innobackupex: Error: Unsupported server version: '10.1.12-MariaDB-1~jessie' Please report a bug at https://bugs.launchpad.net/percona-xtrabackup

Attached patch fix this bug and fix bug with executing query on locked tables.

innobackupex: Executing FLUSH ENGINE LOGS...
 
DBD::mysql::db do failed: Can't execute the query because you have a conflicting read lock at /usr//bin/innobackupex line 3059.
 
innobackupex: Error:
 
Error executing 'FLUSH ENGINE LOGS': DBD::mysql::db do failed: Can't execute the query because you have a conflicting read lock at /usr//bin/innobackupex line 3059.
 
innobackupex: Waiting for ibbackup (pid=32527) to finish
 
innobackupex finished with error: 9.  Check /var/lib/mysql//innobackup.backup.log
 
Cleanup after exit with status:22
 
Cleaning up temporary directories



 Comments   
Comment by Nirbhay Choubey (Inactive) [ 2016-03-10 ]

The Xtrabackup version seems old. Could you upgrade at least to 2.2.13 (as suggested in the bug below), and see if that resolves the issue?

https://bugs.launchpad.net/percona-xtrabackup/+bug/1539533

I also see that a check for 10.0/10.1 is already in place :
https://github.com/percona/percona-xtrabackup/blob/2.2/storage/innobase/xtrabackup/innobackupex.pl#L4790

Comment by Matyashov Andrey [ 2016-03-10 ]

In xtrabackup-v2.2.13 it works.

In xtrabackup-v2.2.3 and script https://github.com/percona/percona-xtrabackup/blob/2.2/storage/innobase/xtrabackup/innobackupex.pl#L4790 not works, see log.

Mar 10 22:06:26 mariadb-01 -wsrep-sst-donor: Streaming with xbstream
 
Mar 10 22:06:26 mariadb-01 -wsrep-sst-donor: Using socat as streamer
 
Mar 10 22:06:26 mariadb-01 -wsrep-sst-donor: Using /tmp/tmp.FxlzFafDIW as innobackupex temporary directory
 
Mar 10 22:06:26 mariadb-01 -wsrep-sst-donor: Streaming GTID file before SST
 
Mar 10 22:06:26 mariadb-01 -wsrep-sst-donor: Evaluating xbstream -c ${INFO_FILE} | socat -u stdio TCP:10.100.22.52:4444; RC=( ${PIPESTATUS[@]} )
 
Mar 10 22:06:26 mariadb-01 -wsrep-sst-donor: Sleeping before data transfer for SST
 
Mar 10 22:06:36 mariadb-01 -wsrep-sst-donor: Streaming the backup to joiner at 10.100.22.52 4444
 
Mar 10 22:06:36 mariadb-01 -wsrep-sst-donor: Evaluating innobackupex     $tmpopts $INNOEXTRA --galera-info --stream=$sfmt $itmpdir 2> >(logger -p daemon.err -t -innobackupex-backup) | socat -u stdio TCP:10.100.22.52:4444; RC=( ${PIPESTATUS[@]} )
 
Mar 10 22:06:36 mariadb-01 -innobackupex-backup: Possible unintended interpolation of @XB_DISTRIBUTION in string at /usr//bin/innobackupex line 1639.
 
Mar 10 22:06:36 mariadb-01 -wsrep-sst-donor: innobackupex finished with error: 255.  Check /var/lib/mysql//innobackup.backup.log
 
Mar 10 22:06:36 mariadb-01 -wsrep-sst-donor: Cleanup after exit with status:22
 
Mar 10 22:06:36 mariadb-01 -wsrep-sst-donor: Cleaning up temporary directories

Maybe need update package percona-xtrabackup to v2.2.13 in your repositories?
Thanks!

Comment by Nirbhay Choubey (Inactive) [ 2016-03-10 ]

Where did you get the xtrabackup package from?

sudo apt-cache policy percona-xtrabackup

Comment by Matyashov Andrey [ 2016-03-10 ]

I downloads this package from percona site ( https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.2.13/binary/debian/jessie/x86_64/percona-xtrabackup-22_2.2.13-1.jessie_amd64.deb ).

Comment by Elena Stepanova [ 2016-03-10 ]

sys.admin, You've downloaded 2.2.13 from Percona site, but where did 2.2.3 come from?
MariaDB does not ship xtrabackup, so most likely you got it from the official Debian repo, the version fits. If so, please address your request to Debian, there is nothing MariaDB can do.

Comment by Matyashov Andrey [ 2016-03-11 ]

i'm sorry, i thought, this package from your repository. Thanks for your answers!

Generated at Thu Feb 08 07:36:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.