I encountered the same issue beginning of the year. After deleting all pending requests, mostly from non-real subscribers, the UI worked fine again.
The mailthread in the archives: https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/thread/O QX2OJJQF3UBME5ASRZVQS7IWTLUWHMI/#NH4EERK2HSXZGU4QJBMPPMY5NHVK73BE
Best regards, Eric
-----Original Message----- From: Morris Jones <mojo@whiteoaks.com> Sent: Friday, 8 August 2025 19:00 To: mailman-users@mailman3.org Subject: [MM3-users] clearing pending db
I have an admittedly out-of-date installation of Mailman 3.3 (3.3.2 Tom Sawyer) but it's been working without issues for a long time, so I haven't had much incentive to bring it up to date. Sorry!
A couple of my larger mailing lists (around 500 members) are currently very slow when making changes through the UI (maybe that's my raison-to-update).
They also both have very large lists of members "pending confirmation."
My suspicion is that the large pending list is slowing down other operations.
But pendingdb.evict() doesn't seem to clear the list. For example, on one of my lists:
from mailman.interfaces.pending import IPendings >>> >>> from zope.component import getUtility >>> >>> pendingdb = getUtility(IPendings) pendingdb.count() 5040 pendingdb.evict() pendingdb.count() 5040
I have several lists, but none of them are extremely active, so I don't have a problem with wiping the pending db for all of them.
And I also might be totally wrong in my guess.
Mojo
Morris Jones, Monrovia, CA
Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/ Archived at: https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/message/ PNZ7WNKBKBW46C6PNSDUTIZGOJKTOTZU/
This message sent to eric.broens@skynet.be