)]}'
{"/PATCHSET_LEVEL":[{"author":{"_account_id":29632,"name":"Carlos Eduardo","email":"ces.eduardo98@gmail.com","username":"silvacarlos"},"change_message_id":"0e58a9ce033d5f4c204dcd3b87e052e9469dde61","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":4,"id":"261ea33a_4895962c","updated":"2023-01-23 19:02:07.000000000","message":"LGTM, thanks Stephen!","commit_id":"e7a74a096b769e0d9621979aea1ed6026ff8790e"},{"author":{"_account_id":16643,"name":"Goutham Pacha Ravi","email":"gouthampravi@gmail.com","username":"gouthamr"},"change_message_id":"12e493a27db5e0de0eec9c1092149a217aa2d70c","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":4,"id":"3aa8e370_a6e08188","updated":"2023-01-09 18:04:40.000000000","message":"LGTM, thanks Stephen!","commit_id":"e7a74a096b769e0d9621979aea1ed6026ff8790e"},{"author":{"_account_id":16643,"name":"Goutham Pacha Ravi","email":"gouthampravi@gmail.com","username":"gouthamr"},"change_message_id":"2e2227bfd80eb9ddea82e139db3bf0d954a30881","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":4,"id":"c87b5e91_1ab64ccc","updated":"2023-01-25 15:59:36.000000000","message":"The failure here: https://zuul.opendev.org/t/openstack/build/32e078ea50514d87a3e7dc68059ee74f/log/job-output.txt#9929\n\n Jan 24 09:58:18 np0032843146 manila-data[35363]: ERROR oslo_service.service oslo_db.exception.DBDuplicateEntry: (pymysql.err.IntegrityError) (1062, \"Duplicate entry \u0027nova-False\u0027 for key \u0027availability_zones.az_name_uc\u0027\")\nJan 24 09:58:18 np0032843146 manila-data[35363]: ERROR oslo_service.service [SQL: INSERT INTO availability_zones (created_at, updated_at, deleted_at, id, deleted, name) VALUES (%(created_at)s, %(updated_at)s, %(deleted_at)s, %(id)s, %(deleted)s, %(name)s)]\n\nSeems related to the new uniqueness constraint (\u0027availability_zones.az_name_uc\u0027) added here: https://review.opendev.org/c/openstack/manila/+/856144/4/manila/db/sqlalchemy/models.py#1205\n\n","commit_id":"e7a74a096b769e0d9621979aea1ed6026ff8790e"},{"author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"change_message_id":"4a79e78082dcbf48e2932d46b30ffe9f28ab2d5f","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":4,"id":"14ab4d19_01a30ec4","updated":"2023-01-24 09:42:05.000000000","message":"recheck","commit_id":"e7a74a096b769e0d9621979aea1ed6026ff8790e"},{"author":{"_account_id":16643,"name":"Goutham Pacha Ravi","email":"gouthampravi@gmail.com","username":"gouthamr"},"change_message_id":"ef82094219a3b4c37249acb450cb163e7965d935","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":4,"id":"88e30b3d_d87585a2","in_reply_to":"c87b5e91_1ab64ccc","updated":"2023-01-25 16:49:18.000000000","message":"It is strange though that it\u0027s happening only on one of the test jobs \n\n- manila\u0027s devstack plugin starts the \"data\" service, and it\u0027s in the default \"nova\" AZ.. https://opendev.org/openstack/manila/src/commit/2f335893f6019929b0f0cb4347548a7645277f7a/devstack/plugin.sh#L892\n\n- We seek to create a service record in the database while launching the service; the service record involves the AZ, and there\u0027s a create-if-it-doesn\u0027t-exist logic via exception handling:\n\nhttps://opendev.org/openstack/manila/src/commit/32176292887567563b4c8dd5ed7158686992fa56/manila/db/sqlalchemy/api.py#L5016-L5022\n\nI wonder why this exception handling isn\u0027t kicking in causing this failure..","commit_id":"e7a74a096b769e0d9621979aea1ed6026ff8790e"}]}