Launchpad itself

timeout querying contents of PPA via API

Bug #1295741 reported by James Page
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Triaged
High
Celso Providelo

Bug Description

We use some automated tools to support detection of differences between the Ubuntu Archive and the Ubuntu Cloud Archive for Ubuntu 12.04.

Package: cloud-archive-utils
PPA: https://launchpad.net/~ubuntu-cloud-archive/+archive/tools

Specifically the command:

  cloud-archive-outdated-packages havana

Fails with an OOPS indicating a timeout:

   At least 2 queries/external actions issued in 0.07 seconds OOPS-d42e86544b03bb60d567fd7740dcafd9

Code for the tools can be found here:

  https://code.launchpad.net/~ubuntu-cloud-archive/cloud-archive-utils/trunk

Revision history for this message
James Page (james-page) wrote :

Varies by PPA

https://launchpad.net/~ubuntu-cloud-archive/+archive/icehouse-staging : OK
https://launchpad.net/~ubuntu-cloud-archive/+archive/havana-staging : FAILS

Celso Providelo (cprov)
Changed in launchpad:
status: New → Triaged
importance: Undecided → High
assignee: nobody → Celso Providelo (cprov)
Revision history for this message
Celso Providelo (cprov) wrote :

This page is timing out primarily because of a pg_planner misbehave on queries that should take less than 1 ms instead of 50~70 ms. This is being taken care already and should be fixed until the end of the week.

However there are many repeated queries, originated from the SPR security check, that should be redesigned anyway.

The plan is to prefill SPR.published_archives with the context Archive (saying if the requestor can view this archive it can also view all SPRs in it). With that change SPR security check will become a DB no-op.

Revision history for this message
James Page (james-page) wrote :

Celso - apologies - I marked this bug as a dupe of bug 1295318 and then realized you are working on it.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

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