neutron.tests.functional.agent.l3.test_legacy_router.L3AgentTestCase.test_legacy_router_lifecycle failed in _assert_internal_devices

[Ihar Hrachyshka]

https://zuul.opendev.org/t/openstack/build/2657d2d29ee84720a6c6a268050d1684

==============================
Failed 1 tests - output below:
==============================

neutron.tests.functional.agent.l3.test_legacy_router.L3AgentTestCase.test_legacy_router_lifecycle
-------------------------------------------------------------------------------------------------

Captured traceback:
~~~~~~~~~~~~~~~~~~~
    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/agent/l3/test_legacy_router.py", line 87, in test_legacy_router_lifecycle
    self._router_lifecycle(enable_ha=False, dual_stack=True)

      File "/home/zuul/src/opendev.org/openstack/neutron/neutron/tests/functional/agent/l3/framework.py", line 365, in _router_lifecycle
    self._assert_internal_devices(router)

      File "/home/zuul/src/opendev.org/openstack/neutron/neutron/tests/functional/agent/l3/framework.py", line 564, in _assert_internal_devices
    self.assertTrue(self.device_exists_with_ips_and_mac(

      File "/usr/lib/python3.10/unittest/case.py", line 687, in assertTrue
    raise self.failureException(msg)

    AssertionError: False is not true

[Lajos Katona (lajos-katona)]

Opensearch link:
https://opensearch.logs.openstack.org/_dashboards/app/data-explorer/discover/?security_tenant=global#?_a=(discover:(columns:!(_source),isDirty:!f,sort:!()),metadata:(indexPattern:'94869730-aea8-11ec-9e6a-83741af3fdcd',view:discover))&_g=(filters:!(),refreshInterval:(pause:!t,value:0),time:(from:now-30d,to:now))&_q=(filters:!(),query:(language:kuery,query:'message:%22line%2087,%20in%20test_legacy_router_lifecycle%22'))

It happened once last week based on that

[Lajos Katona (lajos-katona)]

In the log file there are sqlalchemy exceptions like these:
.....
2024-05-14 17:21:21.292 38773 ERROR ovsdbapp.event oslo_db.exception.DBNonExistentTable: (sqlite3.OperationalError) no such table: networksegments

.....
2024-05-14 17:20:58.255 38773 ERROR ovsdbapp.event oslo_db.exception.DBNonExistentTable: (sqlite3.OperationalError) no such table: ports

See the attached log file (neutron.tests.functional.agent.l3.test_legacy_router.L3AgentTestCase.test_legacy_router_lifecycle.txt )