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

'set autocommit=0' block ddl

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 2.2.21
    • N/A
    • readwritesplit
    • 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.
          • Closed

          Activity

            People

              markus makela markus makela
              dapeng dapeng huang
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.