Person:+delete timeouts on teams

[Emmet Hikory]

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.

[Stuart Bishop (stub)]

# select count(*) from bugnotificationrecipientarchive where person=6213;
-[ RECORD 1 ]-
count | 112647

# select count(*) from bugnotificationrecipientarchive where person=754157;
-[ RECORD 1 ]
count | 24856

# select count(*) from bugnotificationrecipientarchive;
-[ RECORD 1 ]---
count | 58548792

I'd say it is slow because it is trying to update a huge number of rows. Like person merge, this is going to have to be done asynchronously.

[Curtis Hovey (sinzui)]

team delete is really merge where the target is ~registry. This bug is the same as all other team merge bugs.

[Curtis Hovey (sinzui)]

I deleted the team using the proven approach. Keep pressing the Delete but while drinking coffee until the operation finally completes (3 tries).