firefly icon indicating copy to clipboard operation
firefly copied to clipboard

Published 20 hours ago • verified publisher icon hyperledger

Database is locked

Open awrichar opened this issue 2 years ago • 1 comments

From Discord thread "Database is locked": https://discord.com/channels/905194001349627914/997135847797305484

Sometimes when running with the sqlite database, an HTTP request will be met with {"error":"FF10116: Database insert failed: database is locked"}. This seems to happen most frequently with the tokens E2E tests, although it's not necessarily specific to tokens. Might just be an issue with too many concurrent database routines on the sqlite database.

awrichar avatar Aug 04 '22 13:08 awrichar

Reopening as this has still been seen lately.

awrichar avatar Aug 11 '22 15:08 awrichar

This appears to have been a side-effect of config having been moved and no longer picking up defaults. sqlite was being configured with concurrency of "0" (unlimited connections) instead of "1".

Fixed by https://github.com/hyperledger/firefly-common/pull/30 and no longer seen after bringing this into mainline (as part of PR https://github.com/hyperledger/firefly/pull/960).

awrichar avatar Aug 16 '22 04:08 awrichar