Test case neutron.tests.unit.objects.test_quota.ReservationDbObjectTestCase.test_delete_expired failing in periodic job openstack-tox-py39-with-oslo-master

[Miguel Lavalle]

Test case neutron.tests.unit.objects.test_quota.ReservationDbObjectTestCase.test_delete_expired failing in periodic job openstack-tox-py39-with-oslo-master: https://zuul.opendev.org/t/openstack/builds?job_name=openstack-tox-py39-with-oslo-master&project=openstack%2Fneutron&skip=0. It doesn't fail all the time, but has failed several times over the past few days. This is the traceback:

ft1.4: neutron.tests.unit.objects.test_quota.ReservationDbObjectTestCase.test_delete_expiredtesttools.testresult.real._StringException: Traceback (most recent call last):
  File "/home/zuul/src/opendev.org/openstack/neutron/neutron/tests/base.py", line 182, in func
    return f(self, *args, **kwargs)
  File "/home/zuul/src/opendev.org/openstack/neutron/neutron/tests/unit/objects/test_quota.py", line 72, in test_delete_expired
    self.assertEqual([], objs)
  File "/home/zuul/src/opendev.org/openstack/neutron/.tox/py39/lib/python3.9/site-packages/testtools/testcase.py", line 393, in assertEqual
    self.assertThat(observed, matcher, message)
  File "/home/zuul/src/opendev.org/openstack/neutron/.tox/py39/lib/python3.9/site-packages/testtools/testcase.py", line 480, in assertThat
    raise mismatch_error
testtools.matchers._impl.MismatchError: !=:
reference = []
actual = [Reservation(expiration=2015-03-31T14:30:00Z,id=7b11ded2-9612-4f6c-8774-a19456fbe9ff,project_id=<?>,resource_deltas=[]),
 Reservation(expiration=2016-03-31T14:30:00Z,id=d35a8cb9-9dc1-46fe-af6d-b5b507d25d5d,project_id=<?>,resource_deltas=[])]

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/neutron/+/855703

[yatin (yatinkarel)]

Just to update the issue is now seen randomly in all unit test(py38, py39, py310, arm jobs, tox-cover etc) jobs after oslo.db-12.1.0 update in upper-constraints:-

https://opensearch.logs.openstack.org/_dashboards/app/discover/?security_tenant=global#/?_g=(filters:!(),refreshInterval:(pause:!t,value:0),time:(from:now-30d,to:now))&_a=(columns:!(log_url),filters:!(),index:'94869730-aea8-11ec-9e6a-83741af3fdcd',interval:auto,query:(language:kuery,query:'message:%22in%20test_delete_expired%22'),sort:!())

[OpenStack Infra (hudson-openstack)]

Related fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/neutron/+/857810

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/neutron/+/857810
Committed: https://opendev.org/openstack/neutron/commit/075fb6b87476080e7a02d1aa882591ec51eaaa66
Submitter: "Zuul (22348)"
Branch: master

commit 075fb6b87476080e7a02d1aa882591ec51eaaa66
Author: yatinkarel <email address hidden>
Date: Thu Sep 15 11:34:10 2022 +0530

    [Unit] Temporary mark test_delete_expired as unstable

    test_delete_expired unit test is randomly failing since
    oslo.db-12.1.0 release and impacting patches merge, Until
    we have a fix for it let's temporary mark it as unstable.

    Related-Bug: #1988604
    Change-Id: I466de88475d42c075f68fba79fd580e794c6f6e6

[OpenStack Infra (hudson-openstack)]

Related fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/neutron/+/858504

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/neutron/+/858504
Committed: https://opendev.org/openstack/neutron/commit/a765b7acbb3633245bca8d6e00c64c03b2384661
Submitter: "Zuul (22348)"
Branch: master

commit a765b7acbb3633245bca8d6e00c64c03b2384661
Author: Rodolfo Alonso Hernandez <email address hidden>
Date: Thu Sep 15 14:12:12 2022 +0200

    [sqlalchemy-20] Add py39 oslo master to experimental

    In order to quickly detect new changes or errors with the latest oslo.db
    library, this patch adds the "openstack-tox-py39-with-oslo-master" CI
    job to the "neutron-experimental-jobs" queue.

    Related-Bug: #1988604

    Change-Id: Ic8fc6d8701fe17ebd870f57df83f21c110b73849

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/neutron/+/855703
Committed: https://opendev.org/openstack/neutron/commit/9eddb132b2f1828cb36c6b5409b64ec54c2cc7ac
Submitter: "Zuul (22348)"
Branch: master

commit 9eddb132b2f1828cb36c6b5409b64ec54c2cc7ac
Author: Miguel Lavalle <email address hidden>
Date: Fri Sep 2 17:10:11 2022 -0500

    Fix openstack-tox-py39-with-oslo-master job

    DB writer and reader contexts are added to test case [0] to make sure
    updates are commited to DB before testing if objects have been deleted.

    [0] neutron.tests.unit.objects.test_quota.ReservationDbObjectTestCase.test_delete_expired

    Change-Id: I7d3b940db867d97712b6d9de90920dca7c3c23eb
    Closes-Bug: #1988604

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/zed
Review: https://review.opendev.org/c/openstack/neutron/+/858890

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/neutron/+/858890
Committed: https://opendev.org/openstack/neutron/commit/c42cc757f636eeebb417920fc0a40326f59fd3dc
Submitter: "Zuul (22348)"
Branch: stable/zed

commit c42cc757f636eeebb417920fc0a40326f59fd3dc
Author: Miguel Lavalle <email address hidden>
Date: Fri Sep 2 17:10:11 2022 -0500

    Fix openstack-tox-py39-with-oslo-master job

    DB writer and reader contexts are added to test case [0] to make sure
    updates are commited to DB before testing if objects have been deleted.

    [0] neutron.tests.unit.objects.test_quota.ReservationDbObjectTestCase.test_delete_expired

    Change-Id: I7d3b940db867d97712b6d9de90920dca7c3c23eb
    Closes-Bug: #1988604
    (cherry picked from commit 9eddb132b2f1828cb36c6b5409b64ec54c2cc7ac)

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/neutron 21.0.0.0rc2 release candidate.

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/neutron 22.0.0.0rc1 release candidate.