On 8 Nov 2018, at 19:55, Reindl Harald h.reindl@thelounge.net wrote:
Am 08.11.18 um 19:49 schrieb Sophie Loewenthal:
On 8 Nov 2018, at 19:47, Reindl Harald h.reindl@thelounge.net wrote:
Am 08.11.18 um 19:44 schrieb Sophie Loewenthal:
I tried the gc.sh after stopping nginx & backed up the file:
# bin/gc.sh ERROR: [13] database or disk is full (SQL Query: DELETE FROM session WHERE changed < datetime('now','-1200 seconds'))
The disc has 8Mb free
you simply can't optimize a 20 MB database file when there are only 8 MB free - who in the world has 8 MB free in 2018?
Who in the world has a 20Mb sqlite db for RC? I do. You should have guessed :-)
I run a lean machine.
and?
my smartphone has 140 GB free space the 20 MB sqlite file are not big but 8 MB free is a bad joke
Not a problem:
lvresize -L 50M /dev/vg00/sqlite resize2fs !$
run the optimise
resize2fs /dev/vg00/sqlite 30M lvresize -L 32M /dev/vg00/sqlite resize2fs !$
add some e2fsck’s in there too.
Not an issue, but I’ll do this during the day because it’s late.
Dear Reind,
Update: Solution was to optimise the dB: find -type f -name roundcube.sq -exec sqlite3 {} 'VACUUM;' ;
Size dropped from 21Mb down to 280kB.
Thanks.
On 8 Nov 2018, at 19:59, Sophie Loewenthal sophie@klunky.co.uk wrote:
On 8 Nov 2018, at 19:55, Reindl Harald h.reindl@thelounge.net wrote:
Am 08.11.18 um 19:49 schrieb Sophie Loewenthal:
On 8 Nov 2018, at 19:47, Reindl Harald h.reindl@thelounge.net wrote:
Am 08.11.18 um 19:44 schrieb Sophie Loewenthal:
I tried the gc.sh after stopping nginx & backed up the file:
# bin/gc.sh ERROR: [13] database or disk is full (SQL Query: DELETE FROM session WHERE changed < datetime('now','-1200 seconds'))
The disc has 8Mb free
you simply can't optimize a 20 MB database file when there are only 8 MB free - who in the world has 8 MB free in 2018?
Who in the world has a 20Mb sqlite db for RC? I do. You should have guessed :-)
I run a lean machine.
and?
my smartphone has 140 GB free space the 20 MB sqlite file are not big but 8 MB free is a bad joke
Not a problem:
lvresize -L 50M /dev/vg00/sqlite resize2fs !$
run the optimise
resize2fs /dev/vg00/sqlite 30M lvresize -L 32M /dev/vg00/sqlite resize2fs !$
add some e2fsck’s in there too.
Not an issue, but I’ll do this during the day because it’s late. _______________________________________________ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
On Sun, 11 Nov 2018, Sophie Loewenthal wrote:
Update: Solution was to optimise the dB: find -type f -name roundcube.sq -exec sqlite3 {} 'VACUUM;' ;
Size dropped from 21Mb down to 280kB.
Nice!
I just tried that and went from 3MB to ~800kb. Not that dramatic, but nice to know :)
Cheers, Bernardo.