Are you using the SQLite data store in a multi-threaded application?
Robert, how did we resolve threading for CL-SQL data stores? This
sounds like a conflict where a second thread is accessing a db while
the first thread has the file locked. However this is just a
speculation.
Ian
On Jul 25, 2007, at 7:30 AM, [EMAIL PROTECTED] wrote:
With sqlite backend from time to time I have error "Error 5 /
database is
locked"
I have workarounded this by wrapping calls to cl-sql with
(defmacro wrapper-submacro (name &rest q)
`(loop
(handler-case
(return (,name ,@q))
(clsql:sql-condition ()
(sleep .05)))))
I think using sqlite3_busy_timeout call is more elegant solution.
But calling sqlite functions via UFFI directly from elephant
doesnt seem to
be a good idea.
Any suggestions?
_______________________________________________
elephant-devel site list
elephant-devel@common-lisp.net
http://common-lisp.net/mailman/listinfo/elephant-devel
_______________________________________________
elephant-devel site list
elephant-devel@common-lisp.net
http://common-lisp.net/mailman/listinfo/elephant-devel
