[Freeswitch-users] Why database is locked?

[Anthony Minessale]

Are you running the latest version of FS?
Also are you doing anything externally to mess with the sql db files?
Another possibility is a slow filesystem, we used to have people get this
problem on suse linux.
You could try running your db dir in a ramdisk.


On Thu, Jan 5, 2012 at 10:56 PM, Valery Kalinin <valery.kalinin at gmail.com>wrote:

> Hi all!
>
> Periodically database is locked and all calls stopped.
>
> Log:
> 2012-01-06 08:32:52.492796 [ERR] switch_core_sqldb.c:481 SQL ERR
> [database is locked]
> update sip_dialogs set presence_id='2002 at 192.168.205.1',presence_data=''
> where uuid='f506627c-ea28-481c-ba72-beaeebc16a6b';
> 2012-01-06 08:33:12.486159 [ERR] ftmod_zt.c:1104 [s1c16][1:16] HDLC abort
> frame received (ZT_EVENT_ABORT)
> 2012-01-06 08:33:22.591484 [ERR] switch_core_sqldb.c:481 SQL ERR
> [database is locked]
> 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','<
> sip:2003 at 192.168.205.217:5062>','2003 at 192.168.205.1','','',1325817146)
> 2012-01-06 08:33:41.089426 [ERR] ftmod_zt.c:1280 [s1c16][1:16] Dropping
> event 8 to be able to write data
> 2012-01-06 08:33:52.667878 [ERR] switch_core_sqldb.c:481 SQL ERR
> [database is locked]
> delete from sip_dialogs where uuid='8ed4b985-1f1f-4901-938d-56619a42eb1c'
> 2012-01-06 08:34:02.189552 [ERR] ftmod_zt.c:1104 [s1c16][1:16] HDLC abort
> frame received (ZT_EVENT_ABORT)
> 2012-01-06 08:34:22.607797 [ERR] switch_core_sqldb.c:481 SQL ERR
> [database is locked]
> delete from sip_authentication where expires > 0 and expires <= 1325817161
> and hostname='srv-pok-phone.lpurs.argos-group.ru'
> 2012-01-06 08:34:52.460796 [ERR] switch_core_sqldb.c:481 SQL ERR
> [database is locked]
> insert into sip_authentication (nonce,expires,profile_name,hostname,
> last_nc) values('9643f3a4-acc0-41cf-8a08-ca9dd791dbbb', 1325817222,
> 'internal', 'srv-pok-phone', 0)
> 2012-01-06 08:42:54.233881 [ERR] switch_core_sqldb.c:481 SQL ERR
> [database is locked]
> insert into sip_authentication (nonce,expires,profile_name,hostname,
> last_nc) values('4611d24f-cfa0-47d4-a8d3-5fdce08ed85a', 1325817734,
> 'internal', 'srv-pok-phone', 0)
> 2012-01-06 08:42:54.884449 [CRIT] ftdm_io.c:5467 [s1c9][1:9] Forcing
> hangup since the user did not confirmed our hangup after 3000ms
> 2012-01-06 08:43:06.435420 [ERR] ftmod_libpri.c:132 XXX Progress message
> requested but no information is provided
> 2012-01-06 08:43:06.813352 [ERR] ftmod_libpri.c:132 Received unsolicited
> status: Mandatory information element is missing
> 2012-01-06 08:43:24.297760 [ERR] switch_core_sqldb.c:481 SQL ERR
> [database is locked]
> delete from sip_dialogs where uuid='563a394c-5c82-4381-868d-35e344f3ccd9'
>
> Thanks.
>
> _________________________________________________________________________
> 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
>
>


-- 
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/
Twitter: http://twitter.com/FreeSWITCH_wire

AIM: anthm
MSN:anthony_minessale at hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org
googletalk:conf+888 at conference.freeswitch.org
pstn:+19193869900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120106/a2a22480/attachment.html