Bug #52753 DROP TABLE fails on slave with Proxy and semi-snc replication

• Submitted: 12 Apr 2010 6:55
• Reporter: Sveta Smirnova
• Status: Verified
• Category: MySQL Proxy: Core
• Severity: S3 (Non-critical)
• Version: 0.8.0
• OS: Any
• Assigned to: Jan Kneschke
• CPU Architecture: Any

[12 Apr 2010 6:55] Sveta Smirnova

Description:
While tried to repeat bug #52524 noticed different problem: if issue DROP TABLE t1; DROP TABLE t2; on master second statement is not replicated to slave if slave connects to master via Proxy

How to repeat:
1. Setup Proxy so it listens master prot
2. On slave: stop slave; change master to master_port=PROXY_PORT; start slave
3. On master:
CREATE TABLE t1(f1 INT);
CREATE TABLE t2(f1 INT);
CREATE TABLE t3(f1 INT);
CREATE TABLE t4(f1 INT);
DROP TABLE t1;
DROP TABLE t2;
DROP TABLE t3;
DROP TABLE t4;
SHOW TABLES;
-- returns empty set
4. On slave:
SHOW SLAVE STATUS\G
-- shows slave is working
SHOW TABLES;
+----------------+
| Tables_in_test |
+----------------+
| t2             |
| t3             |
| t4             |
+----------------+
3 rows in set (0.01 sec)