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 [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
