Timeout on listing pages

[James Westby]

Hi,

For the last few days I have been getting timeouts on branch listing pages,
such as https://code.edge.launchpad.net/groff. This seems to happen for
both project and people listings, but only for me, not for other people on
the same page.

An example is OOPS-1314ED463.

Thanks,

James

[Jonathan Lange (jml)]

Looks like there are a bunch of merge proposal queries all taking ~2s.

SELECT COUNT(*) FROM BranchMergeProposal WHERE BranchMergeProposal.source_branch IN (SELECT Branch.id FROM Branch WHERE Branch.product = %s AND Branch.id IN ((SELECT Branch.id FROM Branch WHERE Branch.private = %s) UNION (SELECT Branch.id FROM Branch, TeamParticipation WHERE Branch.owner = TeamParticipation.team AND TeamParticipation.person = %s) UNION (SELECT Branch.id FROM Branch, BranchSubscription, TeamParticipation WHERE BranchSubscription.branch = Branch.id AND BranchSubscription.person = TeamParticipation.team AND TeamParticipation.person = %s AND Branch.private = %s))) AND BranchMergeProposal.target_branch IN ((SELECT Branch.id FROM Branch WHERE Branch.private = %s) UNION (SELECT Branch.id FROM Branch, TeamParticipation WHERE Branch.owner = TeamParticipation.team AND TeamParticipation.person = %s) UNION (SELECT Branch.id FROM Branch, BranchSubscription, TeamParticipation WHERE BranchSubscription.branch = Branch.id AND BranchSubscription.person = TeamParticipation.team AND TeamParticipation.person = %s AND Branch.private = %s)) AND BranchMergeProposal.queue_status IN (%s)

[Tim Penhey (thumper)]

This is primarily around the visibility query for branches and merge proposals. I *think* I have this fixed now.

[James Westby (james-w)]

Hi,

I'm getting OOPS still on branch listings:

    https://lp-oops.canonical.com/oops.py/?oopsid=1364ED613

would you like a new bug for it?

Thanks,

James