Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0.12-galera
-
Fix Version/s: 10.0.13-galera
-
Component/s: None
-
Environment:ubuntu 14.04
lxc
Description
wsrep_sst_rsync can't be used.
Jul 27 01:38:25 mgc_1 mysqld: 140727 1:38:25 [Note] WSREP: Tables flushed. Jul 27 01:38:25 mgc_1 mysqld: 140727 1:38:25 [Warning] WSREP: error executing 'SET GLOBAL innodb_disallow_writes=1': 1193 (Unknown system variable 'innodb_disallow_writes'). Was mysqld built wi th --with-innodb-disallow-writes ? Jul 27 01:38:25 mgc_1 mysqld: 140727 1:38:25 [ERROR] WSREP: Failed to disallow InnoDB writes Jul 27 01:39:08 mgc_1 mysqld: tail: »mysqld-bin.index“ kann nicht zum Lesen geöffnet werden: Datei oder Verzeichnis nicht gefunden Jul 27 01:39:08 mgc_1 mysqld: 140727 1:39:08 [ERROR] WSREP: Failed to read from: wsrep_sst_rsync --role 'donor' --address '10.0.3.110:4444/rsync_sst' --auth '(null)' --socket '/var/run/mysqld/m ysqld.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --binlog 'mysqld-bin' --gtid '061d9f9a-145a-11e4-b219-2b644d4c7e86:0' Jul 27 01:39:08 mgc_1 mysqld: 140727 1:39:08 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'donor' --address '10.0.3.110:4444/rsync_sst' --auth '(null)' --socket '/var/run /mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --binlog 'mysqld-bin' --gtid '061d9f9a-145a-11e4-b219-2b644d4c7e86:0': 1 (Operation not permitted) Jul 27 01:39:08 mgc_1 mysqld: 140727 1:39:08 [Warning] WSREP: error executing 'SET GLOBAL innodb_disallow_writes=0': 1193 (Unknown system variable 'innodb_disallow_writes'). Was mysqld built wi th --with-innodb-disallow-writes ? Jul 27 01:39:08 mgc_1 mysqld: 140727 1:39:08 [ERROR] WSREP: Failed to disallow InnoDB writes Jul 27 01:39:08 mgc_1 mysqld: 140727 1:39:08 [Note] WSREP: resuming provider at 25
And yes there is no support for innodb_disallow_writes
ariaDB [(none)]> SET GLOBAL innodb_disallow_writes=1; ERROR 1193 (HY000): Unknown system variable 'innodb_disallow_writes'
So every sst using "flush tables" is going to fail 
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
>> Jul 27 01:39:08 mgc_1 mysqld: tail: »mysqld-bin.index“ kann nicht zum Lesen geöffnet werden: Datei oder Verzeichnis nicht gefunden
Why is "mysqld-bin.index" missing?
Ahoi Nirbhay,
most likely because wsrep_sst.cc checks for log_bin. So it is going to fail if you can't generate log_bin_index from log_bin 
Ok to push.
Fix pushed to maria-10.0-galera.
http://bazaar.launchpad.net/~maria-captains/maria/maria-10.0-galera/revision/3866
It looks like wsrep_sst.cc did get the right binlog suffix... --binlog 'mysqld-bin' .. but wsrep_sst_rsync script couldn't find it :
.. snip ..
binlog_files_full=$(tail -n $BINLOG_N_FILES $
.index)
.. snip ..
We might have to switch to InnoDB as default "InnoDB".