I'd be interested to hear more about this.. as far as I knew the internal SQLite DB wouldn't become culprit to this sort of problem.<div><br></div><div>Could any core devs comment on this?<br><div><br></div><div>Cal<br>
<br><div class="gmail_quote">On Thu, Apr 11, 2013 at 9:01 PM, Steven Schoch <span dir="ltr"><<a href="mailto:schoch+freeswitch.org@xwin32.com" target="_blank">schoch+freeswitch.org@xwin32.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div class="im">On Thu, Apr 11, 2013 at 11:44 AM, Steven Ayre <span dir="ltr"><<a href="mailto:steveayre@gmail.com" target="_blank">steveayre@gmail.com</a>></span> wrote:<br></div><div class="gmail_extra">
<div class="gmail_quote"><div class="im">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">What database are you using? Sqlite? MySQL? PostgreSQL?</div></blockquote><div><br></div></div><div>The one that came with FreeSWITCH (Sqlite).</div>
<div class="im">
<div><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Check if there's anything else connected to the same database and what queries are being run. Perhaps something is holding a lock on the voicemail table.</div>
</div></blockquote><div><br></div></div><div>FreeSWITCH is the only thing that is connected to the database. I have no other programs on that machine accessing that database.</div><div><br></div><div>The problem eventually went away after letting it sit for a couple of minutes. I suspect the DB locked was just a symptom of the real problem which may have happened earlier. The user couldn't connect to VM for some reason, so he made multiple tries in rapid succession, which locked the database somehow. The trouble is that I can't reproduce it.</div>
<span class="HOEnZb"><font color="#888888">
<div><br></div><div>-- </div><div>Steve</div></font></span></div></div></div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br></div></div>