Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
2.2.21
-
None
Description
Example:
Thread 1 | Thread2 |
---|---|
SET AUTOCOMMIT = 0 | ... |
SELECT * FROM t1 – maxscale route to slave | ... |
COMMIT | ... |
... | DROP TABLE t1 |
'set autocommit=0' will route to all node, but commit only route to master, so in slave the transaction will not commit, hold mdl lock on t1 util session close, then when slave apply binlog 'DROP TABLE t1' will be block
Attachments
Issue Links
- is caused by
-
MXS-1816 Prepared statements cause problems when done on all servers
- Closed