Hi Brian,

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:

*mod_callcenter: callcenter_api locked
https://freeswitch.org/jira/browse/FS-10638


*error message: fail to send query to pgsql:
https://freeswitch.org/jira/browse/FS-10474

*sofia stop response to requests:
https://freeswitch.org/jira/browse/FS-10676


I all i solve it by restart only postgresql, with forces FS to clean up all dbhandles open.

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.

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:

cliente <- [WSS] -> nginx <-[WS]-> fs

But of course i need to implement in nginx a "WSS helper"  to change all tls contact to non tls.


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.


Saludos / Regards / Cumprimentos,
António silva
On 01/09/2018 01:12 AM, Brian West wrote:
I do not believe that is what is going on.

https://freeswitch.org/jira/browse/FS-9371
https://freeswitch.org/jira/browse/FS-10721


Are you using freeswitch.Dbh from LUA? I think its probably closing the file out from under you and corrupting the db in the process.
Maybe these JIRAs will provide a way to replicate the issue on demand.
/b


On Sun, Jan 7, 2018 at 5:51 PM, Geoff Mina <gmina@connectfirst.com> wrote:
As a confirmation, the profile which corrupted was exclusively WSS connections.

> On Jan 7, 2018, at 4:24 PM, Jeremy Lainé <jeremy.laine@m4x.org> wrote:
>
> Hi all,
>
> 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.
>
> 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?
>
> As a workaround I am considering migrating to postgresql (core + sofia) but it's frustating not to understand the root cause of the problem.
>
> Cheers,
>
> Jeremy
>

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org



--

Brian West | General Operations Director

FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045

Email: brian@freeswitch.com

Mobile: 918-424-9378

Website: https://www.FreeSWITCH.com

color-facebook-96.pngcolor-twitter-96.png



_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org