databendcloud / metabase-databend-driver

Databend database driver for the Metabase business intelligence front-end
Apache License 2.0
4 stars 2 forks source link

If the SQL execution time exceeds 10 seconds, retry is triggered and the correct result cannot be receviced #2

Closed wubx closed 1 year ago

wubx commented 1 year ago

Repeat:

select sleep(11) a;

Error executing query: Error fetching next (attempts: 6, duration: PT1M1.712153625S)cause: java.io.UncheckedIOException: java.net.SocketTimeoutException: Read timed out

flaneur2020 commented 1 year ago

@hantmac I remember there have a timeout argument in the jdbc driver, maybe can make it a bigger value by default?

hantmac commented 1 year ago

@hantmac I remember there have a timeout argument in the jdbc driver, maybe can make it a bigger value by default?

Yes, connection_timeout was set default 15s. But this problem seems triggered by metabase 🤔.

hantmac commented 1 year ago

I will try to fix this problem by adding the socket_timeout param in jdbc.

hantmac commented 1 year ago

img_v2_9ad64cf9-403c-4189-9e01-68aaf422da8g Fixed.