dsharp
1
I have a query that is throwing the unknown error…and has been for hours. How do I address this?
;WITH dateInstances AS (
SELECT
EntryMonth
,InstanceCount
FROM cached_query_407999
WHERE EntryDate >= date(‘now’,’-1 month’)
GROUP BY instanceName
)
select * from dateInstances
I am able to run the actual query for “407999” and get results. Other queries work. What would be causing this?
k4s1m
2
Whoa. Query id 407999. You have more than 400k queries in your self-hosted instance? Are you certain that’s not a typo?
If not, how many results does query 407999 return?
dsharp
3
This isn’t self-hosted. Because it is from the shared server I wasn’t sure what others could access. The real query returns fewer than 50 results.
k4s1m
4
If you’re on SaaS Redash you might check with their support team. Could be a performance issues outside your control.
One debugging step: replace cached_query with query and see if that makes a difference.