Activity log for bug #796434

Date Who What changed Old value New value Message
2011-06-13 05:26:28 Robert Collins bug added bug
2011-06-13 05:30:00 Robert Collins summary HWDevice:EntryResource:getSubmissions timeouts HWDevice:EntryResource:getSubmissions timeouts at high batch offset
2011-06-13 05:30:03 Robert Collins description 22 SELECT DISTINCT HWSubmission.contactable, HWSubmission.date_created, HWSubmission.date_submitted, ... D HWSubmissionDevice.submission = HWSubmission.id ORDER BY HWSubmission.id LIMIT $INT OFFSET $INT: GET: 22 Robots: 0 Local: 0 6 https://api.launchpad.net/beta/+hwdb/+device/365 (HWDevice:EntryResource:getSubmissions) OOPS-1989AQ136, OOPS-1989CC117, OOPS-1989D138, OOPS-1989F123, OOPS-1989H151 6 https://api.launchpad.net/beta/+hwdb/+device/8 (HWDevice:EntryResource:getSubmissions) OOPS-1989AZ13, OOPS-1989BA19, OOPS-1989CD16, OOPS-1989CL19, OOPS-1989DY22 4 https://api.launchpad.net/beta/+hwdb/+device/36 (HWDevice:EntryResource:getSubmissions) OOPS-1989AU124, OOPS-1989AY131, OOPS-1989CJ85, OOPS-1989CQ99 [3 other URLs]  22 SELECT DISTINCT HWSubmission.contactable, HWSubmission.date_created, HWSubmission.date_submitted, ... D HWSubmissionDevice.submission = HWSubmission.id ORDER BY HWSubmission.id LIMIT $INT OFFSET $INT:    GET: 22 Robots: 0 Local: 0       6 https://api.launchpad.net/beta/+hwdb/+device/365 (HWDevice:EntryResource:getSubmissions)        OOPS-1989AQ136, OOPS-1989CC117, OOPS-1989D138, OOPS-1989F123, OOPS-1989H151       6 https://api.launchpad.net/beta/+hwdb/+device/8 (HWDevice:EntryResource:getSubmissions)        OOPS-1989AZ13, OOPS-1989BA19, OOPS-1989CD16, OOPS-1989CL19, OOPS-1989DY22       4 https://api.launchpad.net/beta/+hwdb/+device/36 (HWDevice:EntryResource:getSubmissions)        OOPS-1989AU124, OOPS-1989AY131, OOPS-1989CJ85, OOPS-1989CQ99    [3 other URLs] 18. 68 6580ms SQL-launchpad-main-master SELECT DISTINCT HWSubmission.contactable, HWSubmission.date_created, HWSubmission.date_submitted, HWSubmission.distroarchseries, HWSubmission.format, HWSubmission.id, HWSubmission.OWNER, HWSubmission.private, HWSubmission.raw_emailaddress, HWSubmission.raw_submission, HWSubmission.status, HWSubmission.submission_key, HWSubmission.system_fingerprint FROM HWDevice, HWDeviceDriverLink, HWSubmission, HWSubmissionDevice WHERE NOT HWSubmission.private AND HWDeviceDriverLink.device = HWDevice.id AND HWDevice.id = 365 AND HWSubmissionDevice.device_driver_link = HWDeviceDriverLink.id AND HWSubmissionDevice.submission = HWSubmission.id ORDER BY HWSubmission.id LIMIT 76 OFFSET 122025 -
2012-09-14 03:17:20 Curtis Hovey tags timeout hwdb timeout
2012-10-19 01:11:42 Ian Booth launchpad: importance Critical High