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
