Delete the SQLite .db file and restart FS<div><br></div><div>FS will recreate it<br><div><div><br></div><div>When power fails the database file can become corrupt because of incomplete writes, or data in the write cache. </div>
<div><br></div><div>You can prevent that in future by using an odbc database that has better crash recovery, and tweaking your write cache </div><div><br></div><div><br></div><div><br>On Friday, February 14, 2014, Stefano <<a href="mailto:stefano@i360tecnologia.com.br">stefano@i360tecnologia.com.br</a>> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="PT-BR" link="blue" vlink="purple"><div><p class="MsoNormal"><span lang="EN-US">Hello all.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">After a power failure, my freeswitch put some output errors:<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:9.0pt">2014-02-14 08:05:11.105388 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [database is locked]<u></u><u></u></span></i></p><p class="MsoNormal"><i><span lang="EN-US" style="font-size:9.0pt">BEGIN EXCLUSIVE<u></u><u></u></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:9.0pt">2014-02-14 08:05:11.105388 [CRIT] switch_core_sqldb.c:1719 ERROR [database is locked]<u></u><u></u></span></i></p><p class="MsoNormal"><i><span lang="EN-US" style="font-size:9.0pt">2014-02-14 08:05:11.105388 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [cannot commit - no transaction is active]<u></u><u></u></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:9.0pt">COMMIT<u></u><u></u></span></i></p><p class="MsoNormal"><i><span lang="EN-US" style="font-size:9.0pt"><u></u> <u></u></span></i></p><p class="MsoNormal"><i><span lang="EN-US" style="font-size:9.0pt">2014-02-14 08:05:40.145389 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [database disk image is malformed]<u></u><u></u></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:9.0pt">delete from registrations where reg_user='5136000620' and realm='shopping' and hostname='srv-014'<u></u><u></u></span></i></p><p class="MsoNormal">
<i><span lang="EN-US" style="font-size:9.0pt">2014-02-14 08:05:40.165353 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [database disk image is malformed]<u></u><u></u></span></i></p><p class="MsoNormal"><i><span lang="EN-US" style="font-size:9.0pt">delete from registrations where reg_user='5136000661' and realm='shopping' and hostname='srv-014'<u></u><u></u></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:9.0pt">2014-02-14 08:05:40.165353 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [database disk image is malformed]<u></u><u></u></span></i></p><p class="MsoNormal">
<i><span lang="EN-US" style="font-size:9.0pt">delete from registrations where expires > 0 and expires <= 1392372295 and hostname='srv-014'<u></u><u></u></span></i></p><p class="MsoNormal"><i><span lang="EN-US" style="font-size:9.0pt">2014-02-14 08:05:40.385344 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [database disk image is malformed]<u></u><u></u></span></i></p>
<p class="MsoNormal"><i><span lang="EN-US" style="font-size:9.0pt">delete from registrations where reg_user='5136000626' and realm='shopping' and hostname='srv-014'<u></u><u></u></span></i></p><p class="MsoNormal">
<i><span lang="EN-US" style="font-size:9.0pt">2014-02-14 08:05:40.585366 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [database disk image is malformed]<u></u><u></u></span></i></p><p class="MsoNormal"><i><span lang="EN-US" style="font-size:9.0pt">delete from registrations where reg_user='5136000662' and realm='shopping' and hostname='srv-014'<u></u><u></u></span></i></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">How I can fix it?<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal">
<span lang="EN-US">Thanks<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">Att,<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span><img width="549" height="146" src="cid:image001.jpg@01CF295E.75D17680" alt="Assinatura - Stefano I360 "><u></u><u></u></span></p><p class="MsoNormal"><span><u></u> <u></u></span></p><p class="MsoNormal">
<u></u> <u></u></p></div></div></blockquote></div></div></div>