[Pdns-users] powerdns authoritative 4.0.0 alpha stops working from time to time

[Pieter Lexis]

Hi Peter,

On Fri, 26 Feb 2016 14:49:16 +0200
Keresztes Péter-Zoltán <zozo at z0z0.tk> wrote:

> I have installed the new 4.0 version of the pdns. It works great however from time to time it suddenly stops working. In the logs I see lots of these:

By "stops working", do you mean that the process dies or it just stops responding or it only sends out SERVFAILs?

> Feb 26 07:42:34 dns1 pdns[6514]: Backend reported condition which prevented lookup (GSQLBackend lookup query: Attempt to bind more parameters than query has: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=?) sending out servfail

This is the `basic-query`, interesting that it gives this error, as we never bind more than 2 elements in the code.

If your server is not stressed for resources could you set `query-logging=yes` in the pdns.conf (with possibly `loglevel=7` as well if no queries show up in syslog) to identify the query that causes this and share the results with us?

Secondly, could you share your pdns.conf (without passwords)?

Best regards,

Pieter

-- 
Pieter Lexis
PowerDNS.COM BV -- https://www.powerdns.com