<p>Running the DB out of cifs can also cause the same symptoms of a locked database </p>
<div class="gmail_quote">On 2012-01-06 7:50 AM, "Anthony Minessale" <<a href="mailto:anthony.minessale@gmail.com">anthony.minessale@gmail.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Are you running the latest version of FS?<div>Also are you doing anything externally to mess with the sql db files?</div><div>Another possibility is a slow filesystem, we used to have people get this problem on suse linux.</div>
<div>You could try running your db dir in a ramdisk.</div><div><br><br><div class="gmail_quote">On Thu, Jan 5, 2012 at 10:56 PM, Valery Kalinin <span dir="ltr"><<a href="mailto:valery.kalinin@gmail.com" target="_blank">valery.kalinin@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi all!<br><br>Periodically database is locked and all calls stopped.<br><br>Log:<br><a href="tel:2012-01-06%2008" value="+12012010608" target="_blank">2012-01-06 08</a>:32:52.492796 [ERR] switch_core_sqldb.c:481 SQL ERR [database is locked]<br>
update sip_dialogs set presence_id='<a href="mailto:2002@192.168.205.1" target="_blank">2002@192.168.205.1</a>',presence_data='' where uuid='f506627c-ea28-481c-ba72-beaeebc16a6b';<br>
<a href="tel:2012-01-06%2008" value="+12012010608" target="_blank">2012-01-06 08</a>:33:12.486159 [ERR] ftmod_zt.c:1104 [s1c16][1:16] HDLC abort frame received (ZT_EVENT_ABORT)<br><a href="tel:2012-01-06%2008" value="+12012010608" target="_blank">2012-01-06 08</a>:33:22.591484 [ERR] switch_core_sqldb.c:481 SQL ERR [database is locked]<br>
insert into sip_dialogs (call_id,uuid,sip_to_user,sip_to_host,sip_to_tag,sip_from_user,sip_from_host,sip_from_tag,contact_user,contact_host,state,direction,user_agent,profile_name,hostname,contact,presence_id,presence_data,call_info,rcd) values('810ae706-b2b1-122f-aa88-6cf049ef3354','b925d777-a70c-4d71-a07b-bce5a804f48a','2002','192.168.205.1','e21ByaF046ppQ','2003','192.168.205.1','1436972916','2003','192.168.205.217','early','outbound','Yealink SIP-T22P 7.60.14.5','internal','srv-pok-phone','<<a href="http://sip:2003@192.168.205.217:5062" target="_blank">sip:2003@192.168.205.217:5062</a>>','<a href="mailto:2003@192.168.205.1" target="_blank">2003@192.168.205.1</a>','','',1325817146)<br>
<a href="tel:2012-01-06%2008" value="+12012010608" target="_blank">2012-01-06 08</a>:33:41.089426 [ERR] ftmod_zt.c:1280 [s1c16][1:16] Dropping event 8 to be able to write data<br><a href="tel:2012-01-06%2008" value="+12012010608" target="_blank">2012-01-06 08</a>:33:52.667878 [ERR] switch_core_sqldb.c:481 SQL ERR [database is locked]<br>
delete from sip_dialogs where uuid='8ed4b985-1f1f-4901-938d-56619a42eb1c'<br>
<a href="tel:2012-01-06%2008" value="+12012010608" target="_blank">2012-01-06 08</a>:34:02.189552 [ERR] ftmod_zt.c:1104 [s1c16][1:16] HDLC abort frame received (ZT_EVENT_ABORT)<br><a href="tel:2012-01-06%2008" value="+12012010608" target="_blank">2012-01-06 08</a>:34:22.607797 [ERR] switch_core_sqldb.c:481 SQL ERR [database is locked]<br>
delete from sip_authentication where expires > 0 and expires <= 1325817161 and hostname='<a href="http://srv-pok-phone.lpurs.argos-group.ru" target="_blank">srv-pok-phone.lpurs.argos-group.ru</a>'<br>
<a href="tel:2012-01-06%2008" value="+12012010608" target="_blank">2012-01-06 08</a>:34:52.460796 [ERR] switch_core_sqldb.c:481 SQL ERR [database is locked]<br>insert into sip_authentication (nonce,expires,profile_name,hostname, last_nc) values('9643f3a4-acc0-41cf-8a08-ca9dd791dbbb', 1325817222, 'internal', 'srv-pok-phone', 0)<br>
<a href="tel:2012-01-06%2008" value="+12012010608" target="_blank">2012-01-06 08</a>:42:54.233881 [ERR] switch_core_sqldb.c:481 SQL ERR [database is locked]<br>insert into sip_authentication (nonce,expires,profile_name,hostname, last_nc) values('4611d24f-cfa0-47d4-a8d3-5fdce08ed85a', 1325817734, 'internal', 'srv-pok-phone', 0)<br>
<a href="tel:2012-01-06%2008" value="+12012010608" target="_blank">2012-01-06 08</a>:42:54.884449 [CRIT] ftdm_io.c:5467 [s1c9][1:9] Forcing hangup since the user did not confirmed our hangup after 3000ms<br><a href="tel:2012-01-06%2008" value="+12012010608" target="_blank">2012-01-06 08</a>:43:06.435420 [ERR] ftmod_libpri.c:132 XXX Progress message requested but no information is provided<br>
<a href="tel:2012-01-06%2008" value="+12012010608" target="_blank">2012-01-06 08</a>:43:06.813352 [ERR] ftmod_libpri.c:132 Received unsolicited status: Mandatory information element is missing<br><a href="tel:2012-01-06%2008" value="+12012010608" target="_blank">2012-01-06 08</a>:43:24.297760 [ERR] switch_core_sqldb.c:481 SQL ERR [database is locked]<br>
delete from sip_dialogs where uuid='563a394c-5c82-4381-868d-35e344f3ccd9'<br>
<br>Thanks.<br>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org" target="_blank">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" target="_blank">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><br clear="all"><div><br></div>-- <br>Anthony Minessale II<br><br>FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>
Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br><br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com" target="_blank">MSN:anthony_minessale@hotmail.com</a><br>
GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br><br>FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org" target="_blank">sip:888@conference.freeswitch.org</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank">googletalk:conf+888@conference.freeswitch.org</a><br>
pstn:<a href="tel:%2B19193869900" value="+19193869900" target="_blank">+19193869900</a><br>
</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>