getting "unexpected error happened" after using $__user.login variables in mysql query

[manjunath4038]

Hi Team,

I wrote a following query in mysql and see that the pie chart panel is crashing. it worked well without "${__user.login}".
SELECT now() as time, count(*) cnt, base.Class metric
FROM base
LEFT JOIN owner ON base.serial_No = owner.serial_No
where owner.current_owner_email = '${__user.login}' AND base.Class in ($Category)
group by base.Class
order by cnt desc

I changed the visualization to " Bar Gauge" and didn't

see the issue.

Please help to resolve this issue. I have latest version of Grafana and Pie chart panel
attaching the screen shot for the same.

[mikebdp2]

@manjunath4038 I noticed it crashes when there are too many of pie slices (>~10). Temporary solution: don't display the pie slices smaller than a certain size, or unite them to "Others".

[BGraco]

I am running Grafana 7.2.2 with version 1.6.1 of the pie chart plugin and am having the exact same issue. My chart only has 4 slices, so I don't think the work around above helps for me.

Example result: