I have just opened a bug for this:
https://bugs.launchpad.net/ubuntu/+source/fail2ban/+bug/1706085 mark it as
"This bug affects you" to gain visibility.
On Mon, Jul 24, 2017 at 2:41 PM, Jonathan Kamens <j...@kamens.us> wrote:
> You should be able to make this change in Ubuntu 16.04 by applying this
> patch to /usr/lib/python3/dist-packages/fail2ban/server/database.py and
> then restarting fail2ban:
>
> --- database.py.orig 2017-07-24 16:38:31.910178301 -0400
> +++ database.py 2017-07-24 16:40:04.754185435 -0400
> @@ -183,6 +183,8 @@
>
> cur = self._db.cursor()
> cur.execute("PRAGMA foreign_keys = ON;")
> + cur.execute("PRAGMA synchronous = OFF")
> + cur.execute("PRAGMA temp_store = MEMORY")
>
> try:
> cur.execute("SELECT version FROM fail2banDb LIMIT 1")
>
> Note that I have not tested this; I can't, since I'm on Ubuntu 17.10. I
> came up with this patch by comparing what's in database.py in Ubuntu 16.04
> with what's in 17.10.
>
> Or you could just upgrade Ubuntu. ;-)
>
> jik
> On 07/24/2017 01:56 AM, Dominic Raferd wrote:
>
>
>
> On 18 July 2017 at 16:00, Patrick Shanahan <p...@opensuse.org> wrote:
>
>> * Robert Kudyba <rkud...@fordham.edu> [07-18-17 09:46]:
>> >
>> > > On Jul 17, 2017, at 11:13 AM, Patrick Shanahan <p...@opensuse.org>
>> wrote:
>> > >
>> > > * Robert Kudyba <rkud...@fordham.edu <mailto:rkud...@fordham.edu>>
>> [07-17-17 10:36]:
>> > >>> On Sun, Jul 16, 2017 at 9:37 AM, Jafa <j...@silicondust.com> wrote:
>> > >>>
>> > >>>> I noticed the SSD lifespan numbers dropping rapidly on some
>> servers -
>> > >>>> losing a percent every 1-2 days. The wear leveling count was
>> incrementing
>> > >>>> about once an hour.
>> > >>>> Figure 125 days for a new SSD to reach 0% lifespan remaining.
>> > >>>>
>> > >>>> fail2ban was using a sqlite DB... 130k in size.
>> > >>>> Changing the configuration to :memory: fixed the problem - writes
>> all but
>> > >>>> disappeared.
>> > >>>>
>> > >>>> Looking at sqlite...
>> > >>>> 1) The sqlite DB is causing high disk writes - ~600kB/s to disk
>> with a
>> > >>>> 130k DB file.
>> > >>>> 2) The sqlite DB appears to be writing very small chunks of data
>> resulting
>> > >>>> in a high write amplification factor.
>> > >>>> 3) The sqlite DB appears to be forcing a sync to disk at a high
>> rate.
>> > >>>> Rewriting part or all of a 130k file should be cached and result
>> in very
>> > >>>> little write load.
>> > >>>>
>> > >>>> I suspect configuring sqlite not to force a sync to disk, or to
>> force the
>> > >>>> sync at a slower rate, say once every 5 seconds, would solve the
>> problem.
>> > >>>>
>> > >>>
>> > >>> Answering my own question - it looks like this problem was fixed in
>> > >>> fail2ban 0.10 which sets "PRAGMA synchronous=OFF”.
>> > >>
>> > >> So there’s no way to do this in the 0.95 version?
>> > >
>> > > you must pay attention to the key word:
>> > >
>> > > it looks like this problem was fixed in
>> > > ^^^^^
>> > > fail2ban 0.10 which sets "PRAGMA synchronous=OFF”
>> > >
>> > > wouldn't *that* lead you to believe that there is indeed no way to do
>> it
>> > > in the 0.95 version?
>> >
>> > I figured I would ask as there is still some development being done on
>> 0.95.
>>
>> what would that be aside from distros doing backports?
>>
>> from https://www.fail2ban.org/wiki/index.php/Downloads
>> 0.9.x line is no longer heavily developed. If you are interested in
>> new features (e.g. IPv6 support), please consider 0.10 branch and its
>> releases.
>>
>> > But why is 0.10 still called alpha?
>>
>> it has not been released.
>>
>> version I have is 0.97 which also sets "PRAGMA synchronous = OFF"
>> so it must have been fixed earlier than that or openSUSE has backported
>> the fix.
>>
>> ps: google is you friend and will answer most of your questions
>> immediately.
>>
>
> fail2ban 0.9.3 is the latest version supported in Ubuntu 16.04 and it
> does not seem to have this setting. Does anyone have a way to install an
> updated version (especially 0.10+) successfully with Ubuntu 16.04? I tried
> and failed earlier so I am still running 0.9.3, which it does seem is
> causing more activity than anything else on my SSD.
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
>
> _______________________________________________
> Fail2ban-users mailing
> listFail2ban-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/fail2ban-users
>
>
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Fail2ban-users mailing list
> Fail2ban-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/fail2ban-users
>
>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Fail2ban-users mailing list
Fail2ban-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/fail2ban-users
