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

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

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 5.5.35
    • Fix Version/s: N/A
    • Component/s: Locking
    • Labels:
    • Environment:
      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

            • Assignee:
              Unassigned
              Reporter:
              ivan.stoykov@skysql.com Stoykov (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: