[elephant-devel] SQLite locking error / BDB multi-image support

[Leslie P. Polzer]

> I don't fully understand all the BDB particulars here, but I'm short
> on time to fix these things.  Let me know if this works for you.  The
> short story is that BDB is unlikely to 'just work' for a real system
> using multiple processes.  You have to run deadlock detection
> (probably in a parallel process), you have to think about how to
> coordinate processes to clean up in the event of an error, you may
> have to sequence your startup, you have to think about how parallel
> use of the DB effects performance.  No free lunches here.

Ewww... guess I'll leave it at Postmodern then for the time being.
It's good to defer this stuff to a separate high-level software
package.

I'll check out later whether your changes work.


> Anyway, for the details of why I added the patch see info on
> DB_REGISTER option to DBENV->open (db-env-open in lisp via open-
> controller in bdb-controller which is called from open-store - I've
> made DB_REGISTER the default).

I see. An easy fix.


> I'm not going to be able to track down the CL-SQL/SQLite issues
> anytime soon.

Understandable. As I see it, one would have to fiddle with timeouts
and flags, and probably add some coordination code, too.

And most likely a bunch of this would have to happen at the CLSQL
level. I might look into it when I get a round tuit.

  Thanks!

    Leslie