Questions tagged [influxdb-2]

More information here https://v2.docs.influxdata.com/v2.0/. Version 2 uses a new query language called Flux and it is also reactive in nature.

289 questions
0
votes
1 answer

Setup my Windows server as a Proxy server for Iotawatt energy monitor

IotaWatt (IW) is an open source energy monitor with a lot of features and great perfomance. It is based on the ESP8266 chip and we have been using it for more than a year now. The monitor can send all the measured parameters to different Databases…
0
votes
1 answer

Why does my infulxdb insert a new row of data only every 10 seconds?

I wrote a timed task in c# to insert one row of data per second, but I found that only one row of data is inserted every 10 seconds. I also noticed that new insert requests within 10 seconds will only update the same row of data and not insert a new…
Afowne
  • 1
0
votes
1 answer

Influxdb2 : How to downsample data in a different measurement in same bucket?

I would like to create aggregation measurement into same bucket with monthly data. At the moment I have a task with this query: import "strings" option task = {name: "MTU Monthly", every: 1d} from(bucket: "my_bucket") |> range(start:…
Michal Špondr
  • 1,337
  • 2
  • 21
  • 44
0
votes
1 answer

InfluxDB 2 storage retention/max. size

I am using InfluxDB 2.2 to store & aggregate data on a gateway device. The environment is pretty limited regarding space. I do not know in which interval and how large the data is that get's ingested. Retention is not that much of a requirement. All…
domdeger
  • 31
  • 6
0
votes
1 answer

Deploying influxDB 2 in Azure AKS cluster with provisioned storage account

I'm having trouble to deploy Influxdb2 into my Azure AKS Cluster. I'm using a simple storage account to serve as storage. Looking the influxdb pod: ** ts=2021-11-26T00:43:44.126091Z lvl=error msg=“Failed to apply SQL migrations” log_id=0Y2Q~wH0000…
0
votes
1 answer

Flux from (All buckets) in Influxdb 2

I have a dynamic amount of buckets that i want to list, i only want to list the buckets that contain a specific value from a field. So a more specific explanation here: I have x amount of bucket, each bucket have a field called software, i want to…
Timmy
  • 52
  • 1
  • 2
  • 8
0
votes
1 answer

Grafana influxdb2 not showing correct legend label

Using Grafana 8 & influx db2 I want to combine two measurements & add the values measurement 1: from(bucket: "myBucket") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "SCP" ) |> filter(fn:…
Kermit754
  • 343
  • 5
  • 14
0
votes
1 answer

Where is Influxdb.conf in influxdb2.2(windows)

I try to find Influxdb.conf, but when I download Influxdb2.2, I find there is no file name Influxdb.conf, does anyone know how can I find this file?
umr
  • 59
  • 7
0
votes
1 answer

Influxdb2 Python API: Path not found

I have a working InfluxDb2 server and, on a Raspberry Pi, the Python client library. I've generated the the tokens in the server UI and copied an all-areas one into the Python. The test bucket is set up in the UI too. In the Python program I have…
Hugh Barnard
  • 352
  • 2
  • 12
0
votes
2 answers

Cannot see Jmeter measurement filter in influxdb

I was trying to interate Jmeter, influxDB and Grafana to see the test results. I am running docker containers with below versions INFLUXDB_VERSION=2.1.1 Grafana v8.5.0 Jmeter 5.4.1 After I create the data source in Grafana I can see one jmeter…
Shabar
  • 2,617
  • 11
  • 57
  • 98
0
votes
1 answer

Which csv format is appropriate for influxdb2?

I'm going to put the csv file into the bucket using influxdb v2.1. Attempting to insert a simple example file results in the following error: error in csv.from(): failed to read metadata: failed to read annotations: expected annotation datatype The…
SecY
  • 307
  • 4
  • 12
0
votes
1 answer

max-series-per-database limit exceeded clarification needed / how to calculate number of series in use

We recently started to encounter this error: {"error":"partial write: max-series-per-database limit exceeded: (1000000) dropped=1"} When writing metric data like…
Keith Palmer Jr.
  • 27,666
  • 16
  • 68
  • 105
0
votes
1 answer

How to get _value of two tables into one table?

I'm trying to create a dashboard where i can filter data by gas station location and fuel type. This is my Table from this query: from(bucket: "homeassistant") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) =>…
Niklas G.
  • 11
  • 1
0
votes
1 answer

Recording high frequency time-series data with influxdb

I want to record data every 10 milliseconds. Here is the sample code: with InfluxDBClient(url=url, token=token, org=org, enable_gzip=True) as client: with client.write_api( write_options=WriteOptions( batch_size=100,…
torayeff
  • 9,296
  • 19
  • 69
  • 103
0
votes
2 answers

Issue with min - max - mean task

I have a bucket (homeassistant) that collects info from a temperature / humidity sensor. Of course, I want to downsample his data to min/max/mean of previous day. Inspired by this post, I created a new bucket downsample and two tasks for the…
sineverba
  • 5,059
  • 7
  • 39
  • 84