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.

I encounter this problem several times. So, is it better if I switch to PostgreSQL or MySQL?

Tks,
/Nandy

On Fri, Mar 6, 2015 at 7:54 PM, Muhammad Naseer Bhatti <nbhatti@gmail.com> wrote:

You seem to be using SQLite for core db. Remove the db files from your FreeSWITCH install location /db and restart FreeSWITCH.  

—
Thanks,
Muhammad Naseer Bhatti


From: Aqs Younas <aqsyounas@gmail.com>
Reply: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>>
Date: March 6, 2015 at 2:43:22 PM
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>>
Subject:  [Freeswitch-users] NATIVE SQL ERR [database disk image is malformed]

Hi, users.

After power failure on my server, now when I start my freeswitch  I see these errors logs on my freeswitch.

state='CS_ROUTING',cid_name='12397284003',cid_num='12397284003',callee_name='',callee_num='',sent_callee_name='',sent_callee_num='',ip_addr='216.55.169.165',dest='18572166595',dialplan='XML',context='public',presence_id='',presence_data='' where uuid='d1dabf5d-b0e5-49e1-a2a4-64fab587214b'
2015-03-06 11:29:19.447128 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [database disk image is malformed]
update channels set state='CS_EXECUTE' where uuid='d1dabf5d-b0e5-49e1-a2a4-64fab587214b'
2015-03-06 11:29:19.646659 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [database disk image is malformed]
update channels set application='sched_hangup',application_data='+10800 alloted_timeout',presence_id='',presence_data='' where uuid='d1dabf5d-b0e5-49e1-a2a4-64fab587214b'
2015-03-06 11:29:19.846678 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [database disk image is malformed]
update channels set application='answer',application_data='',presence_id='',presence_data='' where uuid='d1dabf5d-b0e5-49e1-a2a4-64fab587214b'
2015-03-06 11:29:20.046670 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [database disk image is malformed]
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'
2015-03-06 11:29:20.246667 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [database disk image is malformed]
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'
2015-03-06 11:29:20.447279 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [database disk image is malformed]
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'

How can I resolve this on my server?

I was using mysql database to dump my cdr using mod_json_cdr.

Thanks for you help.
_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org