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

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

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

          The original request was revoked since the issue is not reproducible anymore on the reporter's side. I suppose we can close it as well.

          elenst Elena Stepanova added a comment - The original request was revoked since the issue is not reproducible anymore on the reporter's side. I suppose we can close it as well.

          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.