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

[Steven Ayre]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130901/1840109f/attachment-0001.html