400 Bad Request on retrieving 7 days of Sonicwall Stats

Grafana MySQL
1
  • 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?
2

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

3

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

4

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.