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' ] searchTasks( structural_ subscriber= xswat)
tasks = ubuntu.
and this works fine. However, if an additional parameter is added like importance it results in a OOPS.
tasks = ubuntu. searchTasks( structural_ subscriber= xswat,importanc e='High' )
https:/ /lp-oops. canonical. com/oops. py/?oopsid= OOPS-1626EC2715
LaunchpadTimeou tError: 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, StructuralSubsc ription\ n WHERE BugTask.product = StructuralSubsc ription. product\ n AND StructuralSubsc ription. subscriber = 458651\n UNION ALL\n SELECT BugTask.id FROM BugTask, StructuralSubsc ription\ n WHERE\n BugTask. distribution = StructuralSubsc ription. distribution\ n AND BugTask. sourcepackagena me =\n StructuralSubsc ription. sourcepackagena me\n AND StructuralSubsc ription. subscriber = 458651\n UNION ALL\n SELECT BugTask.id FROM BugTask, StructuralSubsc ription\ n WHERE\n BugTask. distroseries = StructuralSubsc ription. distroseries\ n AND StructuralSubsc ription. subscriber = 458651\n UNION ALL\n SELECT BugTask.id FROM BugTask, StructuralSubsc ription\ n WHERE\n BugTask.milestone = StructuralSubsc ription. milestone\ n AND StructuralSubsc ription. subscriber = 458651\n UNION ALL\n SELECT BugTask.id FROM BugTask, StructuralSubsc ription\ n WHERE\n BugTask. productseries = StructuralSubsc ription. productseries\ n AND StructuralSubsc ription. subscriber = 458651\n UNION ALL\n SELECT BugTask.id FROM BugTask, StructuralSubsc ription, Product\n WHERE\n BugTask.product = Product.id\n AND Product.project = StructuralSubsc ription. project\ n AND StructuralSubsc ription. subscriber = 458651\n UNION ALL\n SELECT BugTask.id FROM BugTask, StructuralSubsc ription\ n WHERE\n BugTask. distribution = StructuralSubsc ription. distribution\ n AND StructuralSubsc ription. sourcepackagena me is NULL\n AND StructuralSubsc ription. subscriber = 458651) AND \n (Bug.private = FALSE OR EXISTS (\n SELECT BugSubscription .bug\n FROM BugSubscription, TeamParticipation\n WHERE TeamParticipati on.person = 972620 AND\n BugSubscription .person = TeamParticipati on.team AND\n BugSubscription.bug = Bug.id))\n AND (1=1)'<br /> ror('canceling statement due to statement timeout\n',)
Parameters:()<br />
Original error: QueryCanceledEr