Bug #2542 If slave ignores a query it may make the next LOAD DATA INFILE fail
Submitted: 28 Jan 2004 6:25 Modified: 28 Jan 2004 7:11
Reporter: Guilhem Bichot Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:4.1.1 OS:Any (all)
Assigned to: Guilhem Bichot CPU Architecture:Any

[28 Jan 2004 6:25] Guilhem Bichot
See how-to-repeat

How to repeat:
Start mysqld on the slave with --replicate-wild-ignore-table=db1.%.
On master do
create database db2;
create table db2.t (a int);
create database db1;
create table db1.t (a int);
insert into db1.t values(1);
load data infile 'some_file' into table db2.t;
you'll get on slave:
040128 14:29:18  Slave: Error 'Slave SQL thread ignored the query because of replicate-*-table rules' running LOAD DATA INFILE

Suggested fix:
I will fix it now.
Though it is repeatable in 4.1.1, the wrong code is in 4.0; but in 4.1.1 some other code than replication was changed, which makes this wrong code execute.
So I'll fix the bug in 4.0.
[28 Jan 2004 6:29] Guilhem Bichot
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at

Additional info:

Fixed in 4.0 source tree:
ChangeSet@1.1686.1.1, 2004-01-28 15:26:01+01:00, guilhem@mysql.com