<div dir="ltr">Hi Sergey,<div><br></div><div><br></div><div class="gmail_extra"><div><div class="gmail_signature"><div dir="ltr"><div><div>Yes, a UPS esp intelligent types, shuts down FS properly.  But not all UPS has line conditioners which filters out nasty noise, surge and sags esp common-mode types. It&#39;s these disturbances which enter servers that cause some bits in the memory (perhaps) to clubber the database file.</div></div><div><br></div><div>No doubt a UPS helps.</div><div><br></div><div>Tks,</div><div>/Nandy</div></div></div></div>
<br><div class="gmail_quote">On Sun, Mar 8, 2015 at 10:39 PM, Sergey Safarov <span dir="ltr">&lt;<a href="mailto:s.safarov@gmail.com" target="_blank">s.safarov@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir="ltr">Nandy, online UPS will protect you data from this error</p>
<br><div class="gmail_quote">вс, 8 марта 2015, 14:47, Nandy Dagondon &lt;<a href="mailto:nandy1925@gmail.com" target="_blank">nandy1925@gmail.com</a>&gt;:<div><div class="h5"><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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></div></div><div dir="ltr"><div>/Nandy</div></div><div dir="ltr"><div><br><div class="gmail_extra"><div><div><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">&lt;<a href="mailto:max@nysolutions.com" target="_blank">max@nysolutions.com</a>&gt;</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:&quot;Calibri&quot;,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:&quot;Calibri&quot;,sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:&quot;Verdana&quot;,sans-serif;color:#333399">Thanks,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:&quot;Verdana&quot;,sans-serif;color:#333399"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:&quot;Verdana&quot;,sans-serif;color:#333399">Moishe Grunstein<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:&quot;Verdana&quot;,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:&quot;Verdana&quot;,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:&quot;Verdana&quot;,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:&quot;Arial&quot;,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:&quot;Arial&quot;,sans-serif;color:#1f497d;text-decoration:none"><img border="0" width="147" height="68" src="cid:7df4d9eb4d741280_0.0.1" alt="cid:image001.jpg@01C72F94.9EE45D60"></span></a><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:&quot;Calibri&quot;,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:&quot;Calibri&quot;,sans-serif;color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,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>
<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 &lt;<a href="mailto:nbhatti@gmail.com" target="_blank">nbhatti@gmail.com</a>&gt; 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:&quot;Helvetica&quot;,sans-serif"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Helvetica&quot;,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:&quot;Helvetica&quot;,sans-serif">—<u></u><u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Helvetica&quot;,sans-serif">Thanks,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Helvetica&quot;,sans-serif">Muhammad Naseer Bhatti<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Helvetica&quot;,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">&lt;aqsyounas@gmail.com&gt;</a><br>
Reply: FreeSWITCH Users Help <a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank">
&lt;freeswitch-users@lists.freeswitch.org&gt;&gt;</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">
&lt;freeswitch-users@lists.freeswitch.org&gt;&gt;</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=&#39;CS_ROUTING&#39;,cid_name=&#39;<a href="tel:12397284003" target="_blank">12397284003</a>&#39;,cid_num=&#39;<a href="tel:12397284003" target="_blank">12397284003</a>&#39;,callee_name=&#39;&#39;,callee_num=&#39;&#39;,sent_callee_name=&#39;&#39;,sent_callee_num=&#39;&#39;,ip_addr=&#39;216.55.169.165&#39;,dest=&#39;<a href="tel:18572166595" target="_blank">18572166595</a>&#39;,dialplan=&#39;XML&#39;,context=&#39;public&#39;,presence_id=&#39;&#39;,presence_data=&#39;&#39;
 where uuid=&#39;d1dabf5d-b0e5-49e1-a2a4-64fab587214b&#39;<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=&#39;CS_EXECUTE&#39; where uuid=&#39;d1dabf5d-b0e5-49e1-a2a4-64fab587214b&#39;<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=&#39;sched_hangup&#39;,application_data=&#39;+10800 alloted_timeout&#39;,presence_id=&#39;&#39;,presence_data=&#39;&#39; where uuid=&#39;d1dabf5d-b0e5-49e1-a2a4-64fab587214b&#39;<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=&#39;answer&#39;,application_data=&#39;&#39;,presence_id=&#39;&#39;,presence_data=&#39;&#39; where uuid=&#39;d1dabf5d-b0e5-49e1-a2a4-64fab587214b&#39;<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=&#39;PCMU&#39;,read_rate=&#39;8000&#39;,read_bit_rate=&#39;64000&#39;,write_codec=&#39;PCMU&#39;,write_rate=&#39;8000&#39;,write_bit_rate=&#39;64000&#39; where uuid=&#39;d1dabf5d-b0e5-49e1-a2a4-64fab587214b&#39;<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=&#39;PCMU&#39;,read_rate=&#39;8000&#39;,read_bit_rate=&#39;64000&#39;,write_codec=&#39;PCMU&#39;,write_rate=&#39;8000&#39;,write_bit_rate=&#39;64000&#39; where uuid=&#39;d1dabf5d-b0e5-49e1-a2a4-64fab587214b&#39;<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=&#39;PCMU&#39;,read_rate=&#39;8000&#39;,read_bit_rate=&#39;64000&#39;,write_codec=&#39;PCMU&#39;,write_rate=&#39;8000&#39;,write_bit_rate=&#39;64000&#39; where uuid=&#39;d1dabf5d-b0e5-49e1-a2a4-64fab587214b&#39;<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" 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><br></blockquote></div><br></div></div></div>
______________________________<u></u>______________________________<u></u>_____________<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.<u></u>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.<u></u>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.<u></u>freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/<u></u>mailman/listinfo/freeswitch-<u></u>users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.<u></u>freeswitch.org/mailman/<u></u>options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a></blockquote></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>