PostgreSQL migration is broken

[Julien Danjou]

2013-08-30 19:32:33.379 | 2013-08-30 19:32:33 ProgrammingError: (ProgrammingError) constraint "resource_user_id_project_id_key" of relation "resource" does not exist
2013-08-30 19:32:33.381 | 2013-08-30 19:32:33 'ALTER TABLE resource DROP CONSTRAINT resource_user_id_project_id_key' {}

http://logs.openstack.org/51/43851/1/gate/gate-tempest-devstack-vm-postgres-full/c35ad4d/console.html.gz

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/45196
Committed: http://github.com/openstack/ceilometer/commit/aae3f55304ff161b401b803769350e9cb66b0e8c
Submitter: Jenkins
Branch: master

commit aae3f55304ff161b401b803769350e9cb66b0e8c
Author: Svetlana Shturm <email address hidden>
Date: Thu Sep 5 12:50:03 2013 +0400

    Fix wrong migrations

    For Postgres migrations are failed.
    More then we can get for mysql an error
    "Specified key was too long; max key length is 1000 bytes" in b6ae66d05e3
    migration in some versions of dialect.

    Fixes-Bug: #1219776

    Change-Id: Id9b0e1eb0e685053291367f7eb62fef68b6b2f84

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: milestone-proposed
Review: https://review.openstack.org/45330

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: milestone-proposed
Review: https://review.openstack.org/45384

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/45384
Committed: http://github.com/openstack/ceilometer/commit/774513b52e16abdf16f61032ae462d52488e92ff
Submitter: Jenkins
Branch: milestone-proposed

commit 774513b52e16abdf16f61032ae462d52488e92ff
Author: Julien Danjou <email address hidden>
Date: Thu Sep 5 12:50:03 2013 +0400

    Fix wrong migrations and fix tests in nova_notifier

    This is a joint commit of 2 other commits from master:

    For Postgres migrations are failed.
    More then we can get for mysql an error
    "Specified key was too long; max key length is 1000 bytes" in b6ae66d05e3
    migration in some versions of dialect.
    Fixes-Bug: #1219776
    (cherry-picked from aae3f55304ff161b401b803769350e9cb66b0e8c)

    The prototype for instance_update_and_get_original changed, so let's
    ignore it completely for the future.
    Fixes-Bug: #1221173
    (cherry-picked from d2a87a9dfd3cd9ef034eed3d693683972c842576)

    Change-Id: Id4d349bbc49cdc957076b3e211f70db9838cd4cb