Thank you Mark.
What you have said is right..
I found a list with two "hyperkitty" records in the listarchiver in the database. I had removed the list and recreated it and now I found it is working fine. The recreated list is having only one record.
After searching the links you provided I found there is just a work around but not the precaution to be taken for not getting the duplicate record.
Can you say what might be the reason for this duplication? If I need to provide any details, please let me know.
On Fri, Jul 24, 2020 at 11:50 PM Mark Sapiro <mark@msapiro.net> wrote:
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/6...
.
We don't know how it happens, but the issue is that the
listarchivertable in the database has multiplemhonarcentries for the samemailing_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_idand deleting one of them will fix this and you can runmailman unshuntto 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
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/
-- Thanks & Regards, Shashi Kanth.K 9052671936