[Freeswitch-users] Corrupted core.db

Tue Jul 16 17:51:00 UTC 2019

I can get a corrupted file, no idea how to replicate.

On Tue, 16 Jul 2019 at 16:38, Brian West <brian at freeswitch.com> wrote:

> Find a way to replicate it and we can fix it, this one is one I've been
> looking at for a while now.
>
> /b
>
>
> On Tue, Jul 16, 2019 at 9:38 AM Joseph Barrero <joe at expert.net> wrote:
>
>> Someone mentioned that they had this problem on AWS. Is anyone having
>> this problem on a local block device rather than EBS?
>>
>> On Tue, May 28, 2019 at 10:36 PM Nathan Neulinger <nneul at mst.edu> wrote:
>>
>>> It's probably infeasible to do so unless the DBs are super small - but
>>> might be useful to try to find at a low level what is corrupted - maybe the
>>> particular areas of corruption in the actual file might give some clue as
>>> to what was happening at the time.
>>>
>>> -- Nathan
>>>
>>> ------------------------------
>>> *From:* Jai Rangi [mailto:jprangi at gmail.com <jprangi at gmail.com>]
>>> *Sent:* Thursday, May 23, 2019, 4:58 PM
>>> *To:* FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
>>> <freeswitch-users at lists.freeswitch.org>
>>> *Subject:* [Freeswitch-users] Corrupted core.db
>>>
>>> My best assumption is it happens at startup. For me I restarted FS last
>>> night to free-up memory (trust me it has memory leak too, we use lots of
>>> LUA scripts if that makes a difference), this is first log I see (at-least
>>> in this case).
>>>
>>> |  \ \ /\ / /\ \ /\ / /\ \ /\ / /     | |   | | | | |/ _ \ |   / _ \| '_
>>> \       / __/ _ \| '_ ` _ \    |
>>> |   \ V  V /  \ V  V /  \ V  V /   _  | |___| | |_| |  __/ |__| (_) | |
>>> | |  _  | (_| (_) | | | | | |   |
>>> |    \_/\_/    \_/\_/    \_/\_/   (_)  \____|_|\__,_|\___|\____\___/|_|
>>> |_| (_)  \___\___/|_| |_| |_|   |
>>> |
>>> |
>>>
>>> .=======================================================================================================.
>>> ^[[m
>>>
>>> 2019-05-22 23:44:33.327486 [INFO] switch_core.c:2435
>>> FreeSWITCH Version 1.6.16+git~20170407T164913Z~3da6bd0108~64bit (git
>>> 3da6bd0 2017-04-07 16:49:13Z 64bit)
>>>
>>> FreeSWITCH Started
>>> Max Sessions [2000]
>>> Session Rate [500]
>>> SQL [Enabled]
>>> 2019-05-22 23:44:33.605347 [ALERT] sofia_presence.c:2909
>>> sofia_presence_sub_callback: endpt is internal
>>> 2019-05-22 23:44:34.305393 [DEBUG] switch_core_file.c:334 File
>>> /usr/local/freeswitch/share/freeswitch/sounds/music/8000/one_day_amplify_reduced.wav
>>> sample rate 44100 doesn't match requested rate 8000
>>> 2019-05-22 23:44:34.305393 [WARNING] switch_core_file.c:352 File has 2
>>> channels, muxing to 1 channel will occur.
>>> 2019-05-22 23:44:34.665410 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR
>>> [database disk image is malformed]
>>>
>>> I might be corrupted during shutdown, (we have almost 1000 users on this
>>> machine, so lots of registration requests), but I only notice it right
>>> after restart. Will gather more incidents and share.
>>>
>>> Best,
>>> -Jai
>>>
>>>
>>>
>>> On Thu, May 23, 2019 at 2:24 PM Brian West <brian at freeswitch.com> wrote:
>>>
>>>> You could help narrow down the cause, its a known problem we've been
>>>> tracking for a while now, but nobody has narrowed down the exact steps to
>>>> replicate it.
>>>>
>>>> /b
>>>>
>>>>
>>>> On Thu, May 23, 2019 at 4:19 PM Jai Rangi <jprangi at gmail.com> wrote:
>>>>
>>>>> We are getting this error
>>>>> When we do show registration
>>>>>
>>>>> switch_core_sqldb.c:1197 SQL ERR: [select * from registrations where
>>>>> hostname='freeswitch'] database disk image is malformed
>>>>>
>>>>> If there a way to fix this without restarting free-switch.
>>>>>
>>>>> Thank you
>>>>> -Jai
>>>>>
>>>>>
>>>>>
>>>>> _________________________________________________________________________
>>>>>
>>>>> The FreeSWITCH project is sponsored by SignalWire
>>>>> https://signalwire.com
>>>>> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN
>>>>> services.
>>>>> Build your next product on our scalable cloud platform.
>>>>>
>>>>> Join our online community to chat in real time
>>>>> https://signalwire.community
>>>>>
>>>>> Professional FreeSWITCH Services
>>>>> sales at freeswitch.com
>>>>> https://freeswitch.com
>>>>>
>>>>> Official FreeSWITCH Sites
>>>>> https://freeswitch.com/oss
>>>>> https://freeswitch.org/confluence
>>>>> https://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
>>>>> https://freeswitch.com
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> Brian West | Co-founder and Developer
>>>>
>>>> Need Commercial support? email sales at freeswitch.com
>>>>
>>>> FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045
>>>> <https://maps.google.com/?q=17345+Civic+Drive+%232531+Brookfield,+WI+53045&entry=gmail&source=g>
>>>>
>>>> Email: brian at freeswitch.com
>>>>
>>>> Mobile: 918-424-9378
>>>>
>>>> Website: https://www.FreeSWITCH.com <https://www.freeswitch.com/>
>>>>
>>>> [image: https://www.facebook.com/signalwireinc?src=email]
>>>> <https://www.facebook.com/freeswitch> [image:
>>>> https://twitter.com/freeswitch] <https://twitter.com/freeswitch>
>>>>
>>>> _________________________________________________________________________
>>>>
>>>> The FreeSWITCH project is sponsored by SignalWire
>>>> https://signalwire.com
>>>> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN
>>>> services.
>>>> Build your next product on our scalable cloud platform.
>>>>
>>>> Join our online community to chat in real time
>>>> https://signalwire.community
>>>>
>>>> Professional FreeSWITCH Services
>>>> sales at freeswitch.com
>>>> https://freeswitch.com
>>>>
>>>> Official FreeSWITCH Sites
>>>> https://freeswitch.com/oss
>>>> https://freeswitch.org/confluence
>>>> https://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
>>>> https://freeswitch.com
>>>
>>>
>>> _________________________________________________________________________
>>>
>>> The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
>>> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.
>>> Build your next product on our scalable cloud platform.
>>>
>>> Join our online community to chat in real time https://signalwire.community
>>>
>>> Professional FreeSWITCH Servicessales at freeswitch.comhttps://freeswitch.com
>>>
>>> Official FreeSWITCH Siteshttps://freeswitch.com/osshttps://freeswitch.org/confluencehttps://cluecon.com
>>>
>>> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttps://freeswitch.com
>>>
>>> --
>>>
>>> ------------------------------------------------------------
>>> Nathan Neulinger                            nneul at mst.edu
>>> Missouri S&T Information Technology         (573) 341-6679
>>> System Administrator - Architect            (573) 612-1412
>>> System and Desktop Infrastructure Team Manager
>>>
>>> _________________________________________________________________________
>>>
>>> The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
>>> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN
>>> services.
>>> Build your next product on our scalable cloud platform.
>>>
>>> Join our online community to chat in real time
>>> https://signalwire.community
>>>
>>> Professional FreeSWITCH Services
>>> sales at freeswitch.com
>>> https://freeswitch.com
>>>
>>> Official FreeSWITCH Sites
>>> https://freeswitch.com/oss
>>> https://freeswitch.org/confluence
>>> https://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
>>> https://freeswitch.com
>>
>> _________________________________________________________________________
>>
>> The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
>> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN
>> services.
>> Build your next product on our scalable cloud platform.
>>
>> Join our online community to chat in real time
>> https://signalwire.community
>>
>> Professional FreeSWITCH Services
>> sales at freeswitch.com
>> https://freeswitch.com
>>
>> Official FreeSWITCH Sites
>> https://freeswitch.com/oss
>> https://freeswitch.org/confluence
>> https://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
>> https://freeswitch.com
>
>
>
> --
>
> Brian West | Co-founder and Developer
>
> Need Commercial support? email sales at freeswitch.com
>
> FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045
> <https://maps.google.com/?q=17345+Civic+Drive+%232531+Brookfield,+WI+53045&entry=gmail&source=g>
>
> Email: brian at freeswitch.com
>
> Mobile: 918-424-9378
>
> Website: https://www.FreeSWITCH.com <https://www.freeswitch.com/>
>
> [image: https://www.facebook.com/signalwireinc?src=email]
> <https://www.facebook.com/freeswitch> [image:
> https://twitter.com/freeswitch] <https://twitter.com/freeswitch>
> _________________________________________________________________________
>
> The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN
> services.
> Build your next product on our scalable cloud platform.
>
> Join our online community to chat in real time
> https://signalwire.community
>
> Professional FreeSWITCH Services
> sales at freeswitch.com
> https://freeswitch.com
>
> Official FreeSWITCH Sites
> https://freeswitch.com/oss
> https://freeswitch.org/confluence
> https://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
> https://freeswitch.com

-- 
Regards,

David Villasmil
email: david.villasmil.work at gmail.com
phone: +34669448337
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20190716/29dc82d5/attachment-0001.html>