After upgrading from OH3.2 to OH3.3 (via apt), my logs are flooded with this entry.
14:43:07.595 [ERROR] [org.knowm.yank.Yank ] - Error in SQL query!!!
java.sql.SQLException: ERROR: column "value" is of type double precision but expression is of type character varying
Hint: You will need to rewrite or cast the expression.
Position: 51 Query: INSERT INTO item0000 (TIME, VALUE) VALUES( NOW(), CAST( ? as VARCHAR) ) Parameters: [OFF]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:392) ~[?:?]
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:491) ~[?:?]
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:457) ~[?:?]
at org.knowm.yank.Yank.execute(Yank.java:194) ~[?:?]
at org.knowm.yank.Yank.execute(Yank.java:177) ~[?:?]
at org.openhab.persistence.jdbc.db.JdbcPostgresqlDAO.doStoreItemValue(JdbcPostgresqlDAO.java:144) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcMapper.storeItemValue(JdbcMapper.java:163) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcPersistenceService.internalStore(JdbcPersistenceService.java:156) ~[?:?]
at org.openhab.persistence.jdbc.internal.JdbcPersistenceService.store(JdbcPersistenceService.java:135) ~[?:?]
at org.openhab.core.persistence.internal.PersistItemsJob.run(PersistItemsJob.java:60) ~[?:?]
at org.openhab.core.internal.scheduler.CronSchedulerImpl.lambda$0(CronSchedulerImpl.java:62) ~[?:?]
at org.openhab.core.internal.scheduler.CronSchedulerImpl.lambda$1(CronSchedulerImpl.java:69) ~[?:?]
at org.openhab.core.internal.scheduler.SchedulerImpl.lambda$12(SchedulerImpl.java:191) ~[?:?]
at org.openhab.core.internal.scheduler.SchedulerImpl.lambda$1(SchedulerImpl.java:88) ~[?:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:829) [?:?]
They come in bursts with 100ms interval. The database backend is Postgresql.
Any suggestion to solve this?