Influxdb string vs number

Setup, Configuration and Use Items & Sitemaps
1

Hi all,

I created a string item, it got stored in InfluxDB, decided to change to a number. Now get this in logs. How do I clear the item out of the database so it can get recreated?

2018-02-05 08:31:25.422 [ERROR] [org.influxdb.impl.BatchProcessor    ] - Batch could not be sent. Data will be lost
java.lang.RuntimeException: {"error":"field type conflict: input field \"value\" on measurement \"sprinklerRuntime\" is type float64, already exists as type string"}

        at org.influxdb.impl.InfluxDBErrorHandler.handleError(InfluxDBErrorHandler.java:19) [341:org.openhab.persistence.influxdb:1.11.0.201712150210]
        at retrofit.RestAdapter$RestHandler.invoke(RestAdapter.java:242) [341:org.openhab.persistence.influxdb:1.11.0.201712150210]
        at org.influxdb.impl.$Proxy160.writePoints(Unknown Source) [341:org.openhab.persistence.influxdb:1.11.0.201712150210]
        at org.influxdb.impl.InfluxDBImpl.write(InfluxDBImpl.java:151) [341:org.openhab.persistence.influxdb:1.11.0.201712150210]
        at org.influxdb.impl.BatchProcessor.write(BatchProcessor.java:171) [341:org.openhab.persistence.influxdb:1.11.0.201712150210]
        at org.influxdb.impl.BatchProcessor$1.run(BatchProcessor.java:144) [341:org.openhab.persistence.influxdb:1.11.0.201712150210]
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:?]
        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) [?:?]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) [?:?]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) [?:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:?]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:?]
        at java.lang.Thread.run(Thread.java:748) [?:?]
2

Oddly after a reboot and it went away. However I started getting

2018-02-06 01:11:52.285 [ERROR] [sql.internal.MysqlPersistenceService] - mySQL: Could not store item 'sprinklerNextHour' in database with statement 'INSERT INTO Item137 (TIME, VALUE) VALUES(NOW(),?) ON DUPLICATE KEY UPDATE VALUE=?;': Data truncated for column 'Value' at row 1

Took the easy route and just renamed the item… :slight_smile: