[Pdns-dev] OpenDBX Backend with FreeTDS - Error: Attempt to initiate a new Adaptive Server operation with results pending

[Sam Beechey]

Hi, 

 

Problem: ~2000 queries in ~1.3M produce the following error:

 

[OpendbxBackend] execStmt: Unable to execute query - Attempt to initiate
a new Adaptive Server operation with results pending, Success

 

Database module reported condition which prevented lookup (Error: DB
statement failed) sending out servfail

 

Debian Squeeze               2.6.32-5-xen-amd64

 

gcc version 4.4.5

 

PowerDNS                          pdns-2.9.22
http://downloads.powerdns.com/releases/pdns-2.9.22.tar.gz

 

./configure --with-modules="opendbx" --with-dynmodules=""
--enable-pdns_server --prefix=/usr --sysconfdir=/etc/powerdns
--localstatedir=/var/run

 

I had issues compiling. However the following link and instructions
resolved this.

 

http://mailman.powerdns.com/pipermail/pdns-users/2010-May/006728.html

 

rcpgenerator.hh

added line: #include <cstdio>

 

dnsparser.hh

added line: #include <cstdio>

 

OpenDBX                                            opendbx-1.4.5
http://linuxnetworks.de/opendbx/download/opendbx-1.4.5.tar.gz

 

./configure --with-backends="mssql" --prefix=/usr --disable-utils

 

FreeTDS                                               0.82-7
apt-get install freetds-bin freetds-dev fakeroot debhelper docbook2x
doxygen cl-sql-odbc

 

There is no firewall in place or firewall rules configured on the box.

 

The following link (Re: Loosing Control With Bad SQL) seems to imply
that there is a problem with the OpenDBX module.

 

http://blog.gmane.org/gmane.comp.db.tds.freetds/month=20101001

 

Any idea what this might be? Is a patch needed?

 

Sam

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-dev/attachments/20110331/e81e3497/attachment.htm>