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,

 

Assinatura - Stefano I360