Bind 9.3.1 Beta 2 and SDB PostgreSQL

Michael Lang michi+bind-users at relay3.jackal-net.at
Tue Feb 15 22:52:33 UTC 2005


Hi all,

can someone tell me why Bind 9.3.1beta2 does take nearly 2 minutes to
answer the query when using SDB PostgreSQL ?
# dig +time=300 @127.0.0.1 -t soa rbl-plus.mail-abuse.org.
;; Warning: ID mismatch: expected ID 56422, got 49575
;; Warning: ID mismatch: expected ID 56422, got 49575

15-Feb-2005 23:44:05.451 socket 0x8e6c6d0 127.0.0.1#46442: packet
received correctly
15-Feb-2005 23:44:05.451 socket 0x8e6c6d0: processing cmsg 0x8e42388
15-Feb-2005 23:44:05.451 client 127.0.0.1#46442: UDP request
15-Feb-2005 23:44:05.451 client 127.0.0.1#46442: using view '_default'
15-Feb-2005 23:44:05.451 client 127.0.0.1#46442: request is not signed
15-Feb-2005 23:44:05.451 client 127.0.0.1#46442: recursion available
15-Feb-2005 23:44:05.451 client 127.0.0.1#46442: query
15-Feb-2005 23:44:05.451 client 127.0.0.1#46442: ns_client_attach: ref =
1
15-Feb-2005 23:44:05.451 client 127.0.0.1#46442: query 'rbl-plus.mail-
abuse.org/SOA/IN' approved
15-Feb-2005 23:45:25.959 client 127.0.0.1#46442: send
^^^^^^^^^^^^^^^^^^^^^^^ last Log 1 Minute 20 Seconds ago, and thats one
of the faster ones ...

15-Feb-2005 23:45:25.959 client 127.0.0.1#46442: sendto
15-Feb-2005 23:45:25.959 client 127.0.0.1#46442: senddone
15-Feb-2005 23:45:25.959 client 127.0.0.1#46442: next
15-Feb-2005 23:45:25.959 client 127.0.0.1#46442: ns_client_detach: ref =
0
15-Feb-2005 23:45:25.959 client 127.0.0.1#46442: endrequest

Zones defined with File are no problem
]# dig @127.0.0.1 -t soa localhost.localdomain.

; <<>> DiG 9.3.0 <<>> @127.0.0.1 -t soa localhost.localdomain.
;; global options:  printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 20030
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 1, ADDITIONAL: 1

;; QUESTION SECTION:
;localhost.localdomain.         IN      SOA

;; ANSWER SECTION:
localhost.localdomain.  86400   IN      SOA     localhost.localdomain.
hostmaster.localhost.localdomain. 2003010115 10800 3600 604800 86400

;; AUTHORITY SECTION:
localhost.localdomain.  86400   IN      NS      localhost.localdomain.

;; ADDITIONAL SECTION:
localhost.localdomain.  86400   IN      A       127.0.0.1

;; Query time: 29 msec
;; SERVER: 127.0.0.1#53(127.0.0.1)
;; WHEN: Tue Feb 15 23:42:43 2005
;; MSG SIZE  rcvd: 116

also the Database is running localy Config Host is set to 127.0.0.1 so
no Resolution Problem should occur.
The Database itself returns the query in 'normal' Response time ...
 SELECT ttl, rdtype, rdata FROM "rbl-plus.mail-abuse.org" WHERE name =
'rbl-plus.mail-abuse.org';
  ttl   | rdtype |                                    rdata
--------+--------
+-----------------------------------------------------------------------------
    300 | SOA    | zb2.mail-abuse.org. rbl-plus.mail-abuse.org.
1108478460 1200 300 604800 300
    300 | TXT    | "Copyright 2005 Kelkea, Inc."
    300 | MX     | 10 mx01.mail-abuse.com.
    300 | MX     | 10 mx02.mail-abuse.com.
    300 | MX     | 10 mx03.mail-abuse.com.
    300 | MX     | 10 mx04.mail-abuse.com.
 581400 | NS     | east1.mail-abuse.org.
 581400 | NS     | east2.mail-abuse.org.
 581400 | NS     | west1.mail-abuse.org.
 581400 | NS     | west2.mail-abuse.org.
 581400 | NS     | west3.mail-abuse.org.
 581400 | NS     | west4.mail-abuse.org.
 581400 | NS     | west5.mail-abuse.org.
 581400 | NS     | west6.mail-abuse.org.
(14 rows)

Time: 0.670 ms

the hole named is blocking when query the database, no rndc no other dig
and nothing else works ...

any suggestions ?
I found a way to Load rbl-plus.mail-abuse.org in nearly 25 Minutes into
PostgreSQL but now the Server lacks doing what it should be ... ;(

Kind regards
Michael Lang




More information about the bind-users mailing list