Provide warning after returning large queries

Bug #1227830 reported by Nicholas Skaggs on 2013-09-19
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Thomi Richards
autopilot (Ubuntu)

Bug Description

Autopilot should provide a warning after returning a large number of objects for a select query.


select_many('Label') will return a huge object set and take a long time. While it might be impossible to know the size of the query beforehand, a warning line to the output of the test can alert test authors to potentially poorly written or performing code.

As an addendum could similar warnings should exist for selects that time a long time to run, indicative of a similar performance issue?

Related branches

Thomi Richards (thomir) on 2013-09-27
Changed in autopilot:
status: New → In Progress
importance: Undecided → High
assignee: nobody → Thomi Richards (thomir)
PS Jenkins bot (ps-jenkins) wrote :

Fix committed into lp:autopilot/1.3 at revision 342, scheduled for release in autopilot, milestone Unknown

Changed in autopilot:
status: In Progress → Fix Committed
PS Jenkins bot (ps-jenkins) wrote :

Fix committed into lp:autopilot at revision 342, scheduled for release in autopilot, milestone 1.4

Launchpad Janitor (janitor) wrote :

This bug was fixed in the package autopilot - 1.3.1+13.10.20131003.1-0ubuntu1

autopilot (1.3.1+13.10.20131003.1-0ubuntu1) saucy; urgency=low

  [ Thomi Richards ]
  * Fix attribute error in click package support.
  * Remove a spurious log message. (LP: #1227852)
  * Fix several functional tests.
  * Fix a missing test dependency, and add more logging when a process
    exits before we find the introspection interface. (LP: #1229034)
  * Add a warning when an autopilot query returns many items, and should
    probably be optimised. (LP: #1227830)

  [ Jamie Strandboge ]
  * Adds the apparmor rule needed for click package testing.

  [ Christopher Lee ]
  * Backout additions for logging when a process dies.
  * Changes how the proxy objects are created so the inheritance is
    correct. (LP: #1230046)
  * Fixes issue where a classes _Backend can be None causes uncaught
    exceptions. (LP: #1233972)

  [ Ubuntu daily release ]
  * Automatic snapshot from revision 343
 -- Ubuntu daily release <email address hidden> Thu, 03 Oct 2013 09:40:57 +0000

Changed in autopilot (Ubuntu):
status: New → Fix Released
Thomi Richards (thomir) on 2013-11-07
Changed in autopilot:
milestone: none → 1.4
status: Fix Committed → Fix Released
Rolf Leggewie (r0lf) wrote :

saucy has seen the end of its life and is no longer receiving any updates. Marking the saucy task for this ticket as "Won't Fix".

Changed in autopilot (Ubuntu Saucy):
status: New → Won't Fix
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers