[elephant-devel] Sqlite-3 backend, threads and transactions

[Robert L. Read]

On Wed, 2006-04-19 at 18:34 +0300, Ignas Mikalajunas wrote:

> A testcase for SBCL:
> 
> (defun test ()
>   (ele:with-open-store ('(:sqlite3 "/home/ignas/src/common-
> blog/dev.db"))))
> 
> (sb-thread:make-thread #'test) ;; a few times - works
> 
> (dotimes (i 3) (sb-thread:make-thread #'test)) ;; you get 3 tracebacks
> 
> By the way thanks for a wonderful library!


Dear Ignas,
    This is a really nice test case; I commend you again.
    I can reproduce this error on the latest code base from CVS, using
both SQLite3 and Postgres.

    The PostGres error seems to suggest that we are simply not
threadsafe and one thread is closing
the controller while another expects it to be open.

    I will think about this some more.



----
Robert L. Read, PhD                                     read &T
robertlread.net
Consider visiting Progressive Engineering:
http://robertlread.net/pe
In Austin: 912-8593                                        "Think
globally, Act locally." -- RBF


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.common-lisp.net/pipermail/elephant-devel/attachments/20060419/d0c3f3ed/attachment.html>