ValidPersonOrTeamVocabulary searchForTerms OOPS with empty search string and times out on others

Bug #365322 reported by Brad Crittenden
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Brad Crittenden

Bug Description

Searching with an empty string results in a TypeError in searchForTerms due to the emptyResults being a SQLObjectResultSet when a Storm ResultSet is expected. See OOPS-1208S210.

Also, performing a search with non-empty terms results in a timeout as shown by OOPS-1208S208. The query for ValidPersonOrTeam needs to be optimized.

Currently these errors only occur on staging.

Brad Crittenden (bac)
Changed in launchpad-registry:
assignee: nobody → Brad Crittenden (bac)
importance: Undecided → High
milestone: none → 2.2.4
status: New → In Progress
tags: added: oops
Revision history for this message
Brad Crittenden (bac) wrote :

db-devel r8009

Changed in launchpad-registry:
status: In Progress → Fix Committed
Curtis Hovey (sinzui)
Changed in launchpad-registry:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.