mysql 1305 errores handled differently with Mysql-Python

Bug #1630899 reported by Attila Fazekas
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
neutron
Invalid
Low
Unassigned
oslo.db
Fix Released
High
Roman Podoliaka

Bug Description

The following check https://review.openstack.org/#/c/326927/6/neutron/db/api.py , does not works when I am using:
MySQL-python (1.2.5)
oslo.db (4.13.3)
SQLAlchemy (1.1.0)

2016-10-06 04:39:20.674 16262 ERROR neutron.api.v2.resource OperationalError: (_mysql_exceptions.OperationalError) (1305, 'SAVEPOINT sa_savepoint_1 does not exist') [SQL: u'ROLLBACK TO SAVEPOINT sa_savepoint_1']
2016-10-06 04:39:20.674 16262 ERROR neutron.api.v2.resource

^^^ Is in the log.

Not caught by the is_retriable , because it fails on the _is_nested_instance(e, db_exc.DBError) check. The exception's type is: <class 'sqlalchemy.exc.OperationalError'>
 .

I did not used the '+pymysql', so it is the old MySQL-python driver.

Doug Wiegley (dougwig)
Changed in neutron:
status: New → Confirmed
importance: Undecided → Low
Revision history for this message
Roman Podoliaka (rpodolyaka) wrote :

Apparently, it's not only this specific error, but others as well: they are currently raised as OperationalError's instead of InternalError's, which breaks oslo.db unit tests on mysql-python.

Changed in oslo.db:
status: New → Confirmed
importance: Undecided → Medium
assignee: nobody → Roman Podoliaka (rpodolyaka)
summary: - mysql 1305 errores handled differntly with Mysql-Python
+ mysql 1305 errores handled differently with Mysql-Python
Changed in oslo.db:
importance: Medium → High
status: Confirmed → In Progress
Revision history for this message
Roman Podoliaka (rpodolyaka) wrote :
Changed in oslo.db:
status: In Progress → Fix Released
description: updated
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/oslo.db 4.13.4

This issue was fixed in the openstack/oslo.db 4.13.4 release.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/oslo.db 4.15.0

This issue was fixed in the openstack/oslo.db 4.15.0 release.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/oslo.db 4.13.4

This issue was fixed in the openstack/oslo.db 4.13.4 release.

Changed in neutron:
status: Confirmed → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.