Deleting git repository with many MPs times out
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Triaged
|
Critical
|
Unassigned |
Bug Description
OOPS-37cfede9eefb5b51adcbbef4f1a1b738 shows lots of missing bulk operations. The top ones are:
1. 188 572 3 569 SQL-main-master
DELETE
FROM BranchMergeProp
WHERE BranchMergeProp
2. 65 528 8 520 SQL-main-master
SELECT $INT
FROM (
SELECT GitRepository.
FROM GitRepository
WHERE GitRepository.id IN ($INT)
AND (GitRepository.
OR COALESCE(
(SELECT ARRAY_AGG(
FROM TeamParticipation
WHERE TeamParticipati
OR COALESCE(
3. 62 375 6 369 SQL-main-master
DELETE
FROM CodeReviewMessage
WHERE CodeReviewMessa
4. 33 130 3 127 SQL-main-master
DELETE
FROM CodeReviewVote
WHERE CodeReviewVote.id = $INT
5. 32 160 5 155 SQL-main-master
SELECT BranchMergeProp
FROM BranchMergeProposal
WHERE BranchMergeProp
ORDER BY BranchMergeProp
6. 32 151 4 147 SQL-main-master
SELECT CodeReviewVote.
FROM CodeReviewVote
WHERE CodeReviewVote.
7. 32 91 2 89 SQL-nostore
SELECT Webhook.active,
Webhook.id,
Webhook.snap
FROM Webhook
WHERE Webhook.
ORDER BY Webhook.id
8. 31 456 14 442 SQL-main-master
SELECT BranchMergeProp
FROM BranchMergeProp
WHERE BranchMergeProp
9. 31 207 6 201 SQL-main-master
SELECT CodeReviewMessa
FROM CodeReviewMessage
WHERE CodeReviewMessa
10. 31 161 5 156 SQL-main-master
DELETE
FROM BranchMergeProposal
WHERE BranchMergeProp
11. 31 121 3 118 SQL-main-master
DELETE
FROM PreviewDiff
WHERE PreviewDiff.
12. 10 26 2 24 SQL-main-master
DELETE
FROM CodeReviewInlin
WHERE CodeReviewInlin
13. 10 25 2 23 SQL-main-master
DELETE
FROM CodeReviewInlin
WHERE CodeReviewInlin