problems

Today I noticed somehow my imap messed things up with older
messages.  
The content of one message got mixed up into a totally
different one.
After moving the message, content was again the right one.

Later today, a customer complained, message send to colleges
got  
mixed up, having one receiving the message of the other,
while his  
outbox states it right.

Furthermore doing an dbmail-util -by constantly gives:

Repairing DBMAIL for cached header values...
Ok. Found [24] un-cached physmessages.
........................

  dbmail-util -V
This is DBMail version 2.2.5-rc3-svn


Are these problems related?
Are these problems known with 2.2.5?

Marc


_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

I had this sinton some time ago in one message to.
But it was just one and i had no way to trace it

----- Original Message ----- 
From: "Marc Dirix" <marcelectronics-design.nl>
To: "DBMail mailinglist" <dbmaildbmail.org>
Sent: Tuesday, July 24, 2007 8:26 AM
Subject: [Dbmail] problems


> Today I noticed somehow my imap messed things up with
older messages.  
> The content of one message got mixed up into a totally
different one.
> After moving the message, content was again the right
one.
> 
> Later today, a customer complained, message send to
colleges got  
> mixed up, having one receiving the message of the
other, while his  
> outbox states it right.
> 
> Furthermore doing an dbmail-util -by constantly gives:
> 
> Repairing DBMAIL for cached header values...
> Ok. Found [24] un-cached physmessages.
> ........................
> 
>  dbmail-util -V
> This is DBMail version 2.2.5-rc3-svn
> 
> 
> Are these problems related?
> Are these problems known with 2.2.5?
> 
> Marc
> 
> 
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

I had the same problem a few times with dbmail 2.0 and
thunderbird.
Restarting thunderbird solved the problem.

On Tue, 24 Jul 2007, Marc Dirix wrote:

> Today I noticed somehow my imap messed things up with
older messages. The 
> content of one message got mixed up into a totally
different one.
> After moving the message, content was again the right
one.
>
> Later today, a customer complained, message send to
colleges got mixed up, 
> having one receiving the message of the other, while
his outbox states it 
> right.
>
> Furthermore doing an dbmail-util -by constantly gives:
>
> Repairing DBMAIL for cached header values...
> Ok. Found [24] un-cached physmessages.
> ........................
>
> dbmail-util -V
> This is DBMail version 2.2.5-rc3-svn
>
>
> Are these problems related?
> Are these problems known with 2.2.5?
>
> Marc
>
>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

The imap thing is not my real concern, however customers
receiving  
(by pop) messages of different accounts is.

I'm hoping this is a one-time occurence.

What can I do about the cache?

Marc

Op 24-jul-2007, om 20:15 heeft Martin Furter het volgende
geschreven:

>
> I had the same problem a few times with dbmail 2.0 and
thunderbird.
> Restarting thunderbird solved the problem.
>
> On Tue, 24 Jul 2007, Marc Dirix wrote:
>
>> Today I noticed somehow my imap messed things up
with older  
>> messages. The content of one message got mixed up
into a totally  
>> different one.
>> After moving the message, content was again the
right one.
>>
>> Later today, a customer complained, message send to
colleges got  
>> mixed up, having one receiving the message of the
other, while his  
>> outbox states it right.
>>
>> Furthermore doing an dbmail-util -by constantly
gives:
>>
>> Repairing DBMAIL for cached header values...
>> Ok. Found [24] un-cached physmessages.
>> ........................
>>
>> dbmail-util -V
>> This is DBMail version 2.2.5-rc3-svn
>>
>>
>> Are these problems related?
>> Are these problems known with 2.2.5?
>>
>> Marc
>>
>>
>> _______________________________________________
>> DBmail mailing list
>> DBmaildbmail.org
>> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
>>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Thank you Josh for your answer.

I get:
dbmail=> select * from dbmail_physmessage WHERE id NOT IN
(SELECT  
physmessage_id FROM dbmail_messages);
  id | messagesize | rfcsize | internal_date
----+-------------+---------+---------------
(0 rows)


So deleting wouldn't do anything right?

I'm upgrading to 2.2.6. Howecome the debian package number
did not  
change? After building svn I get: dbmail_2.2.5-1.deb.

Marc


Op 25-jul-2007, om 0:19 heeft Josh Marshall het volgende
geschreven:

> Hi Marc,
>
> I had the same problem also with 2.2.5, until I ran the
following  
> SQL code:
>
> DELETE FROM dbmail_physmessage WHERE id NOT IN (SELECT 

> physmessage_id FROM dbmail_messages);
>
> Regards,
> Josh.
>
> Marc Dirix wrote:
>> Repairing DBMAIL for cached header values...
>> Ok. Found [24] un-cached physmessages.
>> ........................
>
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

>

This concerns a smaller imap server, not the 10K produktion
one:

>
> SELECT count(id) FROM dbmail_physmessage WHERE id NOT
IN (SELECT  
> physmessage_id FROM dbmail_messages);
> result: 233753 records
>

  count
-------
      0


> SELECT count(id) FROM dbmail_physmessage
> result: 302735 records
>

  count
-------
  18076

> SELECT count(message_idnr) FROM dbmail_messages
> result: 75369 records
>

  count
-------
  18120

With 2.2.6 I still get doing dbmail-util -ay everytime:

Repairing DBMAIL for cached header values...
Ok. Found [24] un-cached physmessages.
........................




_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

On Mittwoch, 25. Juli 2007 Anne wrote:
> SELECT count(id) FROM dbmail_physmessage WHERE id NOT
IN (SELECT
> physmessage_id FROM dbmail_messages);
> result: 233753 records

In dbmail-2.2.6 or so, dbmail-util was extended, so a call
to
dbmail-util -uy
should drop these, as I understood.

However, I tried it now:
# dbmail-util -u
Choosing dry-run mode. No changes will be made at this
time.

Checking DBMAIL for NULL messages...
Ok. Found [0] NULL messages.

Checking DBMAIL for NULL physmessages...
Ok. Found [0] physmessages without messageblocks.

but there are some messages:
select count(*) from dbmail_physmessage WHERE id NOT IN
(SELECT 
physmessage_id FROM dbmail_messages);
 count
-------
 31349
(1 Zeile)

And very strange is, that I created a rule which should
prevent this:

CREATE RULE drop_messages_with_mailbox AS ON DELETE TO
dbmail_messages 
DO DELETE FROM dbmail_physmessage WHERE id =
OLD.physmessage_id AND id 
NOT IN (SELECT physmessage_id from dbmail_messages);

The rule is active, still I see again 31.349 physmessages
hanging 
around. What could be the problem?

mfg zmi
-- 
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                     
.network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg
--import"
// Fingerprint: EA39 8918 EDFF 0A68 ACFB  11B7 BA2D 060F
1C6F E6B0
// Keyserver: www.keyserver.net                   Key-ID:
1C6FE6B0

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

I've been looking to all there emails, but my question is:

When i delete an user, run dbmail-util -ay, after this i
still have remain 
record in this table/tables?



----- Original Message ----- 
From: "Aleksander Kamenik" <aleksanderkrediidiinfo.ee>
To: "DBMail mailinglist" <dbmaildbmail.org>
Sent: Wednesday, July 25, 2007 10:49 AM
Subject: Re: [Dbmail] problems


> Anne wrote:
>
>> Looks like we can clean up a lot records!
>> It would be nice to see some other people's stats.
>>
>
> As I understood these are the messages of deleted
users. Looking at your 
> stats most of your accounts have been deleted. I had
iirc 70k/270k.
>
>
>
> -- 
> Aleksander Kamenik
> system administrator
> +372 6659 649
> aleksanderkrediidiinfo.ee
>
> Krediidiinfo AS
> http://www.krediidiinfo.e
e/
> _______________________________________________
> DBmail mailing list
> DBmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> 

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Jorge Bastos wrote:
> I've been looking to all there emails, but my question
is:
> 
> When i delete an user, run dbmail-util -ay, after this
i still have 
> remain record in this table/tables?
>

Yes, that is the problem. This will be fixed by the time
2.2.6 comes out 
AFAIK.

-- 
Aleksander Kamenik
system administrator
+372 6659 649
aleksanderkrediidiinfo.ee

Krediidiinfo AS
http://www.krediidiinfo.e
e/
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

On Mittwoch, 25. Juli 2007 Michael Monnerie wrote:
> In dbmail-2.2.6 or so

The rc1 I meant of course.

# dbmail-util -V
This is DBMail version 2.2.6-rc1

mfg zmi
-- 
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                     
.network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg
--import"
// Fingerprint: EA39 8918 EDFF 0A68 ACFB  11B7 BA2D 060F
1C6F E6B0
// Keyserver: www.keyserver.net                   Key-ID:
1C6FE6B0

_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail