DistributionSourcePackage:+publishinghistory timeouts

Reported by Robert Collins on 2011-03-21
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Critical
William Grant

Bug Description

  5 SELECT SourcePackagePublishingHistory.ancestor, SourcePackagePublishingHistory.archive, SourcePac ... sourcepackagename = $INT AND ($INT=$INT) ORDER BY SourcePackagePublishingHistory.datecreated DESC:
   GET: 3 Other: 2 Robots: 0 Local: 1
      3 https://launchpad.net/ubuntu/+source/linux-meta/+publishinghistory (DistributionSourcePackage:+publishinghistory)
       OOPS-1904E640, OOPS-1904F844, OOPS-1904H2023
      1 https://launchpad.net/ubuntu/+source/linux/+publishinghistory (DistributionSourcePackage:+publishinghistory)
       OOPS-1904D305
      1 https://launchpad.net/ubuntu/+source/ubiquity/+publishinghistory (DistributionSourcePackage:+publishinghistory)
       OOPS-1904G293

See bug 758258 for some issues related to the schema that might help this timeout.

Related branches

Ursula Junque (ursinha) on 2011-03-29
summary: - DistributionSourcePackage:+publishinghistory
+ DistributionSourcePackage:+publishinghistory timeouts
description: updated
Colin Watson (cjwatson) wrote :

Somebody reminded me recently that ages ago I had objected to +publishinghistory being batched, IIRC on the grounds that that made it unsearchable. For the record, I no longer think that this is a sensible objection: we have other tools to get full history if we need to, and in any event a page that times out due to having to render way too much data is clearly less useful than one that manages to display something. As Ubuntu gets older, +publishinghistory for important packages gets longer and longer, and this becomes incrementally more of a problem.

So, if batching would help - and I suspect it would, certainly for the packages in question - consider my objection withdrawn.

William Grant (wgrant) on 2012-11-21
Changed in launchpad:
assignee: nobody → William Grant (wgrant)
status: Triaged → In Progress
Launchpad QA Bot (lpqabot) wrote :
tags: added: qa-needstesting
Changed in launchpad:
status: In Progress → Fix Committed
William Grant (wgrant) on 2012-11-22
tags: added: qa-ok
removed: qa-needstesting
Changed in launchpad:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers