the db query in ArchivePermissionSet.checkAuthenticated() is broken

Bug #402108 reported by Muharem Hrnjadovic
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Muharem Hrnjadovic

Bug Description

.. and times out during LP API testing on staging and mawson.

Tags: lp-soyuz

Related branches

Revision history for this message
Muharem Hrnjadovic (al-maisan) wrote :

The original OOPS: https://pastebin.canonical.com/20138/
The original query: https://pastebin.canonical.com/20131/
The EXPLAIN ANALYZE (ran against the db on mawson) for the query above: https://pastebin.canonical.com/20130/

Changed in soyuz:
status: New → In Progress
importance: Undecided → High
assignee: nobody → Muharem Hrnjadovic (al-maisan)
milestone: none → 2.2.7
Revision history for this message
Diogo Matsubara (matsubara) wrote : Bug fixed by a commit

Fixed in db r8305.

Changed in soyuz:
status: In Progress → Fix Committed
Changed in soyuz:
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.