maria-discuss team mailing list archive

[Guillaume Lefranc <guillaume.lefranc@xxxxxxxxxxx>]

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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
-- 
Guillaume Lefranc
Remote DBA Services Manager
MariaDB Corporation