[MDEV-6691] 'FLUSH TABLES WITH READ LOCK' command for database backup has failed Created: 2014-09-04  Updated: 2015-02-11  Resolved: 2015-02-11

Status: Closed
Project: MariaDB Server
Component/s: Locking
Affects Version/s: 5.5.35
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Stoykov (Inactive) Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: backup
Environment:

Red Hat Enterprise Linux 6.3


Attachments: File MysqlOnlineBackup_20140702.log     Zip Archive messages.zip    

 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 ?



 Comments   
Comment by Elena Stepanova [ 2015-02-11 ]

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.

Generated at Thu Feb 08 07:13:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.