SQLITE_BUSY - DB Full?

Add-ons Persistence Services
21

It still happens…
2019-11-08 19:00:03.139 [ERROR] [org.knowm.yank.Yank ] - Error in SQL query!!!
java.sql.SQLException: [SQLITE_BUSY] The database file is locked (database is locked) Query: SELECT time, value FROM item0867 WHERE TIME>‘2019-11-08 00:00:00’ ORDER BY time ASC Parameters: []

I guess I need to consider another persistence then. :frowning:

22

By the way: Is there any option to migrate SQlite data from my existing DB to InfluxDB? :slight_smile:

23

Search the forum. Someone published a script to migrate from rrd4j to InfluxDB using the OH REST API to pull the data out of rrd4j that should work for any active OH persistence, perhaps with only very minor modifications.

1 Like
24

I found it!
Thanks for the hint.