Launchpad itself

OOPS generation failing due to sql statements after incomplete statement

Bug #636801 reported by William Grant
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Robert Collins

Bug Description

Starting a few days ago, some attempts to file Ubuntu bugs with apport have been failing with a 502 ("Please try again. Sorry, there was a problem connecting to the Launchpad server."). It only affects some packages, and apparently sometimes works after a lot of tries.

(Note, there is a separate bug about the performance of this page)

See original description
Tags: lp-bugs
Revision history for this message
William Grant (wgrant) wrote :

This seems to only occur when the blob has lots of attachments -- 36e2e3cc-bedc-11df-98f4-0025b3df357a is problematic, and has 20. I suspect that the problem is BugNotificationRecipient creation: Ubuntu has lots of structural subscribers, and reusing a problematic blob against a product with just a couple works fine. Assuming around 50 subscribers in total for xserver-xorg-video-intel in Ubuntu, 20 attachments would result in 1000 INSERTs on BugNotificationRecipient. Ouch. But this doesn't explain why it's an Apache 502 and not an OOPS-generating timeout.

Another oddity: I saw timeout OOPSes return from staging after 13s, but the 502 returns after slightly over 10s. So the proxy is erroring before a timeout could possibly occur.

This can be reproduced with 'APPORT_STAGING=1 ubuntu-bug linux' and going through the usual filing process on staging. The 502 occurs in the final stage, after the description is entered and the submit button pressed.

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

So, we need to get a trace of some sort to see whats going on. The timeout page you're getting isn't an appserver one, but appservers can (AIUI) provoke it if they go totally off into lala land.

Changed in malone:
status: New → Triaged
importance: Undecided → High
tags: added: timeout
Robert Collins (lifeless)
summary: - +filebug with lots of apport attachments results in a 502
+ DistributionSourcePackage:+filebug with lots of apport attachments
+ results in a 502
summary: - DistributionSourcePackage:+filebug with lots of apport attachments
- results in a 502
+ DistributionSourcePackage:+filebug with lots of apport attachments times
+ out
summary: - DistributionSourcePackage:+filebug with lots of apport attachments times
- out
+ OOPS generation failing due to sql statements after incomplete statement
Robert Collins (lifeless)
description: updated
Changed in malone:
status: Triaged → Fix Committed
assignee: nobody → Robert Collins (lifeless)
Revision history for this message
Robert Collins (lifeless) wrote :

CP'd to prod etc

tags: removed: timeout
Changed in malone:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

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