I updated (via Git) today an installation of FreeSWITCH I've been running without incident for a few months. Upon restarting the FreeSWITCH process I receive at a constant rate these errors: ...switch_core_sqldb.c xxx SQL ERR [database is locked] ...switch_core_sqldb.c xxx SQL ERR [database is locked] ...switch_core_sqldb.c xxx SQL ERR [database is locked] How should I resolve?
why did you feel the need to xxx out the line numbers? This is what exact revision, was it literally from today? Do you have the exact excerpt from the logs not a paraphrased on? On Mon, Mar 7, 2011 at 1:28 PM, elijah <elijah@crankenstein.com> wrote:
I updated (via Git) today an installation of FreeSWITCH I've been running without incident for a few months. Upon restarting the FreeSWITCH process I receive at a constant rate these errors: ...switch_core_sqldb.c xxx SQL ERR [database is locked] ...switch_core_sqldb.c xxx SQL ERR [database is locked] ...switch_core_sqldb.c xxx SQL ERR [database is locked] How should I resolve? _______________________________________________ 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
ideally run fsctl debug_level 10 console loglevel debug then capture it and send it to me. On Mon, Mar 7, 2011 at 1:36 PM, Anthony Minessale <anthony.minessale@gmail.com> wrote:
why did you feel the need to xxx out the line numbers?
This is what exact revision, was it literally from today? Do you have the exact excerpt from the logs not a paraphrased on?
On Mon, Mar 7, 2011 at 1:28 PM, elijah <elijah@crankenstein.com> wrote:
I updated (via Git) today an installation of FreeSWITCH I've been running without incident for a few months. Upon restarting the FreeSWITCH process I receive at a constant rate these errors: ...switch_core_sqldb.c xxx SQL ERR [database is locked] ...switch_core_sqldb.c xxx SQL ERR [database is locked] ...switch_core_sqldb.c xxx SQL ERR [database is locked] How should I resolve? _______________________________________________ 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
-- 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
There was also a similar issue posted at Jira today, related to mod_callcenter - FS-3127. /Peter ________________________________________ Från: freeswitch-users-bounces@lists.freeswitch.org [freeswitch-users-bounces@lists.freeswitch.org] för Anthony Minessale [anthony.minessale@gmail.com] Skickat: den 7 mars 2011 20:42 Till: FreeSWITCH Users Help Ämne: Re: [Freeswitch-users] database is locked ideally run fsctl debug_level 10 console loglevel debug then capture it and send it to me. On Mon, Mar 7, 2011 at 1:36 PM, Anthony Minessale <anthony.minessale@gmail.com> wrote:
why did you feel the need to xxx out the line numbers?
This is what exact revision, was it literally from today? Do you have the exact excerpt from the logs not a paraphrased on?
On Mon, Mar 7, 2011 at 1:28 PM, elijah <elijah@crankenstein.com> wrote:
I updated (via Git) today an installation of FreeSWITCH I've been running without incident for a few months. Upon restarting the FreeSWITCH process I receive at a constant rate these errors: ...switch_core_sqldb.c xxx SQL ERR [database is locked] ...switch_core_sqldb.c xxx SQL ERR [database is locked] ...switch_core_sqldb.c xxx SQL ERR [database is locked] How should I resolve? _______________________________________________ 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
-- 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 _______________________________________________ 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 !DSPAM:4d7535d532761229612182!
here's the extra debug output: 2011-03-07 11:53:04.747232 [DEBUG] switch_core_sqldb.c:1685 Reuse Unused Cached DB handle db="core";user="";pass="" [CORE_DB] 2011-03-07 11:53:19.744948 [DEBUG] switch_core_sqldb.c:1685 Reuse Unused Cached DB handle db="core";user="";pass="" [CORE_DB] 2011-03-07 11:53:22.161581 [ERR] switch_core_sqldb.c:432 SQL ERR [database is locked] DELETE FROM members WHERE system = 'single_box' AND uuid = '' AND (abandoned_epoch = '1299525498' OR joined_epoch = '1299525427') 2011-03-07 11:53:22.161581 [DEBUG] mod_callcenter.c:744 [ 7@live001.voice.telifi.com] rwlock 2011-03-07 11:53:22.261564 [DEBUG] mod_callcenter.c:511 Reuse Unused Cached DB handle db="callcenter";user="";pass="" [CORE_DB] 2011-03-07 11:53:22.261564 [DEBUG] mod_callcenter.c:744 [ 7@live001.voice.telifi.com] rwlock 2011-03-07 11:53:22.261564 [DEBUG] mod_callcenter.c:511 Reuse Unused Cached DB handle db="callcenter";user="";pass="" [CORE_DB] 2011-03-07 11:53:23.546367 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:23.546367 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:23.546367 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:23.546367 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:23.546367 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:23.546367 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:23.546367 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:23.546367 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:23.546367 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.546215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_external";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.546215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_external";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.546215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_external";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.546215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_external";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.546215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_external";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.546215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_external";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.546215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_external";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.546215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_external";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.546215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_external";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.546215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_external";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.550215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.550215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.550215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.550215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.550215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.550215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.550215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.550215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal";user="";pass="" [CORE_DB] 2011-03-07 11:53:24.550215 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal";user="";pass="" [CORE_DB] 2011-03-07 11:53:34.742661 [DEBUG] switch_core_sqldb.c:1685 Reuse Unused Cached DB handle db="core";user="";pass="" [CORE_DB] 2011-03-07 11:53:49.740377 [DEBUG] switch_core_sqldb.c:198 Dropping idle DB connection db="voicemail_telifi";user="";pass="" 2011-03-07 11:53:49.740377 [DEBUG] switch_core_sqldb.c:1685 Reuse Unused Cached DB handle db="core";user="";pass="" [CORE_DB] 2011-03-07 11:53:52.063018 [ERR] switch_core_sqldb.c:432 SQL ERR [database is locked] DELETE FROM members WHERE system = 'single_box' AND uuid = '' AND (abandoned_epoch = '1299525498' OR joined_epoch = '1299525427') 2011-03-07 11:53:52.063018 [DEBUG] mod_callcenter.c:744 [ 7@live001.voice.telifi.com] rwlock 2011-03-07 11:53:52.063018 [DEBUG] mod_callcenter.c:511 Reuse Unused Cached DB handle db="callcenter";user="";pass="" [CORE_DB] 2011-03-07 11:53:53.601788 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:53.601788 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:53.601788 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:53.601788 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:53.601788 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:53.601788 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:53.601788 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] 2011-03-07 11:53:53.601788 [DEBUG] sofia_glue.c:5894 Reuse Unused Cached DB handle db="sofia_reg_internal-ipv6";user="";pass="" [CORE_DB] On Mon, Mar 7, 2011 at 11:42 AM, Anthony Minessale < anthony.minessale@gmail.com> wrote:
ideally run
fsctl debug_level 10 console loglevel debug
then capture it and send it to me.
On Mon, Mar 7, 2011 at 1:36 PM, Anthony Minessale <anthony.minessale@gmail.com> wrote:
why did you feel the need to xxx out the line numbers?
This is what exact revision, was it literally from today? Do you have the exact excerpt from the logs not a paraphrased on?
On Mon, Mar 7, 2011 at 1:28 PM, elijah <elijah@crankenstein.com> wrote:
I updated (via Git) today an installation of FreeSWITCH I've been running without incident for a few months. Upon restarting the FreeSWITCH process I receive at a constant rate these errors: ...switch_core_sqldb.c xxx SQL ERR [database is locked] ...switch_core_sqldb.c xxx SQL ERR [database is locked] ...switch_core_sqldb.c xxx SQL ERR [database is locked] How should I resolve? _______________________________________________ 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
-- 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
_______________________________________________ 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
update to git head and try again - changes were commited that fix this -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/database-is-locked-tp6098671p6... Sent from the freeswitch-users mailing list archive at Nabble.com.
Of course. Sorry (I hastily thought I was replacing a counter): 2011-03-07 11:46:23.406465 [ERR] switch_core_sqldb.c:432 SQL ERR [database is locked] DELETE FROM members WHERE system = 'single_box' AND uuid = '' AND (abandoned_epoch = '1299525498' OR joined_epoch = '1299525427') 2011-03-07 11:46:53.320898 [ERR] switch_core_sqldb.c:432 SQL ERR [database is locked] DELETE FROM members WHERE system = 'single_box' AND uuid = '' AND (abandoned_epoch = '1299525498' OR joined_epoch = '1299525427') 2011-03-07 11:47:23.230337 [ERR] switch_core_sqldb.c:432 SQL ERR [database is locked] DELETE FROM members WHERE system = 'single_box' AND uuid = '' AND (abandoned_epoch = '1299525498' OR joined_epoch = '1299525427') 2011-03-07 11:47:53.139777 [ERR] switch_core_sqldb.c:432 SQL ERR [database is locked] DELETE FROM members WHERE system = 'single_box' AND uuid = '' AND (abandoned_epoch = '1299525498' OR joined_epoch = '1299525427') The version that is producing this error for me is *1.0.head (git-bfd0ba9 2011-03-07 13-02-41 -0600)* Additionally, I am running a previous version (*1.0.head (git-c6f044d 2011-02-28 10-02-11 -0600)*) that is working without this error. Thank you On Mon, Mar 7, 2011 at 11:36 AM, Anthony Minessale < anthony.minessale@gmail.com> wrote:
why did you feel the need to xxx out the line numbers?
This is what exact revision, was it literally from today? Do you have the exact excerpt from the logs not a paraphrased on?
On Mon, Mar 7, 2011 at 1:28 PM, elijah <elijah@crankenstein.com> wrote:
I updated (via Git) today an installation of FreeSWITCH I've been running without incident for a few months. Upon restarting the FreeSWITCH process I receive at a constant rate these errors: ...switch_core_sqldb.c xxx SQL ERR [database is locked] ...switch_core_sqldb.c xxx SQL ERR [database is locked] ...switch_core_sqldb.c xxx SQL ERR [database is locked] How should I resolve? _______________________________________________ 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
_______________________________________________ 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 (4)
-
Anthony Minessale
-
elijah
-
Jeff Lenk
-
Peter Olsson