Found nn messages in the processing-messages database

[Julian Field]

You can only accurately see if there any messages abandoned by letting
a) MailScanner stop nicely
or
b) wait until there are no messages outstanding in your queue and all 
batches of messages still being processed have been delivered.

Or else it will report the number of messages being processed by the sum 
of all the other MailScanner children, which may be quite a large number.

Also make sure you are running the latest stable release as earlier 
releases had a problem with the number not going down properly on 
Postfix systems.

On 05/05/2009 22:38, Juan Pablo Abuyeres wrote:
> I had this feature disabled. Now I re-enabled it to see what happens:
>
> I see messages like these:
>
> May  5 17:29:41 anubis MailScanner[30612]: Connected to 
> processing-messages database
> May  5 17:29:41 anubis MailScanner[30612]: Found 107 messages in the 
> processing-messages database
> May  5 17:29:41 anubis MailScanner[30612]: Using locktype = flock
> May  5 17:30:12 anubis MailScanner[30612]: New Batch: Found 141 
> messages waiting
> May  5 17:30:12 anubis MailScanner[30612]: New Batch: Scanning 3 
> messages, 828769 bytes
> ...
> May  5 17:30:34 anubis MailScanner[30612]: Requeue: 933CB39DEA6.A75E7 
> to 0ED7239CC08
> May  5 17:30:34 anubis MailScanner[30612]: Uninfected: Delivered 2 
> messages
> May  5 17:30:35 anubis MailScanner[30612]: Deleted 3 messages from 
> processing-database
> May  5 17:30:35 anubis MailScanner[30612]: Batch completed at 35483 
> bytes per second (828769 / 23)
> May  5 17:30:35 anubis MailScanner[30612]: Batch (3 messages) 
> processed in 23.36 seconds
>
> But the number of messages in the processing messages database is 
> increasing. Although sometimes it decreses. It's like it is deleting 
> some messages, but not all of them.
>
> May  5 17:29:00 anubis MailScanner[29799]: Found 112 messages in the 
> processing-messages database
> May  5 17:29:13 anubis MailScanner[30022]: Found 110 messages in the 
> processing-messages database
> May  5 17:29:16 anubis MailScanner[30139]: Found 106 messages in the 
> processing-messages database
> May  5 17:29:21 anubis MailScanner[30259]: Found 97 messages in the 
> processing-messages database
> May  5 17:29:41 anubis MailScanner[30612]: Found 107 messages in the 
> processing-messages database
> ...
> May  5 17:35:31 anubis MailScanner[7161]: Found 154 messages in the 
> processing-messages database
>
>
> JP
>
> Mark Sapiro wrote:
>> On Mon, May 04, 2009 at 05:03:44PM -0400, Juan Pablo Abuyeres wrote:
>>    
>>> now I have this:
>>> May  4 16:54:36 anubis MailScanner[1868]: Found 887 messages in the
>>> processing-messages database
>>> May  4 16:55:15 anubis MailScanner[3072]: Found 905 messages in the
>>> processing-messages database
>>> May  4 16:55:17 anubis MailScanner[3217]: Found 906 messages in the
>>> processing-messages database
>>>      
>>
>>
>>
>> When a child processes a batch, do you see log messages similar to
>>
>> May  5 09:51:42 sbh16 MailScanner[23758]: New Batch: Scanning 2 messages, 6276 bytes
>> May  5 09:51:46 sbh16 MailScanner[23758]: Uninfected: Delivered 2 messages
>> May  5 09:51:46 sbh16 MailScanner[23758]: Deleted 2 messages from processing-database
>>
>> I.e. does the child say it deleted the messages from the
>> processing-database, and if not are there other messages to indicate
>> why not?
>>
>>    

Jules

-- 
Julian Field MEng CITP CEng
www.MailScanner.info
Buy the MailScanner book at www.MailScanner.info/store

Need help customising MailScanner?
Contact me!
Need help fixing or optimising your systems?
Contact me!
Need help getting you started solving new requirements from your boss?
Contact me!

PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654
Follow me at twitter.com/JulesFM and twitter.com/MailScanner


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.