test_postgresql_opportunistically fails in stable/havana due to: "ERROR: source database "template1" is being accessed by other users"

e-r query: https://review.openstack.org/#/c/113581/

no hits any more

Hit today in Havana periodic job:
http://logs.openstack.org/periodic-stable/periodic-nova-python26-havana/fe2d023/console.html

Marking as high because this is bad unit test design. We need a lock around the pg tests because they make admin level actions which can conflict.

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

Just hit this on master:

http://logs.openstack.org/78/124178/1/check/gate-nova-python27/b1f5a8f/console.html#_2014-09-25_21_54_06_705

Fix proposed to branch: stable/icehouse
Review: https://review.openstack.org/124437

Reviewed: https://review.openstack.org/122011
Committed: https://git.openstack.org/cgit/openstack/nova/commit/?id=02fa15b4caaa414930b6ddf6a3a9fe8019751c26
Submitter: Jenkins
Branch: master

commit 02fa15b4caaa414930b6ddf6a3a9fe8019751c26
Author: Roman Podoliaka <email address hidden>
Date: Wed Sep 17 01:06:33 2014 +0300

    postgresql: use postgres db instead of template1

    In PostgreSQL template1 database is kind of special, as all new databases are
    copied from it, when you do CREATE DATABASE. This implies a few restrictions:
    e.g. you can't have more than one active session to template1, if one of them
    tries to create a database. It will fail with:

        ERROR: source database "template1" is being accessed by other users

    Using of postgres database instead of template1 resolves this issue.

    Closes-Bug: #1355929

    Change-Id: I8b1a36163984fbef6be66964456072d32da6a9d0

Reviewed: https://review.openstack.org/124437
Committed: https://git.openstack.org/cgit/openstack/nova/commit/?id=98a6c1e4c4c1b72463f1200650ff54e94f742999
Submitter: Jenkins
Branch: stable/icehouse

commit 98a6c1e4c4c1b72463f1200650ff54e94f742999
Author: Roman Podoliaka <email address hidden>
Date: Wed Sep 17 01:06:33 2014 +0300

    postgresql: use postgres db instead of template1

    In PostgreSQL template1 database is kind of special, as all new databases are
    copied from it, when you do CREATE DATABASE. This implies a few restrictions:
    e.g. you can't have more than one active session to template1, if one of them
    tries to create a database. It will fail with:

        ERROR: source database "template1" is being accessed by other users

    Using of postgres database instead of template1 resolves this issue.

    Closes-Bug: #1355929

    Change-Id: I8b1a36163984fbef6be66964456072d32da6a9d0
    (cherry picked from commit 02fa15b4caaa414930b6ddf6a3a9fe8019751c26)