Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add query timeout setting to the Web Console #135

Open
ideoma opened this issue May 11, 2023 · 1 comment
Open

Add query timeout setting to the Web Console #135

ideoma opened this issue May 11, 2023 · 1 comment
Labels
web-console Issues relevant to "web-console" package

Comments

@ideoma
Copy link
Contributor

ideoma commented May 11, 2023

Is your feature request related to a problem?

By default all SQL queries timeout after 60 seconds. While this is OK for the majority of them, sometimes there is a need to run longer queries, for example to copy tables.

Describe the solution you'd like.

Add a setting in the console to set the query timeout. Pass the timeout in each query header:

https://questdb.io/docs/reference/api/rest/#headers

This could be done in web console UI, after a user runs a query which hits a timeout. Consider the case in screenshot:

Screenshot 2023-05-12 at 16 00 11

At the bottom Log says timeout, query aborted [fd=104]. It would be useful to introduce some kind of a button to retry the query but with increased timeout limit.

Query used in screenshot:

CREATE TABLE readings AS(
  SELECT
    x ID,
    timestamp_sequence(
      to_timestamp('2019-10-17T00:00:00', 'yyyy-MM-ddTHH:mm:ss'),
      rnd_long(1, 10, 0) * 100000L
    ) ts,
    rnd_double(0) * 8 + 15 temp,
    rnd_long(0, 10000, 0) sensorId
  FROM
    long_sequence(100000000L) x
) TIMESTAMP(ts) PARTITION BY MONTH
@argshook argshook transferred this issue from questdb/questdb May 11, 2023
@argshook argshook added the web-console Issues relevant to "web-console" package label May 12, 2023
@argshook
Copy link
Contributor

to reproduce timeout this can be used:

  1. server.conf with query.timeout.sec=1 (or any other low value)
  2. select DISTINCT rnd_double() a from long_sequence(1000000000000L)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
web-console Issues relevant to "web-console" package
Projects
None yet
Development

No branches or pull requests

2 participants