a followup on this post:
i was running some straces on sqlite while it using transactions and think i
may have found the source of the problem, we see this in in the strace output:
... ... close(5) = 0 unlink("/dmsp/moby-1-1/ahoward/shared/silly/db-journal") = 0 ... ...
i think what is happening is
... ... close(5) = 0
here remote client opens db-journal
unlink("/dmsp/moby-1-1/ahoward/shared/silly/db-journal") = 0
I think this file is created everytime you start a transaction. Maybe even if you only perform read only commands.
The journal is what is used to keep track of the changes to the database. Anyone else have any thoughts?
John LeSueur
