<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<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.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#333399">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#333399"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#333399">Moishe Grunstein<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#333399">Tornado Computer Systems, Inc.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Verdana",sans-serif;color:#333399">212.400.7650 888.IPPBX.US<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">support@nysolutions.com</a> </span></b><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#333399"><o:p></o:p></span></p>
<p class="MsoNormal"><a href="http://www.nysolutions.com/"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;text-decoration:none"><img border="0" width="147" height="68" id="Picture_x0020_1" 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"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></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"> freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org]
<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]<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></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.<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I encounter this problem several times. So, is it better if I switch to PostgreSQL or MySQL?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Tks,<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal">/Nandy<o:p></o:p></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></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:<o:p></o:p></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"><o:p> </o:p></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. <o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif">—<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Thanks,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Muhammad Naseer Bhatti<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><o:p> </o:p></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] <o:p>
</o:p></span></p>
</div>
<p class="MsoNormal"><br>
<br>
<o:p></o:p></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'<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">How can I resolve this on my server?<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">I was using mysql database to dump my cdr using mod_json_cdr.<o:p></o:p></p>
</div>
<p class="MsoNormal">Thanks for you help.<o:p></o:p></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><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><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><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</body>
</html>