*-tempest-dsvm-postgres-full failing on trove-manage db_sync

[Joe Gordon]

*-tempest-dsvm-postgres-full failing on trove-manage db_sync

http://logs.openstack.org/25/94125/1/check/check-tempest-dsvm-postgres-full/2a0c72f/logs/devstacklog.txt.gz
http://logs.openstack.org/25/94125/1/check/check-tempest-dsvm-postgres-full/2a0c72f/console.html

It looks like this started happening once https://review.openstack.org/#/c/92845/ was merged.

Also it looks like trove doesn't run with the postgres gate which explains how this happened.

[Joe Gordon (jogo)]

When reproduced locally:

$ cat /var/log/postgresql/postgresql-9.1-main.log

2014-05-20 06:52:51 UTC ERROR: constraint "name" of relation "datastore_versions" does not exist

[OpenStack Infra (hudson-openstack)]

Related fix proposed to branch: master
Review: https://review.openstack.org/94315

[OpenStack Infra (hudson-openstack)]

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

commit f9d015c29109a5b3a0b148df4127e4f35d76d72d
Author: Joe Gordon <email address hidden>
Date: Tue May 20 16:24:29 2014 +0900

    Specify correct constraint name for postgresql

    The UniqueConstraint is not named 'name,' this causes postgres to fail
    with the following error:
    UTC ERROR: constraint "name" of relation "datastore_versions" does not
    exist
    The constraint name should be 'datastore_versions_name_key' in the case
    of postgresql.

    Since postgres isn't tested in trove's gate yet (Fix:
    I53e7fa2729542b88b43cd3de51e15118adaeec57) this has been tested locally
    to make sure it stack.sh (which runs trove-manage db_sync) works.

    Co-Authored-By: Nikhil Manchanda <email address hidden>
    Change-Id: I265925566b8e84d92c838cb3b39ad1f8502cd052
    Related-Bug: #1321093