On 7/24/20 10:34 AM, Shashikanth Komandoor wrote:
Hi Team,
Today, I found an error message like "Multiple rows were foundfor one_or_none()" when a hold message is approved for a list. Until yesterday the mails were accepted and delivered fine.
We have seen this issue before. See <https://gitlab.com/mailman/mailman/-/issues/657>. There are also multiple threads on it in the archive, e.g., <https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/thread/6PLIYZHUOFTOISGRIECI5FFSHMXMV7X5/>.
We don't know how it happens, but the issue is that the listarchiver
table in the database has multiple mhonarc entries for the same
mailing_list_id.
You can see the problem with the query
select * from listarchiver where name = 'mhonarc';
There will be two entries with the same mailing_list_id and deleting
one of them will fix this and you can run mailman unshunt to reprocess
the shunted messages.
The above referenced issue contains a script that can be run to remove the extra entry.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan