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 <mailto: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 <mailto: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 <mailto:consulting@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@lists.freeswitch.org <mailto:FreeSWITCH-users@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@freeswitch.com <mailto:brian@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@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