Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.12-galera
-
None
-
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.29OS: 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