diff options
| author | Alfranio Correia <alfranio.correia@sun.com> | 2009-07-06 09:02:14 +0100 |
|---|---|---|
| committer | Alfranio Correia <alfranio.correia@sun.com> | 2009-07-06 09:02:14 +0100 |
| commit | 508fe9dd15ff28ed0d692c00e87d0b6836ea4836 (patch) | |
| tree | 28e07e2f08480564a17d6a9697e39cd2781feaea /sql/slave.h | |
| parent | 7f1715a7c7645e89306303418f05e9a6d056f5a1 (diff) | |
| download | mariadb-git-508fe9dd15ff28ed0d692c00e87d0b6836ea4836.tar.gz | |
BUG#44581 Slave stops when transaction with non-transactional table gets lock wait
timeout
In STMT and MIXED modes, a statement that changes both non-transactional and
transactional tables must be written to the binary log whenever there are
changes to non-transactional tables. This means that the statement gets into the
binary log even when the changes to the transactional tables fail. In particular
, in the presence of a failure such statement is annotated with the error number
and wrapped in a begin/rollback. On the slave, while applying the statement, it
is expected the same failure and the rollback prevents the transactional changes
to be persisted.
Unfortunately, statements that fail due to concurrency issues (e.g. deadlocks,
timeouts) are logged in the same way causing the slave to stop as the statements
are applied sequentially by the SQL Thread. To fix this bug, we automatically
ignore concurrency failures on the slave. Specifically, the following failures
are ignored: ER_LOCK_WAIT_TIMEOUT, ER_LOCK_DEADLOCK and ER_XA_RBDEADLOCK.
Diffstat (limited to 'sql/slave.h')
| -rw-r--r-- | sql/slave.h | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/sql/slave.h b/sql/slave.h index 160418955b5..a44a7eed83e 100644 --- a/sql/slave.h +++ b/sql/slave.h @@ -171,7 +171,6 @@ bool rpl_master_has_bug(const Relay_log_info *rli, uint bug_id, bool report, bool rpl_master_erroneous_autoinc(THD* thd); const char *print_slave_db_safe(const char *db); -int check_expected_error(THD* thd, Relay_log_info const *rli, int error_code); void skip_load_data_infile(NET* net); void end_slave(); /* release slave threads */ |