# Replication Warning  when replicating with replicate-ignore-db.

**URL:** <https://forums.percona.com/t/replication-warning-when-replicating-with-replicate-ignore-db/4098>\
**Category:** Other MySQL® Questions\
**Created:** [March 11, 2015, 2:48am UTC](https://forums.percona.com/t/replication-warning-when-replicating-with-replicate-ignore-db/4098 "2015-03-11T02:48:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![singh](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/singh/32/1058_2.png) [@singh](https://forums.percona.com/u/singh)\
**Post date:** [March 11, 2015, 2:48am UTC](https://forums.percona.com/t/replication-warning-when-replicating-with-replicate-ignore-db/4098/1 "2015-03-11T02:48:18Z")

</div>

When trying to replicate from 5.5(Percona-Server-5.5.28-rel29.2-360.) to 5.6 (Percona-Server-5.6.22-rel71.0-726 ) and having some  
replicate-wild-ignore-table  
replicate-ignore-db

The replication is giving warnings and filling up the mysql error log, even after setting and starting the mysql server with parameter slave\_skip\_errors = 1237

2015-03-11 09:10:49 19579 [Warning] Slave SQL: Could not execute Query event. Detailed error: Slave SQL thread ignored the query because of replicate-\*-table rules; Error log throttle is enabled. This error will not be displayed for next 60 secs. It will be suppressed, Error\_code: 1237

Is this a bug ? or how to get rid of this.

How to get rid of this warnings.

Br  
Singh.

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [March 11, 2015, 2:29pm UTC](https://forums.percona.com/t/replication-warning-when-replicating-with-replicate-ignore-db/4098/2 "2015-03-11T14:29:54Z")

</div>

Can you please show us the contents of my.cnf of master & slave both to verify how replication filters are configured.

---

<div class="post-metadata">

**Author:** ![henn9438](https://avatars.discourse-cdn.com/v4/letter/h/d2c977/32.png) [@henn9438](https://forums.percona.com/u/henn9438)\
**Post date:** [April 14, 2015, 7:04am UTC](https://forums.percona.com/t/replication-warning-when-replicating-with-replicate-ignore-db/4098/3 "2015-04-14T07:04:13Z")

</div>

We want to do this efficiently, however we are finding that `mysqldump` locks the database such that the entire webapp hangs for ~15 minutes during a dump due to the size of the database.

* * *

[easter](http://www.solitaire-champ.com/)

---

<div class="post-metadata">

**Author:** ![wagnerbianchi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wagnerbianchi/32/802_2.png) [@wagnerbianchi](https://forums.percona.com/u/wagnerbianchi)\
**Post date:** [April 14, 2015, 2:33pm UTC](https://forums.percona.com/t/replication-warning-when-replicating-with-replicate-ignore-db/4098/4 "2015-04-14T14:33:31Z")

</div>

This is not a bug. I’ve got the same situation here replicating from 5.5.27 to 5.6.21 and due to have lots of replicate-ignore-table, I’ve getting this WARNING every time a statement tries to update and ignored table through the replication (SQL\_THREAD). Recently I posted a research about this on twitter, check this out: [URL=“[https://twitter.com/wagnerbianchijr/status/583594827566227456](https://twitter.com/wagnerbianchijr/status/583594827566227456)”][https://twitter.com/wagnerbianchijr/...94827566227456[/URL]](https://twitter.com/wagnerbianchijr/...94827566227456%5B/URL%5D)

If you want your log to be clean as possible, out of warning messages, configure log\_warnings=1, otherwise you can keep getting this kind of warning or help from MySQL with log\_warnings=2|3.

I hope it helps, cheers!!