[Freeswitch-users] Can't access voicemail because DB is locked

Cal Leeming [Simplicity Media Ltd] cal.leeming at simplicitymedialtd.co.uk
Fri Apr 12 17:32:55 MSD 2013


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.

Could any core devs comment on this?

Cal

On Thu, Apr 11, 2013 at 9:01 PM, Steven Schoch <
schoch+freeswitch.org at xwin32.com> wrote:

> On Thu, Apr 11, 2013 at 11:44 AM, Steven Ayre <steveayre at gmail.com> wrote:
>
>> What database are you using? Sqlite? MySQL? PostgreSQL?
>>
>
> The one that came with FreeSWITCH (Sqlite).
>
> 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.
>>
>
> FreeSWITCH is the only thing that is connected to the database. I have no
> other programs on that machine accessing that database.
>
> 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.
>
> --
> Steve
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130412/be2c552a/attachment.html 


Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list