Bad task traversal or link

Bug #1894 reported by Stuart Bishop
4
Affects Status Importance Assigned to Milestone
Launchpad itself
Invalid
Medium
Unassigned

Bug Description

I'm getting errors in the PostgreSQL logs where code is sending strings through where integers are expected.

Two URLs that are generating (different) instances of this are:

http://launchpad.net/malone/bugs/820/people/+upstreamtask
http://launchpad.net/malone/bugs/1637/watches/+distrotask

I suspect this might be from some dud links - GoogleBot appears to be triggering them.

Revision history for this message
Christian Reis (kiko) wrote :

Traceback (innermost last):

    * Module zope.publisher.publish, line 135, in publish
      object = request.traverse(object)
    * Module zope.publisher.browser, line 494, in traverse
      ob = super(BrowserRequest, self).traverse(object)
    * Module zope.publisher.http, line 382, in traverse
      ob = super(HTTPRequest, self).traverse(object)
    * Module zope.publisher.base, line 270, in traverse
      subobject = publication.traverseName(
    * Module zope.app.publication.publicationtraverse, line 56, in traverseName
      ob2 = adapter.publishTraverse(request, nm)
    * Module canonical.launchpad.webapp.metazcml, line 393, in publishTraverse
      traversed_to = getattr(self.context, self._getter)(name)
    * Module canonical.launchpad.database.bugset, line 18, in __getitem__
      item = self.table.selectOne(self.table.q.id == id)
    * Module sqlobject.main, line 1038, in selectOne
      connection=connection))
    * Module sqlobject.main, line 1495, in __iter__
      return conn.iterSelect(self)
    * Module sqlobject.dbconnection, line 635, in iterSelect
      select, keepConnection=True)))
    * Module sqlobject.dbconnection, line 567, in __init__
      self.dbconn._executeRetry(self.rawconn, self.cursor, self.query)
    * Module sqlobject.dbconnection, line 204, in _executeRetry
      return cursor.execute(query)
    * Module zope.app.rdb, line 283, in execute
      return self.cursor.execute(operation)

ProgrammingError: ERROR: invalid input syntax for integer: "+distrotask" SELECT BugWatch.id, BugWatch.remotebug, BugWatch.datecreated, BugWatch.lastchanged, BugWatch.lastchecked, BugWatch.bug, BugWatch.owner, BugWatch.remotestatus, BugWatch.bugtracker FROM BugWatch WHERE (BugWatch.id = '+distrotask')

Revision history for this message
Christian Reis (kiko) wrote :

Traceback (innermost last):

    * Module zope.publisher.publish, line 135, in publish
      object = request.traverse(object)
    * Module zope.publisher.browser, line 494, in traverse
      ob = super(BrowserRequest, self).traverse(object)
    * Module zope.publisher.http, line 382, in traverse
      ob = super(HTTPRequest, self).traverse(object)
    * Module zope.publisher.base, line 270, in traverse
      subobject = publication.traverseName(
    * Module zope.app.publication.publicationtraverse, line 56, in traverseName
      ob2 = adapter.publishTraverse(request, nm)
    * Module canonical.launchpad.webapp.metazcml, line 393, in publishTraverse
      traversed_to = getattr(self.context, self._getter)(name)
    * Module canonical.launchpad.database.bugset, line 18, in __getitem__
      item = self.table.selectOne(self.table.q.id == id)
    * Module sqlobject.main, line 1038, in selectOne
      connection=connection))
    * Module sqlobject.main, line 1495, in __iter__
      return conn.iterSelect(self)
    * Module sqlobject.dbconnection, line 635, in iterSelect
      select, keepConnection=True)))
    * Module sqlobject.dbconnection, line 567, in __init__
      self.dbconn._executeRetry(self.rawconn, self.cursor, self.query)
    * Module sqlobject.dbconnection, line 204, in _executeRetry
      return cursor.execute(query)
    * Module zope.app.rdb, line 283, in execute
      return self.cursor.execute(operation)

ProgrammingError: ERROR: invalid input syntax for integer: "+upstreamtask" SELECT BugSubscription.id, BugSubscription.bug, BugSubscription.person, BugSubscription.subscription FROM BugSubscription WHERE (BugSubscription.id = '+upstreamtask')

Revision history for this message
Christian Reis (kiko) wrote :

I don't understand how these URLs could have been generated -- the only reference to them is in the tasks headline list. Stuart, can we look at the server logs and pick up the referer for the original exceptions?

Christian Reis (kiko)
Changed in launchpad:
status: New → Rejected
tags: added: iso-testing
Gary Poster (gary)
tags: removed: iso-testing
tags: added: iso-testing
tags: removed: iso-testing
Revision history for this message
Ubuntu QA Website (ubuntuqa) wrote :

This bug has been reported on the Ubuntu ISO testing tracker.

A list of all reports related to this bug can be found here:
http://iso.qa.ubuntu.com/qatracker/reports/bugs/1894

tags: added: iso-testing
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.