Why database is locked?
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.
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@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
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@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@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
_________________________________________________________________________ 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
participants (3)
-
Anthony Minessale
-
curriegrad2004
-
Valery Kalinin