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

'set autocommit=0' block ddl

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.2.21
    • Fix Version/s: 7
    • 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

          Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MXS-1816 Prepared statements cause problems when done on all servers

          • Major - Major loss of function.
          • Confirmed

            Activity

              People

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

                Dates

                Created:
                Updated:

                  Git Integration