[VPNaaS]: test_migrations_sync failed with alembic 1.4.2

[Dongcan Ye]

Neutron vpnaas functional gate failed with alembic 1.4.2.

2020-04-02 02:16:49.526046 | controller | neutron_vpnaas.tests.functional.common.test_migrations_sync.TestModelsMigrationsMysql.test_models_sync
2020-04-02 02:16:49.526063 | controller | ------------------------------------------------------------------------------------------------------
2020-04-02 02:16:49.526079 | controller |
2020-04-02 02:16:49.526094 | controller | Captured traceback:
2020-04-02 02:16:49.526110 | controller | ~~~~~~~~~~~~~~~~~~~
2020-04-02 02:16:49.526126 | controller | Traceback (most recent call last):
2020-04-02 02:16:49.526142 | controller |
2020-04-02 02:16:49.526157 | controller | File "/home/zuul/src/opendev.org/openstack/neutron-vpnaas/.tox/dsvm-functional-sswan/lib/python3.6/site-packages/neutron/tests/base.py", line 182, in func
2020-04-02 02:16:49.526174 | controller | return f(self, *args, **kwargs)
2020-04-02 02:16:49.526189 | controller |
2020-04-02 02:16:49.526205 | controller | File "/home/zuul/src/opendev.org/openstack/neutron-vpnaas/.tox/dsvm-functional-sswan/lib/python3.6/site-packages/oslo_db/sqlalchemy/test_migrations.py", line 598, in test_models_sync
2020-04-02 02:16:49.526221 | controller | "Models and migration scripts aren't in sync:\n%s" % msg)
2020-04-02 02:16:49.526245 | controller |
2020-04-02 02:16:49.526263 | controller | File "/home/zuul/src/opendev.org/openstack/neutron-vpnaas/.tox/dsvm-functional-sswan/lib/python3.6/site-packages/unittest2/case.py", line 690, in fail
2020-04-02 02:16:49.526279 | controller | raise self.failureException(msg)
2020-04-02 02:16:49.526295 | controller |
2020-04-02 02:16:49.526310 | controller | AssertionError: Models and migration scripts aren't in sync:
2020-04-02 02:16:49.526325 | controller | [ [ ( 'modify_type',
2020-04-02 02:16:49.526341 | controller | None,
2020-04-02 02:16:49.526356 | controller | 'vpn_endpoint_groups',
2020-04-02 02:16:49.526371 | controller | 'endpoint_type',
2020-04-02 02:16:49.526386 | controller | { 'existing_comment': None,
2020-04-02 02:16:49.526402 | controller | 'existing_nullable': False,
2020-04-02 02:16:49.526417 | controller | 'existing_server_default': False},
2020-04-02 02:16:49.526432 | controller | ENUM('subnet', 'cidr', 'vlan', 'network', 'router'),
2020-04-02 02:16:49.526447 | controller | Enum('subnet', 'cidr', 'network', 'vlan', 'router', name='vpn_endpoint_type'))]]
2020-04-02 02:16:49.526463 | controller |
2020-04-02 02:16:49.526478 | controller |
2020-04-02 02:16:49.526494 | controller | neutron_vpnaas.tests.functional.common.test_migrations_sync.TestModelsMigrationsPostgresql.test_models_sync
2020-04-02 02:16:49.526510 | controller | -----------------------------------------------------------------------------------------------------------
2020-04-02 02:16:49.526525 | controller |
2020-04-02 02:16:49.526540 | controller | Captured traceback:
2020-04-02 02:16:49.526555 | controller | ~~~~~~~~~~~~~~~~~~~
2020-04-02 02:16:49.526570 | controller | Traceback (most recent call last):
2020-04-02 02:16:49.526585 | controller |
2020-04-02 02:16:49.526600 | controller | File "/home/zuul/src/opendev.org/openstack/neutron-vpnaas/.tox/dsvm-functional-sswan/lib/python3.6/site-packages/neutron/tests/base.py", line 182, in func
2020-04-02 02:16:49.526616 | controller | return f(self, *args, **kwargs)
2020-04-02 02:16:49.526631 | controller |
2020-04-02 02:16:49.526647 | controller | File "/home/zuul/src/opendev.org/openstack/neutron-vpnaas/.tox/dsvm-functional-sswan/lib/python3.6/site-packages/oslo_db/sqlalchemy/test_migrations.py", line 598, in test_models_sync
2020-04-02 02:16:49.526663 | controller | "Models and migration scripts aren't in sync:\n%s" % msg)
2020-04-02 02:16:49.526678 | controller |
2020-04-02 02:16:49.526694 | controller | File "/home/zuul/src/opendev.org/openstack/neutron-vpnaas/.tox/dsvm-functional-sswan/lib/python3.6/site-packages/unittest2/case.py", line 690, in fail
2020-04-02 02:16:49.526723 | controller | raise self.failureException(msg)
2020-04-02 02:16:49.526741 | controller |
2020-04-02 02:16:49.526757 | controller | AssertionError: Models and migration scripts aren't in sync:
2020-04-02 02:16:49.526772 | controller | [ [ ( 'modify_type',
2020-04-02 02:16:49.526788 | controller | None,
2020-04-02 02:16:49.526803 | controller | 'vpn_endpoint_groups',
2020-04-02 02:16:49.526818 | controller | 'endpoint_type',
2020-04-02 02:16:49.526833 | controller | { 'existing_comment': None,
2020-04-02 02:16:49.526848 | controller | 'existing_nullable': False,
2020-04-02 02:16:49.526863 | controller | 'existing_server_default': False},
2020-04-02 02:16:49.526879 | controller | ENUM('subnet', 'cidr', 'vlan', 'network', 'router', name='endpoint_type'),
2020-04-02 02:16:49.526894 | controller | Enum('subnet', 'cidr', 'network', 'vlan', 'router', name='vpn_endpoint_type'))]]

[Brian Haley (brian-haley)]

I'll mark as critical since you added the gate-failure tag, please update if that is not correct

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/716838
Committed: https://git.openstack.org/cgit/openstack/neutron-vpnaas/commit/?id=f1856ab2cc01fa6ab7547ed0dfed1d5ffad26dca
Submitter: Zuul
Branch: master

commit f1856ab2cc01fa6ab7547ed0dfed1d5ffad26dca
Author: Dongcan Ye <email address hidden>
Date: Thu Apr 2 04:01:56 2020 +0000

    Fix the endpoint_type column name and order

    Closes-Bug: #1870302

    Change-Id: I35ccfe1db992837585c5c1bd62db5770fbd9c9ca