<div dir="ltr">Hi Moishe,<div><br></div><div>The corruption happened even without power failures. I begin to suspect that an electrical surge or noise is causing this corruption. A line conditioner is needed in this case.</div><div><br></div><div>Thanks for your input re other databases.</div><div><br></div><div>/Nandy<br><div class="gmail_extra"><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><br></div></div></div></div></div>
<br><div class="gmail_quote">On Sun, Mar 8, 2015 at 10:58 AM, Moishe Grunstein <span dir="ltr"><<a href="mailto:max@nysolutions.com" target="_blank">max@nysolutions.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Although more common with SQlite, any Db can get corrupt from an unclean shutdown, you should look in to why you the server is losing power, get a UPS that can
cleanly shut down the server in an even of a long power outage.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#333399">Thanks,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#333399"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#333399">Moishe Grunstein<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#333399">Tornado Computer Systems, Inc.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#333399"><a href="tel:212.400.7650" value="+12124007650" target="_blank">212.400.7650</a> <a href="http://888.IPPBX.US" target="_blank">888.IPPBX.US</a><br>
</span><b><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#76923c">Service Request Email:
<a href="mailto:support@nysolutions.com" target="_blank">support@nysolutions.com</a> </span></b><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#333399"><u></u><u></u></span></p>
<p class="MsoNormal"><a href="http://www.nysolutions.com/" target="_blank"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1f497d;text-decoration:none"><img border="0" width="147" height="68" src="cid:image001.jpg@01D05921.E00DFBB0" alt="cid:image001.jpg@01C72F94.9EE45D60"></span></a><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Calibri",sans-serif;color:#c0504d">Computer Networking * Managed Services * IP Video Surveillance * Network Assessments * Web Solutions
* Voice over IP * Disaster Recovery * Network Security * Site Surveys * CMS</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> <a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a> [mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>]
<b>On Behalf Of </b>Nandy Dagondon<br>
<b>Sent:</b> Saturday, March 7, 2015 9:32 PM<br>
<b>To:</b> FreeSWITCH Users Help<br>
<b>Subject:</b> Re: [Freeswitch-users] NATIVE SQL ERR [database disk image is malformed]<u></u><u></u></span></p><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">I made a backup copy of the SQLite file. I made a script that 1) shutdowns FS; 2) copy the backup copy; 3) start FS again.<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I encounter this problem several times. So, is it better if I switch to PostgreSQL or MySQL?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><br clear="all">
<u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Tks,<u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal">/Nandy<u></u><u></u></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On Fri, Mar 6, 2015 at 7:54 PM, Muhammad Naseer Bhatti <<a href="mailto:nbhatti@gmail.com" target="_blank">nbhatti@gmail.com</a>> wrote:<u></u><u></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif">You seem to be using SQLite for core db. Remove the db files from your FreeSWITCH install location /db and restart FreeSWITCH. <u></u><u></u></span></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif">—<u></u><u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Thanks,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Muhammad Naseer Bhatti<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><u></u> <u></u></span></p>
</div>
</div>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><br>
From: Aqs Younas <a href="mailto:aqsyounas@gmail.com" target="_blank"><aqsyounas@gmail.com></a><br>
Reply: FreeSWITCH Users Help <a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank">
<freeswitch-users@lists.freeswitch.org>></a><br>
Date: March 6, 2015 at 2:43:22 PM<br>
To: FreeSWITCH Users Help <a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank">
<freeswitch-users@lists.freeswitch.org>></a><br>
Subject: [Freeswitch-users] NATIVE SQL ERR [database disk image is malformed] <u></u>
<u></u></span></p>
</div>
<p class="MsoNormal"><br>
<br>
<u></u><u></u></p>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi, users.<br>
<br>
After power failure on my server, now when I start my freeswitch I see these errors logs on my freeswitch.<br>
<br>
state='CS_ROUTING',cid_name='<a href="tel:12397284003" target="_blank">12397284003</a>',cid_num='<a href="tel:12397284003" target="_blank">12397284003</a>',callee_name='',callee_num='',sent_callee_name='',sent_callee_num='',ip_addr='216.55.169.165',dest='<a href="tel:18572166595" target="_blank">18572166595</a>',dialplan='XML',context='public',presence_id='',presence_data=''
where uuid='d1dabf5d-b0e5-49e1-a2a4-64fab587214b'<br>
2015-03-06 11:29:19.447128 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [database disk image is malformed]<br>
update channels set state='CS_EXECUTE' where uuid='d1dabf5d-b0e5-49e1-a2a4-64fab587214b'<br>
2015-03-06 11:29:19.646659 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [database disk image is malformed]<br>
update channels set application='sched_hangup',application_data='+10800 alloted_timeout',presence_id='',presence_data='' where uuid='d1dabf5d-b0e5-49e1-a2a4-64fab587214b'<br>
2015-03-06 11:29:19.846678 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [database disk image is malformed]<br>
update channels set application='answer',application_data='',presence_id='',presence_data='' where uuid='d1dabf5d-b0e5-49e1-a2a4-64fab587214b'<br>
2015-03-06 11:29:20.046670 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [database disk image is malformed]<br>
update channels set read_codec='PCMU',read_rate='8000',read_bit_rate='64000',write_codec='PCMU',write_rate='8000',write_bit_rate='64000' where uuid='d1dabf5d-b0e5-49e1-a2a4-64fab587214b'<br>
2015-03-06 11:29:20.246667 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [database disk image is malformed]<br>
update channels set read_codec='PCMU',read_rate='8000',read_bit_rate='64000',write_codec='PCMU',write_rate='8000',write_bit_rate='64000' where uuid='d1dabf5d-b0e5-49e1-a2a4-64fab587214b'<br>
2015-03-06 11:29:20.447279 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [database disk image is malformed]<br>
update channels set read_codec='PCMU',read_rate='8000',read_bit_rate='64000',write_codec='PCMU',write_rate='8000',write_bit_rate='64000' where uuid='d1dabf5d-b0e5-49e1-a2a4-64fab587214b'<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">How can I resolve this on my server?<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">I was using mysql database to dump my cdr using mod_json_cdr.<u></u><u></u></p>
</div>
<p class="MsoNormal">Thanks for you help.<u></u><u></u></p>
</div>
</div>
</div>
<p class="MsoNormal">_________________________________________________________________________
<br>
Professional FreeSWITCH Consulting Services: <br>
<a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a>
<br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a>
<br>
<br>
Official FreeSWITCH Sites <br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
<br>
<a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a>
<br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a> <br>
<br>
FreeSWITCH-users mailing list <br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a>
<br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
<br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div></div></div>
</div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br></blockquote></div><br></div></div></div>