[Bug 617285] [NEW] Possible regression issue in MM3

Public bug reported: Trying to retrieve a list of all mailing lists in the system (using the rest client) MM3 crashes with the traceback below. It seems to be a regression issue but I think it might also be a general bug since a non existing column in the DB is called. About the lock mentioned in the traceback: gallia is my wireless network and the processes I have running are Mailman 3 core and a Django app for the MM3 UI which should work together. anna@athena:~/Documents/Programmering/mailman3/mailman$ Traceback (most recent call last): File "/usr/lib/python2.6/wsgiref/handlers.py", line 93, in run self.result = application(self.environ, self.start_response) File "/home/anna/Documents/Programmering/mailman3/mailman/src/mailman/rest/wsgiapp.py", line 58, in __call__ environ, start_response) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/restish-0.11-py2.6.egg/restish/app.py", line 18, in __call__ response = self.get_response(request, resource_or_response) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/restish-0.11-py2.6.egg/restish/app.py", line 65, in get_response resource_or_response = resource_or_response(request) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/restish-0.11-py2.6.egg/restish/resource.py", line 211, in __call__ return _dispatch(request, match, lambda r: callable(self, r)) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/restish-0.11-py2.6.egg/restish/resource.py", line 239, in _dispatch response = func(request) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/restish-0.11-py2.6.egg/restish/resource.py", line 211, in <lambda> return _dispatch(request, match, lambda r: callable(self, r)) File "/home/anna/Documents/Programmering/mailman3/mailman/src/mailman/rest/lists.py", line 215, in collection resource = self._make_collection(request) File "/home/anna/Documents/Programmering/mailman3/mailman/src/mailman/rest/helpers.py", line 140, in _make_collection collection = self._get_collection(request) File "/home/anna/Documents/Programmering/mailman3/mailman/src/mailman/rest/lists.py", line 134, in _get_collection return list(getUtility(IListManager)) File "/home/anna/Documents/Programmering/mailman3/mailman/src/mailman/model/listmanager.py", line 84, in __iter__ for fqdn_listname in self.names: File "/home/anna/Documents/Programmering/mailman3/mailman/src/mailman/model/listmanager.py", line 90, in names for mlist in config.db.store.find(MailingList): File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/storm-0.16.0-py2.6-linux-i686.egg/storm/store.py", line 968, in __iter__ result = self._store._connection.execute(self._get_select()) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/storm-0.16.0-py2.6-linux-i686.egg/storm/database.py", line 217, in execute raw_cursor = self.raw_execute(statement, params) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/storm-0.16.0-py2.6-linux-i686.egg/storm/databases/sqlite.py", line 153, in raw_execute return Connection.raw_execute(self, statement, params) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/storm-0.16.0-py2.6-linux-i686.egg/storm/database.py", line 299, in raw_execute self._check_disconnect(raw_cursor.execute, *args) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/storm-0.16.0-py2.6-linux-i686.egg/storm/database.py", line 342, in _check_disconnect return function(*args, **kwargs) OperationalError: no such column: mailinglist.last_post_at Aug 13 10:52:47 2010 (2982) timed out Usage: master [options] Master sub-process watcher. Start and watch the configured queue runners and ensure that they stay alive and kicking. Each are fork and exec'd in turn, with the master waiting on their process ids. When it detects a child queue runner has exited, it may restart it. The queue runners respond to SIGINT, SIGTERM, SIGUSR1 and SIGHUP. SIGINT, SIGTERM and SIGUSR1 all cause the qrunners to exit cleanly. The master will restart qrunners that have exited due to a SIGUSR1 or some kind of other exit condition (say because of an exception). SIGHUP causes the master and the qrunners to close their log files, and reopen then upon the next printed message. The master also responds to SIGINT, SIGTERM, SIGUSR1 and SIGHUP, which it simply passes on to the qrunners. Note that the master will close and reopen its own log files on receipt of a SIGHUP. The master also leaves its own process id in the file `data/master-qrunner.pid` but you normally don't need to use this pid directly. master: error: The master qrunner lock could not be acquired, because it appears as if some process on some other host may have acquired it. We can't test for stale locks across host boundaries, so you'll have to clean this up manually. Lock file: /home/anna/Documents/Programmering/mailman3/mailman/var/locks/master-qrunner.lck Lock host: gallia Exiting. Traceback (most recent call last): File "/usr/lib/python2.6/wsgiref/handlers.py", line 93, in run self.result = application(self.environ, self.start_response) File "/home/anna/Documents/Programmering/mailman3/mailman/src/mailman/rest/wsgiapp.py", line 58, in __call__ environ, start_response) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/restish-0.11-py2.6.egg/restish/app.py", line 18, in __call__ response = self.get_response(request, resource_or_response) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/restish-0.11-py2.6.egg/restish/app.py", line 65, in get_response resource_or_response = resource_or_response(request) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/restish-0.11-py2.6.egg/restish/resource.py", line 211, in __call__ return _dispatch(request, match, lambda r: callable(self, r)) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/restish-0.11-py2.6.egg/restish/resource.py", line 239, in _dispatch response = func(request) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/restish-0.11-py2.6.egg/restish/resource.py", line 211, in <lambda> return _dispatch(request, match, lambda r: callable(self, r)) File "/home/anna/Documents/Programmering/mailman3/mailman/src/mailman/rest/lists.py", line 215, in collection resource = self._make_collection(request) File "/home/anna/Documents/Programmering/mailman3/mailman/src/mailman/rest/helpers.py", line 140, in _make_collection collection = self._get_collection(request) File "/home/anna/Documents/Programmering/mailman3/mailman/src/mailman/rest/lists.py", line 134, in _get_collection return list(getUtility(IListManager)) File "/home/anna/Documents/Programmering/mailman3/mailman/src/mailman/model/listmanager.py", line 84, in __iter__ for fqdn_listname in self.names: File "/home/anna/Documents/Programmering/mailman3/mailman/src/mailman/model/listmanager.py", line 90, in names for mlist in config.db.store.find(MailingList): File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/storm-0.16.0-py2.6-linux-i686.egg/storm/store.py", line 968, in __iter__ result = self._store._connection.execute(self._get_select()) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/storm-0.16.0-py2.6-linux-i686.egg/storm/database.py", line 217, in execute raw_cursor = self.raw_execute(statement, params) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/storm-0.16.0-py2.6-linux-i686.egg/storm/databases/sqlite.py", line 153, in raw_execute return Connection.raw_execute(self, statement, params) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/storm-0.16.0-py2.6-linux-i686.egg/storm/database.py", line 299, in raw_execute self._check_disconnect(raw_cursor.execute, *args) File "/home/anna/Documents/Programmering/mailman3/mailman/eggs/storm-0.16.0-py2.6-linux-i686.egg/storm/database.py", line 342, in _check_disconnect return function(*args, **kwargs) OperationalError: no such column: mailinglist.last_post_at ** Affects: mailman Importance: Undecided Status: New ** Tags: mailman3 rest-api -- Possible regression issue in MM3 https://bugs.launchpad.net/bugs/617285 You received this bug notification because you are a member of Mailman Coders, which is subscribed to GNU Mailman.

** Changed in: mailman Assignee: (unassigned) => Barry Warsaw (barry) ** Changed in: mailman Milestone: None => 3.0.0a6 ** Changed in: mailman Status: New => Triaged ** Changed in: mailman Importance: Undecided => High -- Possible regression issue in MM3 https://bugs.launchpad.net/bugs/617285 You received this bug notification because you are a member of Mailman Coders, which is subscribed to GNU Mailman.

I'm not able to reproduce this. It's possible that you just hit a situation where the schema was in migration, so that your current database was out of date with the new model. Is this still reproducible with a clean, updated tree and no schema? Note that until beta, the schema is not guaranteed to be stable. ** Changed in: mailman Status: Triaged => Incomplete ** Changed in: mailman Milestone: 3.0.0a6 => None -- Possible regression issue in MM3 https://bugs.launchpad.net/bugs/617285 You received this bug notification because you are a member of Mailman Coders, which is subscribed to GNU Mailman.

Sorry for the late response. I've been trying to reproduce the bug but just like you I'm not able to any more. It is possible that it was due to a migration issue and that the data base was out of sync so I think the bug can be closed for now. If I'll find a way to reproduce the bug later I'll let you know. -- Possible regression issue in MM3 https://bugs.launchpad.net/bugs/617285 You received this bug notification because you are a member of Mailman Coders, which is subscribed to GNU Mailman.

Thanks Anna. Closing. ** Changed in: mailman Status: Incomplete => Invalid -- Possible regression issue in MM3 https://bugs.launchpad.net/bugs/617285 You received this bug notification because you are a member of Mailman Coders, which is subscribed to GNU Mailman.
participants (2)
-
Anna
-
Barry Warsaw