[Freeswitch-users] Corrupted core.db

Mike Jerris mike at freeswitch.com
Tue Jul 16 21:11:54 UTC 2019 

note to all, while we would like to sort this issue, please be aware that
sqlite is inherently not as fault tolerant as real db servers, and for this
reason we generally recommend using postgres for production deployments
where fault tolerance is important.

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

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

More information about the FreeSWITCH-users mailing list