[MM3-users] Re: trying to clean up the "held messages" mess

On 5/28/21 12:37 AM, Bjoern Franke wrote:

Hi,

I migrated a Mailman3 installation on Debian10 yesterday evening from Debian packages to PIP (thanks to [1]).

I think some bugs which existed before are now cleaned out, but mailman still threw exceptions when trying to get the "held messages".

What exceptions? Note that there is a lot of cleanup in the as yet unreleased core 3.3.5. You might consider installing that. To do so, in your virtualenv as the Mailman user do

pip install --upgrade git+https://gitlab.com/mailman/mailman

The amount of held messages is now reduced, but e.g. a list with 120 held messages before has till 59 held messages. And now I'm confused: where are they?

The held message entries are in the _request table with request_type =

1. For those entries, key is the message-id and data_hash is the token in the pended table and the id in the pended table is the pended_id of the related entries in the pendedkeyvalue table.

The message itself is stored in the file system and is pointed to by the entry in the message table with the corresponding message-id.

The exceptions you see are because entries are missing from the pended, pendedkeyvalue and/or message tables.

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