-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 2.2.21
-
Fix Version/s: Icebox
-
Component/s: readwritesplit
-
Labels:None
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