[Maria-discuss] SST xtrabackup-v2 and 10.1.9-MariaDB-1~trusty-log' (InnoDB version: '5.6.26-74.0')
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
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
Dear Guillaume,
you made my day!
All the best,
Florian
________________________________
From: Guillaume Lefranc
participants (2)
-
Engelmann Florian -
Guillaume Lefranc