[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 22:39, Peter van Dijk <peter.van.dijk at powerdns.com <mailto:peter.van.dijk at powerdns.com>> wrote:
> 
> Hello,
> 
> On 26 Feb 2016, at 14:18, Pieter Lexis wrote:
> 
>> This is the `basic-query`, interesting that it gives this error, as we never bind more than 2 elements in the code.
> 
> Unless there is a code path in which we never reach
> 
>  try {
>    d_query_stmt->reset();
>  } catch (SSqlException &e) {
>   ..
>   ..
> 
> inside GSQLBackend::get
> 
> Kind regards,
> -- 
> Peter van Dijk
> PowerDNS.COM <http://powerdns.com/> BV - https://www.powerdns.com/ <https://www.powerdns.com/>
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com <mailto:Pdns-users at mailman.powerdns.com>
> http://mailman.powerdns.com/mailman/listinfo/pdns-users <http://mailman.powerdns.com/mailman/listinfo/pdns-users>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20160306/2a94d7e6/attachment-0001.html>