slave_skip_errors=1146 and can also get Last_SQL_Errno: 1146 table not exists

Bug #1171859 reported by ypli
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Won't Fix
Medium
Unassigned
5.5
Triaged
Medium
Unassigned
5.6
Fix Released
Medium
Unassigned
5.7
Fix Released
Medium
Unassigned

Bug Description

master my.cnf:binlog_format=mixed
slave my.cnf:slave_skip_errors=1146

master has a table t1(a datetime)
slave doesn't need this table ,and drop the table , skip error 1146;

Run sql in master :insert into t1 values(sysdate());
slave has a error:
   Last_SQL_Errno: 1146
   Last_SQL_Error: Error executing row event: 'Table 'test.t1' doesn't exist'

percona5.5.29 and can also repeat 5.6.10

Revision history for this message
Alexey Kopytov (akopytov) wrote :

Upstream bug http://bugs.mysql.com/bug.php?id=64794. This example is with binlog_format=mixed, but SYSDATE() in INSERT triggers an RBR event.

tags: added: upstream
tags: added: i50799
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Upstream fix in 5.6.32 and 5.7.14

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1357

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.