Issue Details (XML | Word | Printable)

Key: CORE-658
Type: New Feature New Feature
Status: Closed Closed
Resolution: Duplicate
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Pavel Cisar
Votes: 13
Watchers: 10
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Query timeout on the server

Created: 17/Sep/03 12:00 AM   Updated: 22/Feb/17 03:26 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 4.0 Alpha 1

Issue Links:
Relate
 
Replace
 

SF_ID: 807910
Target: 2.5.0


 Description  « Hide
SFID: 807910#
Submitted By: pcisar

The server should have built-in support to ensure that
a query cannot run 'away'. A parameter in the server
config file should establish the maximum query
execution time.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pabloj added a comment - 25/Aug/08 01:21 PM
It would also be nice to have per user "quotas" in resources or max allowed query cost

pabloj added a comment - 19/Oct/09 05:46 PM
I see this is planned for 3.0 Alpha , could you give details on what will be implemented?
A server timeout variable? A user/group/role quota?
Thanks in advance

Dmitry Yemanov added a comment - 19/Oct/09 06:10 PM
I was thinking about the following timeout values:

  - database-level (specified in firebird.conf)
  - transaction-level (specified via TPB) -- which, if exists, overrides the database one

As for quotas, they belong to a much wider topic (including also CPU load, memory and disk space usage, etc) and thus require more thinking. They, if considered, should go into a separate ticket, IMO.

Mark Rotteveel added a comment - 17/Apr/14 06:02 PM
In for example JDBC the query timeout is a property of the statement handle, and similar in ADO.net and ODBC. This also feels like a more natural place than database- or transaction level.

PizzaProgram Ltd. added a comment - 22/Jan/17 10:35 AM
Possible merge with CORE-985 http://tracker.firebirdsql.org/browse/CORE-985
Query timeouts of DB / TR could be a sub-feature through MON&DATABASE.