Hi,
Am 13. Dezember 2019 um 17:10 Uhr -0800 schrieb Mark Sapiro:
key is the <message-id> of the request message request_type is 1 for a held message mailing_list_id is a numeric index into the mailinglist table
The issue is there are still held message requests there for the messages you removed. You need to delete those entries from the _request table.
Thank you again for your valuable help. I've now taken the easy route and ran
DELETE FROM _requests WHERE request_type=1;
, i.e. I cleared the entire held messages queue. As it turned out, there were no requests of any other type than type 1. I've deleted all remaining files below /var/lib/mailman3/messages as well (after seeing it was only spam anyway, this time non-broken spam, but still spam).
Now, finally, I can go to the held messages queue in Postorius again without a 500 error. The list of held messages there is now empty, but this is obviously expected. Let's hope that disabling SMTPUTF8 prevents the problem from further occuring. In any case, I've asked a friend report the problem to the Ubuntu tracker: https://bugs.launchpad.net/ubuntu/+source/mailman3/+bug/1856181
I'm back on track now. Thanks everyone!
Marvin
-- Blog: https://mg.guelker.eu