https://www.growthbook.io/ logo
#ask-questions
Title
# ask-questions
a

adamant-river-54645

02/19/2024, 11:44 AM
hello! can you help please can we somehow change timeout settings for queries in the analytics section?
f

fresh-football-47124

02/19/2024, 4:19 PM
What are you experiencing? We don't have a timeout that I can think of- it might be on your DB side. How long are the queries running for?
a

adamant-river-54645

02/19/2024, 4:29 PM
sometimes we get timeout errors when calculating metrics or adding Fact Tables we thought that there are some internal Growthbook timeouts limits thank, we will check our DB settings
g

gray-daybreak-85246

03/02/2024, 4:16 PM
@fresh-football-47124 I think, I've found, where the timeout (60 seconds) is silently set: Inside the clickhouse client: https://github.com/TimonKK/clickhouse/blob/1e873270cc23a9079f1ac35655257d0b2f61ff68/index.js#L839 Is there a possibility to somehow add a
timeout
parameter to https://github.com/growthbook/growthbook/blob/main/packages/back-end/types/integrations/clickhouse.d.ts#L1 And use them here: https://github.com/growthbook/growthbook/blob/main/packages/back-end/src/integrations/ClickHouse.ts
👍 1
And there is also another problem: now growthbook relies on unofficial clickhouse client clickhouse, which hasn't been maintained for 2 years already 😱 But there is official client @clickhouse/client from the developers of ClickHouse.
f

fresh-football-47124

03/04/2024, 2:43 AM
Hi Andrey - would you mind opening an issue for updating the clickhouse library?
g

gray-daybreak-85246

03/05/2024, 3:55 PM
@fresh-football-47124 we have large amounts of data and a lot metrics easily take 2-3 minutes to calculate. Can we create a quick PR which increases clickhouse timeout from 60 sec to 300 sec ?
11 Views