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

Mon Mar 9 04:44:13 MSK 2015

Hi Sergey,

Yes, a UPS esp intelligent types, shuts down FS properly.  But not all UPS
has line conditioners which filters out nasty noise, surge and sags esp
common-mode types. It's these disturbances which enter servers that cause
some bits in the memory (perhaps) to clubber the database file.

No doubt a UPS helps.

Tks,
/Nandy

On Sun, Mar 8, 2015 at 10:39 PM, Sergey Safarov <s.safarov at gmail.com> wrote:

> 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
>
>
> _________________________________________________________________________
> 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/20150309/450325e2/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/20150309/450325e2/attachment-0001.jpg 