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

Sun Mar 8 17:39:03 MSK 2015

Nandy, online UPS will protect you data from this error

вс, 8 марта 2015, 14:47, Nandy Dagondon <nandy1925 at gmail.com>:

> 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
>>
>
> _________________________________________________________________________
> 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/be4242ca/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/be4242ca/attachment-0002.jpg 
-------------- 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/be4242ca/attachment-0003.jpg