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

[Keresztes Péter-Zoltán]

Hello,

I finally have some logs when this issue is happening: 

Here is what I can find in the logs:

Mar  5 16:57:21 dns1 pdns[7111]: 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
Mar  5 16:57:21 dns1 pdns[7111]: 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
Mar  5 16:57:21 dns1 pdns_server[7109]: Mar 05 16:57:21 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
Mar  5 16:57:21 dns1 pdns_server[7109]: Mar 05 16:57:21 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

Regards,
Peter

> On 26 Feb 2016, at 20:31, Keresztes Péter-Zoltán <zozo at z0z0.tk> wrote:
> 
> 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
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20160307/1435a61d/attachment.html>