Hi,
I noticed a roundcube sqlite dB slowly growing after each login.
in this example the user just logged, ran a search for an email address on Sent folder and logged out. Yet there was an increase in size:
Before login -rw-r----- 1 www www 21295104 Nov 7 21:47 roundcube.db After login -rw-r----- 1 www www 21303296 Nov 7 21:57 roundcube.db
What sort of information could be being added to the dB? And how could I purge this data, or otherwise reduce the sqlite dB? Perhaps though some regular cleaning?
Roundcube 1.3.8 and sqlite 3.16.2.
Best, Sophie
On 11/7/18 11:04 PM, Sophie Loewenthal wrote:
Hi,
I noticed a roundcube sqlite dB slowly growing after each login.
What sort of information could be being added to the dB? And how could I purge this data, or otherwise reduce the sqlite dB? Perhaps though some regular cleaning?
Maybe just session data. It should clean automatically, but depends on php configuration. Try bin/gc.sh.
Hi,
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.
Sophie
On 8 Nov 2018, at 07:36, A.L.E.C alec@alec.pl wrote:
On 11/7/18 11:04 PM, Sophie Loewenthal wrote:
Hi,
I noticed a roundcube sqlite dB slowly growing after each login.
What sort of information could be being added to the dB? And how could I purge this data, or otherwise reduce the sqlite dB? Perhaps though some regular cleaning?
Maybe just session data. It should clean automatically, but depends on php configuration. Try bin/gc.sh.
-- Aleksander 'A.L.E.C' Machniak Kolab Groupware Developer [http://kolab.org] Roundcube Webmail Developer [http://roundcube.net]
PGP: 19359DC1 # Blog: https://kolabian.wordpress.com _______________________________________________ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
-
A.L.E.C -
Sophie Loewenthal