transactions: database is locked error reoccurs

moov-io / accounts

accounts - General Ledger and financial account service with an HTTP API

https://moov.io

Apache License 2.0

48 stars 14 forks source link

transactions: database is locked error reoccurs #82

Closed adamdecaf closed 4 years ago

adamdecaf commented 4 years ago

The following error pops up pretty often. It breaks apitest calls and fires off alerts. I thought this was fixed in https://github.com/moov-io/accounts/pull/80 but I guess not.

ts=2020-02-28T16:54:12.071421823Z caller=transactions.go:183 transactions="problem creating transaction: createTransaction: insert: error=database is locked rollback=<nil>" requestID=86863fc3494a97b707683e5c3f1b08fe363e569a

adamdecaf commented 4 years ago

We could look at adding a busy handler, but the go-sqlite library doesn't support it.

https://sqlite.org/forum/forumpost/c1fbe2411e
https://github.com/mattn/go-sqlite3/issues/290

adamdecaf commented 4 years ago

This should be addressed now. If it comes up again it's a new issue to look into.