slave_skip_errors=1146 and can also get Last_SQL_Errno: 1146 table not exists
Bug #1171859 reported by
ypli
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:
slave my.cnf:
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
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.