Howdy all.
I've recently convinced someone here who was in need of a database for his in
house Tcl/Tk application (under Solaris 8) to try SQLite (which I have been
meaning to try myself for some personal projects that have yet to be started).
I helped facilitate this by putting together a "batteries included" tclkit for
him (built by me, tcl v8.4.9 + tk and a bunch of precompiled stuff pulled from
the latest ActiveTcl distro to save some time) that contained the SQLite Tcl
interface (v3.2.1 and today v3.2.2, also built by me).
Things seemed to be going rather well at first, but now quite frequently his
app is getting the "library routine called out of sequence" error (at
seemingly random times and places), and I have to say that I'm a little
perplexed.
He's not doing anything multithreaded, and the tclkit was not built w/ thread
support (I did compile the sqlite lib w/ thread support however). He's only
using relatively simple inserts and selects. He does have some 'after'
commands (both idle and timed) that are firing off calls to the SQLite layer,
however, and the db file (~50MB of data) is on an NFS mounted directory (I've
verifyied through standalone test cases that fcntl file locking "works" across
this interface) being used by multiple people (although I'm pretty sure we've
made the problem occur when others aren't accessing the db file, since there
are not many people using the program and its use is infrequent anyways so the
chances of collisions are pretty small).
I've tried using the various PRAGMAs to help debug it (side note: the vdbe
ones don't seem to be working for me, even though I compiled with the
--enable-debug flag) as well as putting in an sqlite3 trace command that dumps
the strings being sent so I can watch how things are progressing, and nothing
odd seems to be happening that is shown at that level.
So...given this tiny bit of info, does anyone here have any thoughts on what
might be happening, or hints on how to debug it further? I'm considering
going in through dbx and investigating at that level, but thought that it
might be simpler to ask here first, where people who are more intimite with
the inner workings of SQLite might have some ideas to help me along faster.
Bear in mind that I'm not an expert on Tcl or SQLite, but I am a programmer
that is normally rather adept at problem solving so I'll likely get to the
heart of it eventually, but probably not before this guy throws in the towel
and switches to PostgreSQL at the rate I'm going. :(
Thanks,
Chuck
--
Charles K. Hines <[EMAIL PROTECTED]>
"When things don't sound evil enough on their own I like to toss in
a BU-WHA-HA-HA-HA". - Catbert (from Dilbert)
