[Freeswitch-users] Why database is locked?

curriegrad2004 curriegrad2004 at gmail.com
Fri Jan 6 20:37:36 MSK 2012


Running the DB out of cifs can also cause the same symptoms of a locked
database
On 2012-01-06 7:50 AM, "Anthony Minessale" <anthony.minessale at gmail.com>
wrote:

> 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
>
> _________________________________________________________________________
> 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/20120106/46016a05/attachment.html 


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