Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21862

SHOW BINLOG EVENTS completely locks down writes to binlog, hence transactions

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
    • 10.4(EOL)
    • Replication
    • None

    Description

      While a `SHOW BINLOG EVENTS IN 'logfile' LIMIT X,Y` is executing, any write statement is blocked.

      Implement upstream changes.

      commit 739ac25439176f309cd2132ce16fe49d918127c7
      Author: Venkatesh Duggirala <venkatesh.duggirala@oracle.com>
      Date: Tue Aug 18 17:29:02 2015 +0530
      BUG#20928790 SHOW BINLOG EVENTS COMPLETELY LOCKS DOWN WRITES TO BINLOG, HENCE TRANSACTIONS.
      Problem: While a `SHOW BINLOG EVENTS` is executing, any parallel transaction
      is blocked.

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            sujatha.sivakumar Sujatha Sivakumar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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