clarify whether the behavior of authoritative PowerDNS (version 5.1.3, PostgreSQL backend) is correct

[BadikovVV]

Please clarify whether the behavior of authoritative PowerDNS (version 5.1.3, PostgreSQL backend) is correct.
There is a zone myzone.org.
It contains two records:

1. mypod.myzone.org A 10.10.10.10 - disabled status is true

2. *.mypod.myzone.org A 10.10.10.10 - disabled status is false

dig mypod.myzone.org - NOERROR but returns only SOA
dig myhost.mypod.myzone.org - NOERROR returns 10.10.10.10
If I physically delete record No. 1, then the query dig mypod.myzone.org returns 10.10.10.10.

[miodvallat]

Did you rectify your zone (pdnsutil zone rectify) after removing the first record, to make sure a proper empty non-terminal record is created for the now otherwise empty mypod.myzone.org?

[BadikovVV]

I did not delete the first record, I set the disabled field to True.

[miodvallat]

But did you rectify the zone afterwards? From an operational point of view, disabling a record is similar to removing it, as it will no longer be considered as a possible result, and in this case, an empty non-terminal record needs to be added to fill the mypod.myzone.org level with a non-disabled record.

[Habbie]

Please post actual (unedited) zone contents and dig output. What you are describing does not make sense to me.

[BadikovVV]

pdns=# select *  from records where  name like '%myprod%' and type ='A';
  id      | domain_id  |               name                                   | type   |    content          | ttl       | prio   | disabled   | ordername | auth 
-------+-----------+-----------------------------------+------+---------------+------+------+----------+-----------+------
 22169 |       160      | mypod.myzone.org                           | A       | 10.10.10.10.      | 3600  |    0     | t               |                    | t
 22365 |       160.     | *.mypod.myzone.org.                       | A       |  10.10.10.10.     | 3600  |    0     | f               |                    | t
(2 rows)

dig output
`% dig @8.8.8.8 mypod.myzone.org.

; <<>> DiG 9.10.6 <<>> @8.8.8.8 mypod.myzone.org.
; (1 server found)
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 51510
;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 1

;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 1232
;; QUESTION SECTION:
;mypod.myzone.org. IN A

;; AUTHORITY SECTION:
myzone.org. 3079 IN SOA ns01.myzone.org. hostmaster.myzone.org. 2026092782 21600 3600 604800 86400

;; Query time: 38 msec
;; SERVER: 8.8.8.8#53(8.8.8.8)
`

[Habbie]

actual (unedited)

you missed this bit. Please try again.