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@xwin32.com> wrote:
On Thu, Apr 11, 2013 at 11:44 AM, Steven Ayre <steveayre@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org