<div dir="ltr">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.<div><br></div><div>I encounter this problem several times. So, is it better if I switch to PostgreSQL or MySQL?</div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><div>Tks,</div></div><div>/Nandy</div></div></div></div>
<br><div class="gmail_quote">On Fri, Mar 6, 2015 at 7:54 PM, Muhammad Naseer Bhatti <span dir="ltr"><<a href="mailto:nbhatti@gmail.com" target="_blank">nbhatti@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">You seem to be using SQLite for core db. Remove the db files from your FreeSWITCH install location /db and restart FreeSWITCH. </div> <br> <div><div style="font-family:helvetica,arial;font-size:13px"><span style="font-family:Helvetica,Arial;line-height:normal">—</span><div style="font-family:Helvetica,Arial;line-height:normal">Thanks,</div><div style="font-family:Helvetica,Arial;line-height:normal">Muhammad Naseer Bhatti</div><div style="font-family:Helvetica,Arial;line-height:normal"><br></div></div></div> <div style="color:black"><br>From: <span style="color:black">Aqs Younas</span> <a href="mailto:aqsyounas@gmail.com" target="_blank"><aqsyounas@gmail.com></a><br>Reply: <span style="color:black">FreeSWITCH Users Help</span> <a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank"><freeswitch-users@lists.freeswitch.org>></a><br>Date: <span style="color:black">March 6, 2015 at 2:43:22 PM</span><br>To: <span style="color:black">FreeSWITCH Users Help</span> <a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank"><freeswitch-users@lists.freeswitch.org>></a><br>Subject: <span style="color:black"> [Freeswitch-users] NATIVE SQL ERR [database disk image is malformed] <br></span></div><br> <blockquote type="cite"><span><div><div></div><div><div><div class="h5">
<div dir="ltr">
<div>
<div>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" value="+12397284003" target="_blank">12397284003</a>',cid_num='<a href="tel:12397284003" value="+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" value="+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'<br>
<br></div>
<div>How can I resolve this on my server?<br>
<br></div>
I was using mysql database to dump my cdr using mod_json_cdr.<br>
<br></div>
Thanks for you help.<br></div></div></div>
_________________________________________________________________________
<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></div></div></span></blockquote></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>