MySQL persistence, item stopped updating after adding+removing from group

Tags: #<Tag:0x00007f616f8c6d88> #<Tag:0x00007f616f8c6c48> #<Tag:0x00007f616f8c6b80>

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

I’m having the same issue with my influxdb persistence. Whenever I edit an item in PaperUI, it stops persisting its values. The only solution is to restart openhab. This also means that every time i create a new item in paperui I need to restart openhab if I want that item persisted.

Edit: Added a new item which didn’t cause this problem, however, this item wasn’t added to a group, so it would seem likely that it’s the changing of group association that messes up persistence. Any dev who could shed some light on this or could help with how to debug?

I am having this problem on a current 2.2 snapshot, using postgresql. Is there an official open bug available or did it somehow get solved?

Just experienced the same here, using 2.4.0 #1321 and JDBC-MySQL persistence.

Added a group via PaperUI, edited an existing item to add it to this new group, and the persistence stopped for this item. Even after restarting OH the persistence didn’t start again. I ended up unlinking the Item, deleting it, restarting OH, then adding a new item, and it then started persisting correctly.

@Kai Where should we open a bug? Is this ESH or OpenHAB?

Already opened at https://github.com/eclipse/smarthome/issues/5991