<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hello,<div class=""><br class=""></div><div class="">I finally have some logs when this issue is happening: </div><div class=""><br class=""></div><div class="">Here is what I can find in the logs:</div><div class=""><br class=""></div><div class=""><div class="" style="margin: 0px; font-size: 10px; line-height: normal; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">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</div><div class="" style="margin: 0px; font-size: 10px; line-height: normal; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">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</div><div class="" style="margin: 0px; font-size: 10px; line-height: normal; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">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</div><div class="" style="margin: 0px; font-size: 10px; line-height: normal; font-family: Monaco; color: rgb(245, 245, 245); background-color: rgb(0, 0, 0);">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</div></div><div class=""><br class=""></div><div class="">Regards,</div><div class="">Peter</div><div class=""><br class=""></div><div style=""><blockquote type="cite" class=""><div class="">On 26 Feb 2016, at 20:31, Keresztes Péter-Zoltán <<a href="mailto:zozo@z0z0.tk" class="">zozo@z0z0.tk</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">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. <br class=""><br class="">By stop working I mean that the powerdns does not send response to the request. <br class=""><br class="">The configuration file look like this:<br class=""><br class="">cache-ttl=20<br class="">config-dir=/etc/powerdns<br class="">daemon=yes<br class="">default-soa-edit=<a href="http://ns1.dnsmadefree.com" class="">ns1.dnsmadefree.com</a><br class=""><a href="mailto:default-soa-mail=hostmaster@dnsmadefree.com" class="">default-soa-mail=hostmaster@dnsmadefree.com</a><br class="">default-soa-name=ns1.dnsmadefree.com<br class="">default-ttl=3600<br class="">disable-tcp=no<br class="">distributor-threads=3<br class="">guardian=yes<br class="">include-dir=/etc/powerdns/pdns.d<br class="">launch=gmysql<br class="">local-address=0.0.0.0<br class="">local-port=53<br class="">loglevel=4<br class="">master=no<br class="">max-tcp-connections=10<br class="">module-dir=/usr/lib/x86_64-linux-gnu/pdns<br class="">negquery-cache-ttl=60<br class="">query-cache-ttl=20<br class="">receiver-threads=1<br class="">retrieval-threads=2<br class="">reuseport=yes<br class="">server-id=ns1.dnsmadefree.com<br class="">setgid=pdns<br class="">setuid=pdns<br class="">signing-threads=3<br class="">soa-expire-default=604800<br class="">soa-minimum-ttl=3600<br class="">soa-refresh-default=10800<br class="">soa-retry-default=3600<br class="">write-pid=yes<br class=""><br class="">gmysql-dnssec<br class="">gmysql-user=someuser<br class="">gmysql-password=somepass<br class="">gmysql-dbname=somedb<br class="">gmysql-host=10.160.125.69<br class=""><br class="">Regards,<br class="">Peter<br class=""><blockquote type="cite" class="">On 26 Feb 2016, at 15:18, Pieter Lexis <pieter.lexis@powerdns.com> wrote:<br class=""><br class="">Hi Peter,<br class=""><br class="">On Fri, 26 Feb 2016 14:49:16 +0200<br class="">Keresztes Péter-Zoltán <zozo@z0z0.tk> wrote:<br class=""><br class=""><blockquote type="cite" class="">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:<br class=""></blockquote><br class="">By "stops working", do you mean that the process dies or it just stops responding or it only sends out SERVFAILs?<br class=""><br class=""><blockquote type="cite" class="">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<br class=""></blockquote><br class="">This is the `basic-query`, interesting that it gives this error, as we never bind more than 2 elements in the code.<br class=""><br class="">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?<br class=""><br class="">Secondly, could you share your pdns.conf (without passwords)?<br class=""><br class="">Best regards,<br class=""><br class="">Pieter<br class=""><br class="">-- <br class="">Pieter Lexis<br class="">PowerDNS.COM BV -- https://www.powerdns.com<br class="">_______________________________________________<br class="">Pdns-users mailing list<br class="">Pdns-users@mailman.powerdns.com<br class="">http://mailman.powerdns.com/mailman/listinfo/pdns-users<br class=""></blockquote><br class=""></div></div></blockquote></div><br class=""></body></html>