We run on EC2 and do not have this problem. We did have the problem in the past now and then. But I think that was with an older version of FS. But we are only using FS with Verto. Ideally, we would be using postgresql, but we have not got there yet.

Robert

From: FreeSWITCH-users [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of David Villasmil
Sent: Monday, January 8, 2018 8:50 PM
To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org>
Subject: Re: [Freeswitch-users] Frequent sqlite database corruption

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

Email: brian@freeswitch.com

Mobile: 918-424-9378

Website: https://www.FreeSWITCH.com

_________________________________________________________________________
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

This e-mail and any files transmitted with it may contain privileged or confidential information. It is solely for use by the individual for whom it is intended, even if addressed incorrectly. If you received this e-mail in error, please notify the sender; do not disclose, copy, distribute, or take any action in reliance on the contents of this information; and delete it from your system. Any other use of this e-mail is prohibited.