Comment 1 for bug 1047886

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote : Re: Adding --no-lock in wsrep_sst_xtrabackup causes SST to fail

Confirmed.

Now, this fails because,

from innobackupex:
===========
    if (!$option_no_lock) {
        # make a prep copy before locking tables, if using rsync
        backup_files(1);

        # flush tables with read lock
        mysql_lockall();
    }
=======

and write_galera_info is called from mysql_lockall

write_galera_info mainly does:

    # get binlog position
    mysql_send "SHOW STATUS LIKE 'wsrep_local_state_uuid';";
    mysql_send "SHOW STATUS LIKE 'wsrep_last_committed';";

Now, it needs to checked if above does require FTWRL or not.