influxdata / influxdata/influxdata-docker
Influx 2.1.0 and up: influxd.sqlite -> database locked. Azure Linux web app with share
- Dominant language
- Shell
- Stars
- 364
- Forks
- 255
- Avg merge
- 3h 18m
- Merged PRs (30d)
- 7
Description
Recently we are running Influxdb on a Linux Web App in Azure. A file share from a Storage Account is linked to it (mount).
We have discovered that since the .sqlite file is introduced in 2.1.0, the web app doesn't want to start any more.
msg="Failed to apply SQL migrations" error="database is locked"
We have found several topics related to sqlite db files and azure share issues.
Is there a way to fix this, or even a possibility to ignore this database when running influxdb?
Topics:
https://learn.microsoft.com/en-us/answers/questions/346794/how-to-update-or-insert-sqlite-database-in-web-app
https://learn.microsoft.com/en-us/answers/questions/318948/azure-app-service-nodejs-sqlite3-lock-issue-cifs-m
https://stackoverflow.com/questions/74996628/sqlite-database-locked-for-writing-on-azure-linux-but-not-on-windows
https://github.com/MicrosoftDocs/azure-docs/issues/47130
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the InfluxDB 2.1.0-and-later startup failure with its SQLite database on an Azure Linux Web App mounted file share. Read the linked Azure and SQLite references to compare file-locking behavior and determine whether a supported configuration or database-skip option exists. Done means a verified fix or clear documentation of the required limitation and workaround.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, sqlite
- Domain
- cloud, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100