# SQLite sometimes fails with SQLITE\_BUSY after OH upgrade to 4.0.3

**URL:** <https://community.openhab.org/t/sqlite-sometimes-fails-with-sqlite-busy-after-oh-upgrade-to-4-0-3/150691>\
**Category:** Persistence Services\
**Tags:** sqlite\
**Created:** [October 26, 2023, 5:48am UTC](https://community.openhab.org/t/sqlite-sometimes-fails-with-sqlite-busy-after-oh-upgrade-to-4-0-3/150691 "2023-10-26T05:48:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kennet](https://community.openhab.org/letter_avatar_proxy/v4/letter/k/3bc359/32.png) [@Kennet](https://community.openhab.org/u/Kennet)\
**Post date:** [October 26, 2023, 5:48am UTC](https://community.openhab.org/t/sqlite-sometimes-fails-with-sqlite-busy-after-oh-upgrade-to-4-0-3/150691/1 "2023-10-26T05:48:08Z")

</div>

Hi

I am running OH in a docker container on my Synology NAS.  
I recently upgraded from OH 3.4.0 to 4.0.3.  
After the upgrade I started getting occasional errors with.

> 2023-10-26 06:00:00.845 [WARN] [jdbc.internal.JdbcPersistenceService] - JDBC::store: Unable to store item  
> org.openhab.persistence.jdbc.internal.exceptions.JdbcSQLException: Error in SQL query!!!; [SQLITE\_BUSY] The database file is locked (database is locked) Query: INSERT OR IGNORE INTO item0016 (TIME, VALUE) VALUES( strftime(‘%Y-%m-%d %H:%M:%f’ , ‘now’ , ‘localtime’), CAST( ? as DOUBLE) ) Parameters: [0.021]; Pool Name= yank-default; SQL= INSERT OR IGNORE INTO item0016 (TIME, VALUE) VALUES( strftime(‘%Y-%m-%d %H:%M:%f’ , ‘now’ , ‘localtime’), CAST( ? as DOUBLE) )  
> at org.openhab.persistence.jdbc.internal.db.JdbcSqliteDAO.doStoreItemValue(JdbcSqliteDAO.java:123) ~[?:?]  
> at org.openhab.persistence.jdbc.internal.JdbcMapper.storeItemValue(JdbcMapper.java:220) ~[?:?]  
> at org.openhab.persistence.jdbc.internal.JdbcPersistenceService.internalStore(JdbcPersistenceService.java:162) ~[?:?]  
> at org.openhab.persistence.jdbc.internal.JdbcPersistenceService.store(JdbcPersistenceService.java:140) ~[?:?]  
> at org.openhab.core.persistence.internal.PersistenceManager.lambda$7(PersistenceManager.java:170) ~[?:?]  
> at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[?:?]  
> at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179) ~[?:?]  
> at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179) ~[?:?]  
> at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:179) ~[?:?]  
> at java.util.AbstractList$RandomAccessSpliterator.forEachRemaining(AbstractList.java:720) ~[?:?]  
> at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509) ~[?:?]  
> at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499) ~[?:?]  
> at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150) ~[?:?]  
> at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173) ~[?:?]  
> at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[?:?]  
> at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:596) ~[?:?]  
> at org.openhab.core.persistence.internal.PersistenceManager.lambda$3(PersistenceManager.java:168) ~[?:?]  
> at java.util.concurrent.ConcurrentHashMap$ValuesView.forEach(ConcurrentHashMap.java:4780) ~[?:?]  
> at org.openhab.core.persistence.internal.PersistenceManager.handleStateEvent(PersistenceManager.java:165) ~[?:?]  
> at org.openhab.core.persistence.internal.PersistenceManager.stateUpdated(PersistenceManager.java:334) ~[?:?]  
> at org.openhab.core.items.GenericItem.lambda$1(GenericItem.java:258) ~[?:?]  
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]  
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]  
> at java.lang.Thread.run(Thread.java:833) ~[?:?]

I have a rule that updates two items every 10 minutes and most of the updates get stored without any error.  
I did not change anything else in the update so I am guess it must be the OH update that cause the issue as I have never seen the issue before.  
It looks like the error will only happen on one of the two items, so I am guessing this might be a threading issue in the SQLite persistance service.  
I tried restarting both NAS and OH several times.

Anybody have an input what might cause this ?

---

<div class="post-metadata">

**Author:** ![Kennet](https://community.openhab.org/letter_avatar_proxy/v4/letter/k/3bc359/32.png) [@Kennet](https://community.openhab.org/u/Kennet)\
**Post date:** [October 30, 2023, 3:01pm UTC](https://community.openhab.org/t/sqlite-sometimes-fails-with-sqlite-busy-after-oh-upgrade-to-4-0-3/150691/2 "2023-10-30T15:01:18Z")

</div>

Reported in [[jdbc-sqlite] Sometimes fails with SQLITE\_BUSY with OH 4.0.3 · Issue #15821 · openhab/openhab-addons · GitHub](https://github.com/openhab/openhab-addons/issues/15821)