<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi Brian,<br>
<br>
Is not related to sqlite dbs only, it affects also the access to
postgresql, in the last case the connection to database is lock,
some jiras i could get, different errors but same setup, and i think
that is the same root cause:<br>
<br>
*mod_callcenter: callcenter_api locked<br>
<a class="moz-txt-link-freetext" href="https://freeswitch.org/jira/browse/FS-10638">https://freeswitch.org/jira/browse/FS-10638</a><br>
<br>
<br>
*error message: fail to send query to pgsql:<br>
<a class="moz-txt-link-freetext" href="https://freeswitch.org/jira/browse/FS-10474">https://freeswitch.org/jira/browse/FS-10474</a><br>
<br>
*sofia stop response to requests:<br>
<a class="moz-txt-link-freetext" href="https://freeswitch.org/jira/browse/FS-10676">https://freeswitch.org/jira/browse/FS-10676</a><br>
<br>
<br>
I all i solve it by restart only postgresql, with forces FS to clean
up all dbhandles open. <br>
<br>
Jeremy, for what i could compile from the different times it happens
is the presence of wss endpoints, i've other similar setups without
wss that i don't face this issues. I couldn't figure the what is the
root cause, it could be some bug in openssl lib... for sure is some
corruption in open db handles by fs.<br>
<br>
I try proxy wss connections with nginx, but same issue. Now i was
working on trying to connect to FS without ssl using the proxy this
way:<br>
<br>
cliente <- [WSS] -> nginx <-[WS]-> fs<br>
<br>
But of course i need to implement in nginx a "WSS helper" to change
all tls contact to non tls.<br>
<br>
<br>
Right now i've a server in "quarantine" where i put the my clients
that are using wss, so i can restart FS without affecting many
calls. <br>
<br>
<br>
<pre class="moz-signature" cols="72">Saludos / Regards / Cumprimentos,
António silva</pre>
<div class="moz-cite-prefix">On 01/09/2018 01:12 AM, Brian West
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAEJMVkBM5u0LZ=3h7qL6kzzP2M=U_mZQx6C_8hNDOc-pvvuXTg@mail.gmail.com">
<div dir="ltr">I do not believe that is what is going on.
<div><br>
</div>
<div><a href="https://freeswitch.org/jira/browse/FS-9371"
moz-do-not-send="true">https://freeswitch.org/jira/browse/FS-9371</a><br>
</div>
<div><a href="https://freeswitch.org/jira/browse/FS-10721"
moz-do-not-send="true">https://freeswitch.org/jira/browse/FS-10721</a><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>Are you using <span style="color:rgb(0,0,0);white-space:pre-wrap">freeswitch.Dbh from LUA? I think its probably closing the file out from under you and corrupting the db in the process.</span></div>
<div><span style="color:rgb(0,0,0);white-space:pre-wrap">
</span></div>
<div><font color="#000000"><span style="white-space:pre-wrap">Maybe these JIRAs will provide a way to replicate the issue on demand.</span></font></div>
<div><font color="#000000"><span style="white-space:pre-wrap">
</span></font></div>
<div><font color="#000000"><span style="white-space:pre-wrap">/b</span></font></div>
<div><font color="#000000"><span style="white-space:pre-wrap">
</span></font></div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Sun, Jan 7, 2018 at 5:51 PM, Geoff
Mina <span dir="ltr"><<a
href="mailto:gmina@connectfirst.com" target="_blank"
moz-do-not-send="true">gmina@connectfirst.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">As a
confirmation, the profile which corrupted was exclusively
WSS connections.<br>
<div class="HOEnZb">
<div class="h5"><br>
> On Jan 7, 2018, at 4:24 PM, Jeremy Lainé <<a
href="mailto:jeremy.laine@m4x.org"
moz-do-not-send="true">jeremy.laine@m4x.org</a>>
wrote:<br>
><br>
> Hi all,<br>
><br>
> Just as Geoff Mina recently reported, I too have
encountered numerous instances of sqlite database
corruptions, without any power cuts or disk failures. I
have experienced this both on EC2 instances and on
physical servers.<br>
><br>
> I saw António Silva asked whether Geoff Mina was
using wss endpoints, could you elaborate on why this
might be the root cause? In the setups where I
encountered the corruption, I am indeed using wss
endpoints. How about you Geoff?<br>
><br>
> As a workaround I am considering migrating to
postgresql (core + sofia) but it's frustating not to
understand the root cause of the problem.<br>
><br>
> Cheers,<br>
><br>
> Jeremy<br>
><br>
<br>
______________________________<wbr>______________________________<wbr>_____________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org"
moz-do-not-send="true">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com"
rel="noreferrer" target="_blank"
moz-do-not-send="true">http://www.<wbr>freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" rel="noreferrer"
target="_blank" moz-do-not-send="true">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true">http://confluence.freeswitch.<wbr>org</a><br>
<a href="http://www.cluecon.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org"
moz-do-not-send="true">FreeSWITCH-users@lists.<wbr>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/<wbr>mailman/listinfo/freeswitch-<wbr>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.<wbr>freeswitch.org/mailman/<wbr>options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" rel="noreferrer"
target="_blank" moz-do-not-send="true">http://www.freeswitch.org</a></div>
</div>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
<div class="gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div style="font-size:12.8px"><font
color="#000000"><img
src="http://24.112.99.44/fss.png"
moz-do-not-send="true"><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 | General Operations Director</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: 918-424-9378</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"><font
color="#000000"><a
href="https://www.facebook.com/freeswitch/"
style="color:rgb(17,85,204)"
target="_blank" moz-do-not-send="true"><span style="font-size:11pt;font-family:Arial;background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><img src="https://lh6.googleusercontent.com/l9_7QxvYIM4pcdS6eXAkIOZKqHnR2mYmt879_LZ93jSG-uGqOLzO0KVlBzTnPxn7QwU7I0Ednhi0MT_4nRGSobPt4f-LXMWr891Agu25Mvx-AD3k45rf6vUBquJW8NMPkHb_DBaK" alt="color-facebook-96.png" style="border:none" moz-do-not-send="true" width="23" height="23"></span></a><span style="font-size:11pt;font-family:Arial;background-color:transparent;vertical-align:baseline;white-space:pre-wrap"><a href="https://twitter.com/freeswitch?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor" style="color:rgb(17,85,204)" target="_blank" moz-do-not-send="true"><img src="https://lh5.googleusercontent.com/_iuGyx4UVI8fg3j3y7xgK6SX7BeTVYO7CLvH29tkkdgRnugoB6Ry39J5IcLdAKinOWuYrprkLisaB8sxMNrHgXAaHBy-GC1510iJrNIwBP5bCM_LGbOisxBTgao6yWITZ4lgQZVD" alt="color-twitter-96.png" style="border:none" moz-do-not-send="true" width="23" height="23"></a></span></font></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a class="moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://confluence.freeswitch.org">http://confluence.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.cluecon.com">http://www.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="http://www.freeswitch.org">http://www.freeswitch.org</a></pre>
</blockquote>
<br>
</body>
</html>