launchpad-project milestones gets timeout error

Bug #499219 reported by Brian Fromme on 2009-12-21
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
High
Unassigned

Bug Description

Went to the page:

https://edge.launchpad.net/launchpad-project/+milestones

A timeout error occurs, such as:

Traceback (most recent call last):

Module zope.publisher.publish, line 134, in publish
Module canonical.launchpad.webapp.publication, line 374, in callObject
return mapply(ob, request.getPositionalArguments(), request)
Module zope.publisher.publish, line 109, in mapply
__traceback_info__: <security proxied zope.browserpage.metaconfigure.SimpleViewClass from /srv/edge.launchpad.net/edge/launchpad-rev-10064/lib/lp/registry/browser/../templates/object-milestones.pt instance at 0xe015190>
Module zope.publisher.publish, line 115, in debug_call
Module canonical.launchpad.webapp.publisher, line 283, in __call__
return self.render()
Module canonical.launchpad.webapp.publisher, line 264, in render
return self.template()
Module zope.app.pagetemplate.viewpagetemplatefile, line 83, in __call__
Module zope.app.pagetemplate.viewpagetemplatefile, line 51, in __call__
Module zope.pagetemplate.pagetemplate, line 115, in pt_render
Module zope.tal.talinterpreter, line 271, in __call__
Module zope.tal.talinterpreter, line 343, in interpret
Module zope.tal.talinterpreter, line 888, in do_useMacro
Module zope.tal.talinterpreter, line 343, in interpret
Module zope.tal.talinterpreter, line 533, in do_optTag_tal
Module zope.tal.talinterpreter, line 518, in do_optTag
Module zope.tal.talinterpreter, line 513, in no_tag
Module zope.tal.talinterpreter, line 343, in interpret
Module zope.tal.talinterpreter, line 531, in do_optTag_tal
Module zope.tal.talinterpreter, line 513, in no_tag
Module zope.tal.talinterpreter, line 343, in interpret
Module zope.tal.talinterpreter, line 946, in do_defineSlot
Module zope.tal.talinterpreter, line 343, in interpret
Module zope.tal.talinterpreter, line 533, in do_optTag_tal
Module zope.tal.talinterpreter, line 518, in do_optTag
Module zope.tal.talinterpreter, line 513, in no_tag
Module zope.tal.talinterpreter, line 343, in interpret
Module zope.tal.talinterpreter, line 852, in do_condition
Module zope.tal.talinterpreter, line 343, in interpret
Module zope.tal.talinterpreter, line 821, in do_loop_tal
Module zope.tal.talinterpreter, line 343, in interpret
Module zope.tal.talinterpreter, line 531, in do_optTag_tal
Module zope.tal.talinterpreter, line 513, in no_tag
Module zope.tal.talinterpreter, line 343, in interpret
Module zope.tal.talinterpreter, line 742, in do_insertStructure_tal
Module zope.tales.tales, line 696, in evaluate
/srv/edge.launchpad.net/edge/launchpad-rev-10064/lib/lp/registry/browser/../templates/object-milestones.pt
Line 42, Column 10
Expression: <PathExpr standard:u'milestone/@@+pillar-table-row'>
   - Names:
      {'args': (),
       'context': <Project at 0xbcf4910>,
       'default': <object object at 0x2b3b337e61d0>,
       'loop': {},
       'nothing': None,
       'options': {},
       'repeat': {},
       'request': <canonical.launchpad.webapp.servers.LaunchpadBrowserRequest instance URL=https://edge.launchpad.net/launchpad-project/+milestones>,
       'template': <z3c.ptcompat.ViewPageTemplateFile object at 0x74f6cd0>,
       'view': <zope.browserpage.metaconfigure.SimpleViewClass from /srv/edge.launchpad.net/edge/launchpad-rev-10064/lib/lp/registry/browser/../templates/object-milestones.pt object at 0xe015190>,
       'views': <zope.app.pagetemplate.viewpagetemplatefile.ViewMapper object at 0x2aaab0937c90>}
Module zope.tales.expressions, line 217, in __call__
Module zope.tales.expressions, line 211, in _eval
Module canonical.launchpad.webapp.publisher, line 283, in __call__
return self.render()
Module canonical.launchpad.webapp.publisher, line 264, in render
return self.template()
Module zope.app.pagetemplate.viewpagetemplatefile, line 83, in __call__
Module zope.app.pagetemplate.viewpagetemplatefile, line 51, in __call__
Module zope.pagetemplate.pagetemplate, line 115, in pt_render
Module zope.tal.talinterpreter, line 271, in __call__
Module zope.tal.talinterpreter, line 343, in interpret
Module zope.tal.talinterpreter, line 533, in do_optTag_tal
Module zope.tal.talinterpreter, line 518, in do_optTag
Module zope.tal.talinterpreter, line 513, in no_tag
Module zope.tal.talinterpreter, line 343, in interpret
Module zope.tal.talinterpreter, line 852, in do_condition
Module zope.tal.talinterpreter, line 343, in interpret
Module zope.tal.talinterpreter, line 852, in do_condition
Module zope.tal.talinterpreter, line 343, in interpret
Module zope.tal.talinterpreter, line 533, in do_optTag_tal
Module zope.tal.talinterpreter, line 518, in do_optTag
Module zope.tal.talinterpreter, line 513, in no_tag
Module zope.tal.talinterpreter, line 343, in interpret
Module zope.tal.talinterpreter, line 851, in do_condition
Module zope.tales.tales, line 701, in evaluateBoolean
Module zope.tales.tales, line 696, in evaluate
/srv/edge.launchpad.net/edge/launchpad-rev-10064/lib/lp/registry/browser/../templates/productseries-milestone-table-row.pt
Line 79, Column 6
Expression: <PathExpr standard:u'view/bugtasks'>
   - Names:
      {'args': (),
       'context': <lp.registry.model.milestone.ProjectMilestone object at 0x111071d0>,
       'default': <object object at 0x2b3b337e61d0>,
       'loop': {},
       'nothing': None,
       'options': {},
       'repeat': {},
       'request': <canonical.launchpad.webapp.servers.LaunchpadBrowserRequest instance URL=https://edge.launchpad.net/launchpad-project/+milestones>,
       'template': <z3c.ptcompat.ViewPageTemplateFile object at 0x74f6a90>,
       'view': <zope.browserpage.metaconfigure.SimpleViewClass from /srv/edge.launchpad.net/edge/launchpad-rev-10064/lib/lp/registry/browser/../templates/productseries-milestone-table-row.pt object at 0x12181b10>,
       'views': <zope.app.pagetemplate.viewpagetemplatefile.ViewMapper object at 0xd46cc10>}
Module zope.tales.expressions, line 217, in __call__
Module zope.tales.expressions, line 194, in _eval
Module zope.tales.expressions, line 124, in _eval
Module zope.pagetemplate.engine, line 68, in __call__
Module zope.traversing.adapters, line 138, in traversePathElement
__traceback_info__: (<zope.browserpage.metaconfigure.SimpleViewClass from /srv/edge.launchpad.net/edge/launchpad-rev-10064/lib/lp/registry/browser/../templates/productseries-milestone-table-row.pt object at 0x12181b10>, 'bugtasks')
Module zope.traversing.adapters, line 44, in traverse
__traceback_info__: (<zope.browserpage.metaconfigure.SimpleViewClass from /srv/edge.launchpad.net/edge/launchpad-rev-10064/lib/lp/registry/browser/../templates/productseries-milestone-table-row.pt object at 0x12181b10>, 'bugtasks', [])
Module canonical.cachedproperty, line 78, in __get__
result = self.fn(inst)
Module lp.registry.browser.milestone, line 252, in bugtasks
return [self._getListingItem(bugtask) for bugtask in self._bugtasks]
Module canonical.cachedproperty, line 78, in __get__
result = self.fn(inst)
Module lp.registry.browser.milestone, line 230, in _bugtasks
if task.getConjoinedMaster(bugs_and_tasks[task.bug]) is None:
Module canonical.database.sqlbase, line 716, in block_implicit_flushes_decorator
return func(*args, **kwargs)
Module canonical.launchpad.webapp.authorization, line 203, in checkPermission
principal.account)
Module canonical.launchpad.security, line 156, in checkAccountAuthenticated
return self.checkAuthenticated(person)
Module canonical.launchpad.security, line 893, in checkAuthenticated
return self.obj.bug.userCanView(user)
Module lp.bugs.model.bug, line 1378, in userCanView
for subscription in self.subscriptions:
Module storm.sqlobject, line 523, in __iter__
Module storm.store, line 969, in __iter__
Module storm.databases.postgres, line 249, in execute
Module storm.database, line 217, in execute
Module storm.databases.postgres, line 259, in raw_execute
Module storm.database, line 293, in raw_execute
Module storm.database, line 342, in _check_disconnect
Module storm.tracer, line 95, in trace
Module canonical.launchpad.webapp.adapter, line 416, in connection_raw_execute
connection, raw_cursor, statement, params)
Module storm.tracer, line 49, in connection_raw_execute
TimeoutError: 'SELECT BugSubscription.bug, BugSubscription.id, BugSubscription.person, BugSubscription.subscribed_by, "_prejoin1".account, "_prejoin1".addressline1, "_prejoin1".addressline2, "_prejoin1".city, "_prejoin1".country, "_prejoin1".creation_comment, "_prejoin1".creation_rationale, "_prejoin1".datecreated, "_prejoin1".defaultmembershipperiod, "_prejoin1".defaultrenewalperiod, "_prejoin1".displayname, "_prejoin1".hide_email_addresses, "_prejoin1".homepage_content, "_prejoin1".icon, "_prejoin1".id, "_prejoin1".logo, "_prejoin1".mailing_list_auto_subscribe_policy, "_prejoin1".merged, "_prejoin1".mugshot, "_prejoin1".name, "_prejoin1".organization, "_prejoin1".personal_standing, "_prejoin1".personal_standing_reason, "_prejoin1".phone, "_prejoin1".postcode, "_prejoin1".province, "_prejoin1".registrant, "_prejoin1".renewal_policy, "_prejoin1".subscriptionpolicy, "_prejoin1".teamdescription, "_prejoin1".teamowner, "_prejoin1".verbose_bugnotifications, "_prejoin1".visibility FROM BugSubscription LEFT JOIN Person AS "_prejoin1" ON BugSubscription.person = "_prejoin1".id WHERE BugSubscription.bug = %s AND (1=1) ORDER BY BugSubscription.id', [<storm.variables.IntVariable object at 0x10d25230>]<br />

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers