Bug #56478 --replicate-wild-do-table filter failed with error 1049
Submitted: 2 Sep 2010 3:04 Modified: 6 Oct 2010 21:03
Reporter: Daogang Qu Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.1+ OS:Any
Assigned to: CPU Architecture:Any

[2 Sep 2010 3:04] Daogang Qu
Description:
--replicate-wild-do-table filter failed with error 1049 when doing
replication.

How to repeat:
1. rpl_do_filter.test:
-- source include/master-slave.inc
-- source include/have_binlog_format_statement.inc

-- source extra/rpl_tests/rpl_filters.test

2. extra/rpl_tests/rpl_filters.test:
CREATE DATABASE mydb;
USE mydb;
CREATE TABLE T1 (a INT) ENGINE= MYISAM;
CREATE TABLE t2 (a INT) ENGINE= MYISAM;
INSERT INTO T1 VALUES (1);
INSERT INTO t2 VALUES (1);
-- echo # On master
-- source include/show_binlog_events.inc

-- sync_slave_with_master
-- echo # On slave
-- source include/show_binlog_events.inc

-- connection master
DROP DATABASE mydb;
-- sync_slave_with_master

3. rpl_do_filter-slave.opt

--replicate-do-db=MYDB --replicate-do-table=mydb.T1 --replicate-wild-do-table=mydb.T2 --lower_case_table_names=1

4. rpl_do_filter-master.opt
--lower_case_table_names=1

mysql-test$ ./mtr rpl_do_filter
rpl.rpl_do_filter 'stmt'                 [ fail ]
        Test ended at 2010-09-02 10:46:16

CURRENT_TEST: rpl.rpl_do_filter
=== SHOW MASTER STATUS ===
---- 1. ----
File	slave-bin.000001
Position	107
Binlog_Do_DB	
Binlog_Ignore_DB	
==========================

=== SHOW SLAVE STATUS ===
---- 1. ----
Slave_IO_State	Waiting for master to send event
Master_Host	127.0.0.1
Master_User	root
Master_Port	13000
Connect_Retry	1
Master_Log_File	master-bin.000001
Read_Master_Log_Pos	842
Relay_Log_File	slave-relay-bin.000003
Relay_Log_Pos	337
Relay_Master_Log_File	master-bin.000001
Slave_IO_Running	Yes
Slave_SQL_Running	No
Replicate_Do_DB	MYDB
Replicate_Ignore_DB	
Replicate_Do_Table	mydb.T1
Replicate_Ignore_Table	
Replicate_Wild_Do_Table	mydb.T2
Replicate_Wild_Ignore_Table	
Last_Errno	1049
Last_Error	Error 'Unknown database 'mydb'' on query. Default database: 'mydb'. Query: 'CREATE TABLE T1 (a INT) ENGINE= MYISAM'
[6 Sep 2010 21:03] Sveta Smirnova
Thank you for the report.

I can not repeat described behavior. Also this looks like bug #37656 for me. Please check and indicate tree where you see this result.
[6 Oct 2010 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".