diff options
| author | mkaruza <mario.karuza@galeracluster.com> | 2019-01-22 00:30:50 +0100 |
|---|---|---|
| committer | Sergey Vojtovich <svoj@mariadb.org> | 2019-01-23 00:17:42 +0400 |
| commit | ea6703d2d5f1293e3a58bc92fb6d867e10313514 (patch) | |
| tree | 00ca186ce2cfdc3ab7e4979336a384e2b51c5aa9 | |
| parent | 07c2976a5542ecf77734df3b6b92e37e64908724 (diff) | |
| download | mariadb-git-bb-10.4-galera4.tar.gz | |
Fixed wsrep_sst_mysqldump script when executing while wsrep_on=ONbb-10.4-galera4
If LOG_BIN is enabled on joiner side, we will execute two additional commands:
1. RESET MASTER
2. SET @@global.gtid_binlog_state='$GTID_BINLOG_STATE'
Command will fail if global.wsrep_on=ON. So we need to temporary disable it.
| -rw-r--r-- | scripts/wsrep_sst_mysqldump.sh | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/scripts/wsrep_sst_mysqldump.sh b/scripts/wsrep_sst_mysqldump.sh index 10663216ca5..d36deb5759f 100644 --- a/scripts/wsrep_sst_mysqldump.sh +++ b/scripts/wsrep_sst_mysqldump.sh @@ -139,8 +139,8 @@ then # turned off for the session so that gtid state does not get altered while # the dump gets replayed on joiner. if [[ "$LOG_BIN" == 'ON' ]]; then - RESET_MASTER="RESET MASTER;" - SET_GTID_BINLOG_STATE="SET @@global.gtid_binlog_state='$GTID_BINLOG_STATE';" + RESET_MASTER="SET GLOBAL wsrep_on=OFF; RESET MASTER; SET GLOBAL wsrep_on=ON;" + SET_GTID_BINLOG_STATE="SET GLOBAL wsrep_on=OFF; SET @@global.gtid_binlog_state='$GTID_BINLOG_STATE'; SET GLOBAL wsrep_on=ON;" SQL_LOG_BIN_OFF="SET @@session.sql_log_bin=OFF;" fi fi |