[Pdns-users] OpenDBX + PowerDNS - Unable to execute query - Attempt to initiate a new Adaptive Server operation

[Norbert Sendetzky]

Hi Robert

> I'm load testing PowerDNS with OpenDBX (Using MSSQL) backend server with
> Dnsperf. Unless I restrict the testing to about 100 queries per second
> or less I start getting a much higher than expected number of failed dns
> responses and the entries like the one below keep appearing in the log:
>
> Aug 25 15:28:28 ns02 pdns[16430]: [OpendbxBackend] execStmt: Unable to
> execute query - Attempt to initiate a new Adaptive Server operation with
> results pending, Success
> Aug 25 15:28:28 ns02 pdns[16430]: Database module reported condition
> which prevented lookup (Error: DB statement failed) sending out servfail

Seems that there might be a problem with retrieving the result set from 
the server. Do you have basic C skills and be able to compile and debug 
the OpenDBX/PDNS odbxbackend code? I'm able to guide you through the 
code and tell you what to look for.


Norbert