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@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]
