OpenStack Designate failed to create zones when configuring multiple pools

Can you provide the error you get?

Here is the log of the designate-worker when the zone creation failed in non-default pool:
2023-02-28 01:40:39.530 17 INFO designate.worker.service [req-ffedfb33-9c8f-4525-bde5-4b5a044b85d3 ea5b595b241d45f785083490ef251d79 b15e413b73034d8b9527aecd0d7e9ec1 - - -] Lazily loading pool 48f7da36-223a-48d0-bb66-58280bab84c3
2023-02-28 01:40:39.590 17 DEBUG designate.plugin [req-25e0de66-6340-4c92-87ae-48d20c0f025e - - - - -] Looking for driver bind9 in designate.backend get_driver /var/lib/kolla/venv/lib/python3.8/site-packages/designate/plugin.py:67
2023-02-28 01:40:39.591 17 INFO designate.backend [req-25e0de66-6340-4c92-87ae-48d20c0f025e - - - - -] Backend Driver 'bind9' loaded. Has status of 'integrated'
2023-02-28 01:40:39.592 17 DEBUG designate.plugin [req-25e0de66-6340-4c92-87ae-48d20c0f025e - - - - -] Loaded plugin backend:bind9 __init__ /var/lib/kolla/venv/lib/python3.8/site-packages/designate/plugin.py:35
2023-02-28 01:40:39.597 17 INFO designate.worker.service [req-38d1682f-a27a-4a20-87e0-0e0c19273b96 - - - - -] 1 targets setup
2023-02-28 01:40:39.599 17 INFO designate.worker.tasks.zone [req-38d1682f-a27a-4a20-87e0-0e0c19273b96 - - - - -] Attempting CREATE on zone sondh250.com.
2023-02-28 01:40:39.600 17 DEBUG designate.worker.tasks.zone [req-38d1682f-a27a-4a20-87e0-0e0c19273b96 - - - - -] Attempting CREATE zone sondh250.com. on <PoolTarget id:'954801e9-cef1-4b8b-93e7-9046e9b62dbd' type:'bind9' pool_id:'48f7da36-223a-48d0-bb66-58280bab84c3'> __call__ /var/lib/kolla/venv/lib/python3.8/site-packages/designate/worker/tasks/zone.py:69
2023-02-28 01:40:39.601 17 DEBUG designate.backend.impl_bind9 [req-38d1682f-a27a-4a20-87e0-0e0c19273b96 - - - - -] Create Zone create_zone /var/lib/kolla/venv/lib/python3.8/site-packages/designate/backend/impl_bind9.py:80
2023-02-28 01:40:39.602 17 DEBUG designate.backend.impl_bind9 [req-38d1682f-a27a-4a20-87e0-0e0c19273b96 - - - - -] Executing RNDC call: ['rndc', '-s', '10.240.234.112', '-p', '953', '-k', '/etc/designate/rndc.key', 'addzone', 'sondh250.com { type slave; masters { 10.240.234.110 port 5354;}; file "slave.sondh250.com.af66b10e-bb30-4c9b-9f32-ef8ead13e969"; };'] with timeout None _execute_rndc /var/lib/kolla/venv/lib/python3.8/site-packages/designate/backend/impl_bind9.py:210
2023-02-28 01:40:39.602 17 DEBUG oslo_concurrency.processutils [req-38d1682f-a27a-4a20-87e0-0e0c19273b96 - - - - -] Running cmd (subprocess): sudo designate-rootwrap /etc/designate/rootwrap.conf rndc -s 10.240.234.112 -p 953 -k /etc/designate/rndc.key addzone sondh250.com { type slave; masters { 10.240.234.110 port 5354;}; file "slave.sondh250.com.af66b10e-bb30-4c9b-9f32-ef8ead13e969"; }; execute /var/lib/kolla/venv/lib/python3.8/site-packages/oslo_concurrency/processutils.py:384
2023-02-28 01:40:40.578 17 DEBUG oslo_concurrency.processutils [req-38d1682f-a27a-4a20-87e0-0e0c19273b96 - - - - -] CMD "sudo designate-rootwrap /etc/designate/rootwrap.conf rndc -s 10.240.234.112 -p 953 -k /etc/designate/rndc.key addzone sondh250.com { type slave; masters { 10.240.234.110 port 5354;}; file "slave.sondh250.com.af66b10e-bb30-4c9b-9f32-ef8ead13e969"; };" returned: 0 in 0.975s execute /var/lib/kolla/venv/lib/python3.8/site-packages/o...

I am wondering, did you add the tsig key for the pool to Designate?

openstack tsigkey create --name pool2 --algorithm <algorithm> --secret <secret> --scope POOL --resource-id <pool2 ID>

MDNS will expect a tsig key for the pool.