[Freeswitch-users] Frequent sqlite database corruption

Mon Jan 15 12:18:49 UTC 2018

The only scenario where i have this problem is when using WSS.

On 01/09/2018 03:37 PM, Mundkowsky, Robert wrote:
>
> 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 at lists.freeswitch.org] *On Behalf Of 
> *David Villasmil
> *Sent:* Monday, January 8, 2018 8:50 PM
> *To:* FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
> *Subject:* Re: [Freeswitch-users] Frequent sqlite database corruption
>
> +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 
> <mailto:david.villasmil.work at gmail.com>
>
> phone: +34669448337
>
> On Tue, Jan 9, 2018 at 1:12 AM, Brian West <brian at freeswitch.com 
> <mailto:brian at freeswitch.com>> wrote:
>
>     I do not believe that is what is going on.
>
>     https://freeswitch.org/jira/browse/FS-9371
>     <https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Ffreeswitch.org%2Fjira%2Fbrowse%2FFS-9371&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=KlDgUzhj5w9WW%2FmOlUI3ipwfRotnr6dKJHwTxxkw%2Fig%3D&reserved=0>
>
>     https://freeswitch.org/jira/browse/FS-10721
>     <https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Ffreeswitch.org%2Fjira%2Fbrowse%2FFS-10721&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=ymepJHptZZduq%2FhCF98BGenK5jQB5%2BMb8w1Gk2J4PX8%3D&reserved=0>
>
>     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
>     <mailto: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 <mailto: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 <mailto:consulting at freeswitch.org>
>         http://www.freeswitchsolutions.com
>         <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freeswitchsolutions.com&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=xoLWALmaKeynInjiyXI6v6NhaRDZrtdwgmeizshtUnA%3D&reserved=0>
>
>         Official FreeSWITCH Sites
>         http://www.freeswitch.org
>         <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freeswitch.org&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=yhpc8x9Uft03onJRGvYx5PF8TSUMypMsUXhvPylVqQw%3D&reserved=0>
>         http://confluence.freeswitch.org
>         <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fconfluence.freeswitch.org&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=hR3mLNDpJ%2Bf5%2BTwTRltofWjUAf6eDPtdh7Rq%2BgCEX2I%3D&reserved=0>
>         http://www.cluecon.com
>         <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.cluecon.com&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=tLf4PeEQRBPcBWhtpn62j7D%2FuaeLH%2FwiByELM1V%2FvUg%3D&reserved=0>
>
>         FreeSWITCH-users mailing list
>         FreeSWITCH-users at lists.freeswitch.org
>         <mailto:FreeSWITCH-users at lists.freeswitch.org>
>         http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>         <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.freeswitch.org%2Fmailman%2Flistinfo%2Ffreeswitch-users&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=xIqSe7q%2BUOpxONbFIxJDWHxSpaNs%2Fz0n8aEX%2BkTWKK4%3D&reserved=0>
>         UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>         <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.freeswitch.org%2Fmailman%2Foptions%2Ffreeswitch-users&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=LQgJpY%2FGt43O%2FIuSBrAA31i4s6IHn2OE4K9Bse136C8%3D&reserved=0>
>         http://www.freeswitch.org
>         <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freeswitch.org&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=yhpc8x9Uft03onJRGvYx5PF8TSUMypMsUXhvPylVqQw%3D&reserved=0>
>
>
>
>     -- 
>
>     Brian West | General Operations Director
>
>     FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI
>     53045
>     <https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmaps.google.com%2F%3Fq%3D17345%2BCivic%2BDrive%2B%25232531%2BBrookfield%2C%2BWI%2B53045%26entry%3Dgmail%26source%3Dg&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=xaILh9iibnJefh0jT2zji8HImz2YNO7L75NOGaAa2LQ%3D&reserved=0>
>
>     Email: brian at freeswitch.com <mailto:brian at freeswitch.com>
>
>     Mobile: 918-424-9378 <tel:%28918%29%20424-9378>
>
>     Website: https://www.FreeSWITCH.com
>     <https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.freeswitch.com%2F&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=Hyzwpj0gMbeqokbh7PHrG4PNnJiCLntw4vL81lTaP4s%3D&reserved=0>
>
>     color-facebook-96.png
>     <https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2Ffreeswitch%2F&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=sq9ooktk3ZS34ulN%2B5RTgBw%2FVJINM6u1xJnri0htiyw%3D&reserved=0>color-twitter-96.png
>     <https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2Ffreeswitch%3Fref_src%3Dtwsrc%255Egoogle%257Ctwcamp%255Eserp%257Ctwgr%255Eauthor&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=rBnKff6g%2FA5yWxy%2FyO4w8nQgyhuLsBftFTPEga0hKFU%3D&reserved=0>
>
>
>     _________________________________________________________________________
>     Professional FreeSWITCH Consulting Services:
>     consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>     http://www.freeswitchsolutions.com
>     <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freeswitchsolutions.com&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=xoLWALmaKeynInjiyXI6v6NhaRDZrtdwgmeizshtUnA%3D&reserved=0>
>
>     Official FreeSWITCH Sites
>     http://www.freeswitch.org
>     <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freeswitch.org&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=yhpc8x9Uft03onJRGvYx5PF8TSUMypMsUXhvPylVqQw%3D&reserved=0>
>     http://confluence.freeswitch.org
>     <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fconfluence.freeswitch.org&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=hR3mLNDpJ%2Bf5%2BTwTRltofWjUAf6eDPtdh7Rq%2BgCEX2I%3D&reserved=0>
>     http://www.cluecon.com
>     <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.cluecon.com&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=tLf4PeEQRBPcBWhtpn62j7D%2FuaeLH%2FwiByELM1V%2FvUg%3D&reserved=0>
>
>     FreeSWITCH-users mailing list
>     FreeSWITCH-users at lists.freeswitch.org
>     <mailto:FreeSWITCH-users at lists.freeswitch.org>
>     http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>     <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.freeswitch.org%2Fmailman%2Flistinfo%2Ffreeswitch-users&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=xIqSe7q%2BUOpxONbFIxJDWHxSpaNs%2Fz0n8aEX%2BkTWKK4%3D&reserved=0>
>     UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>     <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.freeswitch.org%2Fmailman%2Foptions%2Ffreeswitch-users&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=LQgJpY%2FGt43O%2FIuSBrAA31i4s6IHn2OE4K9Bse136C8%3D&reserved=0>
>     http://www.freeswitch.org
>     <https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freeswitch.org&data=02%7C01%7Crmundkowsky%40ets.org%7Ce8751ef78ab94a2b8fba08d55703b119%7C0ba6e9b760b34fae92f37e6ddd9e9b65%7C0%7C0%7C636510595763566288&sdata=yhpc8x9Uft03onJRGvYx5PF8TSUMypMsUXhvPylVqQw%3D&reserved=0>
>
>
> ------------------------------------------------------------------------
>
> 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.
>
>
> Thank you for your compliance.
>
> ------------------------------------------------------------------------
>
>
> _________________________________________________________________________
> 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

-- 
Saludos / Regards / Cumprimentos
António Silva

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180115/b0589507/attachment-0001.html>