[MM3-users] Re: Error 500 on held_messages page

On 2/4/22 04:57, Stephan Krinetzki wrote:

we have fixed the issue now:

Good.

 mailman shell -l list@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.
 Die Variable 'm' ist die list@lists.example.com Mailingliste
 >>> lr = IListRequests(m)
 >>> for req in lr.held_requests:
 ...     if lr.get_request(req.id) is None:
 ...         print(req.id)
 ...
 32598
 22449
 66937
 68261
 92927
 >>>

With this IDs

 DELETE FROM _request WHERE id IN (32598, 22449, 66937, 68261, 92927);

And the 500 error is gone.

I'm glad you were able to fix it. Do you happen to have the content of those rows in the db before you deleted them? It would be interesting to know what that was to try to determine how that situation happened in the first place.

-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan