| 2010-07-25 09:55:12 |
Robert Collins |
description |
It is possible to search for bug tasks using structural_subscriber as an argument for example:
xswat = launchpad.people['ubuntu-x-swat']
tasks = ubuntu.searchTasks(structural_subscriber=xswat)
and this works fine. However, if an additional parameter is added like importance it results in a OOPS.
tasks = ubuntu.searchTasks(structural_subscriber=xswat,importance='High')
https://lp-oops.canonical.com/oops.py/?oopsid=OOPS-1626EC2715
LaunchpadTimeoutError: Statement: 'SELECT COUNT(*) FROM Bug, BugTask WHERE Bug.id = BugTask.bug AND BugTask.importance = 40 AND BugTask.distribution = 1 AND ((BugTask.status = 10) OR (BugTask.status = 15) \n AND (Bug.date_last_message IS NOT NULL\n AND BugTask.date_incomplete <=\n Bug.date_last_message)\n OR (BugTask.status = 15) \n AND (Bug.date_last_message IS NULL\n OR BugTask.date_incomplete >\n Bug.date_last_message)\n OR (BugTask.status = 20) OR (BugTask.status = 21) OR (BugTask.status = 22) OR (BugTask.status = 25)) AND Bug.duplicateof is NULL AND BugTask.distroseries is NULL AND BugTask.productseries is NULL AND BugTask.id IN (\n SELECT BugTask.id FROM BugTask, StructuralSubscription\n WHERE BugTask.product = StructuralSubscription.product\n AND StructuralSubscription.subscriber = 458651\n UNION ALL\n SELECT BugTask.id FROM BugTask, StructuralSubscription\n WHERE\n BugTask.distribution = StructuralSubscription.distribution\n AND BugTask.sourcepackagename =\n StructuralSubscription.sourcepackagename\n AND StructuralSubscription.subscriber = 458651\n UNION ALL\n SELECT BugTask.id FROM BugTask, StructuralSubscription\n WHERE\n BugTask.distroseries = StructuralSubscription.distroseries\n AND StructuralSubscription.subscriber = 458651\n UNION ALL\n SELECT BugTask.id FROM BugTask, StructuralSubscription\n WHERE\n BugTask.milestone = StructuralSubscription.milestone\n AND StructuralSubscription.subscriber = 458651\n UNION ALL\n SELECT BugTask.id FROM BugTask, StructuralSubscription\n WHERE\n BugTask.productseries = StructuralSubscription.productseries\n AND StructuralSubscription.subscriber = 458651\n UNION ALL\n SELECT BugTask.id FROM BugTask, StructuralSubscription, Product\n WHERE\n BugTask.product = Product.id\n AND Product.project = StructuralSubscription.project\n AND StructuralSubscription.subscriber = 458651\n UNION ALL\n SELECT BugTask.id FROM BugTask, StructuralSubscription\n WHERE\n BugTask.distribution = StructuralSubscription.distribution\n AND StructuralSubscription.sourcepackagename is NULL\n AND StructuralSubscription.subscriber = 458651) AND \n (Bug.private = FALSE OR EXISTS (\n SELECT BugSubscription.bug\n FROM BugSubscription, TeamParticipation\n WHERE TeamParticipation.person = 972620 AND\n BugSubscription.person = TeamParticipation.team AND\n BugSubscription.bug = Bug.id))\n AND (1=1)'<br />
Parameters:()<br />
Original error: QueryCanceledError('canceling statement due to statement timeout\n',) |
It is possible to search for bug tasks using structural_subscriber as an argument for example:
xswat = launchpad.people['ubuntu-x-swat']
tasks = ubuntu.searchTasks(structural_subscriber=xswat)
and this works fine. However, if an additional parameter is added like importance it results in a OOPS.
tasks = ubuntu.searchTasks(structural_subscriber=xswat,importance='High')
https://lp-oops.canonical.com/oops.py/?oopsid=OOPS-1626EC2715
SQL time: 17078 ms
Non-sql time: 121 ms
Total time: 17199 ms
Statement Count: 21
SELECT COUNT(*) FROM Bug, BugTask WHERE Bug.id = BugTask.bug AND BugTask.importance = 40 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 BugTask.distroseries is NULL AND BugTask.productseries is NULL AND BugTask.id IN ( SELECT BugTask.id FROM BugTask, StructuralSubscription WHERE BugTask.product = StructuralSubscription.product AND StructuralSubscription.subscriber = 458651 UNION ALL SELECT BugTask.id FROM BugTask, StructuralSubscription WHERE BugTask.distribution = StructuralSubscription.distribution AND BugTask.sourcepackagename = StructuralSubscription.sourcepackagename AND StructuralSubscription.subscriber = 458651 UNION ALL SELECT BugTask.id FROM BugTask, StructuralSubscription WHERE BugTask.distroseries = StructuralSubscription.distroseries AND StructuralSubscription.subscriber = 458651 UNION ALL SELECT BugTask.id FROM BugTask, StructuralSubscription WHERE BugTask.milestone = StructuralSubscription.milestone AND StructuralSubscription.subscriber = 458651 UNION ALL SELECT BugTask.id FROM BugTask, StructuralSubscription WHERE BugTask.productseries = StructuralSubscription.productseries AND StructuralSubscription.subscriber = 458651 UNION ALL SELECT BugTask.id FROM BugTask, StructuralSubscription, Product WHERE BugTask.product = Product.id AND Product.project = StructuralSubscription.project AND StructuralSubscription.subscriber = 458651 UNION ALL SELECT BugTask.id FROM BugTask, StructuralSubscription WHERE BugTask.distribution = StructuralSubscription.distribution AND StructuralSubscription.sourcepackagename is NULL AND StructuralSubscription.subscriber = 458651) AND (Bug.private = FALSE OR EXISTS ( SELECT BugSubscription.bug FROM BugSubscription, TeamParticipation WHERE TeamParticipation.person = 972620 AND BugSubscription.person = TeamParticipation.team AND BugSubscription.bug = Bug.id)) AND (1=1)
|
|
