[Freeswitch-users] Frequent sqlite database corruption

[Geoff Mina]

Not using LUA or really anything special. Just proxying UDP to WSS. 


This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

> On Jan 8, 2018, at 6:49 PM, David Villasmil <david.villasmil.work at gmail.com> wrote:
> 
> +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 at gmail.com
> phone: +34669448337
> 
>> On Tue, Jan 9, 2018 at 1:12 AM, Brian West <brian at 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 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> 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
>>> 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
>> 
>> 
>> 
>> -- 
>> 
>> Brian West | General Operations Director
>> FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045
>> Email: brian at freeswitch.com
>> Mobile: 918-424-9378
>> Website: https://www.FreeSWITCH.com
>> 
>> 
>> _________________________________________________________________________
>> 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
> 
> _________________________________________________________________________
> 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/20180108/3653c4b0/attachment-0001.html>