[Freeswitch-users] Corrupted core.db

Brian West brian at freeswitch.com
Mon Jul 22 22:20:18 UTC 2019 

111 is icmp unreachable, Sure the DB was up?

On Mon, Jul 22, 2019 at 4:03 PM sanjeev dubey <sanjeevdb4 at gmail.com> wrote:

> Dear All,
>
> I m getting below error after restarting the server, after that i have to
> reload the SIP profile manually.
> Need your help
>
> 2019-07-19 21:52:00.891950 [DEBUG] mod_event_socket.c:2961 Socket up listening on 127.0.0.1:8021
> 2019-07-19 21:52:00.894828 [ERR] switch_odbc.c:368 STATE: HY000 CODE 2003 ERROR: [unixODBC][MySQL][ODBC 5.2(w) Driver]Can't connect to MySQL server on '127.0.0.1' (111)
>
> 2019-07-19 21:52:00.894851 [CRIT] switch_core_sqldb.c:508 Failure to connect to ODBC opencc!
> 2019-07-19 21:52:00.894858 [ERR] freeswitch_lua.cpp:374 Connection failed. DBH NOT Connected.
> 2019-07-19 21:52:00.895086 [ERR] mod_lua.cpp:202 /usr/local/freeswitch/scripts/resources/functions/database/native.lua:27: assertion failed!
> stack traceback:
> [C]: in function 'assert'
> /usr/local/freeswitch/scripts/resources/functions/database/native.lua:27: in function 'new'
> /usr/local/freeswitch/scripts/resources/functions/database.lua:87: in function </usr/local/freeswitch/scripts/resources/functions/database.lua:86>
> (tail call): ?
> (tail call): ?
> /usr/local/freeswitch/scripts/app/xml_handler/resources/scripts/configuration/acl.conf.lua:33: in main chunk
> [C]: in function 'dofile'
> /usr/local/freeswitch/scripts/app/xml_handler/index.lua:77: in main chunk
> /usr/local/freeswitch/scripts/app.lua:30: in main chunk
> 2019-07-19 21:52:00.895112 [ERR] mod_lua.cpp:270 LUA script parse/execute error!
> 2019-07-19 21:52:00.896754 [INFO] switch_core.c:2447
> FreeSWITCH Version 1.8.5~64bit ( 64bit)
>
> Thanks
>
> Sanjeev
>
>
>
>
>
>
>
>
> On Wed, Jul 17, 2019, 3:19 AM Mike Jerris <mike at freeswitch.com> wrote:
>
>> 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
>>
>> _________________________________________________________________________
>>
>> 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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20190722/35cdd48b/attachment-0001.html>

More information about the FreeSWITCH-users mailing list