timeout for long qsql queries

[Michael]

Is it possible to set a user timeout period for queries?

Some of our less experienced users send queries that try to pull back massive amounts of data causing the server to become unresponsive for other users. We would like to set a trigger that gives a ‘timeout error when a query is taking too long rather than locking up.

~Mike

[admin]

If you start kdb with the argument -T:

q -T 10

This will set a timeout on client queries of 10 seconds. Note not all queries are polite enough to stop when requested and I think commands at the console may ignore this setting.

You should also be able to modify this setting using
\T (seconds)
from within kdb.

[admin]

From the console you can use ctrl+c to break during a long running command:
http://www.timestored.com/kdb-guides/debugging-kdb#interrupt-q
Make sure to exit debug mode so the server answers client queries.

[Author]

Posts