Public bug reported:
Since some time, periodic jobs neutron-functional-with-oslo-master and
neutron-functional-with-sqlalchemy-master are failing with one test
failed:
neutron.tests.functional.db.test_migrations.TestModelsMigrationsMySQL.test_models_sync
Stacktrace:
ft1.4:
neutron.tests.functional.db.test_migrations.TestModelsMigrationsMySQL.test_models_synctesttools.testresult.real._StringException:
Traceback (most recent call last):
File "/home/zuul/src/opendev.org/openstack/neutron/neutron/tests/base.py",
line 178, in func
return f(self, *args, **kwargs)
File
"/home/zuul/src/opendev.org/openstack/neutron/neutron/tests/functional/db/test_migrations.py",
line 382, in test_models_sync
super(TestModelsMigrationsMySQL, self).test_models_sync()
File
"/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-functional-gate/lib/python3.10/site-packages/oslo_db/sqlalchemy/test_migrations.py",
line 284, in test_models_sync
self.fail(
File "/usr/lib/python3.10/unittest/case.py", line 675, in fail
raise self.failureException(msg)
AssertionError: Models and migration scripts aren't in sync:
[ [ ( 'modify_default',
None,
'ml2_distributed_port_bindings',
'vif_details',
{ 'existing_comment': None,
'existing_nullable': False,
'existing_type': VARCHAR(length=4095)},
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f875a14ae30>, for_update=False),
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f875eff4640>, for_update=False))],
[ ( 'modify_default',
None,
'ml2_distributed_port_bindings',
'profile',
{ 'existing_comment': None,
'existing_nullable': False,
'existing_type': VARCHAR(length=4095)},
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f87599f8a90>, for_update=False),
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f875eff4640>, for_update=False))],
[ ( 'modify_default',
None,
'ml2_port_bindings',
'profile',
{ 'existing_comment': None,
'existing_nullable': False,
'existing_type': VARCHAR(length=4095)},
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f87598e9a20>, for_update=False),
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f875eff4640>, for_update=False))],
[ ( 'modify_default',
None,
'ml2_port_bindings',
'vif_details',
{ 'existing_comment': None,
'existing_nullable': False,
'existing_type': VARCHAR(length=4095)},
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f87598e9ae0>, for_update=False),
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f875eff4640>, for_update=False))],
[ ( 'modify_default',
None,
'portdnses',
'dns_domain',
{ 'existing_comment': None,
'existing_nullable': False,
'existing_type': VARCHAR(length=255)},
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f8759dc6f20>, for_update=False),
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f875eff4640>, for_update=False))],
[ ( 'modify_default',
None,
'subnetpools',
'hash',
{ 'existing_comment': None,
'existing_nullable': False,
'existing_type': VARCHAR(length=36)},
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f875aab60b0>, for_update=False),
Failure examples:
* https://zuul.openstack.org/build/55a065238b784ac28e91469d2acce3da
* https://zuul.openstack.org/build/2d8d000b62a1448d984eab7059d677a7
** Affects: neutron
Importance: Critical
Status: Confirmed
** Tags: db functional-tests gate-failure
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/2025126
Title:
Functional MySQL sync test failing with oslo/sqlalchemy master branch
Status in neutron:
Confirmed
Bug description:
Since some time, periodic jobs neutron-functional-with-oslo-master and
neutron-functional-with-sqlalchemy-master are failing with one test
failed:
neutron.tests.functional.db.test_migrations.TestModelsMigrationsMySQL.test_models_sync
Stacktrace:
ft1.4:
neutron.tests.functional.db.test_migrations.TestModelsMigrationsMySQL.test_models_synctesttools.testresult.real._StringException:
Traceback (most recent call last):
File "/home/zuul/src/opendev.org/openstack/neutron/neutron/tests/base.py",
line 178, in func
return f(self, *args, **kwargs)
File
"/home/zuul/src/opendev.org/openstack/neutron/neutron/tests/functional/db/test_migrations.py",
line 382, in test_models_sync
super(TestModelsMigrationsMySQL, self).test_models_sync()
File
"/home/zuul/src/opendev.org/openstack/neutron/.tox/dsvm-functional-gate/lib/python3.10/site-packages/oslo_db/sqlalchemy/test_migrations.py",
line 284, in test_models_sync
self.fail(
File "/usr/lib/python3.10/unittest/case.py", line 675, in fail
raise self.failureException(msg)
AssertionError: Models and migration scripts aren't in sync:
[ [ ( 'modify_default',
None,
'ml2_distributed_port_bindings',
'vif_details',
{ 'existing_comment': None,
'existing_nullable': False,
'existing_type': VARCHAR(length=4095)},
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f875a14ae30>, for_update=False),
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f875eff4640>, for_update=False))],
[ ( 'modify_default',
None,
'ml2_distributed_port_bindings',
'profile',
{ 'existing_comment': None,
'existing_nullable': False,
'existing_type': VARCHAR(length=4095)},
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f87599f8a90>, for_update=False),
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f875eff4640>, for_update=False))],
[ ( 'modify_default',
None,
'ml2_port_bindings',
'profile',
{ 'existing_comment': None,
'existing_nullable': False,
'existing_type': VARCHAR(length=4095)},
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f87598e9a20>, for_update=False),
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f875eff4640>, for_update=False))],
[ ( 'modify_default',
None,
'ml2_port_bindings',
'vif_details',
{ 'existing_comment': None,
'existing_nullable': False,
'existing_type': VARCHAR(length=4095)},
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f87598e9ae0>, for_update=False),
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f875eff4640>, for_update=False))],
[ ( 'modify_default',
None,
'portdnses',
'dns_domain',
{ 'existing_comment': None,
'existing_nullable': False,
'existing_type': VARCHAR(length=255)},
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f8759dc6f20>, for_update=False),
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f875eff4640>, for_update=False))],
[ ( 'modify_default',
None,
'subnetpools',
'hash',
{ 'existing_comment': None,
'existing_nullable': False,
'existing_type': VARCHAR(length=36)},
DefaultClause(<sqlalchemy.sql.elements.TextClause object at
0x7f875aab60b0>, for_update=False),
Failure examples:
* https://zuul.openstack.org/build/55a065238b784ac28e91469d2acce3da
* https://zuul.openstack.org/build/2d8d000b62a1448d984eab7059d677a7
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/2025126/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
