Comment 2 for bug 1995918

Hey @johnsom, thank you very much for your reply. Here is my pools.yaml, there have been "masters" defined for the default pool.

# cat /tmp/check-pool.yaml
- also_notifies: []
  attributes: {}
  description: Pool genergated by Juju
  id: 794ccc2c-d751-44fe-b57f-8894c9f5c842
  name: default
  nameservers:
  - host: 10.5.1.99
    port: 53
  ns_records:
  - hostname: ns1.extdns.example2.
    priority: 10
  targets:
  - masters:
    - host: 10.5.0.88
      port: 5354
    options:
      host: 10.5.1.99
      port: '53'
      rndc_host: 10.5.1.99
      rndc_key_file: /etc/designate/rndc.key
    type: bind9

and it seems that from time to time, the zonemasters listed in the MySQL database designate.zone_masters will disappear when the message is displayed.

1, Sometimes I saw a record was created in the table zone_masters

mysql> select * from zone_masters;
+----------------------------------+---------+---------------------+------------+-----------+------+----------------------------------+
| id | version | created_at | updated_at | host | port | zone_id |
+----------------------------------+---------+---------------------+------------+-----------+------+----------------------------------+
| fd17132d10a0417f9e69c6b9066ecda8 | 1 | 2022-11-07 11:30:17 | NULL | 10.5.0.88 | 5354 | 90c51bbbc03e4fefa87a8e53263497b9 |
+----------------------------------+---------+---------------------+------------+-----------+------+----------------------------------+
1 row in set (0.00 sec)

$ dig +noall +answer @10.5.0.88 -p 5354 extdns.example2. axfr
extdns.example2. 3600 IN SOA ns1.extdns.example2. extdns.example. 1667822134 3529 600 86400 3600
extdns.example2. 3600 IN NS ns1.extdns.example2.
ns1.extdns.example2. 3600 IN A 10.5.1.99
extdns.example2. 3600 IN SOA ns1.extdns.example2. extdns.example. 1667822134 3529 600 86400 3600

2, But sometimes I saw this record disappeared automatically,

mysql> select * from zone_masters;
Empty set (0.00 sec)

so then we saw the exception ZoneMasterNotFound

root@juju-781502-dns-1:/home/ubuntu# grep -r ZoneMasterNotFound /var/log/designate/designate-mdns.log |tail -n1
2022-11-09 12:34:26.687 154700 ERROR oslo_messaging.rpc.server designate.exceptions.ZoneMasterNotFound: Could not find ZoneMaster