Bug #52753 DROP TABLE fails on slave with Proxy and semi-snc replication
Submitted: 12 Apr 2010 6:55
Reporter: Sveta Smirnova Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Proxy: Core Severity:S3 (Non-critical)
Version:0.8.0 OS:Any
Assigned to: Jan Kneschke CPU Architecture:Any
Triage: Needs Triage: D2 (Serious)

[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)