Person:EntryResource:getMembersByStatus timeouts

Bug #1014896 reported by Robert Collins
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
Critical
Curtis Hovey

Bug Description

This API is timingout 6000 times a day, causing bloat in the error reports system.

   1225 https://api.launchpad.net/1.0/%7Econtributor-agreement-canonical (Person:EntryResource:getMembersByStatus)
       OOPS-00b1cdf6014b569e5c97fe73551d54cd, OOPS-012769744d3b07e0fd2df5d08a88c456, OOPS-0131eec9a3848697aa2e0b76d533ebb3, OOPS-01b6ea59b729a08bfc600e05d5683c02, OOPS-01f45167a6de28d040e65795152409c5

1159 SELECT $INT FROM (SELECT PersonTransferJob.json_data, PersonTransferJob.id, PersonTransferJob.job ... tus IN ($INT ... $INT) AND PersonTransferJob.minor_person = $INT LIMIT $INT) AS "_tmp" LIMIT $INT:
   GET: 1159 Robots: 0 Local: 0
   1110 https://api.launchpad.net/1.0/%7Econtributor-agreement-canonical (Person:EntryResource:getMembersByStatus)
       OOPS-000893492bf436a8adb2b5cc546fcb2e, OOPS-000ccd1e253df25240c89c500625cd69, OOPS-00272d7847a5f6d26977562ac8ff4abf, OOPS-006020db576fe3c25c37c7d49d6922e4, OOPS-007c43895fe0ede7f2d4d67684bee407

etc

Tags: timeout
description: updated
Revision history for this message
Jono Bacon (jonobacon) wrote :

I fixed this in the upstream script, so on the next upgrade of people in the PPA they will get it. The server side that validates the accomplishment is fixed too.

William Grant (wgrant)
Changed in launchpad:
assignee: nobody → Curtis Hovey (sinzui)
status: Triaged → 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.