Increasing query execution time

[santurini]

I added the starburst driver to my metabase deployment and I am experiencing issues with queries who take a long time.
In particular for short queries everything works fine while for queries over a certain amount of time the queries just gets cancelled (USER_CANCELLED from the Trino UI) and I'm not able to display the table on Metabase.

How can I change the max execution time for the driver and what is the default value?

Driver version: starburst-5.0.0.metabase-driver.jar

[lpoulain]

The max execution time would be on the server side (see https://trino.io/docs/current/admin/properties-query-management.html)

[santurini]

I haven't touched those values and the default is 5 minutes, however it fails much earlier than 5 minutes, any guess why it could happen? Using the CLI instead of Metabase returns no errors

[lpoulain]

For your information I was able to reproduce this, and am researching the root cause of the issue.

[santurini]

Thank you very much!

[lpoulain]

Thanks to the help of the Metabase folks we were able to identify the root cause of the issue (Metabase things the connection is idle so cancels the query). A PR to fix the problem was just filed.

[santurini]

Great news, thank you again! Can you close the issue once it is merged?

[lpoulain]

Version 6.1.0 has just been released and contains the fix