Branch:+huge-vocabulary timeout (Person and team AJAX picker fails)

https://lp-oops.canonical.com/oops.py/?oopsid=1740EC788

https://code.edge.launchpad.net/%7Elaunchpad-pqm/lp-production-configs/trunk/@@+huge-vocabulary?name=ValidPersonOrTeam&search_text=john%20Arbash%20Meinel&batch=6&start=0

Branch: launchpad-rev-9783.5
Revno: 11676
SQL time: 12913 ms
Non-sql time: 94 ms
Total time: 13007 ms
Statement Count: 26

Long SQL Statements (Shows up to five statements) top

Time Reps Database id Statement
1 8903.0 1 SQL-launchpad-main-slave SELECT COUNT(*) FROM (SELECT Person.account, Person.creation_comment, Person.creation_rationale, Person.datecreated, Person.defaultmembershipperiod, Person.defaultrenewalperiod, Person.displayname, Person.hide_email_addresses, Person.homepage_content, Person.icon, Person.id, Person.logo, Person.mailing_list_auto_subscribe_policy, Person.merged, Person.mugshot, Person.name, Person.personal_standing, Person.personal_standing_reason, Person.registrant, Person.renewal_policy, Person.subscriptionpolicy, Person.teamdescription, Person.teamowner, Person.verbose_bugnotifications, Person.visibility FROM (SELECT DISTINCT Person.account, Person.creation_comment, Person.creation_rationale, Person.datecreated, Person.defaultmembershipperiod, Person.defaultrenewalperiod, Person.displayname, Person.hide_email_addresses, Person.homepage_content, Person.icon, Person.id, Person.logo, Person.mailing_list_auto_subscribe_policy, Person.merged, Person.mugshot, Person.name, Person.personal_standing, Person.personal_standing_reason, Person.registrant, Person.renewal_policy, Person.subscriptionpolicy, Person.teamdescription, Person.teamowner, Person.verbose_bugnotifications, Person.visibility, Person.name = %s FROM ((SELECT Person.account, Person.creation_comment, Person.creation_rationale, Person.datecreated, Person.defaultmembershipperiod, Person.defaultrenewalperiod, Person.displayname, Person.hide_email_addresses, Person.homepage_content, Person.icon, Person.id, Person.logo, Person.mailing_list_auto_subscribe_policy, Person.merged, Person.mugshot, Person.name, Person.personal_standing, Person.personal_standing_reason, Person.registrant, Person.renewal_policy, Person.subscriptionpolicy, Person.teamdescription, Person.teamowner, Person.verbose_bugnotifications, Person.visibility FROM Person LEFT JOIN EmailAddress ON EmailAddress.person = Person.id LEFT JOIN Account ON EmailAddress.account = Account.id WHERE Person.id IN ( SELECT id FROM ( SELECT Person.id, 100 AS rank FROM Person WHERE name = %s UNION ALL SELECT Person.id, rank(fti, ftq(%s)) FROM Person WHERE Person.fti @@ ftq(%s) UNION ALL SELECT Person.id, 10 AS rank FROM Person, IrcId WHERE IrcId.person = Person.id AND lower(IrcId.nickname) = %s UNION ALL SELECT Person.id, 1 AS rank FROM Person, EmailAddress WHERE EmailAddress.person = Person.id AND lower(email) LIKE %s || '%%' ) AS public_subquery ORDER BY rank DESC LIMIT %s ) AND Person.visibility = %s AND Person.merged IS NULL AND (NOT (Person.teamowner IS NULL) OR Account.status = %s AND EmailAddress.status IN (%s, %s)) AND %s) UNION (SELECT Person.account, Person.creation_comment, Person.creation_rationale, Person.datecreated, Person.defaultmembershipperiod, Person.defaultrenewalperiod, Person.displayname, Person.hide_email_addresses, Person.homepage_content, Person.icon, Person.id, Person.logo, Person.mailing_list_auto_subscribe_policy, Person.merged, Person.mugshot, Person.name, Person.personal_standing, Person.personal_standing_reason, Person.registrant, Person.renewal_policy, Person.subscriptionpolicy, Person.teamdescription, Person.teamowner, Person.verbose_bugnotifications, Person.visibility FROM Person JOIN TeamParticipation ON TeamParticipation.team = Person.id WHERE Person.id IN ( SELECT Person.id FROM Person WHERE Person.fti @@ ftq(%s) LIMIT %s ) AND TeamParticipation.person = %s AND NOT (Person.teamowner IS NULL) AND Person.visibility = %s)) AS Person) AS Person ORDER BY (Person.name = %s) DESC, Person.displayname, Person.name LIMIT 100) AS "_tmp"
2 3899.0 1 SQL-launchpad-main-slave SELECT Person.account, Person.creation_comment, Person.creation_rationale, Person.datecreated, Person.defaultmembershipperiod, Person.defaultrenewalperiod, Person.displayname, Person.hide_email_addresses, Person.homepage_content, Person.icon, Person.id, Person.logo, Person.mailing_list_auto_subscribe_policy, Person.merged, Person.mugshot, Person.name, Person.personal_standing, Person.personal_standing_reason, Person.registrant, Person.renewal_policy, Person.subscriptionpolicy, Person.teamdescription, Person.teamowner, Person.verbose_bugnotifications, Person.visibility FROM (SELECT DISTINCT Person.account, Person.creation_comment, Person.creation_rationale, Person.datecreated, Person.defaultmembershipperiod, Person.defaultrenewalperiod, Person.displayname, Person.hide_email_addresses, Person.homepage_content, Person.icon, Person.id, Person.logo, Person.mailing_list_auto_subscribe_policy, Person.merged, Person.mugshot, Person.name, Person.personal_standing, Person.personal_standing_reason, Person.registrant, Person.renewal_policy, Person.subscriptionpolicy, Person.teamdescription, Person.teamowner, Person.verbose_bugnotifications, Person.visibility, Person.name = %s FROM ((SELECT Person.account, Person.creation_comment, Person.creation_rationale, Person.datecreated, Person.defaultmembershipperiod, Person.defaultrenewalperiod, Person.displayname, Person.hide_email_addresses, Person.homepage_content, Person.icon, Person.id, Person.logo, Person.mailing_list_auto_subscribe_policy, Person.merged, Person.mugshot, Person.name, Person.personal_standing, Person.personal_standing_reason, Person.registrant, Person.renewal_policy, Person.subscriptionpolicy, Person.teamdescription, Person.teamowner, Person.verbose_bugnotifications, Person.visibility FROM Person LEFT JOIN EmailAddress ON EmailAddress.person = Person.id LEFT JOIN Account ON EmailAddress.account = Account.id WHERE Person.id IN ( SELECT id FROM ( SELECT Person.id, 100 AS rank FROM Person WHERE name = %s UNION ALL SELECT Person.id, rank(fti, ftq(%s)) FROM Person WHERE Person.fti @@ ftq(%s) UNION ALL SELECT Person.id, 10 AS rank FROM Person, IrcId WHERE IrcId.person = Person.id AND lower(IrcId.nickname) = %s UNION ALL SELECT Person.id, 1 AS rank FROM Person, EmailAddress WHERE EmailAddress.person = Person.id AND lower(email) LIKE %s || '%%' ) AS public_subquery ORDER BY rank DESC LIMIT %s ) AND Person.visibility = %s AND Person.merged IS NULL AND (NOT (Person.teamowner IS NULL) OR Account.status = %s AND EmailAddress.status IN (%s, %s)) AND %s) UNION (SELECT Person.account, Person.creation_comment, Person.creation_rationale, Person.datecreated, Person.defaultmembershipperiod, Person.defaultrenewalperiod, Person.displayname, Person.hide_email_addresses, Person.homepage_content, Person.icon, Person.id, Person.logo, Person.mailing_list_auto_subscribe_policy, Person.merged, Person.mugshot, Person.name, Person.personal_standing, Person.personal_standing_reason, Person.registrant, Person.renewal_policy, Person.subscriptionpolicy, Person.teamdescription, Person.teamowner, Person.verbose_bugnotifications, Person.visibility FROM Person JOIN TeamParticipation ON TeamParticipation.team = Person.id WHERE Person.id IN ( SELECT Person.id FROM Person WHERE Person.fti @@ ftq(%s) LIMIT %s ) AND TeamParticipation.person = %s AND NOT (Person.teamowner IS NULL) AND Person.visibility = %s)) AS Person) AS Person ORDER BY (Person.name = %s) DESC, Person.displayname, Person.name LIMIT 7 OFFSET 0