Questions tagged [influxdb]

InfluxDB is an open-source time series, events, and metrics database written in Go, with no external dependencies.

Links

2990 questions
6
votes
2 answers

influxdb and grafana timezone mismatch

I'm trying to use curl to write datapoints into to influxdb and then display with grafana. The following successfully writes to influxdb, but the time is in UTC # curl -i -XPOST "http://localhost:8086/write?db=db_fio" --data-binary "test…
user192749
  • 247
  • 1
  • 3
  • 11
6
votes
3 answers

InfluxDB write event listener/trigger

Reading through documentation as well as other SO posts did not help me find out either InfluxDB supports event listeners/triggers on write operations or not. Because it's meant for real-time analytics, I would like to be notified when a specific…
Andrei Stalbe
  • 1,511
  • 6
  • 26
  • 44
6
votes
4 answers

How to connect Java to Grafana

I really like the capabilities of Grafana for graphing metrics over time and showing a nice dashboard. I'd like to use it to track CPU, Mem, etc throughout my deployment environment. I'd also like to use it to track some numbers from my Java…
user3923124
  • 279
  • 1
  • 3
  • 9
6
votes
5 answers

Logstash - is an output to influx DB available?

I want to have an output for Influx DB from Logstash, is there any such plugin available? The output is set to graphite.. This is the influx config: [input_plugins] # Configure the graphite api [input_plugins.graphite] enabled = true port =…
Sumit Maingi
  • 2,173
  • 3
  • 24
  • 44
5
votes
0 answers

Grafana Unified Alerting - frame cannot uniquely be identified by its labels: has duplicate results with labels {}

TLDR: I can't access field_keys or alias when working with multidimensional rules from the new Unified Grafana Alerting System (& InfluxDB) I ran into a problem with the new unified grafana alerting system. I created a new alert rule and entered a…
Tben
  • 51
  • 2
5
votes
2 answers

Get the number of points in a bucket for a time interval with Flux query

Given a bucket how do I get the number of points in this bucket with the timestamp in the given time interval using a Flux query? I'm trying to estimate how much data is added to an influxdb2 bucket per unit of time.
axk
  • 5,316
  • 12
  • 58
  • 96
5
votes
2 answers

Problems setting up a docker based InfluxDB/Grafana network

My intention is to use Windows Docker to deploy an InfluxDB 2.0.8 database and link to it via a self-hosted Grafana instance on the same docker network. To do so, I've done the below steps: Start the network, InfluxDB and Grafana via below: docker…
mfcss
  • 1,039
  • 1
  • 9
  • 25
5
votes
2 answers

Influxdb 2.0 Flux - How to return 0 instead null

I want to count amount of values that are greater than specific value. Data: from(bucket: "bucket name") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r._value > 35) |> count() If there are no values in…
Amerousful
  • 2,292
  • 1
  • 12
  • 26
5
votes
3 answers

How can I use key/value dashboard variables in Grafana + InfluxDB?

I’m trying to suss out how to format my key/value pair dashboard variable. I’ve got a variable whose definitions are: sensor_list = 4431,8298,11041,13781 sensor_kv = 4431 : Storage,8298 : Stairs,11041 : Closet,13781 : Attic However, I can't seem to…
Chris R
  • 17,546
  • 23
  • 105
  • 172
5
votes
2 answers

InfluxDB in Docker Bad gateway

I started setting up my Smart Home System in Docker with Openhab, mosquitto, Grafa etc. The Docker topic is still relatively new to me and I have not managed to connect InfluxDB with Grafana. Whenever I try, Influxdb: Bad Gateway appears. I did a…
fps_boost
  • 51
  • 1
  • 2
5
votes
0 answers

Http TLS handshake error when using InfluxDb and Telegraf for Grafana

I generated certificate and key (.crt and .key) files with the OpenSSL tool, and set the generated file paths to these files in the influxdb.conf file. When I run my Telegraf service, the Influxd logs: http: TLS handshake error from [::1]:63020:…
Jure Beton
  • 137
  • 1
  • 9
5
votes
3 answers

Influxdb 2.0 how to get a tag all values?

I'm using influxdb 2.0 to store stock history data. I use ticker as tag name and AAPL(GOOG.. etc..) as tag value to store stock history candle data. Now, I want to get a tag all values by flux language in my program. In other words, get all values…
huang
  • 919
  • 11
  • 22
5
votes
1 answer

How to downsample data older than 14 days only in influxdb and keep it in the same table as raw data?

I am having a setup collecting metrics from telegraf into influxdb. Then grafana uses influxdb as data source to display graphs. My problem is reducing disk usage, so I want to downsample old data (older than 3 days) and keep the new data (younger…
Wojtas.Zet
  • 636
  • 2
  • 10
  • 30
5
votes
1 answer

Provisioning multiple datasources in grafana

I have able to import a datasource & dashboard while building docker container for grafana. I tried creating two separate datasource.yml file (For example: datasoure1.yml and datasource2.yml) and copied in /etc/grafana/provisioning/datasources but…
user4021949
  • 243
  • 5
  • 13
5
votes
2 answers

Drop measurement that belong to a specific retention policy

Recently, we migrated our data from measurement 'users' with retention policy autogen (default) to retention policy sixty_days (sixty_days.users). So we don't need anymore the data in autogen.users. How can we remove it without harming the data in…
Aladin
  • 492
  • 1
  • 8
  • 21