Dear Guillaume,

you made my day!

All the best,
Florian



From: Guillaume Lefranc <guillaume.lefranc@mariadb.com>
Sent: Monday, December 7, 2015 7:04 PM
To: Engelmann Florian; maria-discuss@lists.launchpad.net
Subject: Re: [Maria-discuss] SST xtrabackup-v2 and 10.1.9-MariaDB-1~trusty-log' (InnoDB version: '5.6.26-74.0')
 
Hi Florian,

try with the 2.2 branch of xtrabackup. Apparently the one you're using does not recognize MariaDB 10.1.

Best regards,

On Mon, Dec 7, 2015 at 7:01 PM Engelmann Florian <florian.engelmann@everyware.ch> wrote:
Dear list,

this is my 1st time testing Galera Cluster with MariaDB 10.1. With version 10.1.9 I get the following error using xtrabackup-v2 for SST:

Dec  7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140026872588032 [Note] WSREP: Member 1.0 () requested state transfer from '*any*'. Selected 0.0 ()(SYNCED) as donor.
Dec  7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140026872588032 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 0)
Dec  7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140027564807936 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
Dec  7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140026000176896 [Note] WSREP: Running: 'wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/'    --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0''
Dec  7 18:32:21 wsc-db01a-test mysqld: 2015-12-07 18:32:21 140027564807936 [Note] WSREP: sst_donor_thread signaled with 0
Dec  7 18:32:22 wsc-db01a-test mysqld: WSREP_SST: [INFO] Logging all stderr of SST/Innobackupex to syslog (20151207 18:32:22.249)
Dec  7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Streaming with xbstream
Dec  7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Using socat as streamer
Dec  7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Using /tmp/tmp.l5q4N6ELOD as innobackupex temporary directory
Dec  7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Streaming GTID file before SST
Dec  7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Evaluating xbstream -c ${INFO_FILE} | socat -u stdio TCP:10.1.234.223:4444; RC=( ${PIPESTATUS[@]} )
Dec  7 18:32:22 wsc-db01a-test -wsrep-sst-donor: Sleeping before data transfer for SST
Dec  7 18:32:23 wsc-db01a-test mysqld: 2015-12-07 18:32:23 140026880980736 [Note] WSREP: (6b6485fa, 'tcp://0.0.0.0:4567') turning message relay requesting off
Dec  7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Streaming the backup to joiner at 10.1.234.223 4444
Dec  7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Evaluating innobackupex   --no-version-check  $tmpopts $INNOEXTRA --galera-info --stream=$sfmt $itmpdir 2> >(logger -p daemon.err -t -innobackupex-backup) | socat -u stdio TCP:10.1.234.223:4444; RC=( ${PIPESTATUS[@]} )
Dec  7 18:32:32 wsc-db01a-test -innobackupex-backup:
Dec  7 18:32:32 wsc-db01a-test -innobackupex-backup: InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
Dec  7 18:32:32 wsc-db01a-test -innobackupex-backup: and Percona LLC and/or its affiliates 2009-2013.  All Rights Reserved.
Dec  7 18:32:32 wsc-db01a-test -innobackupex-backup:
Dec  7 18:32:32 wsc-db01a-test -innobackupex-backup: This software is published under
Dec  7 18:32:32 wsc-db01a-test -innobackupex-backup: the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
Dec  7 18:32:32 wsc-db01a-test -innobackupex-backup:
Dec  7 18:32:32 wsc-db01a-test -innobackupex-backup: Get the latest version of Percona XtraBackup, documentation, and help resources:
Dec  7 18:32:32 wsc-db01a-test -innobackupex-backup: http://www.percona.com/xb/ubuntu
Dec  7 18:32:32 wsc-db01a-test -innobackupex-backup:
Dec  7 18:32:32 wsc-db01a-test -innobackupex-backup: 151207 18:32:32  innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/var/run/mysqld/mysqld.sock' as 'sstuser'  (using password: NO).
Dec  7 18:32:32 wsc-db01a-test -innobackupex-backup: 151207 18:32:32  innobackupex: Connected to MySQL server
Dec  7 18:32:32 wsc-db01a-test -innobackupex-backup: innobackupex: Error: Unsupported server version: '10.1.9-MariaDB-1~trusty-log' (InnoDB version: '5.6.26-74.0'). Please report a bug at https://bugs.launchpad.net/percona-xtrabackup
Dec  7 18:32:32 wsc-db01a-test -wsrep-sst-donor: innobackupex finished with error: 1.  Check /var/lib/mysql//innobackup.backup.log
Dec  7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Cleanup after exit with status:22
Dec  7 18:32:32 wsc-db01a-test -wsrep-sst-donor: Cleaning up temporary directories
Dec  7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026000176896 [ERROR] WSREP: Failed to read from: wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/'    --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0'
Dec  7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026000176896 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/'    --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0': 22 (Invalid argument)
Dec  7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026000176896 [ERROR] WSREP: Command did not run: wsrep_sst_xtrabackup-v2 --role 'donor' --address '10.1.234.223:4444/xtrabackup_sst//1' --socket '/var/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/'    --binlog '/var/log/mysql/mariadb-bin' --gtid 'd714578b-9d06-11e5-b89b-2b7551505c87:0' --gtid-domain-id '0'
Dec  7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026872588032 [Warning] WSREP: 0.0 (): State transfer to 1.0 () failed: -22 (Invalid argument)
Dec  7 18:32:32 wsc-db01a-test mysqld: 2015-12-07 18:32:32 140026872588032 [Note] WSREP: Shifting DONOR/DESYNCED -> JOINED (TO: 0)
Dec  7 18:32:33 wsc-db01a-test mysqld: 2015-12-07 18:32:33 140026872588032 [Note] WSREP: Member 0.0 () synced with group.
Dec  7 18:32:33 wsc-db01a-test mysqld: 2015-12-07 18:32:33 140026872588032 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0)

My 90-galera.cnf looks like:

[mysqld]
query_cache_size = 0
binlog_format = ROW
default_storage_engine = InnoDB
innodb_autoinc_lock_mode = 2
innodb_doublewrite = 1
server_id = 100
innodb_flush_log_at_trx_commit = 0
wsrep_on = ON
wsrep_provider_options = "gcache.size=512M;pc.recovery=TRUE"
wsrep_cluster_address = "gcomm://10.1.234.222,10.1.234.223,10.1.234.224,10.1.234.225"
wsrep_cluster_name = dba
wsrep_sst_method = "xtrabackup-v2"
#wsrep_sst_method = "rsync"
wsrep_sst_auth = "sstuser:xxxxxxxxxxxxxxxxxxxxxxx"
wsrep_provider = "/usr/lib/galera/libgalera_smm.so"
wsrep_slave_threads = 4
wsrep_node_address = 10.1.234.221
wsrep_node_incoming_address = 10.0.234.221

With wsrep_sst_method = "rsync" SST works fine.

Did I miss something?

All the best,
Florian
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp
--
Guillaume Lefranc
Remote DBA Services Manager
MariaDB Corporation