Re: HMM got lmtp dupicate entries HOW and WHY?

Peter Rabbitson wrote:

> What would be the query to find the ids of affected
messages? Should
> they be missing a dbmail_hedervalue with an id
corresponding to the
> dbmail_headername entry of return-path? I am not quite
sure how the
> subject gets lost...

Subjects don't get lost. DBmail never alters a message.
Caching tables are not
used for reconstructing messages. Caching tables are only
used for speeding up
IMAP access (FETCH, SEARCH and SORT). If your retrieve a
full message (or
message part) the messageblks table is queried, not the
cache tables.

You can safely remove all cache entries for physmessages
within a date range if
you like. Use the internal_date field on the physmessages
table to narrow the
range. Don't worry about cleaning out the cache for too many
messages.
dbmail-util -by will reconstruct the cache.

In fact it is quite safe (albeit very slow and resource
intensive) to drop and
re-create the cache tables, and run dbmail-util -by
afterwards. But that is
probably overkill in your case.

-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail