systemctl stop fail2ban
cd /var/lib/fail2ban
TMPDIR=/scratch/tmp/ sqlite3 $PWD/fail2ban.sqlite3
SELECT COUNT(*) FROM bans WHERE timeofban < STRFTIME('%s','2022-03-01');
DELETE FROM bans WHERE timeofban < STRFTIME('%s','2022-03-01') LIMIT 10000;
DELETE FROM bans WHERE timeofban < STRFTIME('%s','2022-03-01') LIMIT 10000;
DELETE FROM bans WHERE timeofban < STRFTIME('%s','2022-03-01') LIMIT 35000;
DELETE FROM bans WHERE timeofban < STRFTIME('%s','2022-03-01') ;
ls -lah fail2ban.sqlite3
TMPDIR=/scratch/tmp/ sqlite3 $PWD/fail2ban.sqlite3 "VACUUM ;" && systemctl start fail2ban
ls -lah fail2ban.sqlite3