Grafana dashboards not displayed with influxdb2

[j-zarp]

Thanks for Glances, it is a great tool I've been using for a long time without any problem. Unfortunately, I am now confronted with an issue when I try to switch to influxdb2.

Describe the bug
Graphana can connect and read from influxDB but cannot read and display the data from influxdb2.
The relevant log line is:

msg="Flux query failed" logger=tsdb.influx_flux err="invalid: compilation failed: error at @1:13-1:22: string literal key cpucore must
have a value\nerror at @1:43-1:44: invalid statement: $\nerror at @1:69-1:78: unexpected token for property key: ILLEGAL ($)"
query="SELECT mean(\"cpucore\") FROM \".load\" WHERE $timeFilter GROUP BY time($interval)"

It seems the original dashboard queries are not supported. Is it necessary to adapt the json file with flux queries for influxdb2?

To Reproduce
Steps to reproduce the behavior:

1. Start glances, influxdb and graphana with docker-compose (see yaml below)
2. Create a graphana dashboard with the json import feature and this source
3. Open the dashboard

Expected behavior
Dashboard items are displayed.

Desktop (please complete the following information):

• OS: Debian 10 & 11
• Glances v3.2.4_beta03 with PsUtil v5.8.0
• Glances logs file: see below
• Glances test:

======================================================================================
Glances 3.2.4_beta03 (/glances/glances/__init__.py)
Python 3.9.8 (/usr/local/bin/python3)
PsUtil 5.8.0 (/usr/local/lib/python3.9/site-packages/psutil/__init__.py)
======================================================================================
alert         [OK]    0.00001s []
amps          [OK]    0.00006s []
cloud         [OK]    0.00005s {}
connections   [OK]    0.03388s {'LISTEN': 7, 'ESTABLISHED': 7, 'SYN_SENT': 0, 'SYN_RECV': 0, 'initiated': 0, 'terminated': 0, 'nf_conntrack_count': 43.0, 'nf_conntrack_max': 262144.0, 'nf_
core          [OK]    0.00123s {'phys': 4, 'log': 4}
cpu           [OK]    0.00447s {'total': 6.4, 'user': 5.5, 'nice': 0.0, 'system': 0.7, 'idle': 93.5, 'iowait': 0.2, 'irq': 0.0, 'softirq': 0.1, 'steal': 0.0, 'guest': 0.0, 'guest_nice': 0.
diskio        [OK]    0.00075s key=disk_name [{'time_since_update': 3.114305257797241, 'disk_name': 'sda', 'read_count': 0, 'write_count': 0, 'read_bytes': 0, 'write_bytes': 0, 'key': 'dis
docker        [OK]    0.05854s key=name [{'key': 'name', 'name': 'glances_glances_1', 'Names': ['glances_glances_1'], 'Id': 'fcd53f07c7ab28d547e1890e44ba5c664bf048ef08320b0e328477431fbebe8
folders       [OK]    0.00010s []
fs            [OK]    0.00114s key=mnt_point [{'device_name': '/dev/sda1', 'fs_type': 'ext4', 'mnt_point': '/etc/resolv.conf', 'size': 39051653120, 'used': 20459331584, 'free': 16585039872
gpu           [OK]    0.00022s []
help          [OK]    0.00004s None
ip            [OK]    0.00052s {'address': '10.0.2.15', 'mask': '255.255.255.0', 'mask_cidr': 24, 'gateway': '10.0.2.2', 'public_address': '155.105.149.45'}
irq           [OK]    0.00066s key=irq_line [{'irq_line': 'LOC', 'irq_rate': 2095, 'key': 'irq_line', 'time_since_update': 3.175410270690918}, {'irq_line': 'RES', 'irq_rate': 1128, 'key': 
load          [OK]    0.00012s {'min1': 0.42, 'min5': 0.24, 'min15': 0.12, 'cpucore': 4}
mem           [OK]    0.00027s {'total': 10272305152, 'available': 8165806080, 'percent': 20.5, 'used': 2106499072, 'free': 8165806080, 'active': 2211659776, 'inactive': 952766464, 'buffer
memswap       [OK]    0.00047s {'total': 4228902912, 'used': 0, 'free': 4228902912, 'percent': 0.0, 'sin': 0, 'sout': 0, 'time_since_update': 3.3927061557769775}
network       [OK]    0.00094s key=interface_name [{'interface_name': 'veth4a47129', 'alias': None, 'time_since_update': 3.106832981109619, 'cumulative_rx': 15674, 'rx': 0, 'cumulative_tx'
now           [OK]    0.00002s 2021-11-25 15:49:35 UTC
percpu        [OK]    0.00088s key=cpu_number [{'key': 'cpu_number', 'cpu_number': 0, 'total': 6.9, 'user': 6.3, 'system': 0.6, 'idle': 93.1, 'nice': 0.0, 'iowait': 0.0, 'irq': 0.0, 'softi
ports         [OK]    0.00036s []
processcount  [OK]    0.09218s {'total': 188, 'running': 1, 'sleeping': 142, 'thread': 703, 'pid_max': 0}
processlist   [OK]    0.00040s key=pid [{'pid': 1836, 'status': 'S', 'name': 'gnome-shell', 'memory_percent': 2.984783604683943, 'cpu_times': pcputimes(user=537.29, system=35.57, children_
psutilversion [OK]    0.00022s (5, 8, 0)
quicklook     [OK]    0.00092s {'cpu': 6.4, 'percpu': [{'key': 'cpu_number', 'cpu_number': 0, 'total': 6.9, 'user': 6.3, 'system': 0.6, 'idle': 93.1, 'nice': 0.0, 'iowait': 0.0, 'irq': 0.0
raid          [OK]    0.00046s {}
sensors       [OK]    0.00011s key=label [{'label': 'BAT BAT0', 'value': 100, 'unit': '%', 'type': 'battery', 'key': 'label'}]
smart         [OK]    0.13669s [{'DeviceName': 'sda VBOX HARDDISK'}]
system        [OK]    0.00003s {'os_name': 'Linux', 'hostname': 'debian', 'platform': '64bit', 'linux_distro': 'Debian GNU/Linux 10', 'os_version': '4.19.0-18-amd64', 'hr_name': 'Debian GN
uptime        [OK]    0.00045s {'seconds': 98696}
wifi          [OK]    0.00029s []

Additional context
docker-compose.yml :

version: "3.5"
services:
  glances:
    image: nicolargo/glances:dev
    restart: unless-stopped
    environment:
      # with influxdb and Grafana as interface
      - GLANCES_OPT=-q --export influxdb2 --time 10
    pid: "host"
    privileged: true
    network_mode: "host"
    depends_on:
      - influxdb
    volumes:
      - /var/run/docker.sock:/var/run/docker.sock:ro
      - ./glances.conf:/glances/conf/glances.conf

  influxdb:
    image: influxdb
    restart: unless-stopped
    ports:
      - 8086:8086
    environment:
      - DOCKER_INFLUXDB_INIT_MODE=setup
      - DOCKER_INFLUXDB_INIT_USERNAME=root
      - DOCKER_INFLUXDB_INIT_PASSWORD=MyPassword
      - DOCKER_INFLUXDB_INIT_ORG=nicolargo
      - DOCKER_INFLUXDB_INIT_BUCKET=glances
      - DOCKER_INFLUXDB_INIT_RETENTION=4w
      - DOCKER_INFLUXDB_INIT_ADMIN_TOKEN=MyToken
    volumes:
      - ./influx_data:/var/lib/influxdb2
      - ./influx_config:/etc/influxdb2
    networks:
      - grafana_network

  grafana:
    image: grafana/grafana
    restart: unless-stopped
    ports:
      - 8080:3000
    user: "1000"
    volumes:
      - ./grafana_data:/var/lib/grafana
    networks:
      - grafana_network

networks:
  grafana_network:
    name: grafana_network
    driver: bridge
    driver_opts:
      com.docker.network.bridge.name: br_grafana

glances.conf:

[...]
[influxdb2]
# Configuration for the --export influxdb2 option
# https://influxdb.com/
host=localhost
port=8086
protocol=http
org=nicolargo
bucket=glances
token=MyToken
# Prefix will be added for all measurement name
# Ex: prefix=foo
#     => foo.cpu
#     => foo.mem
# You can also use dynamic values
#prefix=foo
# Followings tags will be added for all measurements
# You can also use dynamic values.
# Note: hostname is always added as a tag
#tags=foo:bar,spam:eggs,domain:`domainname`
[...]

logs:

Starting glances_influxdb_1 ... done
Starting glances_grafana_1  ... done
Starting glances_glances_1  ... done
Attaching to glances_grafana_1, glances_influxdb_1, glances_glances_1
grafana_1   | Error checking server process execution privilege. error: could not get current OS user to detect process privileges
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=warn msg="falling back to legacy setting of 'min_interval_seconds'; please use the configuration option in the `unified_alerting` section if Grafana 8 alerts are enabled." logger=settings
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=warn msg="falling back to legacy setting of 'min_interval_seconds'; please use the configuration option in the `unified_alerting` section if Grafana 8 alerts are enabled." logger=settings
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Config loaded from" logger=settings file=/usr/share/grafana/conf/defaults.ini
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Config loaded from" logger=settings file=/etc/grafana/grafana.ini
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.data=/var/lib/grafana"
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.logs=/var/log/grafana"
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.plugins=/var/lib/grafana/plugins"
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.provisioning=/etc/grafana/provisioning"
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.log.mode=console"
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_DATA=/var/lib/grafana"
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_LOGS=/var/log/grafana"
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_PLUGINS=/var/lib/grafana/plugins"
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_PROVISIONING=/etc/grafana/provisioning"
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Path Home" logger=settings path=/usr/share/grafana
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Path Data" logger=settings path=/var/lib/grafana
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Path Logs" logger=settings path=/var/log/grafana
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Path Plugins" logger=settings path=/var/lib/grafana/plugins
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Path Provisioning" logger=settings path=/etc/grafana/provisioning
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="App mode production" logger=settings
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Starting DB migrations" logger=migrator
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="migrations completed" logger=migrator performed=0 skipped=346 duration=654.087µs
grafana_1   | t=2021-11-23T15:25:15+0000 lvl=info msg="Starting plugin search" logger=plugins
grafana_1   | t=2021-11-23T15:25:16+0000 lvl=info msg="Registering plugin" logger=plugins id=input
grafana_1   | t=2021-11-23T15:25:16+0000 lvl=info msg="Live Push Gateway initialization" logger=live.push_http
grafana_1   | t=2021-11-23T15:25:16+0000 lvl=info msg="HTTP Server Listen" logger=http.server address=[::]:3000 protocol=http subUrl= socket=
influxdb_1  | 2021-11-23T15:25:16.425968555Z    info    found existing boltdb file, skipping setup wrapper  {"system": "docker", "bolt_path": "/var/lib/influxdb2/influxd.bolt"}
influxdb_1  | ts=2021-11-23T15:25:16.583894Z lvl=info msg="Welcome to InfluxDB" log_id=0X~MGPeW000 version=2.1.1 commit=657e1839de build_date=2021-11-09T03:03:48Z
influxdb_1  | ts=2021-11-23T15:25:16.587581Z lvl=info msg="Resources opened" log_id=0X~MGPeW000 service=bolt path=/var/lib/influxdb2/influxd.bolt
influxdb_1  | ts=2021-11-23T15:25:16.587632Z lvl=info msg="Resources opened" log_id=0X~MGPeW000 service=sqlite path=/var/lib/influxdb2/influxd.sqlite
influxdb_1  | ts=2021-11-23T15:25:16.614565Z lvl=info msg="Checking InfluxDB metadata for prior version." log_id=0X~MGPeW000 bolt_path=/var/lib/influxdb2/influxd.bolt
influxdb_1  | ts=2021-11-23T15:25:16.615258Z lvl=info msg="Using data dir" log_id=0X~MGPeW000 service=storage-engine service=store path=/var/lib/influxdb2/engine/data
influxdb_1  | ts=2021-11-23T15:25:16.617363Z lvl=info msg="Compaction settings" log_id=0X~MGPeW000 service=storage-engine service=store max_concurrent_compactions=2 throughput_bytes_per_second=50331648 throughput_bytes_per_second_burst=50331648
influxdb_1  | ts=2021-11-23T15:25:16.617389Z lvl=info msg="Open store (start)" log_id=0X~MGPeW000 service=storage-engine service=store op_name=tsdb_open op_event=start
influxdb_1  | ts=2021-11-23T15:25:16.649451Z lvl=info msg="TSI log compaction (start)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=5 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=start
influxdb_1  | ts=2021-11-23T15:25:16.649851Z lvl=info msg="TSI log compaction (start)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=7 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=start
influxdb_1  | ts=2021-11-23T15:25:16.650347Z lvl=info msg="Log file compacted" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=7 op_name=tsi1_compact_log_file tsi1_log_file_id=1 elapsed=0ms bytes=505 kb_per_sec=952
influxdb_1  | ts=2021-11-23T15:25:16.650495Z lvl=info msg="TSI log compaction (end)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=7 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=end op_elapsed=0.653ms
influxdb_1  | ts=2021-11-23T15:25:16.650692Z lvl=info msg="TSI log compaction (start)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=4 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=start
influxdb_1  | ts=2021-11-23T15:25:16.650750Z lvl=info msg="Log file compacted" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=5 op_name=tsi1_compact_log_file tsi1_log_file_id=1 elapsed=2ms bytes=1044 kb_per_sec=501
influxdb_1  | ts=2021-11-23T15:25:16.650869Z lvl=info msg="TSI log compaction (end)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=5 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=end op_elapsed=2.150ms
influxdb_1  | ts=2021-11-23T15:25:16.651145Z lvl=info msg="TSI log compaction (start)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=2 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=start
influxdb_1  | ts=2021-11-23T15:25:16.651388Z lvl=info msg="TSI log compaction (start)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=8 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=start
influxdb_1  | ts=2021-11-23T15:25:16.651532Z lvl=info msg="Log file compacted" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=4 op_name=tsi1_compact_log_file tsi1_log_file_id=1 elapsed=0ms bytes=1755 kb_per_sec=2003
influxdb_1  | ts=2021-11-23T15:25:16.651594Z lvl=info msg="TSI log compaction (end)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=4 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=end op_elapsed=0.917ms
influxdb_1  | ts=2021-11-23T15:25:16.651242Z lvl=info msg="TSI log compaction (start)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=6 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=start
influxdb_1  | ts=2021-11-23T15:25:16.652921Z lvl=info msg="Log file compacted" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=2 op_name=tsi1_compact_log_file tsi1_log_file_id=1 elapsed=1ms bytes=2114 kb_per_sec=1158
influxdb_1  | ts=2021-11-23T15:25:16.653485Z lvl=info msg="TSI log compaction (end)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=2 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=end op_elapsed=2.348ms
influxdb_1  | ts=2021-11-23T15:25:16.651889Z lvl=info msg="TSI log compaction (start)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=3 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=start
influxdb_1  | ts=2021-11-23T15:25:16.666433Z lvl=info msg="Log file compacted" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=6 op_name=tsi1_compact_log_file tsi1_log_file_id=1 elapsed=15ms bytes=1088 kb_per_sec=69
influxdb_1  | ts=2021-11-23T15:25:16.666525Z lvl=info msg="Log file compacted" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=3 op_name=tsi1_compact_log_file tsi1_log_file_id=1 elapsed=14ms bytes=1105 kb_per_sec=73
influxdb_1  | ts=2021-11-23T15:25:16.666898Z lvl=info msg="TSI log compaction (end)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=6 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=end op_elapsed=15.660ms
influxdb_1  | ts=2021-11-23T15:25:16.652092Z lvl=info msg="TSI log compaction (start)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=1 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=start
influxdb_1  | ts=2021-11-23T15:25:16.667314Z lvl=info msg="TSI log compaction (end)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=3 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=end op_elapsed=15.432ms
influxdb_1  | ts=2021-11-23T15:25:16.675954Z lvl=info msg="Log file compacted" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=8 op_name=tsi1_compact_log_file tsi1_log_file_id=1 elapsed=24ms bytes=988 kb_per_sec=38
influxdb_1  | ts=2021-11-23T15:25:16.676147Z lvl=info msg="TSI log compaction (end)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=8 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=end op_elapsed=25.021ms
influxdb_1  | ts=2021-11-23T15:25:16.698387Z lvl=info msg="index opened with 8 partitions" log_id=0X~MGPeW000 service=storage-engine index=tsi
influxdb_1  | ts=2021-11-23T15:25:16.698747Z lvl=info msg="Log file compacted" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=1 op_name=tsi1_compact_log_file tsi1_log_file_id=1 elapsed=46ms bytes=1372 kb_per_sec=28
influxdb_1  | ts=2021-11-23T15:25:16.698958Z lvl=info msg="TSI log compaction (end)" log_id=0X~MGPeW000 service=storage-engine index=tsi tsi1_partition=1 op_name=tsi1_compact_log_file tsi1_log_file_id=1 op_event=end op_elapsed=46.870ms
influxdb_1  | ts=2021-11-23T15:25:16.701010Z lvl=info msg="Reading file" log_id=0X~MGPeW000 service=storage-engine engine=tsm1 service=cacheloader path=/var/lib/influxdb2/engine/wal/0801d29755d931c6/autogen/1/_00001.wal size=583468
influxdb_1  | ts=2021-11-23T15:25:16.768051Z lvl=info msg="Opened shard" log_id=0X~MGPeW000 service=storage-engine service=store op_name=tsdb_open index_version=tsi1 path=/var/lib/influxdb2/engine/data/0801d29755d931c6/autogen/1 duration=132.381ms
influxdb_1  | ts=2021-11-23T15:25:16.769104Z lvl=info msg="Open store (end)" log_id=0X~MGPeW000 service=storage-engine service=store op_name=tsdb_open op_event=end op_elapsed=151.717ms
influxdb_1  | ts=2021-11-23T15:25:16.769133Z lvl=info msg="Starting retention policy enforcement service" log_id=0X~MGPeW000 service=retention check_interval=30m
influxdb_1  | ts=2021-11-23T15:25:16.769143Z lvl=info msg="Starting precreation service" log_id=0X~MGPeW000 service=shard-precreation check_interval=10m advance_period=30m
influxdb_1  | ts=2021-11-23T15:25:16.769178Z lvl=info msg="Starting query controller" log_id=0X~MGPeW000 service=storage-reads concurrency_quota=1024 initial_memory_bytes_quota_per_query=9223372036854775807 memory_bytes_quota_per_query=9223372036854775807 max_memory_bytes=0 queue_size=1024
influxdb_1  | ts=2021-11-23T15:25:16.773706Z lvl=info msg="Configuring InfluxQL statement executor (zeros indicate unlimited)." log_id=0X~MGPeW000 max_select_point=0 max_select_series=0 max_select_buckets=0
influxdb_1  | ts=2021-11-23T15:25:17.073219Z lvl=info msg=Listening log_id=0X~MGPeW000 service=tcp-listener transport=http addr=:8086 port=8086
influxdb_1  | ts=2021-11-23T15:25:17.073267Z lvl=info msg=Starting log_id=0X~MGPeW000 service=telemetry interval=8h
influxdb_1  | ts=2021-11-23T15:25:38.263106Z lvl=info msg="index opened with 8 partitions" log_id=0X~MGPeW000 service=storage-engine index=tsi
influxdb_1  | ts=2021-11-23T15:25:38.263889Z lvl=info msg="Reindexing TSM data" log_id=0X~MGPeW000 service=storage-engine engine=tsm1 db_shard_id=2
influxdb_1  | ts=2021-11-23T15:25:38.263914Z lvl=info msg="Reindexing WAL data" log_id=0X~MGPeW000 service=storage-engine engine=tsm1 db_shard_id=2
grafana_1   | t=2021-11-23T15:25:51+0000 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=GET path=/api/live/ws status=0 remote_addr=172.19.0.1 time_ms=0 size=0 referer=
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=warn msg="Flux query failed" logger=tsdb.influx_flux err="invalid: error @1:1-1:5: undefined identifier show\n\nerror @1:6-1:9: undefined identifier tag\n\nerror @1:10-1:16: undefined identifier values\n\nerror @1:17-1:21: undefined identifier with" query="show tag values with key=\"interface_name\""
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=POST path=/api/ds/query status=400 remote_addr=172.19.0.1 time_ms=23 size=395 referer="http://localhost:8080/d/000000002/glances?orgId=1&refresh=5s"
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=warn msg="Flux query failed" logger=tsdb.influx_flux err="invalid: error @1:1-1:5: undefined identifier show\n\nerror @1:6-1:9: undefined identifier tag\n\nerror @1:10-1:16: undefined identifier values\n\nerror @1:17-1:21: undefined identifier with" query="show tag values with key=\"name\""
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=POST path=/api/ds/query status=400 remote_addr=172.19.0.1 time_ms=27 size=385 referer="http://localhost:8080/d/000000002/glances?orgId=1&refresh=5s"
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=warn msg="Flux query failed" logger=tsdb.influx_flux err="invalid: error @1:1-1:5: undefined identifier show\n\nerror @1:6-1:9: undefined identifier tag\n\nerror @1:10-1:16: undefined identifier values\n\nerror @1:17-1:21: undefined identifier with" query="show tag values with key=\"disk_name\""
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=POST path=/api/ds/query status=400 remote_addr=172.19.0.1 time_ms=28 size=390 referer="http://localhost:8080/d/000000002/glances?orgId=1&refresh=5s"
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=warn msg="Flux query failed" logger=tsdb.influx_flux err="invalid: error @1:1-1:5: undefined identifier show\n\nerror @1:6-1:9: undefined identifier tag\n\nerror @1:10-1:16: undefined identifier values\n\nerror @1:17-1:21: undefined identifier with" query="show tag values with key=\"hostname\""
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=POST path=/api/ds/query status=400 remote_addr=172.19.0.1 time_ms=50 size=389 referer="http://localhost:8080/d/000000002/glances?orgId=1&refresh=5s"
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=info msg="Initialized channel handler" logger=live channel=grafana/dashboard/uid/000000002 address=grafana/dashboard/uid/000000002
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=warn msg="Flux query failed" logger=tsdb.influx_flux err="invalid: compilation failed: error at @1:13-1:22: string literal key cpucore must have a value\nerror at @1:43-1:44: invalid statement: $\nerror at @1:69-1:78: unexpected token for property key: ILLEGAL ($)" query="SELECT mean(\"cpucore\") FROM \".load\" WHERE $timeFilter GROUP BY time($interval)"
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=POST path=/api/ds/query status=400 remote_addr=172.19.0.1 time_ms=2 size=422 referer="http://localhost:8080/d/000000002/glances?orgId=1&refresh=5s"
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=warn msg="Flux query failed" logger=tsdb.influx_flux err="invalid: compilation failed: error at @1:13-1:20: string literal key total must have a value\nerror at @1:49-1:50: invalid statement: $\nerror at @1:75-1:84: unexpected token for property key: ILLEGAL ($)" query="SELECT mean(\"total\") FROM \".processcount\" WHERE $timeFilter GROUP BY time($interval)"
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=POST path=/api/ds/query status=400 remote_addr=172.19.0.1 time_ms=1 size=426 referer="http://localhost:8080/d/000000002/glances?orgId=1&refresh=5s"
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=warn msg="Flux query failed" logger=tsdb.influx_flux err="invalid: compilation failed: error at @1:13-1:24: string literal key /.percent must have a value\nerror at @1:43-1:44: invalid statement: $\nerror at @1:69-1:78: unexpected token for property key: ILLEGAL ($)" query="SELECT mean(\"/.percent\") FROM \".fs\" WHERE $timeFilter GROUP BY time($interval)"
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=info msg="Request Completed" logger=context userId=1 orgId=1 uname=admin method=POST path=/api/ds/query status=400 remote_addr=172.19.0.1 time_ms=1 size=424 referer="http://localhost:8080/d/000000002/glances?orgId=1&refresh=5s"
grafana_1   | t=2021-11-23T15:25:55+0000 lvl=warn msg="Flux query failed" logger=tsdb.influx_flux err="invalid: compilation failed: error at @1:13-1:22: string literal key percent must have a value\nerror at @1:34-1:60: expected comma in property list, got REGEXEQ\nerror at @1:41-1:59: string literal key hostname must have a value\nerror at @1:52-1:59: unexpected token for property key: REGEXEQ (=~)\nerror at @1:61-1:88: expected comma in property list, got ASSIGN\nerror at @1:66-1:87: string literal key mnt_point must have a value\nerror at @1:78-1:87: invalid expression @1:86-1:87: '\nerror at @1:78-1:87: unexpected token for property key: ASSIGN (=)\nerror at @1:93-1:94: invalid statement: $\nerror at @1:119-1:122: unexpected token for property key: DURATION (30s)" query="SELECT mean(\"percent\") FROM \"fs\" WHERE (\"hostname\" =~ /^$/) AND (\"mnt_point\" = '/boot') AND $timeFilter GROUP BY time(30s)"

[nicolargo]

How do you configure your InfluxDB data source in Grafana ?

[nicolargo]

Perhaps coming from a default configuration in the latest InfluxDB version... Wait and see after the containers upgrade.

[j-zarp]

OK. On my side, I tried with all latest versions of those containers

[nicolargo]

It works after the docker-compose pull !!!

[nicolargo]

I can now have a look on the initial issue :)

[j-zarp]

Great, thanks :)

[nicolargo]

Ok reproduced...

The dashboard looks not compliant with Flux request... :(

[j-zarp]

Yes exactly. Does it mean all of the queries need to be rewritten in order to work with this new version?
I tried a lot of different things with the original dashboard json config but never managed to make it display something unfortunately...

[nicolargo]

Yes the all the query + variables should be converted to Flux...

I am not very familiar with the Flux language.

Try this for the load graph but without success:

from(bucket: "glances")
  |> range(start: v.timeRangeStart, stop:v.timeRangeStop)
  |> filter(fn: (r) =>
    r._measurement == "${host}.load" and
    r._field == "min5"
  )
  |> window(every: v.windowPeriod)
  |> mean()

[nicolargo]

It works with:

[j-zarp]

Looking good!

[nicolargo]

This one is better:

from(bucket: "glances")
  |> range(start: v.timeRangeStart, stop:v.timeRangeStop)
  |> filter(fn: (r) =>
    r._measurement == "load" and
    r._field == "min5"
  )
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "mean")

So need an hard and long work to migrate, i just open an issue #1960 to track this.

[j-zarp]

thank you very much

[nicolargo]

Under progress...

[nicolargo]

Done !

Available in: https://github.com/nicolargo/glances/blob/develop/conf/glances-grafana-flux.json

[j-zarp]

Thanks a lot @nicolargo, that was fast!
Just gave it a try, it works well :)

[nicolargo]

Also a simple stack based on you Docker-compose: https://github.com/nicolargo/docker-influxdb2-grafana-glances

[chiefy]

Just a note. I was trying to hook up influxDB2 / Grafana and Glances in my homelab today. The official Grafana JSON wasn't working, the measurement should be containers and not docker. I am not 100% on this but it worked for me...

glances/conf/glances-grafana-flux.json

Line 2275 in 2061d1b

"query": "from(bucket: \"glances\")\n |> range(start: v.timeRangeStart, stop:v.timeRangeStop)\n |> filter(fn: (r) =>\n r._measurement == \"docker\" and\n r._field == \"cpu_percent\" and\n r.name == \"${container}\" and\n r.hostname == \"${host}\"\n )\n |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)\n |> yield(name: \"CPU%\")\n \n ",