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

TRUNCATE waits for metadata lock on the tables when a SELECT is executing on it

    XMLWordPrintable

Details

    Description

      A ticket was raised earlier as a MariaDB bug that when a SELECT is executing on a table, parallel TRUNCATE waits for the Metadata Lock. After some explanation of this behavior and successful reproduction of this in their test environment, It was categorized as not a BUG.

      However, they still want this TRUNCATE behaviour changed and requesting it as a new FEATURE where they could pass an additional parameter to the TRUNCATE statement and it will ignore all the LOCKS on the table and proceed with its DROP/RECREATE, aborting all SELECT's that are using this table. This is how Oracle does it.

      This according to them is critical as it impacts their daily operations.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Faisal Faisal Saeed (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.