Hi there,
this is my last issue that I am carrying with me since the beginning of running OpenHAB 2.2. I read through all the existing topics but none seems to fit or solve my problem …
For all of my groups I get this error in openhab.log:
20:03:16.408 [ERROR] [ysql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'gTempDB'.
20:03:16.440 [ERROR] [ysql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'gWeather'.
20:03:16.458 [ERROR] [ysql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'gFritzSHome'.
20:03:16.558 [ERROR] [ysql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'gGeoFence'.
20:03:16.566 [ERROR] [ysql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'gLDruckWD'.
20:03:16.620 [ERROR] [ysql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'gTempEG'.
20:03:16.627 [ERROR] [ysql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'gKontakte'.
20:03:16.653 [ERROR] [ysql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'gZwave'.
20:03:16.899 [ERROR] [ysql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'gAstro'.
20:03:16.920 [ERROR] [ysql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'gTempWD'.
20:03:16.964 [ERROR] [ysql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'gBudHeizDruck'.
20:03:16.985 [ERROR] [ysql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'gHeating'.
20:03:17.034 [ERROR] [ysql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'gTempBad'.
Here is my mysql.persist:
Strategies {
default = everyChange
}
Items {
* : strategy = everyUpdate, everyChange, restoreOnStartup
gTempDB* : strategy = every10Minutes, restoreOnStartup
gTempEG* : strategy = every10Minutes, restoreOnStartup
gTempWD* : strategy = every10Minutes, restoreOnStartup
gAstro* : strategy = every10Minutes, restoreOnStartup
gHeating* : strategy = every10Minutes, restoreOnStartup
gTempBad* : strategy = every10Minutes, restoreOnStartup
gLDruckWD* : strategy = every10Minutes, restoreOnStartup
gBudHeizDruck* : strategy = every10Minutes, restoreOnStartup
gZwave* : strategy = every10Minutes, restoreOnStartup
gGeoFence* : strategy = every10Minutes, restoreOnStartup
gWeather* : strategy = every10Minutes, restoreOnStartup
gFritzSHome* : strategy = every10Minutes, restoreOnStartup
gKontakte* : strategy = every10Minutes, restoreOnStartup
}
I do not know why my groups are not recognized/considered/stored … whatever by mySQL persistence.
I found some reported bugs on that topic but only for very old versions and as you can see in the mysql.persist
file, I tried to add them manually.
I found one topic where someone added the tables manually to the openhab database but I do not know what characteristics the table should have so I can not do that.
I would kindly appreciate any hint or suggestion how I can get rid of these error messages or if there is no solution and I should simply ignore them (which I would not prefer )
Thanks for your support!!!