[Freeswitch-users] Why database is locked?

Valery Kalinin valery.kalinin at gmail.com
Fri Jan 6 07:56:00 MSK 2012


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120106/d99a9cab/attachment.html 


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