Hi all. I’m new to OpenHAB, so very possible I’m doing many things wrong.
I had temperature, humidity, and battery voltage, logging to the mysql backend on every change, running smoothly. I was playing around with creating an Item type “Group” in the Paper UI, and didn’t really know what they were doing. I added some link between the Temperature item and the new group. Then removed the group.
In the MySQL DB, a new item entry for the “Group” is created, and at 15:46:34 the value 22.9 is entered. This is the only value in this item’s table. This is also reflected by the temperature updates in the events.log, included below.
Unfortunately something happened that also affected the Multisensor1DHT22ATemperature_Temperature persistence logging. Final entry in this table is at 15:45:57, just before I created the Group, and just before the “Item ‘Multisensor1DHT22ATemperature_Temperature’ has been updated.” log message.
I’m running OpenHAB2 2.0.0-1, installed via apt-get from stable branch, on Ubuntu 16.04.2 LTS.
I tried to edit and save the temperature item and thing, without changing anything, but this had no effect. Then I restarted openhab and the logging has started again.
Could I get Multisensor1DHT22ATemperature_Temperature to resume logging in mysql without restarting openhab?
Is this a known issue, or grounds for a new bug report?
openhab.log and events.log:
2017-04-18 15:43:09.622 [ItemStateChangedEvent ] - Multisensor1DHT22ATemperature_Temperature changed from 23.00 to 22.90
2017-04-18 15:45:38.902 [ItemStateChangedEvent ] - Multisensor1DHT22ATemperature_Temperature changed from 22.90 to 23.00
==> /var/log/openhab2/openhab.log <==
2017-04-18 15:45:48.069 [ERROR] [sql.internal.MysqlPersistenceService] - mySQL: Unable to find table for query 'TestGroupName'.
==> /var/log/openhab2/events.log <==
2017-04-18 15:45:48.071 [ItemAddedEvent ] - Item 'TestGroupName' has been added.
2017-04-18 15:45:57.566 [ItemStateChangedEvent ] - Multisensor1DHT22ATemperature_Temperature changed from 23.00 to 22.90
2017-04-18 15:46:24.040 [ItemUpdatedEvent ] - Item 'Multisensor1DHT22ATemperature_Temperature' has been updated.
2017-04-18 15:46:34.885 [ItemStateChangedEvent ] - Multisensor1DHT22ATemperature_Temperature changed from NULL to 22.90
2017-04-18 15:46:34.896 [GroupItemStateChangedEvent] - TestGroupName changed from NULL to 22.90 through Multisensor1DHT22ATemperature_Temperature
2017-04-18 15:46:34.899 [GroupItemStateChangedEvent] - TestGroupName changed from NULL to 22.90 through Multisensor1DHT22ATemperature_Temperature
2017-04-18 15:46:48.265 [ItemRemovedEvent ] - Item 'TestGroupName' has been removed.
2017-04-18 15:46:57.418 [ItemUpdatedEvent ] - Item 'Multisensor1DHT22ATemperature_Temperature' has been updated.
2017-04-18 15:47:12.218 [ItemStateChangedEvent ] - Multisensor1DHT22ATemperature_Temperature changed from NULL to 22.90
2017-04-18 15:47:30.873 [ItemStateChangedEvent ] - Multisensor1DHT22ATemperature_Temperature changed from 22.90 to 23.00
2017-04-18 15:47:49.534 [ItemStateChangedEvent ] - Multisensor1DHT22ATemperature_Temperature changed from 23.00 to 22.90
mysql.persist:
// persistence strategies have a name and a definition and are referred to in the "Items" section
Strategies {
// if no strategy is specified for an item entry below, the default list will be used
default = everyChange
}
/*
* Each line in this section defines for which item(s) which strategy(ies) should be applied.
* You can list single items, use "*" for all items or "groupitem*" for all members of a group
* item (excl. the group item itself).
*/
Items {
// persist all items on every change and restore them from the db at startup
* : strategy = everyChange, restoreOnStartup
}
openhab2 version:
openhab2:
Installed: 2.0.0-1
Candidate: 2.0.0-1
Version table:
*** 2.0.0-1 500
500 http://dl.bintray.com/openhab/apt-repo2 stable/main amd64 Packages
500 http://dl.bintray.com/openhab/apt-repo2 stable/main i386 Packages
100 /var/lib/dpkg/status