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/[email protected]/thread/O QX2OJJQF3UBME5ASRZVQS7IWTLUWHMI/#NH4EERK2HSXZGU4QJBMPPMY5NHVK73BE Best regards, Eric -----Original Message----- From: Morris Jones <[email protected]> Sent: Friday, 8 August 2025 19:00 To: [email protected] 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 -- [email protected] To unsubscribe send an email to [email protected] https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/ Archived at: https://lists.mailman3.org/archives/list/[email protected]/message/ PNZ7WNKBKBW46C6PNSDUTIZGOJKTOTZU/ This message sent to [email protected] _______________________________________________ Mailman-users mailing list -- [email protected] To unsubscribe send an email to [email protected] https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/ Archived at: https://lists.mailman3.org/archives/list/[email protected]/message/JQHNS5JP54RUPULHOS2OFKWC4IJ7KBAY/ This message sent to [email protected]
