I see some jdbc related errors in my log:
Exception occurred while querying persistence service 'jdbc': java.lang.String cannot be cast to java.lang.Number java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Number
An error occurred while calling method 'QueryablePersistenceService.query()' on 'org.openhab.core.persistence.internal.QueryablePersistenceServiceDelegate@79633b': java.lang.String cannot be cast to java.sql.Timestamp
I’m using JDBC with MariaDB.
This probably means that some numbers and timestamps are stored as a string in my db. How can I find out which items that are? I have over 800 items in my db, so manually checking them all is not an option.
Looks similar as this but my problem is not in the cache, but the db itself. Clearing the cache doesn’t work.
I think I have the same issue as described here.