Found x messages in the Processing Attempts Database
mark at msapiro.net
Thu Sep 26 21:11:44 UTC 2019
On 9/26/19 12:45 PM, PenguinWhispererThe . wrote:
> What's odd, although you mention this table is dynamic, I see the same
> entries being in the processing table for days now (even after
> restarting mailscanner again).
> sqlite> select * from processing;
> Since I first mailed to this mailing list there's still 29 messages in
> the processing database.
Those are all ancient. The three columns are respectively the MTA queue
ID, the number of tries and a timestamp. The timestamp is seconds since
the epoch and is the time that MailScanner will next retry the message.
As I said, they are ancient - the most recent one is Sat Sep 5 18:07:39
When messages are retried, the the number of tries is incremented, but
when it reaches the configured Maximum Processing Attempts (default 6)
the message won't be further retrieed.
> When I try to find files that correspond with the first column I find
> none (perhaps I'm searching for them in the wrong way). Not sure what
> the difference is between the ones starting with s and t. Is it possible
> some of these messages are still in the database but no longer exist and
> so never get removed from it?
As I said, the first column is an MTA queue id with the addition of the
s or t prefix (I don't know what that means), but these entries are all
so old, that the messages are probably no longer queued.
I suggest you just remove the Processing Attempts Database. As it says
> # This is the location of the database file used to track the number of
> # times any message has been attempted.
> # To clear out the database, just delete the file, MailScanner will re-
> # create it automatically when it starts.
> Processing Attempts Database = /var/spool/MailScanner/incoming/Processing.db
This will clear these old entries and then you can focus on any new ones.
Mark Sapiro <mark at msapiro.net> The highway is for gamblers,
San Francisco Bay Area, California better use your sense - B. Dylan
More information about the MailScanner