[MDEV-3525] LP:903798 - slave-skip-errors ignored in RBR mode. Created: 2011-12-13 Updated: 2014-12-05 Resolved: 2012-10-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Trivial |
| Reporter: | Alexey Zilber (Inactive) | Assignee: | Kristian Nielsen |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | Launchpad | ||
| Attachments: |
|
| Description |
|
This looks like a bug that was fixed in Mysql 5.1.35. I just hit it in MariaDB 5.2.10. I'm experiencing identical behavior to the bug filed here: http://bugs.mysql.com/bug.php?id=39393 To replicate the error, I have 1 master, and 1 slave. All servers have binlog_format = MIXED and slave-skip-errors=all On slave 1, drop a database. Slave 1 will report: Last_SQL_Errno: 1146 -Alex |
| Comments |
| Comment by Elena Stepanova [ 2011-12-14 ] |
|
Re: slave-skip-errors ignored in RBR mode. I am trying the scenario that you and Sveta described in the MySQL bug, and it works all right for me, both on MariaDB 5.2.10 and MySQL 5.1.60. However, a slightly different one, which involves DDL, fails, also both on MariaDB and MySQL, with the exact error that you mentioned. Something like this: SET binlog_format='row';
Could you please confirm that's what you encountered? I suppose this flow has never been fixed, or possibly was broken again. I It fails on MySQL 5.1.60 and 5.1.57, but I don't have older versions to check. |
| Comment by Elena Stepanova [ 2012-01-12 ] |
|
Re: slave-skip-errors ignored in RBR mode.
--source include/master-slave.inc SET binlog_format='row'; CREATE TABLE t ( i INT ); SET SQL_LOG_BIN=1; --sync_slave_with_master
|
| Comment by Elena Stepanova [ 2012-01-12 ] |
|
Re: slave-skip-errors ignored in RBR mode. Assigning to Monty to decide whether it is to be fixed in MariaDB (any of the versions) or filed for MySQL. |
| Comment by Kristian Nielsen [ 2012-04-02 ] |
|
Re: slave-skip-errors ignored in RBR mode. Unfortunately, this is not a priority for me to work on at the moment. When MySQL will fix it, we will merge the patch. Or if someone else makes a patch, I would be happy to review + apply. |
| Comment by Rasmus Johansson (Inactive) [ 2012-04-02 ] |
|
Launchpad bug id: 903798 |