LBaaS needs automated test for DB migrations

[Stephen Balukoff]

Given the problems caused recently by a migration on neutron-lbaas that broke things for people using PostgreSQL, we should implement a test which ensures that alembic migrations produce results exactly consistent with the database models in the project, and which are functional for both MySQL and PostgreSQL. More information on how to do this can be found here: http://docs.openstack.org/developer/neutron/devref/template_model_sync_test.html

[Doug Wiegley (dougwig)]

Not sure if we'll have time before m-3, but this is a real issue.

[YAMAMOTO Takashi (yamamoto)]

let me take a look.

see also https://bugs.launchpad.net/neutron/+bug/1552063

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

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

commit cb4ec40a6262da126112cc31a66f4571af1ae103
Author: YAMAMOTO Takashi <email address hidden>
Date: Wed Mar 2 14:28:25 2016 +0900

    Add model sync test

    As neutron-lbaas doesn't have functional tests right now,
    add this to unit tests following the convention.
    (networking-cisco and networking-midonet)

    Note: the Cisco copyright notice in test_migrations is intended.
    It came from networking-cisco via networking-midonet.

    Closes-Bug: #1549699
    Change-Id: I30998407eae04d28a3a653430f8c90711b6c0235

[Thierry Carrez (ttx)]

This issue was fixed in the openstack/neutron-lbaas 8.0.0.0rc1 release candidate.