JDBC persist file wont take CRON syntax entries

Add-ons Persistence Services
#1

JDBC into a MYSQL DB on Openhab2 (up to date). Cron syntax entry of:
fifteenminutes : “0 0,15,30,45 * * * ?”

results in an error on persist file save. This just stopped working a few days ago with no changes to my config. Database only has the default everyChange.

Error on save with CRON syntax entry:
Error handling update of file ‘/etc/openhab2/persistence/jdbc.persist’: null

Error on save after removing the CRON syntax entry:
Refreshing model 'jdbc.persist’
Failed to delete cron job for dbId ‘jdbc’

#2

You could write the cron like this:

fifteenminutes : "0 0/15 * * * ?"

But I think, maybe there is another issue in the file, so could you please post the complete jdbc.persist?

#3

No changes were made to the file prior to the change in what was persisted and the errors:
//JDBC Strategies
Strategies {
fifteenminutes : "0 0,15,30,45 * * * ?"
default = everyChange
}

Items {
* : strategy = fifteenminutes, everyChange, restoreOnStartup
}

#4

Checked the installed base of files against their checksums for corrupted files. Only expected changes to the installed karaf .cfg files.

#5

we have some similar (the same?) problem here…
https://community.openhab.org/t/mapdb-persistence-error/23353

did you solve your problem?

#6

No and now the HTTP binding generates:
[ERROR] [org.openhab.io.net.http.HttpUtil ] - Fatal transport error: java.net.SocketTimeoutException: Read timed out

#7

Hi,
Is there any conclusion on this error message: Failed to delete cron job for dbId ‘jdbc’?

I observe that despite this error the persistence works ok (values are stored as expected, in my case every 15 mins) so not sure why it appears?