Trove db sync does not work correctly with pgsql

Bug #1293465 reported by Nikhil Manchanda
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack DBaaS (Trove)
Fix Released
Critical
Nikhil Manchanda

Bug Description

This causes a trove install on devstack using pgsql to fail.
This needs to be fixed so that trove can be part of the integrated gate.

Changed in trove:
importance: Undecided → High
assignee: nobody → Nikhil Manchanda (slicknik)
milestone: none → icehouse-rc1
Changed in trove:
importance: High → Critical
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to trove (master)

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

Changed in trove:
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to trove (master)

Reviewed: https://review.openstack.org/81073
Committed: https://git.openstack.org/cgit/openstack/trove/commit/?id=f984db30c4d4cab1377d21a73ec0b802590f8a51
Submitter: Jenkins
Branch: master

commit f984db30c4d4cab1377d21a73ec0b802590f8a51
Author: Nikhil Manchanda <email address hidden>
Date: Mon Mar 17 13:29:39 2014 -0700

    Update sqlalchemy migrate scripts for postgres

    pgsql <= 8.3 was lax about char->other casting but this was tightened
    up in 8.4+. We must now specify the USING clause for such a cast to
    succeed. The SQL queries generated by sqlalchemy for pgsql don't
    support this, so an override is needed to support pgsql for the trove
    migrate scripts.

    Closes-bug: 1293465
    Change-Id: I217fc861036911e61bafe706e338bb3b8f49e708

Changed in trove:
status: In Progress → Fix Committed
Thierry Carrez (ttx)
Changed in trove:
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in trove:
milestone: icehouse-rc1 → 2014.1
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.