Activity log for bug #1954662

Date Who What changed Old value New value Message
2021-12-13 13:04:40 Rodolfo Alonso bug added bug
2021-12-13 13:04:46 Rodolfo Alonso neutron: assignee Rodolfo Alonso (rodolfo-alonso-hernandez)
2021-12-13 13:04:49 Rodolfo Alonso neutron: importance Undecided High
2021-12-13 15:31:47 Rodolfo Alonso description Just in case, this is related to [1]. In [1] we found that we were deleting the reservations always for a specific resource and project, regardless of the date. The solution was to introduce a timeout (with reasonable value of 20 seconds) to filter the existing reservations. Any recent reservation, created by an ongoing request transaction, is keep in the DB. This bug shows another problem related to situations with very high concurrency. The deletion of the expired reservations cannot be executed at the same time by two or more concurrent transactions. In case this happens, only one transaction will succeed and the others will fail, triggering the DB retry and ending in a DB lock state. [1]https://bugs.launchpad.net/neutron/+bug/1940311 [2]https://github.com/openstack/neutron/blob/e99d9a9d0697a21ba7ec84465f415f60041f3767/neutron/db/quota/driver_nolock.py#L53-L58 Just in case, this is related to [1]. In [1] we found that we were deleting the reservations always for a specific resource and project, regardless of the date. The solution was to introduce a timeout (with reasonable value of 20 seconds) to filter the existing reservations. Any recent reservation, created by an ongoing request transaction, is keep in the DB. This bug shows another problem related to situations with very high concurrency. The deletion of the expired reservations cannot be executed at the same time by two or more concurrent transactions. In case this happens, only one transaction will succeed and the others will fail, triggering the DB retry and ending in a DB lock state. Error log: https://paste.opendev.org/show/811637/ [1]https://bugs.launchpad.net/neutron/+bug/1940311 [2]https://github.com/openstack/neutron/blob/e99d9a9d0697a21ba7ec84465f415f60041f3767/neutron/db/quota/driver_nolock.py#L53-L58
2021-12-13 15:34:07 OpenStack Infra neutron: status New In Progress
2021-12-15 22:19:23 OpenStack Infra neutron: status In Progress Fix Released
2021-12-20 21:16:14 OpenStack Infra tags in-stable-xena
2022-01-14 14:50:32 Bernard Cafarelli tags in-stable-xena in-stable-xena neutron-proactive-backport-potential
2022-03-11 12:09:50 Slawek Kaplonski tags in-stable-xena neutron-proactive-backport-potential in-stable-xena