kolab_cache_contact huge

[Stelios A.]

Unfortunately the problem remains. I've run fine the sql as suggested here
https://issues.kolab.org/show_bug.cgi?id=4850
but still tables are growing like mad.

Any help is much appreciated.

Stelios

On 25 March 2015 at 10:42, Stelios A. <stelios.a at gmail.com> wrote:

> Many thanks Tobias.
> I've run the script and will wait to see if they still grow.
>
> I received the following errors while run the sql but I assume they are
> not important?
>
> ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key
> constraint fails
> ERROR 1050 (42S01): Table 'kolab_folders' already exists
>
>
> Stelios
>
> On 25 March 2015 at 10:36, Tobias Brunner <tobias at tobru.ch> wrote:
>
>> Hi,
>>
>> On Wednesday 25 March 2015 10.29:27 Stelios A. wrote:
>> > I've truncate a while ago the kolab_cache_contact and kolab_cache_event
>> > table and today after a few weeks checked and its size is 48GB and 30GB
>> for
>> > the event table.
>> >
>> > This is a very low volume email server (getting about 150 emails per
>> day)
>> > and honestly have no idea why those tables are getting huge.
>> >
>> > Is it safe to just add a cron with a script to truncate them?
>>
>> Maybe have a look here: https://issues.kolab.org/show_bug.cgi?id=4850
>> There are some issues with not applied DB schema updates after upgrading
>> Kolab
>> to a newer version.
>>
>> Cheers,
>> Tobias
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kolab.org/pipermail/users/attachments/20150329/ad960e42/attachment.html>