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

[Keresztes Péter-Zoltán]

I have enabled the query logging and increased the log level  however now I need to wait for it to happen which should happen in the next two days. That is the frequency this issue is happening. 

By stop working I mean that the powerdns does not send response to the request. 

The configuration file look like this:

cache-ttl=20
config-dir=/etc/powerdns
daemon=yes
default-soa-edit=ns1.dnsmadefree.com
default-soa-mail=hostmaster at dnsmadefree.com
default-soa-name=ns1.dnsmadefree.com
default-ttl=3600
disable-tcp=no
distributor-threads=3
guardian=yes
include-dir=/etc/powerdns/pdns.d
launch=gmysql
local-address=0.0.0.0
local-port=53
loglevel=4
master=no
max-tcp-connections=10
module-dir=/usr/lib/x86_64-linux-gnu/pdns
negquery-cache-ttl=60
query-cache-ttl=20
receiver-threads=1
retrieval-threads=2
reuseport=yes
server-id=ns1.dnsmadefree.com
setgid=pdns
setuid=pdns
signing-threads=3
soa-expire-default=604800
soa-minimum-ttl=3600
soa-refresh-default=10800
soa-retry-default=3600
write-pid=yes

gmysql-dnssec
gmysql-user=someuser
gmysql-password=somepass
gmysql-dbname=somedb
gmysql-host=10.160.125.69

Regards,
Peter
> On 26 Feb 2016, at 15:18, Pieter Lexis <pieter.lexis at powerdns.com> wrote:
> 
> 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
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users