Bug 708272 - sqlalchemy bug 1493 reproducing in production, update to sqlalchemy 0.5.6 or later required.
Summary: sqlalchemy bug 1493 reproducing in production, update to sqlalchemy 0.5.6 or ...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Fedora EPEL
Classification: Fedora
Component: python-sqlalchemy0.5
Version: el5
Hardware: x86_64
OS: Linux
unspecified
urgent
Target Milestone: ---
Assignee: Luke Macken
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-05-27 05:00 UTC by Lev Shamardin
Modified: 2016-09-20 02:42 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-12-18 19:02:35 UTC
Type: ---


Attachments (Terms of Use)

Description Lev Shamardin 2011-05-27 05:00:02 UTC
Description of problem:
We have hit sqlalchemy bug http://www.sqlalchemy.org/trac/ticket/1493 several times in production. It is fixed in newer versions of sqlalchemy 0.5.x. Please, update the package to the newer version.

Version-Release number of selected component (if applicable):
python-sqlalchemy0.5-0.5.5-1.el5

How reproducible:
random (due to the nature of the bug)

Actual results:
application crash

Expected results:
application working

Comment 1 Toshio Ernie Kuratomi 2011-05-31 18:55:13 UTC
I took a look at performing this upgrade over the past week but 0.5.6 and newer are failing their unittests.  In 0.5.6 there's only one failing unittest -- I haven't confirmed that it's only a single unittest failure for 0.5.8 but the build for 0.5.8 failed in the same place.

Failing build:
https://koji.fedoraproject.org/koji/taskinfo?taskID=3098567

Build with just that test patched out to show that we'd otherwise be fine:
https://koji.fedoraproject.org/koji/taskinfo?taskID=3098569

@Lev: are you abbot?  If so, I'll approve your pkgdb request if you'd like to work on upgrading.

We'd want to see if we can get this unittest to not use empty inserts to perform its test.  If it can then we can patch and update.  If we can't then we could consider adding the decorator to exclude running this test if the sqlite is old enough to not support empty inserts.

Comment 2 Lev Shamardin 2011-05-31 19:50:56 UTC
Hi, yes I'm abbot, sorry, forgot to mention that I've left the access request.

I saw this test failing, and currently I just built a package locally which patches this failing test away. I'm not sure if it does worth it to re-implement this failing test with non-empty inserts, I would consider simply removing it from the known to fail platforms (which is only EL5 to my best knowledge). Same with the a decorator to exclude the test: this is the only failing test, it is easier to remove it, and consider a decorator/more complex solution if this situation repeats with another sqlalchem version (but this is unlikely since 0.5.8 is the last release in the 0.5.x series and there should be no more releases in this branch).

Comment 3 Toshio Ernie Kuratomi 2011-05-31 21:48:18 UTC
AFAIK, the decorator is already implemented which is why I bring it up.  The other way would be to use the -e commandline option to nosetests to exclude the test from running.

Fixing the test would be better in that we would know that we aren't breaking a feature in our quest to fix something else :-)  but yeah, I bring up the methods to exclude since, if we can tell that the test is only failing b/c of the version of sqlite but we could use the feature fine with other db's; we could exclude the test rather than fix the test.

Anyhow, you're now approved so go ahead and update the package to 0.5.8 :-)

Comment 4 Luke Macken 2012-12-18 19:02:35 UTC
Toshio pushed python-sqlalchemy0.5-0.5.8-9.el5 to the epel5 stable repo to fix security Bug #783305.

https://admin.fedoraproject.org/updates/EL-5/FEDORA-EPEL-2012-0715


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