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

[Ian Eslick]

I just opened a fresh DB from both an Allegro image and an SBCL image  
with no problems, set some data in one and read it from the other.   
This fails for you?  I believe other people are using multiple images  
on multi-processor machines without incident so this may be a  
configuration or environment issue.

Why don't you send over stack traces and a more in-depth description  
of your setup.

Ian

PS - Are you trying to run this on your local disk, or over a  
networked filesystem?


On Feb 24, 2008, at 2:54 PM, Leslie P. Polzer wrote:

>
> I just got this:
>
> While accessing database #<SQLITE3-DATABASE /home/sky/mystic/db/ 
> world.sqlite3 OPEN
> {D5AEC99}>
>  with expression "UPDATE KEYVALUE SET KEY =
> 'DysAAAANCQYAAABQT1RJT04JBgAAAE1ZU1RJQw==',CLCTN_ID = 28,VALUE =  
> 'DQkBAAAAVAkLAAA
> AQ09NTU9OLUxJU1A=' WHERE ((CLCTN_ID = 28) AND (KEY =
> 'DysAAAANCQYAAABQT1RJT04JBgAAAE1ZU1RJQw=='))":
>  Error 5 / database is locked
>  has occurred.
>
> It seems to be a transient problem, since I got away error-free with  
> repeating
> the action...
>
> Also the BDB backend instantly complains about a corrupted database  
> as soon
> as I access a DB with another Lisp image.
>
> Seems I have to resort to Postgres...
>
> All backtraces available on request.
>
>  Leslie
>
> -- 
> My personal blog: http://blog.viridian-project.de/
>
> _______________________________________________
> elephant-devel site list
> elephant-devel at common-lisp.net
> http://common-lisp.net/mailman/listinfo/elephant-devel