Paul,
any statement to the "referencesfield" Problem?
thx
Harald
Am 29.03.2012, 10:34 Uhr, schrieb ITronic Harald Leithner
:
Hi,
So I truncating the cache was successful, but I got duplicate error
message while rebuilding:
---
Mar 29 08:37:31 mailstore dbmail-util[19249]: [0x1e7c040]
Hi,
today my imapd crashed with the following message:
Apr 2 12:10:26 mailstore kernel: [4393934.966925] dbmail-imapd[21452]:
segfault at 0 ip 7faead3468ea sp 7fae9b5b1c20 error 4 in
libdbmail.so.0.0.0[7faead329000+5c000]
I think with this informations no body can help me, so its j
this is not really a problem and is triggered
by the fact the we truncated only the header-tables
while the references table had already data
more a problem is that headervalues is growing and
growing over the time and after few months it
uses more index-space as the rest of the database
Am 02.04
imapd has currently memory leaks and is growing over
some hundret MB up to > 1 GB memory after few days
the crash is easy to solve by systemd-autorestart
last sunday it stopped accepting connections around
12AM and i happily was in front of my machine for
restart the daemon - in this state all mai
hmm... daily restarting is a good workaround for now.
thx
Harald
Am 02.04.2012, 12:32 Uhr, schrieb Reindl Harald :
imapd has currently memory leaks and is growing over
some hundret MB up to > 1 GB memory after few days
the crash is easy to solve by systemd-autorestart
last sunday it stopped a
On 04/02/2012 12:28 PM, Reindl Harald wrote:
> this is not really a problem and is triggered
> by the fact the we truncated only the header-tables
> while the references table had already data
>
Correct.
> more a problem is that headervalues is growing and
> growing over the time and after few m
Am 02.04.2012 12:45, schrieb Paul J Stevens:
> On 04/02/2012 12:28 PM, Reindl Harald wrote:
>> this is not really a problem and is triggered
>> by the fact the we truncated only the header-tables
>> while the references table had already data
>>
>
> Correct.
>
>> more a problem is that headerva
Am 02.04.2012 12:45, schrieb Paul J Stevens:
> On 04/02/2012 12:28 PM, Reindl Harald wrote:
>> this is not really a problem and is triggered
>> by the fact the we truncated only the header-tables
>> while the references table had already data
>>
>
> Correct.
>
>> more a problem is that headerva
With this query you will find all unconnected headervalues:
select * from dbmail_headervalue where id not in (select headervalue_id
from dbmail_header);
In my case there are 245,257 unused values while purging 4000 messages, so
I could do a cronjob with:
delete from dbmail_headervalue
cool - this seems to work perfectly
shouldn't it be a part of dbmail-util?
Am 02.04.2012 14:03, schrieb ITronic Harald Leithner:
>
> With this query you will find all unconnected headervalues:
>
> select * from dbmail_headervalue where id not in (select headervalue_id from
> dbmail_header);
>
On 04/02/2012 02:55 PM, Reindl Harald wrote:
>> delete from dbmail_headervalue where id not in (select headervalue_id from
>> dbmail_header);
correct me if I'm wrong but last I checked neither MySQL nor PostgreSQL
support deleting rows selected in a sub-query.
--
___
I only know it for MySQL, you can't delete rows from the same table (this
would only work with sub-sub query).
In this Query I take the values from another table.
So this would not work:
delete from dbmail_headervalue b where id in (select id from
dbmail_headervalue a where id=1);
but thi
On 04/02/2012 03:21 PM, ITronic Harald Leithner wrote:
> I only know it for MySQL, you can't delete rows from the same table
that's what I meant. Misread the query.
--
Paul J Stevenspjstevns @ gmail, twitter, skype, linkedin
On Monday, April 02, 2012 03:15:07 PM Paul J Stevens wrote:
> On 04/02/2012 02:55 PM, Reindl Harald wrote:
> >> delete from dbmail_headervalue where id not in (select
> >> headervalue_id from dbmail_header);
> correct me if I'm wrong but last I checked neither MySQL nor PostgreSQL
> support delet
14 matches
Mail list logo
