sqlwatch
sqlwatch copied to clipboard
marcingminski
Dashboard - Grafana 8.0.x - Fail
Describe the bug We just migrated to Grafana 8.0.x
To Reproduce Steps to reproduce the behavior:
- Install Grafana 7.5.8
- Import SQL Instance Overview.json on Grafana
- Install Grafana 8.0.2
Screenshots
SqlWatch
SQL Instance Overview
Grafana 7.5.8
Grafana 8.0.2
There are more errors but it is enough to show the problem.
Did you raise this with Grafana? Does not sound like a Sqlwatch problem if it used to work in Grafana 7?
Btw, the error suggest waits are not sorted by time? Can you check the query and test with order by time?
I think the problem is more serious than the message says. I changed the "order by", but still had other problems. It needs more analyze to fix.
I wrote to Grafana support, but I don't have Grafana Enterprise to have support. I hope they will answer me.
By now, my workaround is rollback to Grafana 7.5.8, but to someone that arrives now, they will think that SqlWatch doesn't work with Grafana.
From your screenshot, I can see that it's the waits and checks that fail. These are the only ones not sorted by time. I am still sure it will work when you sort it by time.
@marcingminski
I have the same problem. After upgrading Grafana to 8.0. I think this should be mentioned in the documentation.
ERROR: failed to convert long to wide series when converting from dataframe: long series must be sorted ascending by time to be converted
Please can anyone try these V8 Dashboards? I tried them on V8 & V8.1 and soetimes get different result on Checks & Waits.
On latest Grafana V8 Version everything seem fine. Fixes on Instance Overview: Summary: Checks, Waits, Disk Used Table Memory: duplicate Column Error - replace the dupblicate Column "Page reads/sec" with missing "Readahead reads/sec"
On the Repository Dashboard the Datalinks on the Table are fixed to.
Please let me know if the Dashboards are ok, I'll create a Pull Request after validation.
Greetings from Germany Steffen
Hi @kekcjkee @marcingminski @sozezzo do you testet the dashboards?
Greetings from Hamburg Steffen
Unfortunately, my panels still have errors.
I have no time to check and to fix it, I use Grafana old version, and it is okay.
Hello I tested on Grafana 8.2.1 and the problem is gone
Hmm... On 8.3.4 I have still the issues @sozezzo mentions. O, then I was trying to fix it and fixed it partly and then happened to find out that there was a new Grafana 8.1.zip which solves it completely. Thanx @steffenengelhamburg .
