Exception on update_messages w/ SQLite backend

Bug #803237 reported by Tony Wooster
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Burrow
Fix Released
High
Eric Day

Bug Description

Running against a local burrow instance, thru the WSGI interface w/ a SQLite backend, first create a message on the burrow server:

curl -X PUT -H 'Content-Type: text/plain' -d 'message body' 'http://localhost:8080/v1.0/acct/queue/messageid?ttl=5000'

Then attempt to update all messages in that queue:

curl -X POST 'http://localhost:8080/v1.0/acct/queue?ttl=3000'

And the server will throw:

Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/eventlet/wsgi.py", line 336, in handle_one_response
    result = self.application(self.environ, start_response)
  File "burrow/frontend/wsgi.py", line 111, in __call__
    return self._routes(*args, **kwargs)
  File "/usr/lib/pymodules/python2.7/routes/middleware.py", line 131, in __call__
    response = self.app(environ, start_response)
  File "/usr/lib/pymodules/python2.7/webob/dec.py", line 147, in __call__
    resp = self.call_func(req, *args, **self.kwargs)
  File "/usr/lib/pymodules/python2.7/webob/dec.py", line 208, in call_func
    return self.func(req, *args, **kwargs)
  File "burrow/frontend/wsgi.py", line 122, in _route
    return method(req, **args)
  File "/usr/lib/pymodules/python2.7/webob/dec.py", line 161, in __call__
    return self.func(req, *args, **kw)
  File "burrow/frontend/wsgi.py", line 53, in wrapper
    res = method(self, req, account, queue, *args, **kwargs)
  File "burrow/frontend/wsgi.py", line 178, in _post_queue
    self.backend.update_messages(account, queue, attributes, filters)]
  File "burrow/backend/sqlite.py", line 144, in update_messages
    self.db.execute(query % ','.join(ids), values)
OperationalError: no such column: msg

A POST without an attribute update will not trigger this error.

Related branches

Eric Day (eday)
Changed in burrow:
status: New → In Progress
importance: Undecided → High
assignee: nobody → Eric Day (eday)
milestone: none → 2011.3
Eric Day (eday)
Changed in burrow:
status: In Progress → Fix Committed
Eric Day (eday)
Changed in burrow:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.