Activity log for bug #652802

Date Who What changed Old value New value Message
2010-10-01 08:36:25 Emmet Hikory bug added bug
2010-10-01 08:39:43 Robert Collins affects launchpad launchpad-registry
2010-10-01 08:39:43 Robert Collins launchpad-registry: importance Undecided High
2010-10-01 08:39:43 Robert Collins launchpad-registry: status New Triaged
2010-10-01 08:42:44 Robert Collins summary Unable to delete the ~ubuntu-universe-sponsors team Person:+delete timeouts on teams
2010-10-01 08:45:07 Robert Collins description Attempting to delete ~ubuntu-universe-sponsors results in a repeatable timeout. One of the results is: (Error ID: OOPS-1735H851) https://lp-oops.canonical.com/oops.py/?oopsid=1735H851 https://launchpad.net/%7Eubuntu-universe-sponsors/+delete DB id: 237586 Branch: launchpad-rev-9777.1 Revno: 9777 SQL time: 18582 ms Non-sql time: 640 ms Total time: 19222 ms Statement Count: 695 1 15002.0 1 SQL-launchpad-main-master UPDATE bugnotificationrecipientarchive SET person=6213 WHERE person=754157 2 587.0 1 SQL-launchpad-main-master UPDATE BugNotificationRecipient SET person=6213 WHERE person=754157 AND bug_notification NOT IN ( SELECT bug_notification FROM BugNotificationRecipient WHERE person=6213 ) There's obviously another 3 seconds of hundreds of choppy sql queries, but the 15 second one is the primary culprit; other oopses may hint whether thats consistently a problem.
2010-10-01 10:45:48 Robert Collins tags timeout
2010-10-07 18:06:44 Curtis Hovey marked as duplicate 162510