)]}'
{"/COMMIT_MSG":[{"author":{"_account_id":13861,"name":"yatin","email":"ykarel@redhat.com","username":"yatinkarel"},"change_message_id":"4625d24dc45fe16314bc4067c13f1c11bac4e0f0","unresolved":true,"context_lines":[{"line_number":12,"context_line":"allocations. The next workers will check that the database is correctly"},{"line_number":13,"context_line":"updated and will exit this method."},{"line_number":14,"context_line":""},{"line_number":15,"context_line":"Closes-Bug: #2089940"},{"line_number":16,"context_line":"Related-Bug: #2083570"},{"line_number":17,"context_line":"Change-Id: I208ba38bff9191cabcc1325fec516d0b0179c97c"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":6,"id":"f6cbb111_0325e2c0","line":15,"range":{"start_line":15,"start_character":0,"end_line":15,"end_character":6},"updated":"2024-12-09 06:31:34.000000000","message":"Can see the same traces from bug description in test patch would be good to avoid those, although the patch itself should skip some tasks but still there could be race as all wsgi workers being spawned concurrently and pass the current check injected in the patch\nDec 06 12:53:24.674693 np0039273400 devstack@neutron-api.service[62087]: DEBUG neutron_lib.db.api [None req-7ab7a1b7-9372-4a51-9bc4-30dd517f9737 None None] Retry wrapper got retriable exception: (pymysql.err.IntegrityError) (1062, \"Duplicate entry \u00271\u0027 for key \u0027ml2_geneve_allocations.PRIMARY\u0027\")\nDec 06 12:53:24.674693 np0039273400 devstack@neutron-api.service[62087]: [SQL: INSERT INTO ml2_geneve_allocations (geneve_vni, allocated) VALUES (%(geneve_vni)s, %(allocated)s)]\nDec 06 12:53:24.674693 np0039273400 devstack@neutron-api.service[62087]: [parameters: [{\u0027geneve_vni\u0027: 1, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 2, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 3, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 4, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 5, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 6, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 7, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 8, \u0027allocated\u0027: 0}  ... displaying 10 of 100 total bound parameter sets ...  {\u0027geneve_vni\u0027: 99, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 100, \u0027allocated\u0027: 0}]]\nDec 06 12:53:24.674693 np0039273400 devstack@neutron-api.service[62087]: (Background on this error at: https://sqlalche.me/e/20/gkpj) {{(pid\u003d62087) wrapped /opt/stack/data/venv/lib/python3.12/site-packages/neutron_lib/db/api.py:185}}\nDec 06 12:53:24.674693 np0039273400 devstack@neutron-api.service[62087]: DEBUG oslo_db.api [None req-7ab7a1b7-9372-4a51-9bc4-30dd517f9737 None None] Performing DB retry for function neutron.plugins.ml2.drivers.type_tunnel._TunnelTypeDriverBase.sync_allocations {{(pid\u003d62087) wrapper /opt/stack/data/venv/lib/python3.12/site-packages/oslo_db/api.py:155}}\nDec 06 12:53:24.675974 np0039273400 devstack@neutron-api.service[62086]: DEBUG neutron_lib.db.api [None req-514590f0-f1a7-41a3-b824-52bbff65eb0e None None] Retry wrapper got retriable exception: (pymysql.err.IntegrityError) (1062, \"Duplicate entry \u00271\u0027 for key \u0027ml2_geneve_allocations.PRIMARY\u0027\")\nDec 06 12:53:24.675974 np0039273400 devstack@neutron-api.service[62086]: [SQL: INSERT INTO ml2_geneve_allocations (geneve_vni, allocated) VALUES (%(geneve_vni)s, %(allocated)s)]\nDec 06 12:53:24.675974 np0039273400 devstack@neutron-api.service[62086]: [parameters: [{\u0027geneve_vni\u0027: 1, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 2, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 3, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 4, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 5, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 6, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 7, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 8, \u0027allocated\u0027: 0}  ... displaying 10 of 100 total bound parameter sets ...  {\u0027geneve_vni\u0027: 99, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 100, \u0027allocated\u0027: 0}]]\nDec 06 12:53:24.675974 np0039273400 devstack@neutron-api.service[62086]: (Background on this error at: https://sqlalche.me/e/20/gkpj) {{(pid\u003d62086) wrapped /opt/stack/data/venv/lib/python3.12/site-packages/neutron_lib/db/api.py:185}}\nDec 06 12:53:24.675974 np0039273400 devstack@neutron-api.service[62086]: DEBUG oslo_db.api [None req-514590f0-f1a7-41a3-b824-52bbff65eb0e None None] Performing DB retry for function neutron.plugins.ml2.drivers.type_tunnel._TunnelTypeDriverBase.sync_allocations {{(pid\u003d62086) wrapper /opt/stack/data/venv/lib/python3.12/site-packages/oslo_db/api.py:155}}\nDec 06 12:53:24.676489 np0039273400 devstack@neutron-api.service[62088]: DEBUG neutron_lib.db.api [None req-3b42107a-80bd-447e-be10-8077b2c48529 None None] Retry wrapper got retriable exception: (pymysql.err.IntegrityError) (1062, \"Duplicate entry \u00271\u0027 for key \u0027ml2_geneve_allocations.PRIMARY\u0027\")\nDec 06 12:53:24.676489 np0039273400 devstack@neutron-api.service[62088]: [SQL: INSERT INTO ml2_geneve_allocations (geneve_vni, allocated) VALUES (%(geneve_vni)s, %(allocated)s)]\nDec 06 12:53:24.676489 np0039273400 devstack@neutron-api.service[62088]: [parameters: [{\u0027geneve_vni\u0027: 1, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 2, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 3, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 4, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 5, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 6, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 7, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 8, \u0027allocated\u0027: 0}  ... displaying 10 of 100 total bound parameter sets ...  {\u0027geneve_vni\u0027: 99, \u0027allocated\u0027: 0}, {\u0027geneve_vni\u0027: 100, \u0027allocated\u0027: 0}]]\nDec 06 12:53:24.676489 np0039273400 devstack@neutron-api.service[62088]: (Background on this error at: https://sqlalche.me/e/20/gkpj) {{(pid\u003d62088) wrapped /opt/stack/data/venv/lib/python3.12/site-packages/neutron_lib/db/api.py:185}}\nDec 06 12:53:24.676489 np0039273400 devstack@neutron-api.service[62088]: DEBUG oslo_db.api [None req-3b42107a-80bd-447e-be10-8077b2c48529 None None] Performing DB retry for function neutron.plugins.ml2.drivers.type_tunnel._TunnelTypeDriverBase.sync_allocations {{(pid\u003d62088) wrapper /opt/stack/data/venv/lib/python3.12/site-packages/oslo_db/api.py:155}}","commit_id":"2dda971bbd1908e54819ce26bc3fbc44186b6882"},{"author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"change_message_id":"510bf4163073ef6eb85816384e88ef2c6fc20712","unresolved":false,"context_lines":[{"line_number":12,"context_line":"allocations. The next workers will check that the database is correctly"},{"line_number":13,"context_line":"updated and will exit this method."},{"line_number":14,"context_line":""},{"line_number":15,"context_line":"Closes-Bug: #2089940"},{"line_number":16,"context_line":"Related-Bug: #2083570"},{"line_number":17,"context_line":"Change-Id: I208ba38bff9191cabcc1325fec516d0b0179c97c"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":6,"id":"9f51099a_2fd9c517","line":15,"range":{"start_line":15,"start_character":0,"end_line":15,"end_character":6},"in_reply_to":"f6cbb111_0325e2c0","updated":"2024-12-09 07:20:52.000000000","message":"Actually this patch won\u0027t be very effective in the CI because the geneve registers are not created yet. Despite the messages are not elegant, the DB operation is retried but the registers cannot be duplicated nor deleted. We need to rely on the DB engine transactionality.","commit_id":"2dda971bbd1908e54819ce26bc3fbc44186b6882"}],"/PATCHSET_LEVEL":[{"author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"change_message_id":"710d5788ca8f6062d334272ea60f42ac81299f94","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":4,"id":"c12fb9e5_ac117628","updated":"2024-12-04 07:32:26.000000000","message":"recheck neutron-functional","commit_id":"4ef5b3f50a5f217eb18ea1107313ccdd2dbda7dd"},{"author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"change_message_id":"1da6b74e5ae93c9fd9edeb51247771ae7a20fe64","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":5,"id":"67fe5b62_c5f5153b","updated":"2024-12-05 11:24:33.000000000","message":"recheck neutron-functional","commit_id":"7f3eac544cb3a78345155cfd2e6ce32d036641d4"},{"author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"change_message_id":"5a1fa8f81138dd1cefd0cebef9ff45527b83c948","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":6,"id":"335a44fb_1e6529dc","updated":"2024-12-09 06:56:12.000000000","message":"recheck neutron-fullstack","commit_id":"2dda971bbd1908e54819ce26bc3fbc44186b6882"},{"author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"change_message_id":"7bbe01b90b5fbd4e3baf04c326b58ba8b65a5f34","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":10,"id":"f9bace8f_8e99535d","updated":"2024-12-18 10:09:59.000000000","message":"recheck FTs","commit_id":"dce01d7550642ec478eaeb19deded4c974134ea9"},{"author":{"_account_id":13861,"name":"yatin","email":"ykarel@redhat.com","username":"yatinkarel"},"change_message_id":"ac85943e4b9f48ae8f977ef1dd026f83701fb32d","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":10,"id":"0800a761_5b4d25df","updated":"2024-12-18 06:41:07.000000000","message":"recheck blocked kernel build","commit_id":"dce01d7550642ec478eaeb19deded4c974134ea9"},{"author":{"_account_id":13861,"name":"yatin","email":"ykarel@redhat.com","username":"yatinkarel"},"change_message_id":"ff27068b32ec23ad2c695ea1520fb80c36a4141a","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":10,"id":"35b8ebc7_8ce6618a","updated":"2024-12-16 04:50:26.000000000","message":"recheck https://bugs.launchpad.net/neutron/+bug/2083609","commit_id":"dce01d7550642ec478eaeb19deded4c974134ea9"},{"author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"change_message_id":"0aae94f8df4d182af2a1a659ff1dbec675669bbd","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":10,"id":"f14c0d46_295f1001","updated":"2024-12-16 21:19:20.000000000","message":"recheck neutron-tempest-plugin-ovn","commit_id":"dce01d7550642ec478eaeb19deded4c974134ea9"},{"author":{"_account_id":1131,"name":"Brian Haley","email":"haleyb.dev@gmail.com","username":"brian-haley"},"change_message_id":"10ac4b3003c099ea1fd7a613a22a4604233fb48c","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":10,"id":"b0ce8460_d51f6aba","updated":"2024-12-14 23:03:03.000000000","message":"recheck ovs","commit_id":"dce01d7550642ec478eaeb19deded4c974134ea9"},{"author":{"_account_id":13861,"name":"yatin","email":"ykarel@redhat.com","username":"yatinkarel"},"change_message_id":"b61350c4cbd3eb6cf29417c9f7319cb371d45f57","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":10,"id":"95b021e1_6bad5877","updated":"2024-12-18 04:24:07.000000000","message":"we have real issue with jobs running ubuntu jammy so recheck will not help until that\u0027s clear","commit_id":"dce01d7550642ec478eaeb19deded4c974134ea9"},{"author":{"_account_id":13861,"name":"yatin","email":"ykarel@redhat.com","username":"yatinkarel"},"change_message_id":"4b66d3dd44168d9dcfa974f779eb4c9a0dc22032","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":10,"id":"55e0438f_34059a05","in_reply_to":"95b021e1_6bad5877","updated":"2024-12-18 06:32:59.000000000","message":"reported https://bugs.launchpad.net/neutron/+bug/2091990","commit_id":"dce01d7550642ec478eaeb19deded4c974134ea9"}],"neutron/plugins/ml2/drivers/type_tunnel.py":[{"author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"change_message_id":"665b7296cdec4f40fa5b74a9597aa4ce149fedf3","unresolved":true,"context_lines":[{"line_number":202,"context_line":"            # Check if the allocations are updated. Fast exit in that case."},{"line_number":203,"context_line":"            # If another worker handled that before, this section will end"},{"line_number":204,"context_line":"            # here."},{"line_number":205,"context_line":"            num_allocs \u003d ctx.session.query(self.model).filter("},{"line_number":206,"context_line":"                tunnel_col.in_(tunnel_ids)).count()"},{"line_number":207,"context_line":"            if len(tunnel_ids) \u003d\u003d num_allocs:"},{"line_number":208,"context_line":"                return"},{"line_number":209,"context_line":""}],"source_content_type":"text/x-python","patch_set":2,"id":"3a138c3f_180d18a3","line":206,"range":{"start_line":205,"start_character":11,"end_line":206,"end_character":51},"updated":"2024-12-02 13:19:13.000000000","message":"This check should also retrieve all self.model registers to check that there are no leftovers.","commit_id":"55e0610de683ca018905766cd243acd23f394d46"},{"author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"change_message_id":"a118d40614778af183a382233a09c85086f3b4aa","unresolved":false,"context_lines":[{"line_number":202,"context_line":"            # Check if the allocations are updated. Fast exit in that case."},{"line_number":203,"context_line":"            # If another worker handled that before, this section will end"},{"line_number":204,"context_line":"            # here."},{"line_number":205,"context_line":"            num_allocs \u003d ctx.session.query(self.model).filter("},{"line_number":206,"context_line":"                tunnel_col.in_(tunnel_ids)).count()"},{"line_number":207,"context_line":"            if len(tunnel_ids) \u003d\u003d num_allocs:"},{"line_number":208,"context_line":"                return"},{"line_number":209,"context_line":""}],"source_content_type":"text/x-python","patch_set":2,"id":"a268d0c2_3e39e2f0","line":206,"range":{"start_line":205,"start_character":11,"end_line":206,"end_character":51},"in_reply_to":"3a138c3f_180d18a3","updated":"2024-12-03 07:52:05.000000000","message":"Done","commit_id":"55e0610de683ca018905766cd243acd23f394d46"}]}