[MDEV-6490] mysqldump unknown option --galera-sst-mode Created: 2014-07-25  Updated: 2014-08-07  Resolved: 2014-08-07

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.12-galera
Fix Version/s: 10.0.13

Type: Bug Priority: Major
Reporter: Michael Both Assignee: Nirbhay Choubey (Inactive)
Resolution: Fixed Votes: 0
Labels: galera
Environment:

OS: Ubuntu 14.04 inside Docker Container and installation like this:
apt-get install -y software-properties-common
apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
add-apt-repository 'deb http://ftp.hosteurope.de/mirror/mariadb.org/repo/10.0/ubuntu trusty main'
apt-get update && apt-get install -y mariadb-galera-server galera

Currently installed versions are:
mariadb-client-10.0 10.0.12+maria-1~trusty
mariadb-client-core-10.0 10.0.12+maria-1~trusty
mariadb-common 10.0.12+maria-1~trusty
mariadb-galera-server-10.0 10.0.12+maria-1~trusty
libmariadbclient18 10.0.12+maria-1~trusty

Additional configuration done:
[client]
default-character-set = utf8

[mysqld]
bind-address=0.0.0.0
character-set-server = utf8
collation-server = utf8_general_ci
character_set_server = utf8
collation_server = utf8_general_ci
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
query_cache_size=0
query_cache_type=0
general_log_file = /var/log/mysql/mysql.log
general_log = 1
slow_query_log_file = /var/log/mysql/mariadb-slow.log
log_error=/var/log/mysql/mysql_error.log

Other options are set when running mysqld_safe:

--wsrep_provider=/usr/lib/galera/libgalera_smm.so
--wsrep_cluster_name=test_cluster
--wsrep_node_name=$(hostname)
--wsrep_node_address=$(getip)
--wsrep_sst_method=mysqldump
--wsrep_sst_auth=root:MYSQL_ROOT_PASSWORD
--wsrep_cluster_address=gcomm://172.17.0.29

Issue Links:
Relates
relates to MDEV-6316 Fix mysqldump SST method to transfer ... Closed

 Description   

wsrep_sst_method=mysqldump does not work oob.

It fails on donor side with
[...]
140725 17:16:24 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
mysqldump: unknown option '--galera-sst-mode'
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SST failed to comp
lete' at line 1
140725 17:16:25 [ERROR] WSREP: Process completed with error: wsrep_sst_mysqldump --user 'root' --password '' --host '172.17.0.29' --port '3306' --local-p
ort '3306' --socket '/run/mysqld/mysqld.sock' --defaults-file '/etc/mysql/my.cnf' --gtid '730429aa-141d-11e4-bc5d-cbe43f5cf0ac:0': 1 (Operation not permitted)

Deleting the flag "--galera-sst-mode" out of the corresponding mysqldump call in wsrep_sst_mysqldump lets the SST complete.
It seems related to https://mariadb.atlassian.net/browse/MDEV-6316
But I'm not sure whether the reported bug in MDEV-6316 is still present after removing the flag as I don't use log_slave_updates right now.

 Comments   
Comment by Nirbhay Choubey (Inactive) [ 2014-08-05 ]

Patch committed: http://lists.askmonty.org/pipermail/commits/2014-August/006390.html

Comment by Sergei Golubchik [ 2014-08-06 ]

ok to push

Comment by Nirbhay Choubey (Inactive) [ 2014-08-07 ]

Fix pushed to 10.0 branch.

http://bazaar.launchpad.net/~maria-captains/maria/10.0/revision/4341

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