This appears to have resolved the problem. The server has been running for the past several days with no database crashes. The only unusual behavior is an occasional condition being raised that looks like this:<br><br>attempt to THROW to a tag that does not exist: DB-BDB::TRANSACTION<br>
[Condition of type SB-INT:SIMPLE-CONTROL-ERROR]<br><br>Restarts:<br> 0: [TERMINATE-THREAD] Terminate this thread (#<THREAD "hunchentoot worker 'upcoming-songs' 9eda90fbc9391875b47d47717c988bf986c8dd01" RUNNING {1003082A71}>)<br>
<br>Backtrace:<br> ...<br> 10: (SIGNAL #<SB-INT:SIMPLE-CONTROL-ERROR {100311D211}>)[:EXTERNAL]<br> 11: (ERROR SB-INT:SIMPLE-CONTROL-ERROR)[:EXTERNAL]<br> 12: (SB-KERNEL::UNSEEN-THROW-TAG-ERROR-HANDLER ..)<br> 13: (SB-KERNEL::UNSEEN-THROW-TAG-ERROR-HANDLER ..)[:EXTERNAL]<br>
14: (SB-KERNEL:INTERNAL-ERROR #.(SB-SYS:INT-SAP #X7F3DDF523000) #<unavailable argument>)<br> 15: ("foreign function: #x41D8E2")<br> 16: ("foreign function: #x40B02E")<br> 17: ("foreign function: #x40FBF0")<br>
18: ("no debug information for frame")<br> 19: (SLOT-VALUE #<SONG oid:34141> QT::MUSIC-LIBRARY-ID)<br><br><br>Thanks for the fix. This remaining issue does not seem to happen too much so I can live with it. It simply belongs in the documentary record.<br>
<br>Red<br><br><div class="gmail_quote">On Sat, Oct 18, 2008 at 1:27 AM, Leslie P. Polzer <span dir="ltr"><<a href="mailto:sky@viridian-project.de">sky@viridian-project.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d"><br>
> Unfortunately the standalone deadlock utility provided by BDB does not seem<br>
> to resolve this. I just tried running it with all these hung threads and<br>
> somehow the result was a database that needs recovery. db_stat also<br>
> indicates the number of deadlocks is 0.<br>
><br>
> This seems to indicate that the problem is not caused by deadlocks. What do<br>
> you think?<br>
<br>
</div>Let's make sure. After opening the store controller run<br>
<br>
(db-bdb::db-env-set-lock-detect<br>
(elephant::controller-environment *store-controller*)<br>
db-bdb::DB_LOCK_DEFAULT)<br>
<br>
and check whether this still occurs.<br>
<div><div></div><div class="Wj3C7c"><br>
Leslie<br>
<br>
<br>
_______________________________________________<br>
elephant-devel site list<br>
<a href="mailto:elephant-devel@common-lisp.net">elephant-devel@common-lisp.net</a><br>
<a href="http://common-lisp.net/mailman/listinfo/elephant-devel" target="_blank">http://common-lisp.net/mailman/listinfo/elephant-devel</a><br>
</div></div></blockquote></div><br>