Bug 584046 - RFE - try to limit dangerous queries
Summary: RFE - try to limit dangerous queries
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Beaker
Classification: Retired
Component: scheduler
Version: 0.5
Hardware: All
OS: Linux
low
medium
Target Milestone: ---
Assignee: Bill Peck
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2010-04-20 15:36 UTC by Bill Peck
Modified: 2010-04-29 18:52 UTC (History)
4 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2010-04-29 18:52:32 UTC
Embargoed:


Attachments (Terms of Use)

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


Note You need to log in before you can comment on or make changes to this bug.