Package: mailman3-web Version: 0+20200530-2 Severity: important I'm in the process of migrating from buster to bullseye and am migrating from mailman 2 to mailman 3. Installing mailman3, I get a SQL syntax error:
Setting up mailman3-web (0+20200530-2) ... dbconfig-common: writing config to /etc/dbconfig-common/mailman3-web.conf creating postgres user mailman3web: already exists. resetting password: success. creating database mailman3web: already exists. dbconfig-common: flushing administrative password Traceback (most recent call last): File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) psycopg2.errors.SyntaxError: syntax error at or near "WITH ORDINALITY" LINE 6: FROM unnest(c.conkey) WITH ORDINALITY co... ^ The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/bin/django-admin", line 5, in <module> management.execute_from_command_line() File "/usr/lib/python3/dist-packages/django/core/management/__init__.py", line 381, in execute_from_command_line utility.execute() File "/usr/lib/python3/dist-packages/django/core/management/__init__.py", line 375, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/usr/lib/python3/dist-packages/django/core/management/base.py", line 323, in run_from_argv self.execute(*args, **cmd_options) File "/usr/lib/python3/dist-packages/django/core/management/base.py", line 364, in execute output = self.handle(*args, **options) File "/usr/lib/python3/dist-packages/django/core/management/base.py", line 83, in wrapped res = handle_func(*args, **kwargs) File "/usr/lib/python3/dist-packages/django/core/management/commands/migrate.py", line 232, in handle post_migrate_state = executor.migrate( File "/usr/lib/python3/dist-packages/django/db/migrations/executor.py", line 117, in migrate state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial) File "/usr/lib/python3/dist-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial) File "/usr/lib/python3/dist-packages/django/db/migrations/executor.py", line 245, in apply_migration state = migration.apply(state, schema_editor) File "/usr/lib/python3/dist-packages/django/db/migrations/migration.py", line 124, in apply operation.database_forwards(self.app_label, schema_editor, old_state, project_state) File "/usr/lib/python3/dist-packages/django/db/migrations/operations/fields.py", line 249, in database_forwards schema_editor.alter_field(from_model, from_field, to_field) File "/usr/lib/python3/dist-packages/django/db/backends/base/schema.py", line 534, in alter_field self._alter_field(model, old_field, new_field, old_type, new_type, File "/usr/lib/python3/dist-packages/django/db/backends/postgresql/schema.py", line 122, in _alter_field super()._alter_field( File "/usr/lib/python3/dist-packages/django/db/backends/base/schema.py", line 543, in _alter_field fk_names = self._constraint_names(model, [old_field.column], foreign_key=True) File "/usr/lib/python3/dist-packages/django/db/backends/base/schema.py", line 1115, in _constraint_names constraints = self.connection.introspection.get_constraints(cursor, model._meta.db_table) File "/usr/lib/python3/dist-packages/django/db/backends/postgresql/introspection.py", line 155, in get_constraints cursor.execute(""" File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 67, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers return executor(sql, params, many, context) File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/usr/lib/python3/dist-packages/django/db/utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "/usr/lib/python3/dist-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) django.db.utils.ProgrammingError: syntax error at or near "WITH ORDINALITY" LINE 6: FROM unnest(c.conkey) WITH ORDINALITY co... ^ dpkg: error processing package mailman3-web (--configure): installed mailman3-web package post-installation script subprocess returned error exit status 1 dpkg: dependency problems prevent configuration of mailman3-full: mailman3-full depends on mailman3-web; however: Package mailman3-web is not configured yet. dpkg: error processing package mailman3-full (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mailman3-web mailman3-full E: Sub-process /usr/bin/dpkg returned an error code (1) -- System Information: Debian Release: 11.0 APT prefers stable-security APT policy: (500, 'stable-security'), (500, 'stable') Architecture: amd64 (x86_64) Kernel: Linux 5.10.0-8-amd64 (SMP w/2 CPU threads) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE not set Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages mailman3-web depends on: ii dbconfig-mysql 2.0.19 ii debconf [debconf-2.0] 1.5.77 ii init-system-helpers 1.60 ii lsb-base 11.1.0 ii python3 3.9.2-3 ii python3-django-hyperkitty 1.3.4-4 ii python3-django-postorius 1.3.4-2 ii python3-psycopg2 2.8.6-2 ii python3-whoosh 2.7.4+git6-g9134ad92-5 ii ucf 3.0043 ii uwsgi-core 2.0.19.1-7.1 ii uwsgi-plugin-python3 2.0.19.1-7.1 Versions of packages mailman3-web recommends: ii libapache2-mod-proxy-uwsgi 2.4.48-3.1+deb11u1 Versions of packages mailman3-web suggests: ii postgresql 13+225 -- debconf information: mailman3-web/mysql/authplugin: default mailman3-web/dbconfig-reinstall: false mailman3-web/db/basepath: /var/lib/mailman3/web mailman3-web/superuser-name: admin mailman3-web/mysql/admin-user: * mailman3-web/remote/host: localhost mailman3-web/pgsql/changeconf: false mailman3-web/remote/newhost: localhost mailman3-web/pgsql/admin-user: postgres mailman3-web/missing-db-package-error: abort mailman3-web/db/dbname: mailman3web mailman3-web/upgrade-error: abort mailman3-web/pgsql/authmethod-admin: ident mailman3-web/configure-webserver: none mailman3-web/install-error: abort mailman3-web/internal/skip-preseed: false mailman3-web/restart-webserver: true mailman3-web/dbconfig-remove: true mailman3-web/upgrade-backup: true mailman3-web/db/app-user: mailman3web@localhost mailman3-web/pgsql/authmethod-user: password mailman3-web/internal/reconfiguring: false mailman3-web/dbconfig-upgrade: true mailman3-web/purge: false mailman3-web/passwords-do-not-match: mailman3-web/pgsql/method: TCP/IP mailman3-web/pgsql/manualconf: mailman3-web/remove-error: abort * mailman3-web/dbconfig-install: true mailman3-web/emailname: localhost.local mailman3-web/mysql/method: Unix socket mailman3-web/superuser-mail: root@localhost mailman3-web/remote/port: mailman3-web/nginx-choice: * mailman3-web/database-type: pgsql mailman3-web/pgsql/no-empty-passwords: