[Freeswitch-users] Error on FreeSwitch database

[Steven Ayre]

Delete the SQLite .db file and restart FS

FS will recreate it

When power fails the database file can become corrupt because of incomplete
writes, or data in the write cache.

You can prevent that in future by using an odbc database that has better
crash recovery, and tweaking your write cache



On Friday, February 14, 2014, Stefano <stefano at i360tecnologia.com.br> wrote:

> Hello all.
>
>
>
> After a power failure, my freeswitch put some output errors:
>
>
>
> *2014-02-14 08:05:11.105388 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
> [database is locked]*
>
> *BEGIN EXCLUSIVE*
>
> *2014-02-14 08:05:11.105388 [CRIT] switch_core_sqldb.c:1719 ERROR
> [database is locked]*
>
> *2014-02-14 08:05:11.105388 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
> [cannot commit - no transaction is active]*
>
> *COMMIT*
>
>
>
> *2014-02-14 08:05:40.145389 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
> [database disk image is malformed]*
>
> *delete from registrations where reg_user='5136000620' and
> realm='shopping' and hostname='srv-014'*
>
> *2014-02-14 08:05:40.165353 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
> [database disk image is malformed]*
>
> *delete from registrations where reg_user='5136000661' and
> realm='shopping' and hostname='srv-014'*
>
> *2014-02-14 08:05:40.165353 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
> [database disk image is malformed]*
>
> *delete from registrations where expires > 0 and expires <= 1392372295 and
> hostname='srv-014'*
>
> *2014-02-14 08:05:40.385344 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
> [database disk image is malformed]*
>
> *delete from registrations where reg_user='5136000626' and
> realm='shopping' and hostname='srv-014'*
>
> *2014-02-14 08:05:40.585366 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
> [database disk image is malformed]*
>
> *delete from registrations where reg_user='5136000662' and
> realm='shopping' and hostname='srv-014'*
>
>
>
> How I can fix it?
>
>
>
> Thanks
>
>
>
> Att,
>
>
>
> [image: Assinatura - Stefano I360]
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140214/9b0270f6/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 34758 bytes
Desc: not available
Url : http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140214/9b0270f6/attachment-0001.jpg