Hi,

I recently noticed roughly 4000 entries in my phymessage table that have a 
messagesize of 0.  I also noticed that the internal_date field seems to be a 
bit screwed up.  If I recall correctly, all internal_dates are stored in 
(YYYY-MM-DD HH:MM:SS) format and not (YYYY-MM-DD HH:MM:SS.SSSSSS) as I'm 
seeing.  A lookup of the messageblks table using the id key do not produce any 
entries.  What are these entries and is there a way to clean them up with 
dbmail-maintenance?  I'm currently running dbmail 2.0rc3

David



  id   | messagesize | rfcsize |       internal_date
-------+-------------+---------+----------------------------
 12068 |           0 |       0 | 2004-08-26 03:55:40.662427
 19809 |           0 |       0 | 2004-09-04 12:01:49.990678
  8513 |           0 |       0 | 2004-02-25 02:05:23
  8554 |           0 |       0 | 2004-02-27 05:57:07
 20995 |           0 |       0 | 2004-09-07 03:05:10.260702
 12069 |           0 |       0 | 2004-08-26 05:02:20.686243
 15928 |           0 |       0 | 2004-09-02 04:42:05.465936
  8518 |           0 |       0 | 2004-02-25 08:59:11
 12070 |           0 |       0 | 2004-08-26 06:09:01.775816
 12113 |           0 |       0 | 2004-08-27 03:49:02.190768
 20022 |           0 |       0 | 2004-09-05 03:01:49.464194
 17039 |           0 |       0 | 2004-09-03 05:07:03.873583
 17102 |           0 |       0 | 2004-09-03 06:18:13.403755
....

Reply via email to