[Twisted-Python] Anyone ever used successfully sqlanydb together with Twisted and adbapi?

[Hynek Schlawack]

Hi,

I've essentially written a whois daemon that serves via TCP as well as
via web, fetching its data from a sqlanywhere 12 server, using the
official sqlanydb driver.

Everything works fine except for occasional SIGABRTs (or inside of
gdb: SIGSEGVs inside of the sqlanywhere binary driver) in the first
query. If that one works, it keeps running.
 However it's impossible to run tests as at some point it always
crashes while doing queries because I recreate the pool for every
test.

Essentially I get a domain record from the database and fetch some
related data afterward. I tried to implement it using DeferredList and
using runInteraction and it always aborts before doing the second
query. I've already posted some code and gdb backtraces to
stackoverflow: http://stackoverflow.com/questions/5790435/python-twisted-sqlanydb-abort
maybe there's some helpful data I missed here. To stress it: The
lookup of the domain record usually works. It's the following defers
that crash my application.

My essential question is: Has someone already used Twisted and
SQLAnywhere together successfully? Is it me or is it sqlanywhere or
even Twisted? What are my options?

TIA,
-h