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

'FLUSH TABLES WITH READ LOCK' command for database backup has failed

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 5.5.35
    • N/A
    • Locking
    • Red Hat Enterprise Linux 6.3

    Description

      Summary : FLUSH TABLES WITH READ LOCK hangs in NULL state

      There was an issue with a backup script with hanging FLUSH TABLES WITH READ LOCK; due to long running queries.

      After a fix, the backup script waits for all the processes to finish or it kills the long running queries and after executing the FLUSH TABLES WITH READ LOCK command, its listed with NULL state at the processlist:

      There are some lines at MysqlOnlineBackup_20140702.log where the NULL state can be seen:
      "root localhost NULL Query 0 NULL FLUSH TABLES WITH READ LOCK"

      Could that be a bug, if yes is it fixable, or what would be the possible workaround ?

      Attachments

        Activity

          People

            Unassigned Unassigned
            ivan.stoykov@skysql.com Stoykov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.