Bug 584046

Summary:	RFE - try to limit dangerous queries
Product:	[Retired] Beaker	Reporter:	Bill Peck <bpeck>
Component:	scheduler	Assignee:	Bill Peck <bpeck>
Status:	CLOSED NOTABUG	QA Contact:
Severity:	medium	Docs Contact:
Priority:	low
Version:	0.5	CC:	bpeck, kbaker, mcsontos, rmancy
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2010-04-29 18:52:32 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Bill Peck 2010-04-20 15:36:07 UTC

Description of problem:

I've seen queries on the key/value table that end up doing 20 self joins which mysql doesn't handle well.

Couple things to try here.

1 - Identify possibly problem queries, count the number of joins being built and fail if the joins are over a configured limit.

2 - Implement a timeout so that we don't wait forever on a query.

Comment 1 Raymond Mancy 2010-04-20 23:02:52 UTC

The Search could be a problem in this regard. By adding more criteria to the search they can ramp up the query to their hearts content pretty much.

Comment 2 Bill Peck 2010-04-29 18:52:32 UTC

since the query plan has been updated this doesn't seem like a problem anymore.

closing