timeout on NullBugTask:+index

Bug #607948 reported by Robert Collins
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Invalid
Critical
Unassigned

Bug Description

 11 (SELECT StructuralSubscription.date_created, StructuralSubscription.date_last_updated, Structural ... ING,$STRING,$STRING]::TEXT[])@>ARRAY_AGG(BugSubscriptionFilterTag.tag))))) AS filters_matching))):
   GET: 11 Robots: 5 Local: 0
      2 https://bugs.launchpad.net/debian/+bug/260918/+index (NullBugTask:+index)
       OOPS-1880G782, OOPS-1880K939
      2 https://bugs.launchpad.net/ubuntu/+bug/217908/+index (NullBugTask:+index)
       OOPS-1880A2097, OOPS-1880H2103
      2 https://bugs.launchpad.net/ubuntu/+bug/59695/+index (NullBugTask:+index)
       OOPS-1880F2121, OOPS-1880L1498

Revision history for this message
Robert Collins (lifeless) wrote :

This may also be driven by 'has many subscribers' as it dies on the real bug task too.

Revision history for this message
Robert Collins (lifeless) wrote :

The actual exception -
  TimeoutError: 'SELECT TeamParticipation.id, TeamParticipation.person, TeamParticipation.team FROM TeamParticipation WHERE TeamParticipation.person = %s AND TeamParticipation.team = %s', [<storm.variables.IntVariable object at 0x2aaaaceb1b90>, <storm.variables.IntVariable object at 0xc3e7938>] - suggests that there was a lot of sql time still, as per the oops-tools bug on analysing sql/nonsql time.

tags: removed: oops
tags: added: pg83
Changed in launchpad:
importance: High → Critical
description: updated
description: updated
description: updated
Revision history for this message
Robert Collins (lifeless) wrote :

NBT no longer exists.

Changed in launchpad:
status: Triaged → Invalid
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.