Bug 1198774 - some mysql "commands out of sync" errors may not be interpreted correctly as a "database disconnect" situation, sqlalchemy 0.8.4
Summary: some mysql "commands out of sync" errors may not be interpreted correctly as ...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: python-sqlalchemy
Version: 5.0 (RHEL 6)
Hardware: Unspecified
OS: Unspecified
low
low
Target Milestone: z4
: 5.0 (RHEL 6)
Assignee: Michael Bayer
QA Contact: Ami Jeain
URL:
Whiteboard:
Depends On: 1121798
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-03-04 19:22 UTC by Michael Bayer
Modified: 2023-02-22 23:02 UTC (History)
7 users (show)

Fixed In Version: 0.8.4-2.el6ost
Doc Type: Bug Fix
Doc Text:
Previously, the MySQL-Python DBAPI was observed under some circumstances using the ProgrammingError exception class to report on the 'command out of sync' errors, which is considered to be the case where a connection need to be thrown away; the SQLAlchemy dialect only expected this error to be emitted within the OperationalError class. As a result, in some cases a MySQL-Python connection that became corrupt would not signal to the SQLAlchemy engine that the pool of connections should be disposed, leading the engine not being able to proceed with new operations. With this update, the error handling scheme of the MySQL-Python dialect is modified to expect either the OperationalError or ProgrammingError exception class when testing for this particular class of error. As a result, the SQLAlchemy engine/connection pool now correctly disposes off its connections when a MySQL-Python ProgrammingError delivers the 'command out of sync' error code.
Clone Of: 1121798
Environment:
Last Closed: 2015-04-16 14:38:19 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2015:0820 0 normal SHIPPED_LIVE Red Hat Enterprise Linux OpenStack Platform Bug Fix and Enhancement Advisory 2015-04-16 18:28:41 UTC

Comment 5 Ami Jeain 2015-04-12 11:17:53 UTC
verified using automation regression on RHOS5 RHEL 6.6

Comment 7 errata-xmlrpc 2015-04-16 14:38:19 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://rhn.redhat.com/errata/RHBA-2015-0820.html


Note You need to log in before you can comment on or make changes to this bug.