<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">
<div id="rwhMsgHeader">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.</div>
<div><br>
</div>
<div>-- Nathan</div>
<div><br>
<hr id="rwhMsgHdrDivider" style="border:0;border-top:1px solid
#B5C4DF;padding:0;margin:10px 0 5px 0;width:100%;">
<div style="font-family:Tahoma !important; color:#000000
!important; font-size:13px !important;"><b>From:</b> Jai Rangi
[<a class="moz-txt-link-freetext" href="mailto:jprangi@gmail.com">mailto:jprangi@gmail.com</a>]</div>
<div style="font-family:Tahoma !important; color:#000000
!important; font-size:13px !important;"><b>Sent:</b> Thursday,
May 23, 2019, 4:58 PM</div>
<div style="font-family:Tahoma !important; color:#000000
!important; font-size:13px !important;"><b>To:</b> FreeSWITCH
Users Help <a class="moz-txt-link-rfc2396E" href="mailto:freeswitch-users@lists.freeswitch.org"><freeswitch-users@lists.freeswitch.org></a></div>
<div style="font-family:Tahoma !important; color:#000000
!important; font-size:13px !important;"><b>Subject:</b>
[Freeswitch-users] Corrupted core.db</div>
<br>
</div>
</div>
<blockquote type="cite"
cite="mid:CAPfjz3hn_-qUUMHaqBXp2u8Uhk-WyfE5dL3nCnrnunoG_wHSjQ@mail.gmail.com"
style="border:none !important; margin-left:0px !important;
margin-right:0px !important; margin-top:0px !important;
padding-left:0px !important; padding-right:0px !important">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr">
<div>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). <br>
</div>
<div><br>
</div>
<div>| \ \ /\ / /\ \ /\ / /\ \ /\ / / | | | | | | |/ _
\ | / _ \| '_ \ / __/ _ \| '_ ` _ \ |<br>
| \ V V / \ V V / \ V V / _ | |___| | |_| | __/
|__| (_) | | | | _ | (_| (_) | | | | | | |<br>
| \_/\_/ \_/\_/ \_/\_/ (_)
\____|_|\__,_|\___|\____\___/|_| |_| (_) \___\___/|_| |_|
|_| |<br>
|
|<br>
.=======================================================================================================.<br>
^[[m<br>
<br>
2019-05-22 23:44:33.327486 [INFO] switch_core.c:2435<br>
FreeSWITCH Version
1.6.16+git~20170407T164913Z~3da6bd0108~64bit (git 3da6bd0
2017-04-07 16:49:13Z 64bit)<br>
<br>
FreeSWITCH Started<br>
Max Sessions [2000]<br>
Session Rate [500]<br>
SQL [Enabled]<br>
2019-05-22 23:44:33.605347 [ALERT] sofia_presence.c:2909
sofia_presence_sub_callback: endpt is internal<br>
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<br>
2019-05-22 23:44:34.305393 [WARNING] switch_core_file.c:352
File has 2 channels, muxing to 1 channel will occur.<br>
2019-05-22 23:44:34.665410 [ERR] switch_core_sqldb.c:587
NATIVE SQL ERR [database disk image is malformed]<br>
</div>
<div><br>
</div>
<div>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. <br>
</div>
<div><br>
</div>
<div>Best,</div>
<div>-Jai <br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, May 23, 2019 at 2:24
PM Brian West <<a href="mailto:brian@freeswitch.com"
moz-do-not-send="true">brian@freeswitch.com</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="border:none !important;
margin-left:0px !important; margin-right:0px !important;
margin-top:0px !important; padding-left:0px !important;
padding-right:0px !important">
<div dir="ltr">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.
<div><br>
</div>
<div>/b</div>
<div><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, May 23, 2019 at
4:19 PM Jai Rangi <<a href="mailto:jprangi@gmail.com"
target="_blank" moz-do-not-send="true">jprangi@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="border:none
!important; margin-left:0px !important; margin-right:0px
!important; margin-top:0px !important; padding-left:0px
!important; padding-right:0px !important">
<div dir="ltr">
<div dir="ltr">
<div>We are getting this error</div>
<div>When we do show registration <br>
</div>
<div><br>
</div>
<div>switch_core_sqldb.c:1197 SQL ERR: [select * from
registrations where hostname='freeswitch'] database
disk image is malformed<br>
</div>
<div><br>
</div>
<div>If there a way to fix this without restarting
free-switch. <br>
</div>
<div><br>
</div>
<div>Thank you</div>
<div>-Jai<br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
_________________________________________________________________________<br>
<br>
The FreeSWITCH project is sponsored by SignalWire <a
href="https://signalwire.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://signalwire.com</a><br>
Enhance your FreeSWITCH install with disruptive priced SMS
and PSTN services.<br>
Build your next product on our scalable cloud platform.<br>
<br>
Join our online community to chat in real time <a
href="https://signalwire.community" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://signalwire.community</a><br>
<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank"
moz-do-not-send="true">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank" moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a></blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr"
class="gmail-m_-4848944502059181473gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div style="font-size:12.8px"><font
color="#000000"><br>
</font></div>
<div style="font-size:12.8px">
<p dir="ltr"
style="font-size:12.8px;line-height:1.38;margin-top:0pt;margin-bottom:0pt;margin-left:4.5pt"><span style="font-size:8pt;font-family:Arial;background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><font color="#000000">Brian West | Co-founder and Developer</font></span></p>
<p
style="font-size:12.8px;line-height:1.38;margin-top:0pt;margin-bottom:0pt;margin-left:4.5pt"><span style="font-size:8pt;font-family:Arial;background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><font color="#000000">Need Commercial support? email <a href="mailto:sales@freeswitch.com" target="_blank" moz-do-not-send="true">sales@freeswitch.com</a> </font></span></p>
<p dir="ltr"
style="font-size:12.8px;line-height:1.38;margin-top:0pt;margin-bottom:0pt;margin-left:4.5pt"><span style="font-size:8pt;font-family:Arial;background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><font color="#000000">FreeSWITCH Solutions | <a href="https://maps.google.com/?q=17345+Civic+Drive+%232531+Brookfield,+WI+53045&entry=gmail&source=g" style="color:rgb(17,85,204)" target="_blank" moz-do-not-send="true">17345 Civic Drive #2531 Brookfield, WI 53045</a></font></span></p>
<p dir="ltr"
style="font-size:12.8px;line-height:1.38;margin-top:0pt;margin-bottom:0pt;margin-left:4.5pt"><font
color="#000000"><span style="font-size:8pt;font-family:Arial;background-color:transparent;vertical-align:baseline;white-space:pre-wrap">Email: </span><span style="color:rgb(17,85,204);font-size:8pt;font-family:Arial;background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><a href="mailto:brian@freeswitch.com" target="_blank" moz-do-not-send="true">brian@freeswitch.com</a></span></font></p>
<p dir="ltr"
style="font-size:12.8px;line-height:1.38;margin-top:0pt;margin-bottom:0pt;margin-left:4.5pt"><span style="font-size:8pt;font-family:Arial;background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><font color="#000000">Mobile: <span title="Call with Google Voice">918-424-9378</span></font></span></p>
<p dir="ltr"
style="font-size:12.8px;line-height:1.38;margin-top:0pt;margin-bottom:0pt;margin-left:4.5pt"><font
color="#000000"><span style="font-size:8pt;font-family:Arial;background-color:transparent;vertical-align:baseline;white-space:pre-wrap">Website: </span><a
href="https://www.freeswitch.com/" style="color:rgb(17,85,204)"
target="_blank"
moz-do-not-send="true"><span style="font-size:8pt;font-family:Arial;background-color:transparent;vertical-align:baseline;white-space:pre-wrap">https://www.FreeSWITCH.com</span></a></font></p>
<p dir="ltr"
style="font-size:12.8px;line-height:1.2;margin-top:0pt;margin-bottom:0pt"><span style="background-color:transparent;font-size:9pt;font-family:Arial;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap"><a href="https://www.facebook.com/freeswitch" target="_blank" moz-do-not-send="true"><img alt="https://www.facebook.com/signalwireinc?src=email" src="https://lh6.googleusercontent.com/AYfRoSNaDNtMPRMevPn_GqcVEMd5NDRFi0GlluGUWzV6I5TAY_3T2-Tt0IuIXeUtEdYsgNsM8DOYKRKhjmrG_-n2Ga-LCnoNk46sO8VyEma1sBFYdiGJcLRUvkrD1CYHN79qimeg" style="border: medium none;" moz-do-not-send="true" width="31" height="31"></a> </span><span style="background-color:transparent;font-size:9pt;font-family:Tahoma;color:rgb(0,0,0);vertical-align:baseline;white-space:pre-wrap"><a href="https://twitter.com/freeswitch" target="_blank" moz-do-not-send="true"><img alt="https://twitter.com/freeswitch" src="https://lh3.googleusercontent.com/W4SqXyybH2qdAozvtoKjcz736qOjk9LHDwldvs1ahc-WVU0putVMSsUH474KDrJ32jsqi6JDjyUWxqeEkN5I1xSlC5ShYrd1b8NIMUkDzDrtbWQfa6A_90UcygqesBtRLgeFirKa" style="border: medium none;" moz-do-not-send="true" width="31" height="31"></a></span><br>
</p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_________________________________________________________________________<br>
<br>
The FreeSWITCH project is sponsored by SignalWire <a
href="https://signalwire.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://signalwire.com</a><br>
Enhance your FreeSWITCH install with disruptive priced SMS and
PSTN services.<br>
Build your next product on our scalable cloud platform.<br>
<br>
Join our online community to chat in real time <a
href="https://signalwire.community" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://signalwire.community</a><br>
<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank"
moz-do-not-send="true">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer" target="_blank"
moz-do-not-send="true">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank" moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a></blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire <a class="moz-txt-link-freetext" href="https://signalwire.com">https://signalwire.com</a>
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 <a class="moz-txt-link-freetext" href="https://signalwire.community">https://signalwire.community</a>
Professional FreeSWITCH Services
<a class="moz-txt-link-abbreviated" href="mailto:sales@freeswitch.com">sales@freeswitch.com</a>
<a class="moz-txt-link-freetext" href="https://freeswitch.com">https://freeswitch.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="https://freeswitch.com/oss">https://freeswitch.com/oss</a>
<a class="moz-txt-link-freetext" href="https://freeswitch.org/confluence">https://freeswitch.org/confluence</a>
<a class="moz-txt-link-freetext" href="https://cluecon.com">https://cluecon.com</a>
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="https://freeswitch.com">https://freeswitch.com</a></pre>
</blockquote>
<pre class="moz-signature" cols="120">--
------------------------------------------------------------
Nathan Neulinger <a class="moz-txt-link-abbreviated" href="mailto:nneul@mst.edu">nneul@mst.edu</a>
Missouri S&T Information Technology (573) 341-6679
System Administrator - Architect (573) 612-1412
System and Desktop Infrastructure Team Manager</pre>
</body>
</html>