On Thu, Jan 5, 2012 at 10:56 PM, Valery Kalinin <valery.kalinin@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@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@192.168.205.217:5062>','2003@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@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@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@hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org
googletalk:conf+888@conference.freeswitch.org
pstn:+19193869900