Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3036

'set autocommit=0' block ddl

    XMLWordPrintable

    Details

    • 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

      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

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            dapeng dapeng huang
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: