FAQ
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 at 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.

Search Discussions

  • Barry Warsaw at Sep 1, 2010 at 4:13 pm
    ** 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.
  • Barry Warsaw at Sep 20, 2010 at 8:50 pm
    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.
  • Anna at Oct 4, 2010 at 10:18 am
    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.
  • Barry Warsaw at Oct 4, 2010 at 2:01 pm
    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.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupmailman-coders @
categoriespython
postedAug 13, '10 at 9:19a
activeOct 4, '10 at 2:01p
posts5
users2
websitelist.org

2 users in discussion

Barry Warsaw: 3 posts Anna: 2 posts

People

Translate

site design / logo © 2022 Grokbase