Skip to content
This repository has been archived by the owner on Jun 18, 2024. It is now read-only.

[BUG]Grafana 8.1+ compatibility #247

Open
taogejiang opened this issue Feb 9, 2022 · 1 comment
Open

[BUG]Grafana 8.1+ compatibility #247

taogejiang opened this issue Feb 9, 2022 · 1 comment

Comments

@taogejiang
Copy link

Dear @diafour , please check this problem, thanks very much .

  • env:
    Grafana version: Grafana v8.3.3
    flant-statusmap-panel version: 0.4.2
    Data source type & version: MySQL
    OS Grafana is installed on: Centos v7.9
    User OS & Browser: Windows 10 & Microsoft Edge

  • problem:

"failed to convert long to wide series when converting from dataframe: long series must be sorted ascending by time to be converted" in grafana v8.3.3
image

but it's ok in grafana v7.4.0
image

  • MySQL SQL:
    SELECT
    UNIX_TIMESTAMP(STR_TO_DATE(SUBSTR(trigger_time, 1, 8), '%Y%m%d')) AS time,
    concat(department,' - ',product_series,' - ',base_qgmr_version) AS metric,
    min(CASE ci_result WHEN 'FAIL' THEN 0 WHEN 'PASS' THEN 1 WHEN 'NONE' THEN 2 WHEN 'RUNNING' THEN 3 ELSE -1 END) AS "status"
    FROM qdevops_version_pipeline
    WHERE
    department='SW1'
    GROUP BY 1,2
    ORDER BY metric

Looking forward to your reply ^-^

Originally posted by @taogejiang in #230 (comment)

@diafour
Copy link
Collaborator

diafour commented Apr 7, 2022

Hello! It seems a bug in Grafana 8+: Grafana 8 failed to convert long to wide series when converting from dataframe

New release v0.5.0 supports DataFrames, please try it.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants