Filip Charikov
07/16/2024, 3:35 PMExplore from here
. For users it just opens a blank white frame while loading. It then hangs for more than 2 minutes. After that it loads like nothing happened. The console log however returns this: {status: 400, detail: A result cache error has occurred during the calculation of the result', resultId: 'a2b3ab1736e4df31873267202601067895a68b9f', reason: 'Query timeout occurred', traceId: 'c6bec71c898bb582e99144fa7a78fd0d'}detail: "A result cache error has occurred during the calculation of the result"reason: "Query timeout occurred"resultId: "a2b3ab1736e4df31873267202601067895a68b9f"status: 400traceId: "c6bec71c898bb582e99144fa7a78fd0d"
So what I think its trying to do is to load the chart using cache/preload but fails so it's recalculating?
We need help on this - waiting for 2+ minutes for explore from here is seriously frustrating our customers.Julius Kos
07/16/2024, 5:20 PMExecution of SQL statement was cancelled due to timeout
Julius Kos
07/16/2024, 5:20 PMStart time
, Duration
and SQL
, would it be possible to include and/or verify the query queue time as well as the queue priority? The idea here is to verify that the query queue time plus the execution/duration time are not longer than 30s on the database side and that the queries have the sufficient priority.
• Are there any workload management rules or specific setup on the database side that might impact the query priority or the time it spends in the queue?