[MM3-users] Re: import21 / hyperkitty_import: sqlalchemy.orm.exc.MultipleResultsFound: Multiple rows were found for one_or_none()

It was a constraint violation in the database (I guess caused by an importer). I fixed it manually. Is there a way to trigger all constraint checks from the mailman cli?

Thanks,

Christian

mailman3=# select id,list_name from mailinglist where list_name like 'LISTNAMEREDACTED'; id | list_name ----+------------- 22 | LISTNAMEREDACTED (1 row)

mailman3=# select * from listarchiver where mailing_list_id = 22; id | mailing_list_id | name | _is_enabled -----+-----------------+--------------+------------- 105 | 22 | mhonarc | f 106 | 22 | mail-archive | f 107 | 22 | prototype | f 108 | 22 | hyperkitty | t 109 | 22 | mhonarc | f (5 rows)

mailman3=# select * from listarchiver where mailing_list_id = 21; id | mailing_list_id | name | _is_enabled -----+-----------------+--------------+------------- 118 | 21 | mhonarc | f 119 | 21 | mail-archive | f 120 | 21 | prototype | f 121 | 21 | hyperkitty | t (4 rows)

mailman3=# select * from listarchiver where mailing_list_id = 22; id | mailing_list_id | name | _is_enabled -----+-----------------+--------------+------------- 105 | 22 | mhonarc | f 106 | 22 | mail-archive | f 107 | 22 | prototype | f 108 | 22 | hyperkitty | t 109 | 22 | mhonarc | f (5 rows)

mailman3=# delete from listarchiver where id = 109; DELETE 1