[Freeswitch-users] Frequent sqlite database corruption

[David Villasmil]

+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
> <https://maps.google.com/?q=17345+Civic+Drive+%232531+Brookfield,+WI+53045&entry=gmail&source=g>
>
> Email: brian at 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 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/5fb0c429/attachment.html>