[elephant-devel] sqlite backend, "Error 5 / database is locked"

woei at yandex.ru woei at yandex.ru
Wed Jul 25 11:30:31 UTC 2007


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 , at 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?



More information about the elephant-devel mailing list