On 11/12/25 11:48, [email protected] wrote:
I'm migrating from Ubuntu 20.04, mailman 3.2.2, postgresql 12 to Debian 13,
mailman 3.3.10, postgresql 17.
After migrating the postgresql databases and assuring the perms and passwords work, this
is what I get with a "mailman-web migrate":
([email protected]) redacted from the original
# mailman-web migrate
Operations to perform:
Apply all migrations: account, admin, auth, contenttypes, django_mailman3,
django_q, hyperkitty, postorius, \
sessions, sites, socialaccount
Running migrations:
Applying account.0003_alter_emailaddress_create_unique_verified_email... OK
Applying account.0004_alter_emailaddress_drop_unique_email... OK
Applying account.0005_emailaddress_idx_upper_email... OK
Applying account.0006_emailaddress_lower...Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 89,
in _execute
return self.cursor.execute(sql, params)
~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint
"account_emailaddress_user_id_\
email_987c8728_uniq"
DETAIL: Key (user_id, email)=(24, [email protected]) already exists.
This is actually a django-allauth issue. This issue is due to changes in
Django allauth to prevent creating
multiple addresses differing only in case. The problem is if you have
such multiple addresses in your account_emailaddress table, this
migration fails. There is a script at
https://www.msapiro.net/scripts/UC_fix that will fix this. You may need
to adjust the shebang and replace psycopg2 with sqlite3.
See https://github.com/pennersr/django-allauth/issues/3019 perhaps
starting at
This issue is due to changes in Django allauth to prevent creating
multiple addresses differing only in case. The problem is if you have
such multiple addresses in your account_emailaddress table, this
migration fails. There is a script at
https://www.msapiro.net/scripts/UC_fix that will fix this. You may need
to adjust the shebang.
See https://github.com/pennersr/django-allauth/issues/3019 perhaps
starting at
https://github.com/pennersr/django-allauth/issues/3019#issuecomment-1748028271
--
Mark Sapiro <[email protected]> The highway is for gamblers,
San Francisco Bay Area, California better use your sense - B. Dylan
_______________________________________________
Mailman-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
Archived at:
https://lists.mailman3.org/archives/list/[email protected]/message/NXXUNBNW3R3GXZI44WORW5YWSYLIYFSF/
This message sent to [email protected]
