Comment 0 for bug 594247

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',)