Bug 254012

Summary:	Mysql bug 20048: 5.0.22 FLUSH TABLES WITH READ LOCK bug; need upgrade to 5.0.23
Product:	Red Hat Enterprise Linux 5	Reporter:	J. Parsons <jparsons-redhat>
Component:	mysql	Assignee:	Tom Lane <tgl>
Status:	CLOSED ERRATA	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	5.0	CC:	byte, hhorak, sputhenp
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:	RHSA-2008-0364	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2008-05-21 15:23:46 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description J. Parsons 2007-08-23 16:48:55 UTC

Description of problem:

Version 5.0.22 exhibits mysql bug 20048 that causes unrecoverable deadlocks when using a statement 
required for LVM-snapshot backups, "FLUSH TABLES WITH READLOCK." The deadlock prevents any 
reasonable recovery and requires the mysql daemon to be killed forcefully. 

Version-Release number of selected component (if applicable):

mysql-server 5.0.22-2.1

How reproducible:

Documented mysql bug

Steps to Reproduce:

See http://bugs.mysql.com/bug.php?id=20048
  

Additional info:

See 5.0.23 release notes documenting fix:

http://www.mysql.org/doc/refman/5.0/en/news-5-0-23.html

Comment 2 RHEL Program Management 2007-10-16 03:45:06 UTC

This request was evaluated by Red Hat Product Management for inclusion in a Red
Hat Enterprise Linux maintenance release.  Product Management has requested
further review of this request by Red Hat Engineering, for potential
inclusion in a Red Hat Enterprise Linux Update release for currently deployed
products.  This request is not yet committed for inclusion in an Update
release.

Comment 7 errata-xmlrpc 2008-05-21 15:23:46 UTC

An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on the solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.

http://rhn.redhat.com/errata/RHSA-2008-0364.html