[Freeswitch-users] SO we lost power at the office and battery backups went out...

[Anthony Minessale]

Just delete the sofia_ ones and there won't be any permanent loss.



On Sun, Sep 1, 2013 at 12:38 PM, Steven Ayre <steveayre at gmail.com> wrote:

> If you're using SQLite (the default) it isn't great at handling crashes or
> power failures... you can easily get a corrupted DB file.
>
> You have to manually remove the .db files then restart FS. It recreates
> the DB for you, but you still have to remove it yourself.
>
> If you instead use an ODBC database (postgresql/mysql/etc) then generally
> they can recover from power failures much better. If configured correctly
> anyway.
>
> -Steve
>
>
> On 1 September 2013 18:10, Blake Priddy <bpriddy at bryantschools.org> wrote:
>
>> How does one do this magic? Lol
>> On Sep 1, 2013 12:09 PM, "François" <fdelawarde at wirelessmundi.com> wrote:
>>
>>> **
>>> The power loss must have caused database corruption. You can remove the
>>> presence db and restart FS, it will be re-created from scratch and
>>> registrations should start happening again!
>>>
>>> François.
>>>
>>> On Sun, 2013-09-01 at 11:47 -0500, Blake Priddy wrote:
>>>
>>> I had to manually start the internal profile. And now when a
>>> registration occurs i get this message.. School starts back tuesday please
>>> help haha
>>>
>>>
>>>
>>>  2013-09-01 11:45:38.234642 [ERR] switch_core_sqldb.c:581 NATIVE SQL
>>> ERR [database is locked]
>>>
>>>  update sip_subscriptions set version=version+1 where ((expires > 0 and
>>> expires <= 1378053639)) and profile_name='internal' and hostname='voice'
>>>
>>>  2013-09-01 11:45:38.234642 [ERR] switch_core_sqldb.c:581 NATIVE SQL ERR
>>> [database disk image is malformed]
>>>
>>>  delete from sip_subscriptions where ((expires > 0 and expires <=
>>> 1378053639)) and profile_name='internal' and hostname='voice'
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>  --
>>>
>>>
>>>
>>>
>>>
>>>  *Blakelund Priddy*
>>>
>>>  Network & Systems Engineer
>>> Bryant Public School District
>>> Bryant, Arkansas 72022
>>> http://www.bryantschools.org
>>>
>>>  p 501-653-5038
>>> f 501-847-5656
>>>
>>>
>>>
>>>  _________________________________________________________________________
>>> Professional FreeSWITCH Consulting Services:consulting at freeswitch.orghttp://www.freeswitchsolutions.com
>>>
>>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>>>
>>> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.cluecon.com
>>>
>>> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.freeswitch.org
>>>
>>>
>>>
>>> _________________________________________________________________________
>>> Professional FreeSWITCH Consulting Services:
>>> consulting at freeswitch.org
>>> http://www.freeswitchsolutions.com
>>>
>>> 
>>> 
>>>
>>> Official FreeSWITCH Sites
>>> http://www.freeswitch.org
>>> http://wiki.freeswitch.org
>>> http://www.cluecon.com
>>>
>>> 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
>>>
>>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> 
>> 
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.cluecon.com
>>
>> 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
>>
>>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130901/dfda6ee8/attachment-0001.html