Since "Zone Update" failure (Zone gets into the ERROR status) is logged as DEBUG, it's hard to find the real reason of failure in worker.log, for example:
2023-06-28 09:28:41.632 7 DEBUG designate.worker.tasks.zone [req-1bd117da-016f-4b68-b48a-5f6e748d5e54 - - - - -] Found serial 1687944380 on 2620:52:0:13b8:5054:ff:fe3e:a9 for zone rand-create_and_update_zone-1127437962.rand-ZonesTest-1775534532.test. __call__ /usr/lib/python3.9/site-packages/designate/worker/tasks/zone.py:334
2023-06-28 09:28:41.634 7 DEBUG designate.worker.tasks.zone [req-1bd117da-016f-4b68-b48a-5f6e748d5e54 - - - - -] Found serial 1687944343 on 2620:52:0:13b8:5054:ff:fe3e:41 for zone rand-create_and_update_zone-1127437962.rand-ZonesTest-1775534532.test. __call__ /usr/lib/python3.9/site-packages/designate/worker/tasks/zone.py:334
2023-06-28 09:28:41.635 7 DEBUG designate.worker.tasks.zone [req-1bd117da-016f-4b68-b48a-5f6e748d5e54 - - - - -] Found serial 1687944380 on 2620:52:0:13b8:5054:ff:fe3e:9e for zone rand-create_and_update_zone-1127437962.rand-ZonesTest-1775534532.test. __call__ /usr/lib/python3.9/site-packages/designate/worker/tasks/zone.py:334
2023-06-28 09:28:41.635 7 DEBUG designate.worker.processing [req-1bd117da-016f-4b68-b48a-5f6e748d5e54 - - - - -] Finished Tasks ['PollForZone', 'PollForZone', 'PollForZone'] in 0.007219s run /usr/lib/python3.9/site-packages/designate/worker/processing.py:86
2023-06-28 09:28:41.636 7 DEBUG designate.worker.tasks.zone [req-1bd117da-016f-4b68-b48a-5f6e748d5e54 - - - - -] Results for polling rand-create_and_update_zone-1127437962.rand-ZonesTest-1775534532.test.-1687944380: DNSQueryResult(positives=2, no_zones=0, consensus_serial=1687944380, results=[1687944343, 1687944380, 1687944380]) parse_query_results /usr/lib/python3.9/site-packages/designate/worker/tasks/zone.py:299
2023-06-28 09:28:41.636 7 DEBUG designate.worker.tasks.zone [req-1bd117da-016f-4b68-b48a-5f6e748d5e54 - - - - -] Unsuccessful poll for rand-create_and_update_zone-1127437962.rand-ZonesTest-1775534532.test. on attempt 10 _do_poll /usr/lib/python3.9/site-packages/designate/worker/tasks/zone.py:407
2023-06-28 09:28:56.652 7 DEBUG designate.storage.impl_sqlalchemy [req-1bd117da-016f-4b68-b48a-5f6e748d5e54 - - - - -] Fetched zone <Zone id:'e974ba81-c2fd-410e-8677-076f49faaebe' type:'PRIMARY' name:'rand-create_and_update_zone-1127437962.rand-ZonesTest-1775534532.test.' pool_id:'794ccc2c-d751-44fe-b57f-8894c9f5c842' serial:'1687944380' action:'UPDATE' status:'PENDING'> _find_zones /usr/lib/python3.9/site-packages/designate/storage/impl_sqlalchemy/__init__.py:252
2023-06-28 09:28:56.653 7 INFO designate.worker.tasks.zone [req-1bd117da-016f-4b68-b48a-5f6e748d5e54 - - - - -] Could not find 1687944380 for rand-create_and_update_zone-1127437962.rand-ZonesTest-1775534532.test. on enough nameservers.
2023-06-28 09:28:56.653 7 DEBUG designate.worker.tasks.zone [req-1bd117da-016f-4b68-b48a-5f6e748d5e54 - - - - -] Updating status for rand-create_and_update_zone-1127437962.rand-ZonesTest-1775534532.test. to ERROR:UPDATE __call__ /usr/lib/python3.9/site-packages/designate/worker/tasks/zone.py:517
This should definitely be changed at least to WARNING.