Persistence don't work, can read old data, but don't write new data

Setup, Configuration and Use Runtime
1
  • Platform information:
    • Hardware: Synology Container (Docker)
    • openHAB version: 2.4

Hallo Community,

my persistence services don’t write any data. Here is an example.
When I test the rest api:

http://192.168.188.30:8080/rest/persistence/items/NAS_Belegt

The result is:

{“name”:“NAS_Belegt”,“datapoints”:“0”,“data”:[]}

What make I wrong? Read old data is ok.

Haus.items:

Number NAS_Belegt “Belegter Speicher [%.2f GB] GB” (gHistory)

Mysql.cfg

the database url like ‘jdbc:mysql://:/’ (without quotes)

url=jdbc:mysql://127.0.0.1:3307/OpenHAB?serverTimezone=Europe/Berlin

the database user

user=openhab

the database password

password=password

mysql:sqltype.string=TEXT

Mysql.persists:

Strategies {
// if no strategy is specified for an item entry below, the default list will be used
everyMinute : “0 * * * * ?”
every5Minutes : “0 */5 * * * ?”
everyHour : “0 0 * * * ?”
everyDay : “0 0 0 * * ?”
default = everyChange
}

Items {
gHistory* : strategy = everyChange, restoreOnStartup
}

Log:

2019-08-25 12:38:20.591 [DEBUG] [sql.internal.MysqlPersistenceService] - mySQL: Stored item ‘NAS_Belegt’ as ‘2.25’[2.25] in SQL database at 2019-08-25 12:38:20.42.
2019-08-25 12:38:20.592 [DEBUG] [sql.internal.MysqlPersistenceService] - mySQL: query: INSERT INTO Item41 (TIME, VALUE) VALUES(NOW(),?) ON DUPLICATE KEY UPDATE VALUE=?;

Thanks Rap

2

I think I’ve seen something like that when an Item type is changed (or Item name re-used for different type) so that the table type no longer matches the Item type.

3

As always… :wink:

Please when posting configuration, logs or code, use code fences to prevent changes in the text through discourse (the forum software).