neutron lbaas DB support is broken on PostgreSQL

[Valeriy Ponomaryov]

Recent change [1] to neutron-lbaas project broke PostgreSQl support.

Also, this project is installed in each CI Devstck job and breaks each PoestreSQL job of other projects just trying to be installed.

Here is error:

logs: http://logs.openstack.org/95/283495/1/check/gate-manila-tempest-dsvm-neutron-postgres-lvm-multibackend/a27485f/logs/devstacklog.txt.gz#_2016-02-23_10_40_31_494

paste: http://paste.openstack.org/show/487887/

raw:

oslo_db.exception.DBError: (psycopg2.ProgrammingError) constraint "lbaas_listeners_ibfk_2" of relation "lbaas_listeners" does not exist

[1] https://review.openstack.org/#/c/218560/

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/283802
Committed: https://git.openstack.org/cgit/openstack/neutron-lbaas/commit/?id=057fb2f3bd5970ff865dcc0fd8822498f40504dc
Submitter: Jenkins
Branch: master

commit 057fb2f3bd5970ff865dcc0fd8822498f40504dc
Author: Stephen Balukoff <email address hidden>
Date: Tue Feb 23 12:55:50 2016 -0800

    Fix shared-pools lbaas_listeners migration

    This patch fixes the MySQL-specific features in the alembic
    migration for shared-pools, so that migrations can also work
    on PostgreSQL.

    This patch also removes the uniqueness of the SQLAlchemy model
    definition of the Listener.default_pool_id field. (This was
    mistakenly left in place in the shared-pools patch.)

    Closes-Bug: 1549372
    Closes-Bug: 1548807
    Change-Id: Ib1896997f2e7a505b5bf8ec0c9e5ee35942f79a6

[Thierry Carrez (ttx)]

This issue was fixed in the openstack/neutron-lbaas 8.0.0.0b3 development milestone.