DBDuplicateEntry is not handled for sqlite

Bug #1259915 reported by Nikita Konovalov
20
This bug affects 4 people
Affects Status Importance Assigned to Milestone
oslo-incubator
Fix Released
Undecided
Nikita Konovalov

Bug Description

There are new exception messages for constraint fails since sqlite v3.7.16
http://www.sqlite.org/releaselog/3_7_16.html

The Integrity Error regex is not matching DBDuplicateEntry anymore.

The new message looks like: (IntegrityError) UNIQUE constraint failed: k1, k2

Changed in oslo:
assignee: nobody → Nikita Konovalov (nkonovalov)
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to oslo-incubator (master)

Fix proposed to branch: master
Review: https://review.openstack.org/61405

description: updated
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to oslo-incubator (master)

Reviewed: https://review.openstack.org/61405
Committed: https://git.openstack.org/cgit/openstack/oslo-incubator/commit/?id=c802fa66f85df1c18c35b355088b24c2040b51f5
Submitter: Jenkins
Branch: master

commit c802fa66f85df1c18c35b355088b24c2040b51f5
Author: Nikita Konovalov <email address hidden>
Date: Wed Dec 11 16:35:54 2013 +0400

    SQLAlchemy error patterns improved

    SQLite has new error messages since 3.7.16.
    DBDuplicateEntry is now recognized correctly.

    Change-Id: I86e9673ac409b3b3e881bea7cb8b3516f320388d
    Fixes: bug #1259915

Changed in oslo:
status: In Progress → Fix Committed
Changed in oslo:
milestone: none → icehouse-2
summary: - DBDuplicateEntry is not had led for sqlite
+ DBDuplicateEntry is not handled for sqlite
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to oslo-incubator (master)

Fix proposed to branch: master
Review: https://review.openstack.org/67093

Thierry Carrez (ttx)
Changed in oslo:
status: Fix Committed → Fix Released
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to oslo-incubator (master)

Reviewed: https://review.openstack.org/67093
Committed: https://git.openstack.org/cgit/openstack/oslo-incubator/commit/?id=986dafd68709bfdf761f2a22b10bab5e059451cf
Submitter: Jenkins
Branch: master

commit 986dafd68709bfdf761f2a22b10bab5e059451cf
Author: Roman Podoliaka <email address hidden>
Date: Wed Jan 15 17:53:36 2014 +0200

    Fix parsing of UC errors in sqlite 3.7.16+/3.8.2+

    The new version of libsqlite changed the format of error messages.
    Code of oslo.db helpers must be updated appropriately. This was meant
    to be fixed by I86e9673ac409b3b3e881bea7cb8b3516f320388d, but that
    change doesn't cope well with the new format of column names.

    Closes-Bug: #1259915

    Change-Id: Iec39c8804ea47307a98d1b79899ff74af9404bf6

Thierry Carrez (ttx)
Changed in oslo:
milestone: icehouse-2 → 2014.1
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

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