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 <[email protected]> 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 > [email protected] > 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 <[email protected]> wrote: >> >> Hi Peter, >> >> On Fri, 26 Feb 2016 14:49:16 +0200 >> Keresztes Péter-Zoltán <[email protected]> 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 >> [email protected] >> http://mailman.powerdns.com/mailman/listinfo/pdns-users >
_______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
