Variable Query originating: "Error updating options: Maximum call stack size exceeded"

Grafana MySQL
,
1

Hi!
I have a dashboard with some panels that contain SQL queries that fetch results from a data source. One of this panels has a query which in turn use the results of a variable query in the ‘where’ condition.
Example:

select *
from my_datasource 
where my_datasource.id in ($list_of_ids)

In the example above the $list_of_ids is my variable query which is fetching results on another different datasource. This panel works fine if the results from the variable query are few (dozens or hundreds) but I have some cases where the variable query get hundreds of thousands results and when that happens I get the following error message: "Error updating options: Maximum call stack size exceeded"

Is there a way to solve this issue?

Thanks in advance!

2 Likes
2

The same thing happens to me, is there a solution for this error?

3

What happens if you take the query (check the Query Inspector) and run it outside of grafana in a query tool for MySQL?