[Freeswitch-users] database is locked

Mon Mar 7 22:56:22 MSK 2011

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 at 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 at 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 at 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 at 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 at 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 at 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 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
> >
>
>
>
> --
> 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
>
> _______________________________________________
> 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/20110307/9a97c809/attachment-0001.html 