Search code examples
kdbq-lang

How to kill KDB queries in RDB or HDB?

We have a ticker plant and sometimes someone mistakenly runs queries in HDB without a date or in RDB without a time or with some other processing logic which may kill KDB. How can we find and kill the query without restarting KDB instance?

Solution

  • You can set client query time out in your service:

    param: '-T '

    reference: http://code.kx.com/q4m3/13_Commands_and_System_Variables/#13121-timeout-t

    From wiki: The timeout parameter (note upper case) is an int that specifies the number of seconds any call from a client will execute before it is timed out and terminated. The default value is 0 which means no timeout. This parameter corresponds to the command \T.

    Ex: start your q process as:

           q -T 40

    it will set client query timeout to 40 seconds.