+1 I have experienced sqlite corruption on physical servers, but it was very seldom... but on EC2s it happens rather frequently. I'm not using freeswitch.Dbh from lua anywhere... ᐧ Regards, David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337 On Tue, Jan 9, 2018 at 1:12 AM, Brian West <brian@freeswitch.com> 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 <https://maps.google.com/?q=17345+Civic+Drive+%232531+Brookfield,+WI+53045&entry=gmail&source=g>
Email: brian@freeswitch.com
Mobile: 918-424-9378 <(918)%20424-9378>
Website: https://www.FreeSWITCH.com <https://www.freeswitch.com/>
[image: color-facebook-96.png] <https://www.facebook.com/freeswitch/>[image: 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