influxdata / influxdata/influxdata-docker

Influx 2.1.0 and up: influxd.sqlite -> database locked. Azure Linux web app with share

Open
#668 0 comments 0 reactions 0 assignees View on GitHub
influxdb
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.