Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.1.12
-
None
-
Ubuntu 14.04.5 LTS (10.1.12)
Description
Master:
M:7914290 [ci4]>SHOW VARIABLES LIKE '%replicate_ignore_db'; |
+---------------------+-------+ |
| Variable_name | Value |
|
+---------------------+-------+ |
| replicate_ignore_db | tmp |
|
+---------------------+-------+ |
1 row in set (0.00 sec) |
|
|
M:7919802 [ci4]>SHOW processlist;
|
+----+---------+------------------+------+-------------+------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+ |
| Id | User | Host | db | Command | Time | State | Info | Progress | |
+----+---------+------------------+------+-------------+------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+ |
[...]
|
| 27 | joe | 172.18.0.5:37334 | ci4 | Query | 1762 | Writing to binlog | CREATE TABLE IF NOT EXISTS tmp.sitemap_511_nl ( |
`id_sitemap` bigint(20) unsigned NOT NULL AUTO_INC | 0.000 | |
[...]
|
+----+---------+------------------+------+-------------+------+-----------------------------------------------------------------------+------------------------------------------------------------------------------------------------------+----------+ |
12 rows in set (0.00 sec) |
I cannot check the binlog to see if this statement was filtered later as mysqlbinlog is not in the package:
ubuntu@ip-172-31-30-16:/wp/ci$ mysqlbinlog ../data/mysql-bin.000001
|
The program 'mysqlbinlog' can be found in the following packages:
|
* mysql-server-5.5
|
* mariadb-server-5.5
|
* mysql-server-5.6
|
* percona-xtradb-cluster-server-5.5
|
Try: sudo apt-get install <selected package>
|
Actually. those tables sitemap* are present on the slave although they had been dropped before:
Slave:
S:421801 [ci4]>SHOW tables from tmp; |
+----------------+ |
| Tables_in_tmp |
|
+----------------+ |
| benchmark |
|
| counter |
|
| se_lng_ex_de |
|
| sitemap_511_de |
|
| sitemap_511_en |
|
| sitemap_511_fr |
|
| sitemap_511_nl |
|
+----------------+ |
7 rows in set (0.00 sec) |