Yes they should. This is https://gitlab.com/mailman/mailman/-/issues/257 fixed in Mailman core 3.3.5. Also in Mailman 3.3.5 is a new Task runner that runs periodic tasks, one of which is to remove orphaned pendings. Hmm our running system right now already was on 3.3.5 since a few days after release. But maybe all of those were still from before. This may also be the issue for the OP in this thread if that pendedkeyvalue table is also large.
Here is a
mailman shell
script that will clean that up.# Prior to Mailman 3.3.5, some tokens for user confirmations were pended with # too long a lifetime. This script removes those pendings based on when they # were pended and the configured pending_request_life rather than their # expiration. With the script we went down to around 16k entries in pendedkeyvalue removed were the following: expunged 6932 orphaned pended held messages expunged 254 expired held messages expunged 21 expired (un)subscription confirmations
This shows that there were a lot of things in an unfinished state to my understanding in our system. For a time this system was running with less RAM than it should have had. So maybe some of the problems came from there.
@mark Thanks for the script. Now the people with 300 messages pending for their lists can throw them all finally away.
regards
Jacob