> Why don't you send over stack traces and a more in-depth description
> of your setup.
Here's the SQLite story.
I'm using SQLite3 version 3.5.6 (apparently compiled with thread safety),
CLSQL 4.0.1, SBCL 1.0.14 and the latest Elephant on an ext3 file system,
kernel 2.6.24.
The error occurs on my development machine with close to zero load
and only two processes writing quickly with minimum time in between.
The backtrace is attached. You can also see the two requests in close
succession before it. The first request removes an object from a PSET,
the second adds it again to the same PSET (although this detail
probably doesn't matter since the error is occuring on the SQLite
layer).
I have also found that the SQLite backend of the Trac project had
a bunch of similar errors in previous versions[1].
The error occurs with roughly 50% probability.
> PS - Are you trying to run this on your local disk, or over a
> networked filesystem?
Everything is local.
Leslie
[1]
http://www.google.de/search?hl=en&q=+site:trac.edgewall.org+trac+sqlite+locking+error
[2008-02-24 21:08:26] 127.0.0.1 - "GET /?&action=5925:04C9FCB15CB6715C52F5AF9478E60F1D&itemid=5860%3A2104d6750738b09681c1d412f8253811 HTTP/1.1" 200 29 "http://localhost:1111/status/inventory"; "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.12) Gecko/20080213 BonEcho/2.0.0.12"
[2008-02-24 21:08:26] 127.0.0.1 - "GET /?&action=5957:515BD0104920CE90A54E9EC65C4BD226&itemid=5860%3A2104d6750738b09681c1d412f8253811 HTTP/1.1" 200 29 "http://localhost:1111/status/inventory"; "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.12) Gecko/20080213 BonEcho/2.0.0.12"
[2008-02-24 21:08:29 [ERROR]] While accessing database #<SQLITE3-DATABASE /home/sky/mystic/db/world.sqlite3 OPEN {A741311}>
with expression "UPDATE KEYVALUE SET KEY = 'DyMAAAANCQUAAABBUk1PUgkGAAAATVlTVElD',CLCTN_ID = 28,VALUE = 'DQkBAAAAVAkLAAAAQ09NTU9OLUxJU1A=' WHERE ((CLCTN_ID = 28) AND (KEY = 'DyMAAAANCQUAAABBUk1PUgkGAAAATVlTVElD'))":
Error 5 / database is locked
has occurred.
0: (BACKTRACE 536870911 #<SB-IMPL::STRING-OUTPUT-STREAM {A8D30D9}>)
1: (HUNCHENTOOT:GET-BACKTRACE #<unavailable argument>)
2: ((LAMBDA (COND)) #<CLSQL-SYS:SQL-DATABASE-DATA-ERROR {A8D2D81}>)
3: ((LAMBDA (COND)) #<CLSQL-SYS:SQL-DATABASE-DATA-ERROR {A8D2D81}>)
4: (SIGNAL #<CLSQL-SYS:SQL-DATABASE-DATA-ERROR {A8D2D81}>)
5: (ERROR CLSQL-SYS:SQL-DATABASE-DATA-ERROR)
6: ((SB-PCL::FAST-METHOD CLSQL-SYS:DATABASE-EXECUTE-COMMAND
(T CLSQL-SQLITE3:SQLITE3-DATABASE))
#<unavailable argument>
#<unavailable argument>
"UPDATE KEYVALUE SET KEY = 'DyMAAAANCQUAAABBUk1PUgkGAAAATVlTVElD',CLCTN_ID = 28,VALUE = 'DQkBAAAAVAkLAAAAQ09NTU9OLUxJU1A=' WHERE ((CLCTN_ID = 28) AND (KEY = 'DyMAAAANCQUAAABBUk1PUgkGAAAATVlTVElD'))"
#<CLSQL-SQLITE3:SQLITE3-DATABASE /home/sky/mystic/db/world.sqlite3 OPEN {A741311}>)
7: ((LAMBDA
(SB-PCL::.PV. SB-PCL::.NEXT-METHOD-CALL. SB-PCL::.ARG0.
SB-PCL::.ARG1.))
#<unavailable argument>
#<unavailable argument>
"UPDATE KEYVALUE SET KEY = 'DyMAAAANCQUAAABBUk1PUgkGAAAATVlTVElD',CLCTN_ID = 28,VALUE = 'DQkBAAAAVAkLAAAAQ09NTU9OLUxJU1A=' WHERE ((CLCTN_ID = 28) AND (KEY = 'DyMAAAANCQUAAABBUk1PUgkGAAAATVlTVElD'))"
#<CLSQL-SQLITE3:SQLITE3-DATABASE /home/sky/mystic/db/world.sqlite3 OPEN {A741311}>)
8: ((SB-PCL::FAST-METHOD CLSQL-SYS:EXECUTE-COMMAND (STRING))
#<unavailable argument>
#<unavailable argument>
"UPDATE KEYVALUE SET KEY = 'DyMAAAANCQUAAABBUk1PUgkGAAAATVlTVElD',CLCTN_ID = 28,VALUE = 'DQkBAAAAVAkLAAAAQ09NTU9OLUxJU1A=' WHERE ((CLCTN_ID = 28) AND (KEY = 'DyMAAAANCQUAAABBUk1PUgkGAAAATVlTVElD'))")
9: ((SB-PCL::FAST-METHOD CLSQL-SYS:EXECUTE-COMMAND
(CLSQL-SYS::%SQL-EXPRESSION))
#<unavailable argument>
#<unavailable argument>
#<CLSQL-SYS::SQL-UPDATE UPDATE KEYVALUE SET KEY = 'DyMAAAANCQUAAABBUk1PUgkGAAAATVlTVElD',CLCTN_ID = 28,VALUE = 'DQkBAAAAVAkLAAAAQ09NTU9OLUxJU1A=' WHERE ((CLCTN_ID = 28) AND (KEY = 'DyMAAAANCQUAAABBUk1PUgkGAAAATVlTVElD'))>)
10: (DB-CLSQL::SQL-ADD-TO-CLCN
28
#<ARMOR oid:35>
T
#<SQL-STORE-CONTROLLER (SQLITE3 /home/sky/mystic/db/world.sqlite3)>)
11: ((SB-PCL::FAST-METHOD ELEPHANT:INSERT-ITEM (T ELEPHANT::DEFAULT-PSET))
#<unavailable argument>
#<unavailable argument>
#<ARMOR oid:35>
#<DEFAULT-PSET oid:29>)
12: ((SB-PCL::FAST-METHOD WEBLOCKS:HANDLE-CLIENT-REQUEST NIL)
#<unavailable argument>
#<unavailable argument>)
13: (HUNCHENTOOT::PROCESS-REQUEST
((:HOST . "localhost:1111")
(:USER-AGENT
. "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.12) Gecko/20080213 BonEcho/2.0.0.12")
(:ACCEPT . "text/javascript, text/html, application/xml, text/xml, */*")
(:ACCEPT-LANGUAGE . "en,en-us;q=0.8,de;q=0.5,de-de;q=0.3")
(:ACCEPT-ENCODING . "gzip,deflate") (:ACCEPT-CHARSET . "UTF-8,*")
(:KEEP-ALIVE . "300") (:CONNECTION . "keep-alive")
(:X-REQUESTED-WITH . "XMLHttpRequest") (:X-PROTOTYPE-VERSION . "1.6.0")
(:REFERER . "http://localhost:1111/status/inventory";)
(:COOKIE
. "mystic-admin-weblocks-session=1%3A801EF37638DFE91582550D0F969E01BC; thanandar-weblocks-session=2%3A6580B1EC164C6B1633E97AEF9BFB93AC; weblocks-session=3%3A2B179872E504CE4EE15394A78F30AA2F"))
#<FLEXI-STREAMS::FLEXI-LATIN-1-IO-STREAM {D44B741}>
:GET
"/?&action=5960:D6F06F89A46E3016FDD44DB0FFFF7117&itemid=5860%3A2104d6750738b09681c1d412f8253811"
:HTTP/1.1)
14: (HUNCHENTOOT::PROCESS-CONNECTION
#<HUNCHENTOOT::SERVER {B366009}>
#<SB-BSD-SOCKETS:INET-SOCKET descriptor 63 {CF3DED1}>)
15: ((FLET SB-THREAD::WITH-MUTEX-THUNK))
16: (SB-UNIX::CALL-WITH-LOCAL-INTERRUPTS
#<CLOSURE (FLET SB-UNIX::WITH-LOCAL-INTERRUPTS-THUNK) {B5D4A08D}>
T)
17: ((FLET SB-UNIX::WITHOUT-INTERRUPTS-THUNK) T)
18: ((FLET SB-UNIX::RUN-WITHOUT-INTERRUPTS))
19: (SB-UNIX::CALL-WITHOUT-INTERRUPTS
#<CLOSURE (FLET SB-UNIX::WITHOUT-INTERRUPTS-THUNK) {B5D4A17D}>)
20: (SB-THREAD::CALL-WITH-MUTEX
#<CLOSURE (FLET SB-THREAD::WITH-MUTEX-THUNK) {B5D4A205}>
#S(SB-THREAD:MUTEX
:NAME "thread result lock"
:%OWNER #<SB-THREAD:THREAD "hunchentoot-worker-493" {CF3EAB9}>
:STATE 1)
#<SB-THREAD:THREAD "hunchentoot-worker-493" {CF3EAB9}>
T)
21: ((LAMBDA ()))
22: ("foreign function: #x806393C")
23: ("foreign function: #x8051F71")
24: ("foreign function: #x805B3ED")
25: ("foreign function: #xB7F8E162")
_______________________________________________
elephant-devel site list
elephant-devel@common-lisp.net
http://common-lisp.net/mailman/listinfo/elephant-devel
