Fatal Error: insert into "attributeValueNumber" ("deviceAttributeId", "time", "value") values (..) - SQLITE_BUSY: database is locked

---

Shortened the title

Anyways, ever since upgrading an old install to v0.9 I’m getting this error from time to time. There is no specific time between the errors, Every few days Pimatic crashes with this error.
The service is not running anymore and this error is the last line in the log.
I said I upgraded, but to be more specific I just formatted the SDcard with a brand new jessie-lite image, installed pimatic v0.9 and loaded the old config.
Pimatic is up to date to the latest version(s) and for a test I have deleted the sqlite database (to create a new one, in case of corruption in the database).
It’s only pimatic that’s crashing, the OS stays running without a issue.

Hey @koffienl,

is sqlite3 installed correctly?
When I installed pimatic v0.9, I had a lot of problems with sqlite, because it wasnt installed correctly. I went to the directory pimatic-app/node_modules, deleted sqlite3 with sudo rm -r sqlite3 and installed it again with sudo npm install --unsafe-perm --verbose -g sqlite3. After this, everything worked fine

Hope this will help you!
Greets Felix

I was just about to make a similar topic: this happens twice to me in the past week, after the last pimatic update (I have been running on v.09 for ages).
Koffie, did it also happen before last week with you?

I am considering the following options:

• bug in latest update of pimatic
• error cause by USB stick issues (pimatic is running on a USB stick)
• In my case it happened twice in the morning, so I was considering some timers being updated to frequently. If it is truly random in your case than tat is unlikely.

Felix, did you have this error or other errors related to SQLIte?

It could be sqlite, bu on the other hand : it’s completely random. If it was a crippled sqlite install it should crash every single time there is a database update.
Weird thing is, it didn’t happened anymore since I created this post. Pimatic is up to date.

I also appeared intermittently this error. Helped replacement SD Card