[MDEV-6490] mysqldump unknown option --galera-sst-mode - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0.12-galera
Fix Version/s: 10.0.13
Component/s: None
Labels:
- galera
Environment:

Hide
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

Show
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

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.

Attachments

Issue Links

relates to

MDEV-6316 Fix mysqldump SST method to transfer binlog state to the joiner

Closed

Activity

Transition	Time In Source Status	Execution Times

Nirbhay Choubey (Inactive) made transition - 2014-08-01 06:12

Open

In Progress

6d 8h 33m

Sergei Golubchik made transition - 2014-08-06 17:01

In Progress

In Review

5d 10h 49m

Sergei Golubchik made transition - 2014-08-06 17:02

In Review

Stalled

11s

Nirbhay Choubey (Inactive) made transition - 2014-08-07 02:45

Stalled

Closed

9h 43m

People

Assignee:: Nirbhay Choubey (Inactive)

Reporter:: Michael Both

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2014-07-25 21:38

Updated:: 2014-08-07 22:29

Resolved:: 2014-08-07 02:45

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server