[Pkg-mailman-hackers] Bug#992510: mailman3-web: SQL Syntax error installing mailman3-web

Michael Schultheiss schultmc at debian.org
Thu Aug 19 14:46:41 BST 2021 

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 at 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 at localhost
  mailman3-web/remote/port:
  mailman3-web/nginx-choice:
* mailman3-web/database-type: pgsql
  mailman3-web/pgsql/no-empty-passwords:

More information about the Pkg-mailman-hackers mailing list