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

Sam Beechey sam at saq.net
Thu Mar 31 12:54:01 CEST 2011


Hi,

Lowering the distributor-threads to 2 causes the error to appear a lot
quicker.

These are the last 2 queries on the MSSQL before it locks up:

SELECT d."id", d."name", d."master", d."last_check",
d."notified_serial", d."auto_serial", r."content" FROM "domains" d LEFT
JOIN "records" r ON ( d."id"=r."domain_id" AND r."type"='SOA' ) WHERE
d."status"='A' AND d."type"='SLAVE'
SELECT d."id", d."name", d."master", d."last_check",
d."notified_serial", d."auto_serial", r."content" FROM "domains" d LEFT
JOIN "records" r ON ( d."id"=r."domain_id" AND r."type"='SOA' ) WHERE
d."status"='A' AND d."type"='MASTER'

Also it seems to successfully find roots like this; this seems odd as
recursion is disabled entirely:

SELECT r."domain_id", r."name", r."type", r."ttl", r."prio", r."content"
FROM "records" r WHERE r."name"=''

Perhaps the threads are hanging?

Sam

-----Original Message-----

Hi Bert,

Have just tried that and it lasted 14 minutes, before it died.
No errors for the first few minutes.
Disabling Master seems to make no difference.
40,000 queries, 5000 errors.
It seems once the error starts, DNS quite quickly stops responding.

Sam.

-----Original Message-----

Could you briefly turn off the master/slave and see if the problem goes
away?

	Bert

On Thu, Mar 31, 2011 at 10:19:20AM +0100, Sam Beechey wrote:
> Hi Bert,
> 
> Master is enabled. Slave is at default (Slave could be disabled).
> 
> Yes, that is correct. In 1.3M queries, the error was produced 2000
> times.
> 
> Thanks, Sam
> 
> -----Original Message-----
> 
> On Thu, Mar 31, 2011 at 10:10:32AM +0100, Sam Beechey wrote:
> > Problem: ~2000 queries in ~1.3M produce the following error:
> 
> Hi Sam,
> 
> Do you run with 'master' or 'slave' enabled in the configuration?
> 
> Also, does the above mean that you perform 1300000 queries, and that
you
> get
> that error 2000 times?
> 
> 	Bert
> 
> 


More information about the Pdns-dev mailing list