Found nn messages in the processing-messages database

[Mark Sapiro]

On Fri, Apr 17, 2009 at 10:02:47AM +0100, Julian Field wrote:
> If "MailScanner --processing=1" produces no output, then the records in 
> the database cannot have a count of 1 (the 2nd number in each column in 
> your table of 26 database entries below). So when you do that, the only 
> records in there must have a value of 0, which means they should have 
> been removed.


[root at sbh16 ~]# MailScanner --processing=0
Currently being processed:

Number of messages: 31
Tries   Message Next Try At
=====   ======= ===========
1       84250690369.89777       Fri Apr 17 05:30:14 2009
1       95234690415.83417       Fri Apr 17 05:29:50 2009
1       53010690431.69741       Fri Apr 17 05:26:55 2009
1       38479690188.83466       Fri Apr 17 05:26:53 2009
1       89182690409.01989       Fri Apr 17 02:40:20 2009
1       34979690423.56858       Thu Apr 16 11:35:07 2009
1       97480690403.80930       Thu Apr 16 11:35:03 2009
1       23751690385.34301       Wed Apr 15 09:29:42 2009
1       42214690429.67487       Tue Apr 14 19:08:09 2009
1       87926690445.21751       Tue Apr 14 15:20:46 2009
1       00894690425.97190       Tue Apr 14 15:19:18 2009
1       35592690431.581E1       Tue Apr 14 15:18:53 2009
1       06950690412.30E45       Tue Apr 14 14:36:36 2009
1       06766690387.55E20       Tue Apr 14 14:35:29 2009
1       00524690436.5E971       Tue Apr 14 10:25:39 2009
1       77828690380.26107       Tue Apr 14 08:06:28 2009
1       95835690388.E2978       Tue Apr 14 08:06:07 2009
1       41693690392.32976       Tue Apr 14 03:35:47 2009
1       49903690394.76309       Tue Apr 14 03:34:40 2009
1       39387690388.E1611       Mon Apr 13 22:27:01 2009
1       88257690407.10923       Mon Apr 13 20:56:21 2009
1       99351690429.04632       Mon Apr 13 20:05:43 2009
1       49358690409.95149       Mon Apr 13 18:10:19 2009
1       39224690405.41276       Mon Apr 13 18:09:14 2009
1       17300690390.3E804       Mon Apr 13 18:09:04 2009
1       57067690409.E4302       Mon Apr 13 11:52:02 2009
1       16020690433.44254       Mon Apr 13 11:49:22 2009
1       02842690389.04452       Mon Apr 13 11:48:42 2009
1       41537690424.26867       Mon Apr 13 11:30:20 2009
1       67650690405.93175       Mon Apr 13 09:55:43 2009
1       92295690444.31465       Mon Apr 13 09:53:55 2009
[root at sbh16 ~]#


> However, when a child starts up, there will be all the messages in the 
> "processing" database table that are currently being processed by other 
> MailScanner children. Are you sure there are no other children running 
> when that child starts? Also, please look at the output of "MailScanner 
> --processing=0" as this will show you all the records in there, which 
> the timestamps converted into something readable, rather than the raw 
> time_t values you have included. That will let us see if they are in the 
> future or way in the past.


There are no other children running. I run with Max Children = 1 in part
because of an occasional message duplication issue that I would see with
multiple children.

In the case of the most recent 4 messages in the above list, the messages
were processed around 05:24 by a child that started at 04:29 and died of
old age at 06:31. There were no other children running and this child
logged that it deleted from the database all the messages that it processed.

 
> I cannot find any situation where the records would fail to be deleted, 
> if it says it has deleted them. The only way that can happen is if the 
> message id was blank, and all the records in your "processing" database 
> table you included below all have non-blank message ids, so it isn't that.
> 
> The code for clearing out the database table is pretty straightforward, 
> please take a look at it yourself and see if you agree with me. It 
> starts at "sub ClearOutProcessedDatabase {" in 
> /usr/lib/MailScanner/MailScanner/MessageBatch.pm. If you can see any 
> bugs or holes in there, please do tell me!


I'll take a look.


-- 
Mark Sapiro mark at msapiro net       The highway is for gamblers,
San Francisco Bay Area, California    better use your sense - B. Dylan