RRD4J and n3-line-chart not show value

Hi, ik have in my Habpanel a panel named charts.
here i display 3 charts with problems

  • Temperature : 3 values are correct 1 is fliping
  • Fueltank level : No Values shown
  • Rainwater level : No Values shown

can somebody see the problem ?

my rrd4j.cfg

All.def=COUNTER,900,0,U,60
All.archives=AVERAGE,0.5,1,480:AVERAGE,0.5,10,144
All.items=KamerJesseThuisTemperature,KamerKTThuisTemperature,KamerNicoThuisTemperature,KamerRuneThuisTemperature

energy.def=GAUGE,500,0,U,60
energy.archives=AVERAGE,0.5,1,480:AVERAGE,0.5,10,144
energy.items=MQTTWaterput_RegenWaterPomp,MQTTWaterput_GrondWaterPomp,MQTTWaterput_RegenWaterNiveau


fuel.def=COUNTER,900,0,U,60
fuel.archives=AVERAGE,0.5,1,480:AVERAGE,0.5,10,144
fuel.items=MQTTDieseltankDieselniveau

my rrd4j.presist

Strategies {
 everyMinute : "0 * * * * ?"
 everyHour   : "0 0 * * * ?"
 everyDay    : "0 0 0 * * ?"
 default = everyChange
}

//deze items worden gelogd: 
Items {
 KamerJesseThuisTemperature : strategy = everyMinute, restoreonstartup //elke minute gelogd
 KamerKTThuisTemperature : strategy = everyMinute, restoreonstartup //elke minute gelogd
 KamerNicoThuisTemperature : strategy = everyMinute, restoreonstartup //elke minute gelogd
 KamerRuneThuisTemperature : strategy = everyMinute, restoreonstartup //elke minute gelogd
 MQTTDieseltankDieselniveau : strategy = everyChange, everyMinute // elk minute gelogd
 MQTTWaterput_RegenWaterPomp : strategy = everyChange, everyMinute // elk minute gelogd
 MQTTWaterput_GrondWaterPomp : strategy = everyChange, everyMinute // elk minute gelogd
 MQTTWaterput_RegenWaterNiveau : strategy = everyChange, everyMinute // elk minute gelogd
}

my items

// kamer Jesse
Group    gtempjesse "Themostaat Van Jesse" [ "Thermostat", "Fahrenheit" ]
Number   KamerJesseThuisTemperature      "Temperature"       (gtempjesse) [ "CurrentTemperature" ]                              {channel="evohome:heatingzone:92b7cc0e:4444515:Temperature"}
String   KamerJesseThuisSetPointStatus   "Set point status"  (gtempjesse)                                                       {channel="evohome:heatingzone:92b7cc0e:4444515:SetPointStatus"}
Number   KamerJesseThuisSetPoint         "Set point"         (gtempjesse) [ "TargetTemperature","homekit:TargetTemperature" ]   {channel="evohome:heatingzone:92b7cc0e:4444515:SetPoint"}

// Kamer Nico
Group    gtempnico "Themostaat van Nico" [ "Thermostat", "Fahrenheit" ]
Number   KamerNicoThuisTemperature      "Temperature"        (gtempnico) [ "CurrentTemperature" ]                               {channel="evohome:heatingzone:92b7cc0e:4444513:Temperature"}
String   KamerNicoThuisSetPointStatus   "Set point status"   (gtempnico)                                                        {channel="evohome:heatingzone:92b7cc0e:4444513:SetPointStatus"}
Number   KamerNicoThuisSetPoint         "Set point"          (gtempnico) [ "TargetTemperature","homekit:TargetTemperature" ]    {channel="evohome:heatingzone:92b7cc0e:4444513:SetPoint"}

// Kamer Rune
Group    gtemprune "Themostaat van Rune" [ "Thermostat", "Fahrenheit" ]
Number   KamerRuneThuisTemperature      "Temperature"        (gtemprune) [ "CurrentTemperature" ]                               {channel="evohome:heatingzone:92b7cc0e:4444516:Temperature"}
String   KamerRuneThuisSetPointStatus   "Set point status"   (gtemprune)                                                        {channel="evohome:heatingzone:92b7cc0e:4444516:SetPointStatus"}
Number   KamerRuneThuisSetPoint         "Set point"          (gtemprune) [ "TargetTemperature","homekit:TargetTemperature" ]    {channel="evohome:heatingzone:92b7cc0e:4444516:SetPoint"}

// Kamer Kim & Toon
Group    gtempkt "Themostaat van Kim en Toon" [ "Thermostat", "Fahrenheit" ]
Number   KamerKTThuisTemperature      "Temperature"        (gtempkt) [ "CurrentTemperature" ]                                   {channel="evohome:heatingzone:92b7cc0e:4444514:Temperature"}
String   KamerKTThuisSetPointStatus   "Set point status"   (gtempkt)                                                            {channel="evohome:heatingzone:92b7cc0e:4444514:SetPointStatus"}
Number   KamerKTThuisSetPoint         "Set point"          (gtempkt) [ "TargetTemperature","homekit:TargetTemperature" ]        {channel="evohome:heatingzone:92b7cc0e:4444514:SetPoint"}

// Fuel monitor
Number   MQTTDieseltankDieselniveau   "Diesel Niveau"  (fuel) {channel="mqtt:topic:fb34543c:Dieselniveau"}

// eco-water-system
Contact   MQTTWaterput_GrondWaterPomp     "Grondwater pomp"             (Ecowatersystem) {channel="mqtt:topic:04041d69:GrondWaterPomp"}
Contact   MQTTWaterput_RegenWaterPomp     "Regenwater pomp"             (Ecowatersystem) {channel="mqtt:topic:04041d69:RegenWaterPomp"}
Number    MQTTWaterput_RegenWaterNiveau   "Regenwater niveau [%.2f]"    (Ecowatersystem) {channel="mqtt:topic:04041d69:RegenWaterNiveau"}

thx !
Toon

For which items actual values are shown?
Which temp value is flipping? Please explain a bit more.
Have a look into the REST API and check if values are persisted.

about the flipping value :
KamerJesseThuisTemperature give no value and sometime a value of : 7158278.8 °c

i’m checking the Rest API but its my first time so need to figure it out

Look under persistence and there the third blue GET (persistence/items/ itemname).
Put in rrd4j as service name and your itemname.
If you do not put in any timedata you will get the return for the last 24 hours, which would show your second archive (of your custom setup).

Additionally, which timeframe do you display on your charts?

this is what i get :

name “MQTTWaterput_RegenwaterNiveau”
datapoints “0”
data []

this is what i get form the KamerJesse :

name “KamerJesseThuis_Temperature”
datapoints “27”
data
0
time 1576520400000
state “0.05”
1
time 1576521000000
state “0.0”
2
time 1576521600000
state “0.0”
3
time 1576522200000
state “7158278.776666666”
4
time 1576522800000
state “0.0”
5
time 1576523400000
state “7158278.776666666”
6
time 1576524000000
state “7158278.776666666”
7
time 1576524600000
state “0.0”
8
time 1576525200000
state “0.0”
9
time 1576525800000
state “0.0”
10
time 1576526400000
state “0.0”
11
time 1576527000000
state “7158278.776666666”
12
time 1576527600000
state “0.0”
13
time 1576528200000
state “0.0”
14
time 1576528800000
state “0.05”
15
time 1576529400000
state “0.0”
16
time 1576530000000
state “0.0”
17
time 1576530600000
state “0.0”
18
time 1576531200000
state “0.0”
19
time 1576531800000
state “0.0”
20
time 1576532400000
state “0.0”
21
time 1576533000000
state “0.0”
22
time 1576533600000
state “7158278.776666666”
23
time 1576534200000
state “0.0”
24
time 1576574400000
state “0.0”
25
time 1576575000000
state “0.0”
26
time 1576575600000
state “0.0”

That points to your flipping.
Are the actual values also looking that way? You could also try a REST call which looks for less then 8 houres ( that would get the values by minute).
I think this flipping could be caused by faulty measurements of the sensor.

if i look in my PaperUI the value looks normal.
the value is provided by Evobinding en gives me te write value on PaperUI

if i change another item as the first item in my rrd4j.presist then that item goes to flip :slight_smile:

but i’m wondering that the value of MQTTWaterput_RegenWaterNiveau don’t come up.
this is provided by a ESP32 arduino via MQTT mosquito.

You used a different spelling for the second Water for the REST call.

Thx !
I just change it but the result is the same .
On both there is no value stored

Try it with deleting the respective .rrd file. Or does it exist?

this give me the same result.

thx for your time opus !

i hope we can find the solution.

Let us work initially on those items:

All use a rrd4j setup as Gauge (I am using such as well!)
Do you see the .rrd files in the /var/lib/openhab2/persistence/rrd4j directory? Do they have an actual savedate? Are they of the same size?
Do you actual values for those items? Do they change over time?

When trying to display a chart for them, what timeframe did you set on HABPanel? Remember your rrd4j database does hold data for a single day only!

Hi,
jes for all items is a .rrd file created.
MQTTWaterput_RegenWaterPomp,MQTTWaterput_GrondWaterPomp ar updated.
the MQTTWaterput_RegenWaterNiveau is created on 11:20 but don’t update anymore.

They all have the same size.

timeframe is 8h on the habpanel .

if i let my pc stands on the habpanel pagefor 1h the MQTTWaterput_RegenWaterNiveau show value but don’t store it

Let’s try it with debug logs for persistence:
Open the karaf console with ssh openhab@localhost -p 8101 (password : habopen)
and put in:
log:set DEBUG org.openhab.persistence.rrd4j

That should show an entry for each item.state that is persisted.
If MQTTWaterput_RegenWaterNiveau within a couple of minutes I’d try to restart the bundle by
With the command bundle:list you’ll a list of all installed bundles, remember the number of the rrd4j bundle and do.
bundle:restart TheNumber

You could additionaly try to remove the “everyChange” on the rrd4j.persist line for those items.

if i do the log:set debug org.openhab.presistence.rrd4j it will show notting …
it this normal ?

i have call the bundle:list and restart 274 for RRD4J

It should have been DEBUG

The log should show on the karaf console with log:tail or via the dashboard.

this is what i get :

2019-12-17 21:28:56.809 [vent.ItemStateChangedEvent] - MQTTWaterput_RegenwaterNiveau changed from  69 to  68

==> /var/log/openhab2/openhab.log <==

2019-12-17 21:29:00.073 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'KamerJesseThuis_Temperature' with state '17.0' in rrd4j database

2019-12-17 21:29:00.086 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'KamerKTThuis_Temperature' with state '15.5' in rrd4j database

2019-12-17 21:29:00.102 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'KamerNicoThuis_Temperature' with state '22.5' in rrd4j database

2019-12-17 21:29:00.116 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'KamerRuneThuis_Temperature' with state '15.5' in rrd4j database

2019-12-17 21:29:00.129 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'MQTTWaterput_RegenWaterPomp' with state '1' in rrd4j database

2019-12-17 21:29:00.141 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'MQTTWaterput_GrondWaterPomp' with state '0' in rrd4j database

2019-12-17 21:29:01.055 [INFO ] [panel.internal.HABPanelDashboardTile] - Stopped HABPanel

2019-12-17 21:29:01.366 [INFO ] [panel.internal.HABPanelDashboardTile] - Started HABPanel at /habpanel

2019-12-17 21:30:00.156 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'KamerJesseThuis_Temperature' with state '17.0' in rrd4j database

2019-12-17 21:30:00.168 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'KamerKTThuis_Temperature' with state '15.5' in rrd4j database

2019-12-17 21:30:00.181 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'KamerNicoThuis_Temperature' with state '22.5' in rrd4j database

2019-12-17 21:30:00.193 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'KamerRuneThuis_Temperature' with state '15.5' in rrd4j database

2019-12-17 21:30:00.211 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'MQTTWaterput_RegenWaterPomp' with state '1' in rrd4j database

2019-12-17 21:30:00.223 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'MQTTWaterput_GrondWaterPomp' with state '0' in rrd4j database

2019-12-17 21:31:00.239 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'KamerJesseThuis_Temperature' with state '17.0' in rrd4j database

2019-12-17 21:31:00.254 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'KamerKTThuis_Temperature' with state '15.5' in rrd4j database

2019-12-17 21:31:00.270 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'KamerNicoThuis_Temperature' with state '22.5' in rrd4j database

2019-12-17 21:31:00.285 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'KamerRuneThuis_Temperature' with state '15.5' in rrd4j database

2019-12-17 21:31:00.304 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'MQTTWaterput_RegenWaterPomp' with state '1' in rrd4j database

2019-12-17 21:31:00.315 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'MQTTWaterput_GrondWaterPomp' with state '0' in rrd4j database

In other words the two other items using the “energy” archive are being persisted correctly.
You did try removing the rrd file already! Try removing the “everyChange”.

that is correct.

jes i removed it twice and also after the “everychange” removing.

the first and the last item is the rrd4j.presist are not working.
can i change the order of the items to check if there is some problem ?