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.
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
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> <aqsyounas@gmail.com> Reply: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>> <freeswitch-users@lists.freeswitch.org> Date: March 6, 2015 at 2:43:22 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>> <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
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. Thanks, Moishe Grunstein Tornado Computer Systems, Inc. 212.400.7650 888.IPPBX.US Service Request Email: support@nysolutions.com<mailto:support@nysolutions.com> [cid:image001.jpg@01C72F94.9EE45D60]<http://www.nysolutions.com/> Computer Networking * Managed Services * IP Video Surveillance * Network Assessments * Web Solutions * Voice over IP * Disaster Recovery * Network Security * Site Surveys * CMS From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Nandy Dagondon Sent: Saturday, March 7, 2015 9:32 PM To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] NATIVE SQL ERR [database disk image is malformed] 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<mailto: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><mailto:aqsyounas@gmail.com> Reply: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>><mailto:freeswitch-users@lists.freeswitch.org> Date: March 6, 2015 at 2:43:22 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>><mailto: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<tel:12397284003>',cid_num='12397284003<tel:12397284003>',callee_name='',callee_num='',sent_callee_name='',sent_callee_num='',ip_addr='216.55.169.165',dest='18572166595<tel: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<mailto: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<mailto: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<mailto: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<mailto: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
Hi Moishe, 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. Thanks for your input re other databases. /Nandy On Sun, Mar 8, 2015 at 10:58 AM, Moishe Grunstein <max@nysolutions.com> wrote:
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.
Thanks,
Moishe Grunstein
Tornado Computer Systems, Inc.
212.400.7650 888.IPPBX.US *Service Request Email: support@nysolutions.com <support@nysolutions.com> *
[image: cid:image001.jpg@01C72F94.9EE45D60] <http://www.nysolutions.com/>
Computer Networking * Managed Services * IP Video Surveillance * Network Assessments * Web Solutions * Voice over IP * Disaster Recovery * Network Security * Site Surveys * CMS
*From:* freeswitch-users-bounces@lists.freeswitch.org [mailto: freeswitch-users-bounces@lists.freeswitch.org] *On Behalf Of *Nandy Dagondon *Sent:* Saturday, March 7, 2015 9:32 PM *To:* FreeSWITCH Users Help *Subject:* Re: [Freeswitch-users] NATIVE SQL ERR [database disk image is malformed]
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> <aqsyounas@gmail.com> Reply: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>> <freeswitch-users@lists.freeswitch.org> Date: March 6, 2015 at 2:43:22 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>> <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
_________________________________________________________________________ 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
participants (4)
-
Aqs Younas
-
Moishe Grunstein
-
Muhammad Naseer Bhatti
-
Nandy Dagondon