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. |
|