Just adding to this. I’ve found the outstanding holds in the pending DB:
(venv) [mailman@mailman ~]$ mailman shell -l somelist.lists.example.com<http://somelist.lists.example.com> Welcome to the GNU Mailman shell Use commit() to commit changes. Use abort() to discard changes since the last commit. Exit with ctrl+D does an implicit commit() but exit() does not. The variable 'm' is the somelist.lists.example.com<http://somelist.lists.example.com> mailing list
from zope.component import getUtility from mailman.interfaces.pending import IPendings pendingsdb = getUtility(IPendings) for token, data in pendingsdb.find(m): ... print(token, data) ... aabef620b654354311d3ad4a229df394560d5c66 {'type': 'unsubscription', 'list_id': 'somelist.lists.example.com<http://somelist.lists.example.com>', 'email': 'john.smith@maildomain.com<mailto:john.smith@maildomain.com>', 'display_name': '', 'when': '2021-05-04T00:03:01', 'token_owner': 'moderator'} 916265d88c14a02a63f8405318e25711cb3884d8 {'type': 'unsubscription', 'list_id': 'somelist.lists.example.com<http://somelist.lists.example.com>', 'email': 'john.smith@maildomain.com<mailto:john.smith@maildomain.com>', 'display_name': '', 'when': '2021-05-04T23:01:39', 'token_owner': 'moderator'} f931755050ecad9c315aba95daf36c39ab01526f {'type': 'unsubscription', 'list_id': 'somelist.lists.example.com<http://somelist.lists.example.com>', 'email': 'john.smith@maildomain.com<mailto:john.smith@maildomain.com>', 'display_name': '', 'when': '2021-04-23T00:14:48', 'token_owner': 'moderator'} 3a858fe31618dfe254398a33d1cb71bf224f5e6e {'type': 'unsubscription', 'list_id': 'somelist.lists.example.com<http://somelist.lists.example.com>', 'email': 'john.smith@maildomain.com<mailto:john.smith@maildomain.com>', 'display_name': '', 'when': '2021-04-23T00:15:39', 'token_owner': 'moderator'}
What is the best way to clean these up?
Mr Simon Coggins Principal Systems Engineer | Digital Services Directorate CQUniversity Australia, Level 6.14, 160 Ann Street, Brisbane, QLD 4000 P +61 7 3295 1182 | X 51182 | M +61 408 115 861 | E s.coggins@cqu.edu.au<mailto:s.coggins@cqu.edu.au>
[https://www.cqu.edu.au/social-media] I respectfully acknowledge the Traditional Owners of the land on which we work and learn, and pay respect to the First Nations Peoples and their Elders, past, present and future. This communication may contain privileged or confidential information. If you have received this in error, please return to sender and delete. CRICOS: 00219C | RTO Code 40939
On 1 Nov 2021, at 11:11 am, Simon Coggins <s.coggins@cqu.edu.au<mailto:s.coggins@cqu.edu.au>> wrote:
Hi,
We’re running mailman 3.3.4 (about to upgrade to 3.3.5 this week). I enabled mailman notify cron a few weeks ago to email out any pending requests for admins. I’ve now got multiple lists that keep emailing out the same outstanding holds but they can’t visible in the GUI. The requests are all duplicates as well. This is a redacted example email:
-----Original Message----- From: mailman-alerts@example.com<mailto:mailman-alerts@example.com> Sent: Monday, 1 November 2021 8:10 AM To: somelist-owner@lists.example.com<mailto:somelist-owner@lists.example.com> Subject: The somelist@lists.example.com<mailto:somelist@lists.example.com> list has 4 moderation requests waiting.
The somelist@lists.example.com<mailto:somelist@lists.example.com> list has 4 moderation requests waiting.
Held Unsubscriptions: User: john.smith@maildomain.com<mailto:john.smith@maildomain.com> User: john.smith@maildomain.com<mailto:john.smith@maildomain.com> User: john.smith@maildomain.com<mailto:john.smith@maildomain.com> User: john.smith@maildomain.com<mailto:john.smith@maildomain.com>
Please attend to this at your earliest convenience.
I have multiple lists sending the same email (with the same user repeated 4 times). Where should I be looking in the internals of mailman to try and work out why this user has hidden unsubscription holds?
-Simon
Mr Simon Coggins Principal Systems Engineer | Digital Services Directorate CQUniversity Australia, Level 6.14, 160 Ann Street, Brisbane, QLD 4000 P +61 7 3295 1182 | X 51182 | M +61 408 115 861 | E s.coggins@cqu.edu.au<mailto:s.coggins@cqu.edu.au>
[https://www.cqu.edu.au/social-media] I respectfully acknowledge the Traditional Owners of the land on which we work and learn, and pay respect to the First Nations Peoples and their Elders, past, present and future. This communication may contain privileged or confidential information. If you have received this in error, please return to sender and delete. CRICOS: 00219C | RTO Code 40939