Data is not sent to influxdb

Topics (not sure which fora)
when not sure where to post, post here and mods will move it to right forum.

Moderators: leecollings, remb0

Post Reply
averter
Posts: 49
Joined: Thursday 24 February 2022 8:32
Target OS: Linux
Domoticz version: 2024.4
Contact:

Data is not sent to influxdb

Post by averter »

I have domoticz and influxdb installed on a raspberry pi 3. It worked perfectly fine for months, sending data every 5 mins, but for some reason a couple of days ago the data is not reaching influxdb. I've checked this via the "select count(*) from /.*/" command of influxdb (result below is always the same)+ data not being displayed on grafana.

Code: Select all

name: Humidity
time count_value
---- -----------
0    44597

name: Lux
time count_value
---- -----------
0    43883

name: Solar-Radiation
time count_value
---- -----------
0    92041

name: Temperature
time count_value
---- -----------
0    37684
The domoticz log seems clear with no errors, e.g. see below domoticz attemps to send the data

Code: Select all

2023-11-24 18:39:06.553 InfluxLink: value Solar-Radiation,idx=23,name=Fullspectrum-streetroof value=0.000
2023-11-24 18:39:06.553 InfluxLink: value Solar-Radiation,idx=22,name=Infrared-streetroof value=0.000
2023-11-24 18:39:06.553 InfluxLink: value Lux,idx=21,name=Light-streetroof value=0.0
2023-11-24 18:39:50.396 InfluxLink: value Solar-Radiation,idx=18,name=Full-spectrum-gardenroof value=0.000
2023-11-24 18:39:50.396 InfluxLink: value Solar-Radiation,idx=17,name=Infrared-gardenroof value=0.000
2023-11-24 18:39:50.396 InfluxLink: value Lux,idx=13,name=Light-gardenroof value=0.0
2023-11-24 18:40:02.958 InfluxLink: value Temperature,idx=20,name=Temperature-rpi-streetroof value=24.5
2023-11-24 18:40:03.964 InfluxLink: value Temperature,idx=11,name=Temperature-rpi-gardenroof value=21.3
2023-11-24 18:45:04.040 InfluxLink: value Temperature,idx=11,name=Temperature-rpi-gardenroof value=20.7
2023-11-24 18:50:03.212 InfluxLink: value Temperature,idx=20,name=Temperature-rpi-streetroof value=23.9
2023-11-24 18:50:56.297 Status: [web:8080] Incoming connection from: 192.168.1.4
2023-11-24 18:55:03.437 InfluxLink: value Temperature,idx=11,name=Temperature-rpi-gardenroof value=21.3 
so I am completely clueless over what might be causing this. I should also state that I have another rpi to monitor my power consumption which is sending data to a separate influxdb database than domoticz one (and at a higher sampling rate) which is working fine (I can visualise all data in grafana). Thanks in advance for any help.
averter
Posts: 49
Joined: Thursday 24 February 2022 8:32
Target OS: Linux
Domoticz version: 2024.4
Contact:

Re: Data is not sent to influxdb

Post by averter »

I've further tried to send a POST request to write data to the database, to make sure that it's not an influxdb problem, using

Code: Select all

curl -i -XPOST 'http://localhost:8086/write?db=DOMOTICZ' --data-binary 'Lux,idx=21,name=Light-streetroof value=0.64 1434055562000000000'
and indeed the database was updated: see the output of

Code: Select all

select count(*) from /.*/
below

Code: Select all

name: Humidity
time count_value
---- -----------
0    44597

name: Lux
time count_value
---- -----------
0    43884

name: Solar-Radiation
time count_value
---- -----------
0    92041

name: Temperature
time count_value
---- -----------
0    37684
Where the count value of Lux has now an additional entry. So this reinforces that this is a domoticz rather than influxdb problem :(
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest