I have a problem several times.
At first I used rrd4j-persistance to store temperature, light-State and rollershutter-state. But after a time, I don’t know after a shutdown or during operations, the service stops.
Now, I tested the mysql-service. But with the same result after 3 weeks.
In the past, I restarted the whole system and it restart working. But mostly I had to delete all the persistence files and restart the system. After that, the persistence will store all new values, but the old ones are lost.
Actually I get messages like that:
2021-05-11 19:47:09.277 [ERROR] [sql.internal.MysqlPersistenceService] - mySQL: Could not create table for item ‘squeezeKitchenFavorite’ with statement ‘CREATE TABLE Item7632 (Time DATETIME, Value VARCHAR(20000), PRIMARY KEY(Time));’: Column length too big for column ‘Value’ (max = 16383); use BLOB or TEXT instead
2021-05-11 19:47:09.279 [ERROR] [sql.internal.MysqlPersistenceService] - mySQL: Item ‘squeezeKitchenFavorite’ was not added to the table - removing index
2021-05-11 19:47:09.317 [ERROR] [sql.internal.MysqlPersistenceService] - mySQL: Could not store item ‘squeezeKitchenFavorite’ in database with statement ‘INSERT INTO Item7632 (TIME, VALUE) VALUES(?,?) ON DUPLICATE KEY UPDATE VALUE=?;’: Table ‘OpenHAB.Item7632’ doesn’t exist
Can someone help me. What will be the problem and how can I restart / get rework the service?
Thanks in advance!