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

[Matt Riedemann]

http://logs.openstack.org/22/112422/1/check/gate-nova-python26/621e0ae/console.html

This is probably a latent bug in the nova unit tests for postgresql in stable/havana, or it's due to slow nodes for the py26 jobs.

http://logstash.openstack.org/#eyJzZWFyY2giOiJtZXNzYWdlOlwiRVJST1I6ICBzb3VyY2UgZGF0YWJhc2UgXFxcInRlbXBsYXRlMVxcXCIgaXMgYmVpbmcgYWNjZXNzZWQgYnkgb3RoZXIgdXNlcnNcIiBBTkQgdGFnczpcImNvbnNvbGVcIiBBTkQgYnVpbGRfYnJhbmNoOlwic3RhYmxlL2hhdmFuYVwiIEFORCBidWlsZF9uYW1lOlwiZ2F0ZS1ub3ZhLXB5dGhvbjI2XCIiLCJmaWVsZHMiOltdLCJvZmZzZXQiOjAsInRpbWVmcmFtZSI6IjYwNDgwMCIsImdyYXBobW9kZSI6ImNvdW50IiwidGltZSI6eyJ1c2VyX2ludGVydmFsIjowfSwic3RhbXAiOjE0MDc4NjA5ODg1MjMsIm1vZGUiOiIiLCJhbmFseXplX2ZpZWxkIjoiIn0=

3 hits in 7 days, check queue only but multiple changes and all failures.

[Matt Riedemann (mriedem)]

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

[Joe Gordon (jogo)]

no hits any more

[Alan Pevec (apevec)]

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

[Sean Dague (sdague)]

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.

[OpenStack Infra (hudson-openstack)]

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

[Matt Riedemann (mriedem)]

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

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

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)