[RCU] Purging an sqlite database - RC 1.3.8

Sophie Loewenthal sophie at klunky.co.uk
Thu Nov 8 19:59:37 CET 2018


> 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.


More information about the users mailing list