<div dir="ltr">What database are you using? Sqlite? MySQL? PostgreSQL?<div><br></div><div style>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 style><br></div><div style>-Steve</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 11 April 2013 19:20, 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">One of my users, whose phone has BLF lines, is having trouble accessing voicemail. The logs say the core database is locked. It is not clear if that is what is causing the inability to access voicemail. Any ideas?<div>
<br></div><div><div>2013-04-11 11:14:31.962286 [ERR] switch_core_sqldb.c:579 NATIVE SQL ERR [database is locked]</div><div>insert into sip_subscriptions (proto,sip_user,sip_host,sub_to_user,sub_to_host,presence_hosts,event,contact,call_id,full_from,full_via,expires,user_agent,accept,profile_name,hostname,network_port,network_ip,version,orig_proto, full_to) values ('sip','519','<a href="http://xxx.com" target="_blank">xxx.com</a>','519','<a href="http://xxx.com" target="_blank">xxx.com</a>','<a href="http://xxx.com" target="_blank">xxx.com</a>,192.168.4.1','line-seize','"519" <<a href="mailto:sip%3A519@192.168.4.235" target="_blank">sip:519@192.168.4.235</a>>','<a href="mailto:540bafdc-5146c237-f2c1bfea@192.168.4.235" target="_blank">540bafdc-5146c237-f2c1bfea@192.168.4.235</a>','"519" <<a href="mailto:sip%3A519@xxx.com" target="_blank">sip:519@xxx.com</a>>;tag=AB12B2E0-A28C235B','SIP/2.0/UDP 192.168.4.235;branch=z9hG4bK3073a02e92D29019',1365704072,'PolycomSoundPointIP-SPIP_320-UA/<a href="http://3.3.5.0247" target="_blank">3.3.5.0247</a>','','phone','<a href="http://pbx.xxx.com" target="_blank">pbx.xxx.com</a>','5060','192.168.4.235',-1,'','<<a href="mailto:sip%3A519@xxx.com" target="_blank">sip:519@xxx.com</a>>;tag=GvUHrcCb8WWl')</div>
<div>2013-04-11 11:14:32.222286 [ERR] switch_core_sqldb.c:579 NATIVE SQL ERR [database is locked]</div><div>BEGIN EXCLUSIVE</div><div>2013-04-11 11:14:32.222286 [CRIT] switch_core_sqldb.c:1679 ERROR [database is locked]</div>
<div>2013-04-11 11:14:32.222286 [ERR] switch_core_sqldb.c:579 NATIVE SQL ERR [cannot commit - no transaction is active]</div><div>COMMIT</div><div>2013-04-11 11:15:02.102979 [ERR] switch_core_sqldb.c:579 NATIVE SQL ERR [database is locked]</div>
<div>insert into sip_dialogs (sip_from_user,sip_from_host,call_info,call_info_state,hostname,expires,rcd,profile_name) values ('519','<a href="http://xxx.com" target="_blank">xxx.com</a>','appearance-index=1','seized','<a href="http://pbx.xxx.com" target="_blank">pbx.xxx.com</a>',1365704101,1365704071,'phone')</div>
<div>2013-04-11 11:15:02.502977 [ERR] switch_core_sqldb.c:579 NATIVE SQL ERR [database is locked]</div><div>BEGIN EXCLUSIVE</div><div>2013-04-11 11:15:02.502977 [CRIT] switch_core_sqldb.c:1679 ERROR [database is locked]</div>
<div>2013-04-11 11:15:02.502977 [ERR] switch_core_sqldb.c:579 NATIVE SQL ERR [cannot commit - no transaction is active]</div><div>COMMIT</div></div><div><br></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>