[Freeswitch-users] Corrupted core.db

sanjeev dubey sanjeevdb4 at gmail.com
Sat Jul 20 10:25:25 UTC 2019 

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

More information about the FreeSWITCH-users mailing list