[Freeswitch-users] Frequent sqlite database corruption

[Antonio Silva]

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 at connectfirst.com 
> <mailto:gmina at 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 at m4x.org
>     <mailto:jeremy.laine at 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 at freeswitch.org <mailto:consulting at freeswitch.org>
>     http://www.freeswitchsolutions.com
>     <http://www.freeswitchsolutions.com>
>
>     Official FreeSWITCH Sites
>     http://www.freeswitch.org
>     http://confluence.freeswitch.org <http://confluence.freeswitch.org>
>     http://www.cluecon.com
>
>     FreeSWITCH-users mailing list
>     FreeSWITCH-users at lists.freeswitch.org
>     <mailto:FreeSWITCH-users at lists.freeswitch.org>
>     http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>     <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>     UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>     <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 
> <https://maps.google.com/?q=17345+Civic+Drive+%232531+Brookfield,+WI+53045&entry=gmail&source=g>
>
> Email: brian at freeswitch.com <mailto:brian at freeswitch.com>
>
> Mobile: 918-424-9378
>
> Website: https://www.FreeSWITCH.com <https://www.freeswitch.com/>
>
> color-facebook-96.png 
> <https://www.facebook.com/freeswitch/>color-twitter-96.png 
> <https://twitter.com/freeswitch?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor>
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180109/48079091/attachment-0001.html>