Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Database is locked #925

Closed
awrichar opened this issue Aug 4, 2022 · 2 comments · Fixed by #928
Closed

Database is locked #925

awrichar opened this issue Aug 4, 2022 · 2 comments · Fixed by #928
Assignees
@awrichar
Milestone
v1.1.0

Comments

@awrichar
Copy link
Contributor

awrichar commented Aug 4, 2022

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 awrichar mentioned this issue Aug 4, 2022
Merged
@awrichar awrichar reopened this Aug 11, 2022
@awrichar awrichar mentioned this issue Aug 11, 2022
Closed
@awrichar awrichar added this to the v1.1.0 milestone Aug 11, 2022
@awrichar
Copy link
Contributor Author

Reopening as this has still been seen lately.

@awrichar
Copy link
Contributor Author

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 hyperledger/firefly-common#30 and no longer seen after bringing this into mainline (as part of PR #960).

@awrichar awrichar self-assigned this Aug 16, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@awrichar awrichar

Labels
None yet
Projects
FireFly
Status: Done
Milestone
v1.1.0
Development

Successfully merging a pull request may close this issue.

Wait up to 1000ms to lock sqlite database kaleido-io/firefly
1 participant
@awrichar