[Bug 1343137] [NEW] listarchiver table missing from postgresql schema
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
** Tags added: mailman3 ** Changed in: mailman Status: New => Triaged ** Changed in: mailman Importance: Undecided => High -- 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
I've been hit by this bug too, and wrote the following merge request to fix it: https://code.launchpad.net/~abompard/mailman/pgsql_upgrade/+merge/227289 -- 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
** Branch linked: lp:~abompard/mailman/pgsql_upgrade -- 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
I think this issue is no longer valid after the port to SQLAlchemy. Aurelien, I'll let you handle your mp. ** Changed in: mailman Status: Triaged => Invalid -- 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
participants (3)
-
Aurélien Bompard
-
Barry Warsaw
-
John Naggets