Percona Server moved to https://jira.percona.com/projects/PS

  1. Bug #1358836
  2. Comment #1

Comment 1 for bug 1358836

Revision history for this message
Alexey Kopytov (akopytov) wrote : Re: Backup locks do not guarantee consistent SHOW SLAVE STATUS

We have a regression test case covering this very scenario, i.e. the one that checks that a DML against an InnoDB table on the master is blocked on an active BINLOG lock when being replayed on the slave (mysql-test/suite/rpl/t/rpl_backup_locks.test). The test case passes with all values of binlog_format.

Which means that either something is different between your environment and the one that the test case sets up, or there's a mistake in your tests.

Can you show the full output of SHOW SLAVE STATUS and the contents of the relay log on the slave corresponding to "before" and "after" values of Exec_Master_Log_Pos?