# Persistence Services **URL:** https://community.openhab.org/c/add-ons/persistence/16.md [Latest](https://community.openhab.org/latest.md) · [Categories](https://community.openhab.org/categories.md) · [Tags](https://community.openhab.org/tags.md) --- ## [Forecast does not work anymore since OH5](https://community.openhab.org/t/forecast-does-not-work-anymore-since-oh5/169773)
**Author:** [@obones](https://community.openhab.org/u/obones)\ **Replies:** 4\ **Last updated:** [October 19, 2026, 4:27pm UTC](https://community.openhab.org/t/forecast-does-not-work-anymore-since-oh5/169773 "2026-10-19T16:27:35Z")
Hello, After the migration to OH5, and having read around here about the changes done to this area, I went to the persistence settings for both rrd4j and influxDb as those are the ones installed on my system. For influ… --- ## [Retirement of Apache Derby (persistence)](https://community.openhab.org/t/retirement-of-apache-derby-persistence/167762)
**Author:** [@lsiepel](https://community.openhab.org/u/lsiepel)\ **Replies:** 13\ **Last updated:** [September 27, 2026, 4:57pm UTC](https://community.openhab.org/t/retirement-of-apache-derby-persistence/167762 "2026-09-27T16:57:42Z")
Apache Derby is an external project that has been used as one of the JDBC persistence options in openHAB for many years. As of October 2025, Derby is no longer actively maintained upstream. This means there will be no fu… --- ## [Mapdb problem after Update 4.3.11 to 5.2.1](https://community.openhab.org/t/mapdb-problem-after-update-4-3-11-to-5-2-1/170444)
**Author:** [@WeRo](https://community.openhab.org/u/WeRo)\ **Replies:** 3\ **Last updated:** [September 20, 2026, 6:17pm UTC](https://community.openhab.org/t/mapdb-problem-after-update-4-3-11-to-5-2-1/170444 "2026-09-20T18:17:18Z")
My Mapdb database seems to be corrupt after update from 4.3.11 to 5.2.1 Several self defined items are not persistet anymore so they are Null after restart of openhab service. How can I solve this problem without loosin… --- ## [TimescaleDB Persistence Service not recognized as Persistence Add-On](https://community.openhab.org/t/timescaledb-persistence-service-not-recognized-as-persistence-add-on/170201)
**Author:** [@Stone](https://community.openhab.org/u/Stone)\ **Replies:** 5\ **Last updated:** [September 5, 2026, 8:10pm UTC](https://community.openhab.org/t/timescaledb-persistence-service-not-recognized-as-persistence-add-on/170201 "2026-09-05T20:10:42Z")
Hi, I’m on Openhab 5.2.1, running on docker. I currently try to switch to timescaleDB persistence and installed the respective persistence Add-On (TimescaleDB - Persistence Services | openHAB). The installation looks go… --- ## [Does ${ENV:VAR} substitution work in service .cfg files (e.g. influxdb.cfg)?](https://community.openhab.org/t/does-env-var-substitution-work-in-service-cfg-files-e-g-influxdb-cfg/170236)
**Author:** [@Alexaas](https://community.openhab.org/u/Alexaas)\ **Replies:** 3\ **Last updated:** [August 25, 2026, 8:46am UTC](https://community.openhab.org/t/does-env-var-substitution-work-in-service-cfg-files-e-g-influxdb-cfg/170236 "2026-08-25T08:46:36Z")
In openHAB 5.2.1, I confirmed that ${ENV:VARIABLE\_NAME} substitution works in .things files. However, I’m unsure if the same syntax works in service configuration files like services/influxdb.cfg. Example: version=V2 … --- ## [How to use two different Configurations for one persistence service t](https://community.openhab.org/t/how-to-use-two-different-configurations-for-one-persistence-service-t/169613)
**Author:** [@FranzS](https://community.openhab.org/u/FranzS)\ **Replies:** 3\ **Last updated:** [June 24, 2026, 2:33pm UTC](https://community.openhab.org/t/how-to-use-two-different-configurations-for-one-persistence-service-t/169613 "2026-06-24T14:33:59Z")
Hi, I’ve tried the first time to store forecast data.from the Solar binding using Solcast. I have the influxdb and use the MainUI. When i setup the config i did it like shown below. Question 1: Is tit plausible (log… --- ## [MapDB vs rrd4j: Recommended Persistence Setup?](https://community.openhab.org/t/mapdb-vs-rrd4j-recommended-persistence-setup/169592)
**Author:** [@the-ninth](https://community.openhab.org/u/the-ninth)\ **Replies:** 6\ **Last updated:** [June 20, 2026, 4:47am UTC](https://community.openhab.org/t/mapdb-vs-rrd4j-recommended-persistence-setup/169592 "2026-06-20T04:47:33Z")
Hi, I have been trying to clean up some openHAB health issues, and one of them pointed out that no default persistence service was defined. I had never touched those settings before, so I started looking into them and … --- ## [InfluxDb downsampled data](https://community.openhab.org/t/influxdb-downsampled-data/169305)
**Author:** [@Dash](https://community.openhab.org/u/Dash)\ **Replies:** 1\ **Last updated:** [May 16, 2026, 1:52pm UTC](https://community.openhab.org/t/influxdb-downsampled-data/169305 "2026-05-16T13:52:28Z")
I’m considering the move to InfluxDb (v1) from RR4J. I currently make use of charts, in the main UI and sitemaps, and analytics. I want to retain the RR4J functionality of downsampling historical data, but ideally I wa… --- ## [New TimescaleDB Persistence Service for openHAB](https://community.openhab.org/t/new-timescaledb-persistence-service-for-openhab/168837)
**Author:** [@ulbi](https://community.openhab.org/u/ulbi)\ **Replies:** 15\ **Last updated:** [April 24, 2026, 1:36pm UTC](https://community.openhab.org/t/new-timescaledb-persistence-service-for-openhab/168837 "2026-04-24T13:36:25Z")
Hi all, I just opened a PR (\[timescaledb\] Initial contribution by ulbi · Pull Request #20412 · openhab/openhab-addons · GitHub) for a new native TimescaleDB persistence add-on. Why I built it JDBC can connect to Timesc… --- ## [\[solved\] MapDB growing indefinitely](https://community.openhab.org/t/solved-mapdb-growing-indefinitely/169091)
**Author:** [@dolittle](https://community.openhab.org/u/dolittle)\ **Replies:** 6\ **Last updated:** [April 23, 2026, 6:59am UTC](https://community.openhab.org/t/solved-mapdb-growing-indefinitely/169091 "2026-04-23T06:59:47Z")
Hi, my mapdb is growing indefinitely filling my disk completely after some time. I’ve searched the community for a relating issue, but nothing covered my issue or I didn’t recognize it. My persistence rules are defaul… --- ## [Upgrade OH3.4 to OH5.1 | No data persistence](https://community.openhab.org/t/upgrade-oh3-4-to-oh5-1-no-data-persistence/169055)
**Author:** [@DaChunky](https://community.openhab.org/u/DaChunky)\ **Replies:** 2\ **Last updated:** [April 14, 2026, 5:55pm UTC](https://community.openhab.org/t/upgrade-oh3-4-to-oh5-1-no-data-persistence/169055 "2026-04-14T17:55:06Z")
Hi, I’ve recently upgraded from OH 3.4 to OH 5.1. Erverything works fine. Thanks for the smooth upgrade procedure. Unfortunately the OH 5.1 does not write any data to my MariaDB database. The only thing I’ve changed aft… --- ## [InfluxDB2 Persistence: Wrong calculation for Rain using Blockly/Persistence](https://community.openhab.org/t/influxdb2-persistence-wrong-calculation-for-rain-using-blockly-persistence/169054)
**Author:** [@Mario75](https://community.openhab.org/u/Mario75)\ **Replies:** 0\ **Last updated:** [April 14, 2026, 4:02pm UTC](https://community.openhab.org/t/influxdb2-persistence-wrong-calculation-for-rain-using-blockly-persistence/169054 "2026-04-14T16:02:40Z")
Hi everyone, I’m trying to calculate the amount of rain over a specific period (e.g., the last week) using Blockly and InfluxDB2. However, the result I’m getting is incorrect (a negative value), and I suspect a misunder… --- ## [Any suggestions regarding Persistence on change?](https://community.openhab.org/t/any-suggestions-regarding-persistence-on-change/168688)
**Author:** [@wjones](https://community.openhab.org/u/wjones)\ **Replies:** 2\ **Last updated:** [March 2, 2026, 5:44pm UTC](https://community.openhab.org/t/any-suggestions-regarding-persistence-on-change/168688 "2026-03-02T17:44:51Z")
Hi All, Today, I am using MariaDB JDBC persistence service with an every change strategy. Recently, I realised some of my z-wave devices were sending energy reports every 5 seconds. This was clogging up my z-wave netw… --- ## [OH5 - Persistence Error message](https://community.openhab.org/t/oh5-persistence-error-message/168646)
**Author:** [@icompas](https://community.openhab.org/u/icompas)\ **Replies:** 3\ **Last updated:** [February 26, 2026, 9:52am UTC](https://community.openhab.org/t/oh5-persistence-error-message/168646 "2026-02-26T09:52:07Z")
I just upgrade to 5.1.3 and just now recognized the changes made to persistence. Anyhow, I renamed the persistence definition file to “influxdb.persist.old” for my influxDB and defined all strategies in the UI, except t… --- ## [Mapdb.persist](https://community.openhab.org/t/mapdb-persist/168381)
**Author:** [@hr3](https://community.openhab.org/u/hr3)\ **Replies:** 1\ **Last updated:** [February 12, 2026, 11:02pm UTC](https://community.openhab.org/t/mapdb-persist/168381 "2026-02-12T23:02:45Z")
In the past, I had no problems with mapdb.persist Strategies {default = everyChange} Items {mCR\* : strategy = everyChange, restoreOnStartup} Now with Release 5.1.x, I get after starting 22:34:27.589\\\[WARN\\\] \\\[org.open… --- ## [Persistence issue with OH5](https://community.openhab.org/t/persistence-issue-with-oh5/167109)
**Author:** [@pleedell](https://community.openhab.org/u/pleedell)\ **Replies:** 2\ **Last updated:** [February 12, 2026, 2:45pm UTC](https://community.openhab.org/t/persistence-issue-with-oh5/167109 "2026-02-12T14:45:35Z")
I have an odd persistence/chart issue since upgrading to OH5 that I’ve noticed recently. For detail, my setup is OH5.0.2 on RPI5 (openhabian) using JDBC with a MariaDB instance on my NAS. I have 3 shelly H&T’s tracking… --- ## [Add a things' location to the persistence for influxdb](https://community.openhab.org/t/add-a-things-location-to-the-persistence-for-influxdb/168193)
**Author:** [@robjkamp](https://community.openhab.org/u/robjkamp)\ **Replies:** 4\ **Last updated:** [February 3, 2026, 4:38pm UTC](https://community.openhab.org/t/add-a-things-location-to-the-persistence-for-influxdb/168193 "2026-02-03T16:38:07Z")
I would like to add a things’ location to the measurememts sent to influxdb. Is this achievable in any way? --- ## [Persistence changes in 5.1](https://community.openhab.org/t/persistence-changes-in-5-1/167915)
**Author:** [@mstormi](https://community.openhab.org/u/mstormi)\ **Replies:** 26\ **Last updated:** [January 31, 2026, 3:40pm UTC](https://community.openhab.org/t/persistence-changes-in-5-1/167915 "2026-01-31T15:40:48Z")
Default persistence configuration has changed in 5.1 as announced here. Please discuss all persistence - migration issues here rather than in the openHAB 5.1 Release discussion thread, thank you. --- ## [Victoria metrics persistence service](https://community.openhab.org/t/victoria-metrics-persistence-service/164343)
**Author:** [@johnuopini](https://community.openhab.org/u/johnuopini)\ **Replies:** 3\ **Last updated:** [January 29, 2026, 9:33pm UTC](https://community.openhab.org/t/victoria-metrics-persistence-service/164343 "2026-01-29T21:33:28Z")
Hello everyone, I’m happy to announce that I’m working on a VictoriaMetrics persistence binding for openHAB! VictoriaMetrics is an efficient and highly performant time-series database, often regarded as a superior alte… --- ## [JDBC Persistence (MariaDB) unable to log into MySQL-Server after Upgrade to 5.1 (wrong charset)](https://community.openhab.org/t/jdbc-persistence-mariadb-unable-to-log-into-mysql-server-after-upgrade-to-5-1-wrong-charset/168081)
**Author:** [@jlemmer](https://community.openhab.org/u/jlemmer)\ **Replies:** 8\ **Last updated:** [January 27, 2026, 3:27pm UTC](https://community.openhab.org/t/jdbc-persistence-mariadb-unable-to-log-into-mysql-server-after-upgrade-to-5-1-wrong-charset/168081 "2026-01-27T15:27:55Z")
I just upgraded from OH4 to OH5.1 with a clean install of openhabian and restoring a backup. The configuration of the MariaDB persistence was present after the restore, so this is 1:1 to the working configuration of the … --- ## [Persistence API Queries Fail](https://community.openhab.org/t/persistence-api-queries-fail/167923)
**Author:** [@BrettLHolmes](https://community.openhab.org/u/BrettLHolmes)\ **Replies:** 10\ **Last updated:** [January 16, 2026, 10:56am UTC](https://community.openhab.org/t/persistence-api-queries-fail/167923 "2026-01-16T10:56:33Z")
Hi Openhabian openHAB 5.1.1 RPi5 8Gb Ram Hi I upgraded to openHAB 5.1.1 from 5.1.0 this morning I happened to be trying to do some API work and I noticed that the persistence queries for the items do not seem to w… --- ## [Is there a persistance bug in 5.1.0 for MapDB?](https://community.openhab.org/t/is-there-a-persistance-bug-in-5-1-0-for-mapdb/167909)
**Author:** [@dastrix80](https://community.openhab.org/u/dastrix80)\ **Replies:** 7\ **Last updated:** [January 11, 2026, 10:14pm UTC](https://community.openhab.org/t/is-there-a-persistance-bug-in-5-1-0-for-mapdb/167909 "2026-01-11T22:14:54Z")
This is my current file, but it wont record the state for GarageAir\_MasterSwitch Current mapdb.persist file is: Items { GarageAir\_MasterSwitch : strategy = everyChange, restoreOnStartup Motion\_PartyMode : stra… --- ## [InfluxDB timeout from docker](https://community.openhab.org/t/influxdb-timeout-from-docker/166589)
**Author:** [@GluffiS](https://community.openhab.org/u/GluffiS)\ **Replies:** 2\ **Last updated:** [December 18, 2025, 12:10pm UTC](https://community.openhab.org/t/influxdb-timeout-from-docker/166589 "2025-12-18T12:10:49Z")
I seem to have a strange problem with my Openhab running in docker. For some reason I get this error: 2025-10-02 13:13:26.850 \[ERROR\] \[icrometer.influx.InfluxMeterRegistry\] - unable to create database ‘openhab’ java.ne… --- ## [Why are persistence records not deleted when the item is deleted?](https://community.openhab.org/t/why-are-persistence-records-not-deleted-when-the-item-is-deleted/166930)
**Author:** [@3edc](https://community.openhab.org/u/3edc)\ **Replies:** 6\ **Last updated:** [December 15, 2025, 5:04am UTC](https://community.openhab.org/t/why-are-persistence-records-not-deleted-when-the-item-is-deleted/166930 "2025-12-15T05:04:52Z")
What the title says, when persisting with RRD4J or JDBC (mariadb/mysql), all records remain if the associated items is deleted. Cannot see any reason for this behaviour. Over time a lot of garbage remains in the persist… --- ## [Historical data with MariaDB- wrong format](https://community.openhab.org/t/historical-data-with-mariadb-wrong-format/167139)
**Author:** [@agricola](https://community.openhab.org/u/agricola)\ **Replies:** 4\ **Last updated:** [December 14, 2025, 1:55pm UTC](https://community.openhab.org/t/historical-data-with-mariadb-wrong-format/167139 "2025-12-14T13:55:20Z")
Hello, I’ll use my historical data in the charts area, but it seems, the format is the raw long number from the originally Mariadb- (Mysql-) timestamp: (How) can I format it to an human readable format? I’d not foun… --- ## [PostgreSQL/TimescaleDB max identifier length](https://community.openhab.org/t/postgresql-timescaledb-max-identifier-length/167344)
**Author:** [@jarnob](https://community.openhab.org/u/jarnob)\ **Replies:** 3\ **Last updated:** [November 28, 2025, 9:29pm UTC](https://community.openhab.org/t/postgresql-timescaledb-max-identifier-length/167344 "2025-11-28T21:29:53Z")
I ran into an issue where the persistence of my item failed, due to the fact that the UID of the items has more than 63 characters. Not a big issue: i’ve renamed the items with a shorter name and now it all functions cor… --- ## [Proposal: Offsetting RRD4J timestamp](https://community.openhab.org/t/proposal-offsetting-rrd4j-timestamp/167296)
**Author:** [@iodb](https://community.openhab.org/u/iodb)\ **Replies:** 2\ **Last updated:** [November 24, 2025, 5:58pm UTC](https://community.openhab.org/t/proposal-offsetting-rrd4j-timestamp/167296 "2025-11-24T17:58:30Z")
A topic that has been mentioned by occasion in this forum is how to ‘time offset’ item states as they are persisted in the database. My use case is similar: One Item (bound to my Homewizard P1 energy meter Thing) cont… --- ## [Double persistence entries for items](https://community.openhab.org/t/double-persistence-entries-for-items/167322)
**Author:** [@binderth](https://community.openhab.org/u/binderth)\ **Replies:** 0\ **Last updated:** [November 24, 2025, 4:34pm UTC](https://community.openhab.org/t/double-persistence-entries-for-items/167322 "2025-11-24T16:34:52Z")
running OH5.0.3 on docker. My persistence (JDBC with mariaDB) does insert double on everyChange: the jdbc-persistence looks like this: configurations: - items: - "\*" - "!PL12Images\*" strategies: … --- ## [Migrate data from InfluxDB v2 to TimescaleDB](https://community.openhab.org/t/migrate-data-from-influxdb-v2-to-timescaledb/167316)
**Author:** [@jarnob](https://community.openhab.org/u/jarnob)\ **Replies:** 0\ **Last updated:** [November 24, 2025, 12:49pm UTC](https://community.openhab.org/t/migrate-data-from-influxdb-v2-to-timescaledb/167316 "2025-11-24T12:49:00Z")
I have been tinkering with my persistence databases. I ran InfluxDB v1 for almost 3 years now and made a mistake by upgrading to InfluxDB v2 a couple of months ago. Couldn’t get used to the flux language. I decided to in… --- ## [Offset by minutes](https://community.openhab.org/t/offset-by-minutes/144574)
**Author:** [@ChrisA](https://community.openhab.org/u/ChrisA)\ **Replies:** 5\ **Last updated:** [November 20, 2025, 5:24pm UTC](https://community.openhab.org/t/offset-by-minutes/144574 "2025-11-20T17:24:39Z")
is it possible to offset a value in a chart by minutes. i get values from an opendata project that are time shifted and i want to plot those with the ones i measure. i use a rrdj4 persistence. [Next page](https://community.openhab.org/c/add-ons/persistence/16.md?page=1)