Activity log for bug #1016156

Date Who What changed Old value New value Message
2012-06-21 17:13:41 JC Hulce bug added bug
2012-06-22 00:08:48 Robert Collins launchpad: status New Triaged
2012-06-22 00:08:49 Robert Collins launchpad: importance Undecided Critical
2012-06-22 00:08:51 Robert Collins summary Timeout on project main page ProjectGroup:+index timeout due to repeated queries of all subprojects.
2012-06-22 00:10:19 Robert Collins description https://launchpad.net/chromium-project (Error ID: OOPS-c182f7f94210ede212ae5b835ef993c7) https://launchpad.net/chromium-project (Error ID: OOPS-c182f7f94210ede212ae5b835ef993c7) SQL time: 12670 ms Non-sql time: 231 ms Total time: 12901 ms Statement Count: 56 count, total, time, savings: 11 9657 877 8780 SQL-main-slave SELECT Product.answers_usage, Product.blueprints_usage, Product.OWNER, Product.active,
2012-06-22 00:12:12 Robert Collins summary ProjectGroup:+index timeout due to repeated queries of all subprojects. ProjectGroup:+index timeout due to slow query of subprojects
2012-06-22 00:14:05 Robert Collins description https://launchpad.net/chromium-project (Error ID: OOPS-c182f7f94210ede212ae5b835ef993c7) SQL time: 12670 ms Non-sql time: 231 ms Total time: 12901 ms Statement Count: 56 count, total, time, savings: 11 9657 877 8780 SQL-main-slave SELECT Product.answers_usage, Product.blueprints_usage, Product.OWNER, Product.active, https://launchpad.net/chromium-project (Error ID: OOPS-c182f7f94210ede212ae5b835ef993c7) SQL time: 12670 ms Non-sql time: 231 ms Total time: 12901 ms Statement Count: 56 served from chaenomeles count, total, time, savings: 11 9657 877 8780 SQL-main-slave SELECT Product.answers_usage,        Product.blueprints_usage,        Product.OWNER, Product.active, Close inspection shows the query is often fast (4-6ms), but the fatal one at the end was 8.5 seconds - either a repeated case of GIL interaction, or a particularly special DB server behaviour. Possible causes: cross DC interruption, GIL, $?
2012-10-11 05:57:57 Ian Booth launchpad: status Triaged In Progress
2012-10-11 05:58:02 Ian Booth launchpad: assignee Ian Booth (wallyworld)
2012-10-12 02:40:34 Ian Booth branch linked lp:~wallyworld/launchpad/projectgroup-timeout-1016156
2012-10-15 00:50:50 Launchpad QA Bot tags timeout qa-needstesting timeout
2012-10-15 00:50:51 Launchpad QA Bot launchpad: status In Progress Fix Committed
2012-10-15 01:05:15 Ian Booth tags qa-needstesting timeout qa-ok timeout
2012-10-16 20:25:00 Richard Harding launchpad: status Fix Committed Fix Released