[RCU] Purging an sqlite database - RC 1.3.8

Sophie Loewenthal sophie at klunky.co.uk
Sun Nov 11 22:57:52 CET 2018


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 at klunky.co.uk> wrote:
> 
>> On 8 Nov 2018, at 19:55, Reindl Harald <h.reindl at thelounge.net> wrote:
>> 
>> 
>> 
>> Am 08.11.18 um 19:49 schrieb Sophie Loewenthal:
>>>> On 8 Nov 2018, at 19:47, Reindl Harald <h.reindl at 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 at lists.roundcube.net
> http://lists.roundcube.net/mailman/listinfo/users


More information about the users mailing list