| 2010-10-17 02:43:50 |
Micah Gersten |
bug |
|
|
added bug |
| 2010-10-17 02:44:07 |
Micah Gersten |
tags |
|
timeout |
|
| 2010-10-17 02:45:03 |
Micah Gersten |
description |
As lifeless said to report new bugs on timeouts now, here we go:
OOPS-1751ED185
https://bugs.edge.launchpad.net/ubuntu/+bugs?field.searchtext=grub_xputs&orderby=-importance&search=Search&field.status%3Alist=NEW&field.status%3Alist=INCOMPLETE_WITH_RESPONSE&field.status%3Alist=INCOMPLETE_WITHOUT_RESPONSE&field.status%3Alist=CONFIRMED&field.status%3Alist=TRIAGED&field.status%3Alist=INPROGRESS&field.status%3Alist=FIXCOMMITTED&field.assignee=&field.bug_reporter=&field.omit_dupes=on&field.has_patch=&field.has_no_package= |
As lifeless said to report new bugs on timeouts now, here we go:
Edge: OOPS-1751ED185
Prod: OOPS-1751E213
https://bugs.edge.launchpad.net/ubuntu/+bugs?field.searchtext=grub_xputs&orderby=-importance&search=Search&field.status%3Alist=NEW&field.status%3Alist=INCOMPLETE_WITH_RESPONSE&field.status%3Alist=INCOMPLETE_WITHOUT_RESPONSE&field.status%3Alist=CONFIRMED&field.status%3Alist=TRIAGED&field.status%3Alist=INPROGRESS&field.status%3Alist=FIXCOMMITTED&field.assignee=&field.bug_reporter=&field.omit_dupes=on&field.has_patch=&field.has_no_package=
|
|
| 2010-10-20 13:18:57 |
Deryck Hodge |
summary |
Timeout on bug search |
Timeout on Distribution:+bugs search |
|
| 2010-10-20 13:19:01 |
Deryck Hodge |
malone: status |
New |
Triaged |
|
| 2010-10-20 13:19:04 |
Deryck Hodge |
malone: importance |
Undecided |
High |
|
| 2010-10-20 13:20:00 |
Deryck Hodge |
description |
As lifeless said to report new bugs on timeouts now, here we go:
Edge: OOPS-1751ED185
Prod: OOPS-1751E213
https://bugs.edge.launchpad.net/ubuntu/+bugs?field.searchtext=grub_xputs&orderby=-importance&search=Search&field.status%3Alist=NEW&field.status%3Alist=INCOMPLETE_WITH_RESPONSE&field.status%3Alist=INCOMPLETE_WITHOUT_RESPONSE&field.status%3Alist=CONFIRMED&field.status%3Alist=TRIAGED&field.status%3Alist=INPROGRESS&field.status%3Alist=FIXCOMMITTED&field.assignee=&field.bug_reporter=&field.omit_dupes=on&field.has_patch=&field.has_no_package=
|
As lifeless said to report new bugs on timeouts now, here we go:
Edge: OOPS-1751ED185
Prod: OOPS-1751E213
https://bugs.edge.launchpad.net/ubuntu/+bugs?field.searchtext=grub_xputs&orderby=-importance&search=Search&field.status%3Alist=NEW&field.status%3Alist=INCOMPLETE_WITH_RESPONSE&field.status%3Alist=INCOMPLETE_WITHOUT_RESPONSE&field.status%3Alist=CONFIRMED&field.status%3Alist=TRIAGED&field.status%3Alist=INPROGRESS&field.status%3Alist=FIXCOMMITTED&field.assignee=&field.bug_reporter=&field.omit_dupes=on&field.has_patch=&field.has_no_package=
SQL time: 12539 ms
Non-sql time: 709 ms
Total time: 13248 ms
Statement Count: 69
|
|
| 2010-10-20 13:26:13 |
Deryck Hodge |
description |
As lifeless said to report new bugs on timeouts now, here we go:
Edge: OOPS-1751ED185
Prod: OOPS-1751E213
https://bugs.edge.launchpad.net/ubuntu/+bugs?field.searchtext=grub_xputs&orderby=-importance&search=Search&field.status%3Alist=NEW&field.status%3Alist=INCOMPLETE_WITH_RESPONSE&field.status%3Alist=INCOMPLETE_WITHOUT_RESPONSE&field.status%3Alist=CONFIRMED&field.status%3Alist=TRIAGED&field.status%3Alist=INPROGRESS&field.status%3Alist=FIXCOMMITTED&field.assignee=&field.bug_reporter=&field.omit_dupes=on&field.has_patch=&field.has_no_package=
SQL time: 12539 ms
Non-sql time: 709 ms
Total time: 13248 ms
Statement Count: 69
|
As lifeless said to report new bugs on timeouts now, here we go:
Edge: OOPS-1751ED185
Prod: OOPS-1751E213
https://bugs.edge.launchpad.net/ubuntu/+bugs?field.searchtext=grub_xputs&orderby=-importance&search=Search&field.status%3Alist=NEW&field.status%3Alist=INCOMPLETE_WITH_RESPONSE&field.status%3Alist=INCOMPLETE_WITHOUT_RESPONSE&field.status%3Alist=CONFIRMED&field.status%3Alist=TRIAGED&field.status%3Alist=INPROGRESS&field.status%3Alist=FIXCOMMITTED&field.assignee=&field.bug_reporter=&field.omit_dupes=on&field.has_patch=&field.has_no_package=
SQL time: 12539 ms
Non-sql time: 709 ms
Total time: 13248 ms
Statement Count: 69
~7.5 seconds in one query to get series_bug_count. ~4 seconds in the query for the bug listing. |
|
| 2011-01-12 16:57:19 |
Robert Collins |
launchpad: importance |
High |
Critical |
|
| 2011-01-16 22:26:07 |
Robert Collins |
description |
As lifeless said to report new bugs on timeouts now, here we go:
Edge: OOPS-1751ED185
Prod: OOPS-1751E213
https://bugs.edge.launchpad.net/ubuntu/+bugs?field.searchtext=grub_xputs&orderby=-importance&search=Search&field.status%3Alist=NEW&field.status%3Alist=INCOMPLETE_WITH_RESPONSE&field.status%3Alist=INCOMPLETE_WITHOUT_RESPONSE&field.status%3Alist=CONFIRMED&field.status%3Alist=TRIAGED&field.status%3Alist=INPROGRESS&field.status%3Alist=FIXCOMMITTED&field.assignee=&field.bug_reporter=&field.omit_dupes=on&field.has_patch=&field.has_no_package=
SQL time: 12539 ms
Non-sql time: 709 ms
Total time: 13248 ms
Statement Count: 69
~7.5 seconds in one query to get series_bug_count. ~4 seconds in the query for the bug listing. |
bug search across all ubuntu
recent:
OOPS-1842C1473
https://bugs.edge.launchpad.net/ubuntu/+bugs?field.searchtext=grub_xputs&orderby=-importance&search=Search&field.status%3Alist=NEW&field.status%3Alist=INCOMPLETE_WITH_RESPONSE&field.status%3Alist=INCOMPLETE_WITHOUT_RESPONSE&field.status%3Alist=CONFIRMED&field.status%3Alist=TRIAGED&field.status%3Alist=INPROGRESS&field.status%3Alist=FIXCOMMITTED&field.assignee=&field.bug_reporter=&field.omit_dupes=on&field.has_patch=&field.has_no_package=
SQL time: 12539 ms
Non-sql time: 709 ms
Total time: 13248 ms
Statement Count: 69
~7.5 seconds in one query to get series_bug_count. ~4 seconds in the query for the bug listing.
|
|
| 2011-02-02 03:04:16 |
Robert Collins |
description |
bug search across all ubuntu
recent:
OOPS-1842C1473
https://bugs.edge.launchpad.net/ubuntu/+bugs?field.searchtext=grub_xputs&orderby=-importance&search=Search&field.status%3Alist=NEW&field.status%3Alist=INCOMPLETE_WITH_RESPONSE&field.status%3Alist=INCOMPLETE_WITHOUT_RESPONSE&field.status%3Alist=CONFIRMED&field.status%3Alist=TRIAGED&field.status%3Alist=INPROGRESS&field.status%3Alist=FIXCOMMITTED&field.assignee=&field.bug_reporter=&field.omit_dupes=on&field.has_patch=&field.has_no_package=
SQL time: 12539 ms
Non-sql time: 709 ms
Total time: 13248 ms
Statement Count: 69
~7.5 seconds in one query to get series_bug_count. ~4 seconds in the query for the bug listing.
|
bug search across all ubuntu
recent:
OOPS-1842C1473
https://bugs.edge.launchpad.net/ubuntu/+bugs?field.searchtext=grub_xputs&orderby=-importance&search=Search&field.status%3Alist=NEW&field.status%3Alist=INCOMPLETE_WITH_RESPONSE&field.status%3Alist=INCOMPLETE_WITHOUT_RESPONSE&field.status%3Alist=CONFIRMED&field.status%3Alist=TRIAGED&field.status%3Alist=INPROGRESS&field.status%3Alist=FIXCOMMITTED&field.assignee=&field.bug_reporter=&field.omit_dupes=on&field.has_patch=&field.has_no_package=
SQL time: 12539 ms
Non-sql time: 709 ms
Total time: 13248 ms
Statement Count: 69
~7.5 seconds in one query to get series_bug_count. ~4 seconds in the query for the bug listing.
on staging:
Aggregate (cost=7733840.35..7733840.36 rows=1 width=0) (actual time=3435.484..3435.484 rows=1 loops=1)
-> Nested Loop Left Join (cost=0.00..7733840.31 rows=16 width=0) (actual time=3369.348..3435.474 rows=1 loops=1)
-> Nested Loop Left Join (cost=0.00..7733835.04 rows=16 width=4) (actual time=3369.343..3435.469 rows=1 loops=1)
-> Nested Loop (cost=0.00..7733830.41 rows=16 width=8) (actual time=3369.339..3435.464 rows=1 loops=1)
Join Filter: ((((bug.fti)::tsvector @@ '''kpassgen'''::tsquery) OR ((public.bugtask.fti)::tsvector @@ '''kpassgen'''::tsquery) OR (public.bugtask.targetnamecache ~~* '%kpassgen%'::text)) AND ((public.bugtask.status = 10) OR ((public.bugtask.status = 15) AND (bug.date_last_message IS NOT NULL) AND (public.bugtask.date_incomplete <= bug.date_last_message)) OR ((public.bugtask.status = 15) AND ((bug.date_last_message IS NULL) OR (public.bugtask.date_incomplete > bug.date_last_message))) OR (public.bugtask.status = 20) OR (public.bugtask.status = 21) OR (public.bugtask.status = 22) OR (public.bugtask.status = 25)))
-> Index Scan using bugtask__distribution__sourcepackagename__idx on bugtask (cost=0.00..75418.40 rows=158746 width=160) (actual time=0.099..1007.335 rows=184186 loops=1)
Index Cond: (distribution = 1)
Filter: ((status = 10) OR ((date_incomplete IS NOT NULL) AND (status = 15)) OR (status = 15) OR (status = 20) OR (status = 21) OR (status = 22) OR (status = 25))
-> Index Scan using bug_pkey on bug (cost=0.00..48.20 rows=1 width=386) (actual time=0.009..0.009 rows=0 loops=184186)
Index Cond: (bug.id = public.bugtask.bug)
Filter: ((bug.duplicateof IS NULL) AND ((NOT bug.private) OR (SubPlan 1)))
SubPlan 1
-> Unique (cost=46.10..46.11 rows=2 width=4) (actual time=0.046..0.046 rows=1 loops=8187)
-> Sort (cost=46.10..46.11 rows=2 width=4) (actual time=0.045..0.045 rows=1 loops=8187)
Sort Key: bugsubscription.bug
Sort Method: quicksort Memory: 25kB
-> Append (cost=0.00..46.09 rows=2 width=4) (actual time=0.027..0.042 rows=1 loops=8187)
-> Nested Loop (cost=0.00..33.34 rows=1 width=4) (actual time=0.025..0.031 rows=1 loops=8187)
-> Index Scan using bugsubscription_bug_idx on bugsubscription (cost=0.00..7.75 rows=4 width=8) (actual time=0.009..0.012 rows=4 loops=8187)
Index Cond: (bug = $0)
-> Index Scan using teamparticipation_team_key on teamparticipation (cost=0.00..6.39 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=29867)
Index Cond: ((public.teamparticipation.team = bugsubscription.person) AND (public.teamparticipation.person = 2497367))
-> Nested Loop (cost=0.00..12.73 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=8187)
-> Index Scan using bugtask__bug__idx on bugtask (cost=0.00..6.33 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=8187)
Index Cond: (bug = $0)
-> Index Scan using teamparticipation_team_key on teamparticipation (cost=0.00..6.39 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=8487)
Index Cond: ((public.teamparticipation.team = public.bugtask.assignee) AND (public.teamparticipation.person = 2497367))
-> Index Scan using sourcepackagename_pkey on sourcepackagename (cost=0.00..0.28 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1)
Index Cond: (public.bugtask.sourcepackagename = sourcepackagename.id)
-> Index Scan using product_pkey on product (cost=0.00..0.32 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1)
Index Cond: (public.bugtask.product = product.id)
Total runtime: 3435.810 ms
(32 rows)
for
SELECT COUNT(*)
FROM BugTask
LEFT JOIN Bug ON BugTask.bug = Bug.id
LEFT JOIN Product ON BugTask.product = Product.id
LEFT JOIN SourcePackageName ON BugTask.sourcepackagename = SourcePackageName.id
WHERE Bug.id = BugTask.bug
AND BugTask.distribution = 1
AND ((BugTask.status = 10)
OR (BugTask.status = 15)
AND (Bug.date_last_message IS NOT NULL
AND BugTask.date_incomplete <= Bug.date_last_message)
OR (BugTask.status = 15)
AND (Bug.date_last_message IS NULL
OR BugTask.date_incomplete > Bug.date_last_message)
OR (BugTask.status = 20)
OR (BugTask.status = 21)
OR (BugTask.status = 22)
OR (BugTask.status = 25))
AND Bug.duplicateof IS NULL
AND (Bug.fti @@ ftq('kpassgen')
OR BugTask.fti @@ ftq('kpassgen')
OR BugTask.targetnamecache ILIKE '%' || 'kpassgen' || '%')
AND (Bug.private = FALSE
OR EXISTS
(SELECT BugSubscription.bug
FROM BugSubscription,
TeamParticipation
WHERE TeamParticipation.person = 2497367
AND TeamParticipation.team = BugSubscription.person
AND BugSubscription.bug = Bug.id
UNION SELECT BugTask.bug
FROM BugTask,
TeamParticipation
WHERE TeamParticipation.person = 2497367
AND TeamParticipation.team = BugTask.assignee
AND BugTask.bug = Bug.id)); |
|
| 2011-02-06 22:12:25 |
Robert Collins |
branch linked |
|
lp:~lifeless/launchpad/bug-661988 |
|
| 2011-02-06 22:58:38 |
Robert Collins |
launchpad: assignee |
|
Robert Collins (lifeless) |
|
| 2011-02-09 06:01:39 |
Launchpad QA Bot |
launchpad: milestone |
|
11.02 |
|
| 2011-02-09 06:01:40 |
Launchpad QA Bot |
tags |
lp-bugs timeout |
lp-bugs qa-needstesting timeout |
|
| 2011-02-09 06:01:42 |
Launchpad QA Bot |
launchpad: status |
Triaged |
Fix Committed |
|
| 2011-02-09 06:13:30 |
Robert Collins |
tags |
lp-bugs qa-needstesting timeout |
lp-bugs qa-ok timeout |
|
| 2011-02-11 13:54:07 |
Curtis Hovey |
launchpad: status |
Fix Committed |
Fix Released |
|
