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
_______________________________________________
Mailman-coders mailing list
[email protected]
https://mail.python.org/mailman/listinfo/mailman-coders
