[Pdns-users] Select of orphaned records with domainname

[Christian Kuehn]

Hi,

using pdns-2.9.21, we found this strange answer:

Asking the pdns for an A-cecord:

; <<>> DiG 9.4.1 <<>> nicole.de
; (1 server found)
;; global options:  printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 59865
;; flags: qr aa rd; QUERY: 1, ANSWER: 2, AUTHORITY: 0, ADDITIONAL: 0
;; WARNING: recursion requested but not available

;; QUESTION SECTION:
;nicole.de.			IN	A

;; ANSWER SECTION:
nicole.de.		21600	IN	A	212.1.40.1
nicole.de.		10800	IN	A	82.165.56.21


Asking again for AXFR:

; <<>> DiG 9.4.1 <<>> nicole.de  axfr
; (1 server found)
;; global options:  printcmd
nicole.de.		21600	IN	SOA	hpri.mcs.de. hostmaster.mcs.de. 2007072001 28800 7200
604800 600
nicole.de.		21600	IN	A	212.1.40.1
www.nicole.de.		21600	IN	CNAME	www.nicolescherzinger.de.
nicole.de.		21600	IN	NS	dns-auth-3.mcs.de.
nicole.de.		21600	IN	NS	dns-auth-2.mcs.de.
nicole.de.		21600	IN	NS	dns-auth-1.mcs.de.
nicole.de.		21600	IN	NS	dns-auth-4.mcs.de.
nicole.de.		21600	IN	SOA	hpri.mcs.de. hostmaster.mcs.de. 2007072001 28800 7200
604800 600


You can see, that there is only ONE A-record.

Looking into the database I found the a.m. 7 records in the 'records'-table,
refering to the actual domain-table-record.

Searching for the suspect addition record, I found 4 old records in the
records-table, without any corresponding record in the domain-table.
But, the records contains the domainname 'nicole.de' and the pdns select them
both, means the A-record with corresponding domain-record and the orphaned A-record.

The axfr works correkt, just the query for a single record is wrong.


OK, the database should be more clean, without any orphaned records int the
records-table (using the constraint ON DELETE CASCADE...)

But, the pdns should not look for any orphaned records in the records-table!


Cheers
Christian




-- 
Christian Kühn
(Technical Consultant / Hostmaster)

======================================================
MCS MOORBEK COMPUTER SYSTEME GmbH
Essener Bogen 17 - 22419 Hamburg - Germany
Tel +49 (0)40 53773 0 - Fax: +49 (0)40 53773 200
E-Mail: christian.kuehn at mcs.de
Web: http://www.mcs.de
Eingetragen im Handelsregister Hamburg B62933
Geschäftsführer: Kai Brandes & Eckard Kabel
GPG 8B52 41A1 4B8F 4DE7 9064  2073 6168 137A 3DDA 0F36
======================================================