Hi all > I get the errors below after a while (About 20mins) with PowerDNS on an > OpenDBX+FreeTDS backend: > > Mar 31 13:33:20 ns01 pdns[3921]: Database module reported condition > which prevented lookup (Error: DB statement failed) sending out servfail > > Mar 31 13:33:20 ns01 pdns[3921]: [OpendbxBackend] execStmt: Unable to > execute query - Attempt to initiate a new Adaptive Server operation with > results pending, Success > > Once a backend thread starts giving this error it does not respond to > any more queries. The MSSQL server shows no unusual queries before a > thread locks up with this error. > > Information I have found so far suggest it is an application issue and > either OpenDBX or the PowerDNS OpenDBX backend because it is not calling > dbresults in certain situations: > > As for "Attempt to initiate a new Adaptive Server operation with results > pending", that's a logical error on the part of the application: you > have > to read your results or cancel them before issuing a new query. Cf. FAQ > http://www.freetds.org/faq.html#pending. > > "Once dbsqlexec returns SUCCEED, the application must call dbresults to > process the results." > > Can anyone help with a fix or patch?
As I said in another mail, I don't think it possible to fix this, because I think it is a threading issue and the underlying dblib is not thread safe. Your only working options to interface a MS SQL server using PowerDNS are either using the OpenDBX sybase or odbc backend. Norbert ------------------------------------------------------------------------------ Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev _______________________________________________ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
