[Bug 1343137] [NEW] listarchiver table missing from postgresql schema

John Naggets hostingnuggets at gmail.com
Thu Jul 17 08:50:44 CEST 2014


Public bug reported:

I am currently testing Mailman3 with PostgreSQL and found out that the
listarchiver table is missing from the PostgreSQL schema
(database/schema/postgres.sql). It is correctly included in SQLite
migration schema though (database/schema/sqlite_20130406000000_01.sql).

Due to the missing listarchiver table I get the following exception:

Jul 16 17:56:36 2014 (25554) Uncaught runner exception: relation "listarchiver" does not exist
LINE 1: ...tarchiver.mailing_list_id, listarchiver.name FROM listarchiv...
                                                             ^
Jul 16 17:56:36 2014 (25554) Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/mailman/core/runner.py", line 169, in _one_iteration
    self._process_one_file(msg, msgdata)
  File "/usr/local/lib/python2.7/dist-packages/mailman/core/runner.py", line 252, in _process_one_file
    keepqueued = self._dispose(mlist, msg, msgdata)
  File "/usr/local/lib/python2.7/dist-packages/mailman/runners/pipeline.py", line 36, in _dispose
    process(mlist, msg, msgdata, pipeline)
  File "/usr/local/lib/python2.7/dist-packages/mailman/core/pipelines.py", line 66, in process
    handler.process(mlist, msg, msgdata)
  File "/usr/local/lib/python2.7/dist-packages/mailman/handlers/rfc_2369.py", line 120, in process
    process(mlist, msg, msgdata)
  File "/usr/local/lib/python2.7/dist-packages/mailman/handlers/rfc_2369.py", line 87, in process
    archiver_set = IListArchiverSet(mlist)
  File "/usr/local/lib/python2.7/dist-packages/zope/component/hookable.py", line 33, in __call__
    return self.__implementation(*args, **kw)
  File "/usr/local/lib/python2.7/dist-packages/zope/component/_api.py", line 156, in adapter_hook
    return sitemanager.queryAdapter(object, interface, name, default)
  File "/usr/local/lib/python2.7/dist-packages/zope/interface/registry.py", line 234, in queryAdapter
    return self.adapters.queryAdapter(object, interface, name, default)
  File "/usr/local/lib/python2.7/dist-packages/mailman/model/mailinglist.py", line 591, in __init__
    ListArchiver.name == archiver_name)).one()
  File "/usr/local/lib/python2.7/dist-packages/storm/store.py", line 1158, in one
    result = self._store._connection.execute(select)
  File "/usr/local/lib/python2.7/dist-packages/storm/databases/postgres.py", line 266, in execute
    return Connection.execute(self, statement, params, noresult)
  File "/usr/local/lib/python2.7/dist-packages/storm/database.py", line 241, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/usr/local/lib/python2.7/dist-packages/storm/databases/postgres.py", line 276, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/usr/local/lib/python2.7/dist-packages/storm/database.py", line 374, in raw_execute
    self._run_execution(raw_cursor, args, params, statement)
  File "/usr/local/lib/python2.7/dist-packages/storm/database.py", line 388, in _run_execution
    self._check_disconnect(raw_cursor.execute, *args)
  File "/usr/local/lib/python2.7/dist-packages/storm/database.py", line 454, in _check_disconnect
    return function(*args, **kwargs)
ProgrammingError: relation "listarchiver" does not exist
LINE 1: ...tarchiver.mailing_list_id, listarchiver.name FROM listarchiv...

** Affects: mailman
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Mailman
Coders, which is subscribed to GNU Mailman.
https://bugs.launchpad.net/bugs/1343137

Title:
  listarchiver table missing from postgresql schema

To manage notifications about this bug go to:
https://bugs.launchpad.net/mailman/+bug/1343137/+subscriptions


More information about the Mailman-coders mailing list