400 Bad Request on retrieving 7 days of Sonicwall Stats

  • What Grafana version and what operating system are you using?

Grafana 10.0
Centos 7
MariaDB 5.5.68
Zabbix Plugin 4.4.1

  • What are you trying to achieve?

I have a Sonicwall Dashboard that shows data from a Zabbix MySQL. When I retrieve 6 days of data, everything fine. When I select 7 days it gives a No Data in the panels and it shows error 400 Bad request in logs

The retention policy is set on zabbix as 7 days.

  • What happened?

Error 400 Bad request and No Data in the panels

  • What did you expect to happen?

Show the 7 days of metrics

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

logger=context userId=1 orgId=1 uname=admin t=2023-09-27T16:34:44.732654247-03:00 level=info msg=“Request Completed” method=POST path=/api/ds/query status=400 remote_addr=192.168.25.134 time_ms=18420 duration=18.420074259s size=196 referer=“http://192.168.25.229:3000/d/LUGe50n7z/galafassi-sonicwall-nsa-3600?from=now-7d&orgId=1&to=now” handler=/api/ds/query
logger=context userId=1 orgId=1 uname=admin t=2023-09-27T16:34:47.516655402-03:00 level=info msg=“Request Completed” method=POST path=/api/ds/query status=400 remote_addr=192.168.25.134 time_ms=17728 duration=17.728074271s size=196 referer=“http://192.168.25.229:3000/d/LUGe50n7z/galafassi-sonicwall-nsa-3600?from=now-7d&orgId=1&to=now” handler=/api/ds/query
logger=context userId=1 orgId=1 uname=admin t=2023-09-27T16:34:55.090145854-03:00 level=info msg=“Request Completed” method=POST path=/api/ds/query status=400 remote_addr=192.168.25.134 time_ms=18405 duration=18.405069486s size=196
logger=context userId=1 orgId=1 uname=admin t=2023-09-27T16:35:03.038686115-03:00 level=info msg=“Request Completed” method=POST path=/api/ds/query status=400 remote_addr=192.168.25.134 time_ms=17995 duration=17.995061478s size=196 referer=“http://192.168.25.229:3000/d/LUGe50n7z/galafassi-sonicwall-nsa-3600?from=now-7d&orgId=1&to=now” handler=/api/ds/query
logger=context userId=1 orgId=1 uname=admin t=2023-09-27T16:35:03.039398538-03:00 level=info msg=“Request Completed” method=POST path=/api/ds/query status=400 remote_addr=192.168.25.134 time_ms=18140 duration=18.140730264s size=196

  • Did you follow any online instructions? If so, what is the URL?

I’ve recorded some videos that shows the problem: https://photos.app.goo.gl/r81nsekLDbDZu4sA6

How can I get more information about this 400 Bad request?

I enabled debug mode on logging file, but it shows the same amount of details than the normal mode

In Zabbix plugin settings the timeout is 60 seconds, and the connection drops at ~30s so it would not be the case I think

I’ve found out that the problem is the Zabbix template that I’m using in this particular Sonicwall, using a different one the problem is not happening.