[Freeswitch-users] Corrupted core.db

Brian West brian at freeswitch.com
Tue Jul 16 19:58:08 UTC 2019 

I can get plenty of corrupt DBs, just no solid steps to replicate the issue.

On Tue, Jul 16, 2019 at 12:52 PM David Villasmil <
david.villasmil.work at gmail.com> wrote:

> 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
> _________________________________________________________________________
>
> 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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20190716/c34f3c76/attachment-0001.html>

More information about the FreeSWITCH-users mailing list