Database is locked
Nobody has claimed this yet.
- Dominant language
- C++
- Stars
- 3.1k
- Forks
- 430
- PR merge metrics
- No merged PRs in 30d
Description
Hi,
I have problems when joining multiple mbtiles files in one and output the result on a network share (SMB share). The process crash with a "database is locked" error.
I tried with TIPPECANOE_MAX_THREADS=1, to disable multithreading with no luck.
It seems that this issue is related to sqlite, maybe this can help
For the moment, mouting the volume with nolock is a good workaround but i'm looking for a better solution.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No source file or test is named. Start by reproducing the multi-MBTiles join while writing to an SMB share, with TIPPECANOE_MAX_THREADS=1, then compare the failure with SQLite's locking guidance; done means the join completes without the database-locked error or requiring the nolock workaround.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, sqlite
- Domain
- databases, networking
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100