[Freeswitch-users] Frequent sqlite database corruption

[Brian West]

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

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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180108/97e5a07b/attachment-0001.html>