[Freeswitch-users] NATIVE SQL ERR [database disk image is malformed]

Sun Mar 8 14:45:32 MSK 2015

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 at 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 at nysolutions.com <support at nysolutions.com> *
>
> [image: cid:image001.jpg at 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 at lists.freeswitch.org [mailto:
> freeswitch-users-bounces at 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 at 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 at gmail.com> <aqsyounas at gmail.com>
> Reply: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>>
> <freeswitch-users at lists.freeswitch.org>
> Date: March 6, 2015 at 2:43:22 PM
> To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>>
> <freeswitch-users at 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 at 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 at 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 at 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 at 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 at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150308/803ab740/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 2424 bytes
Desc: not available
Url : http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150308/803ab740/attachment-0001.jpg 