coussej / node-opcua-logger

An OPCUA Client for logging data to InfluxDB! 🔌 🏭
https://www.factry.io
MIT License
179 stars 63 forks source link

Boolean writing error on Influx V2 #77

Closed ferreroboema closed 2 years ago

ferreroboema commented 2 years ago

Hello,

I'm currently testing this tool with Influx V2 (dev branch), everything seems to work fine with floating values, but I can't make the boolean values work and I get the following error:

[2022-03-03T15:06:54.059] [WARN] influx - failure writing points to database: partial write: field type conflict: input field "value" on measurement "Monitored" is type boolean, already exists as type float dropped=1
false [Function: bound booleanField]
ERROR: Write to InfluxDB failed. d [HttpError]: failure writing points to database: partial write: field type conflict: input field "value" on measurement "Monitored" is type boolean, already exists as type float dropped=1

Any suggestion?

Thanks,

Luca

coussej commented 2 years ago

Hello Luca,

you seem to already have a measurement named 'Monitored' in the database, either because you previously had a float measurement in the config file, or you have a double entry somewhere.

If you check the config file for errors and it is OK, you can just drop the measurement monitored (DROP MEASUREMENT "Monitored") in influxdb and it will be recreated as boolean.

On Thu, 3 Mar 2022 at 11:10, ferreroboema @.***> wrote:

Hello,

I'm currently testing this tool with Influx V2 (dev branch), everything seems to work fine with floating values, but I can't make the boolean values work and I get the following error:

[2022-03-03T15:06:54.059] [WARN] influx - failure writing points to database: partial write: field type conflict: input field "value" on measurement "Monitored" is type boolean, already exists as type float dropped=1 false [Function: bound booleanField] ERROR: Write to InfluxDB failed. d [HttpError]: failure writing points to database: partial write: field type conflict: input field "value" on measurement "Monitored" is type boolean, already exists as type float dropped=1

Any suggestion?

Thanks,

Luca

— Reply to this email directly, view it on GitHub https://github.com/coussej/node-opcua-logger/issues/77, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACL34V6VSQJMGMBPUZFCNBTU6CFZ5ANCNFSM5P2ABKMQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you are subscribed to this thread.Message ID: @.***>

ferreroboema commented 2 years ago

My error, I guess I have misunderstood the measurment field. Thank you very much for the answer and for this amazing tool.

Luca