OH3: Switch item to influx not working anymore as in OH 2.5

[Windrad (Ingo)]

Hello,
in OH 2.5 I defined items like this:

Switch PIR_Flur_Speicher            "Pir Flur Speicher" <light> (FF_Flur)   { channel="knx:device:bridge:generic:PIR_Flur_Speicher", autoupdate="true" }

and they were writen to influx:

PIR_Flur_Speicher                   : strategy =  everyUpdate, everyDay

So they got writen as Number (1/0) to the db. In OH3 I get an error:

org.influxdb.InfluxDBException$FieldTypeConflictException: partial write: field type conflict: input field "value" on measurement "PIR_Flur_Speicher" is type integer, already exists as type float dropped=1

Any suggestions how to make that possible again?
Thanks,
Ingo

[OMR (Ole Morten Rønning)]

InfluxDB Error "field type conflict: input field value on measurement is type integer, already exists as type float dropped=1"

I had the same problem and was able to fix it. However, I had to look through a lot of documentation to find bits and pieces of information I needed. So, in order to help others, here’s a summary. What’s the problem? There was some change in how certain type of fields are presisted in InfluxDB. Due to that change, the definition of the field in InfluxDB, made by a previous version of OH, doesn’t match the data type that the newer version of OH is trying to put into the database. That results in…

[Windrad (Ingo)]

Thank you very much!
So as I understand, every Measured value is transfered to an new value inside the InfluxDB???
What, if I habe OH2.5 and 3.0 running side by side? I transfer the db, but the 2.5er version of OH will put wrong values in it again and problems start over again?

[OMR (Ole Morten Rønning)]

I’m no expert, but I believe you are right. Once converted to OH3 you must convert back again for OH2.5.

[Windrad (Ingo)]

Thanks a lot!
So I will solve my other OH3 Problems first and use your solution when switching to OH3 completly.

[OMR (Ole Morten Rønning)]

Good plan!

[Marijn_Oudijk]

I’m not sure if I have the same problem.

In my influxdb I can check the value from a persisted switch and it is stored as 0/1.

The item is showed as Off/On when I look at it in Main UI. But when I analyze it in a graph there’s nothing.

[Windrad (Ingo)]

Are you using Grafana for graphing?
The query would be:

SELECT distinct("value") FROM "PIR_Eingang" WHERE $timeFilter GROUP BY time($interval) fill(null)

[Marijn_Oudijk]

In grafana it works perfectly. However in main UI I don’t get any data

[czupyt (Rafał Czupyt)]

Have you resolved the problem? Just notice on my chart items that I see no data as well, constantly 0.

[Marijn_Oudijk]

If I remember correctly this was resolved I’m release 3.1 (snapshot) bit can’t remember where I saw that