[Freeswitch-users] Corrupted core.db

[Jai Rangi]

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