Database is locked

[gladdiologist]

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.

[e-n-f]

Thanks for the report. Tippecanoe does its own locking internally to make sure that multiple threads do not access the database at the same time. I don't know why sqlite3 thinks that some other remote process is accessing the same file simultaneously.

You are specifically seeing this problem in tile-join, not in tippecanoe itself?

[gladdiologist]

In this case, tippecanoe only processed local files and tile-join were used to join local files and wrote the result to a network share.
I tried a tippecanoe process writing to the same network share and got the same result:

2019-10-15T19:15:14.96+0000 [APP/TASK/task/0] ERR bin/tippecanoe: Tileset "/var/vcap/data/fd085769-c006-446a-895a-035dfec3ae7d/countries-z3.mbtiles" already exists. You can use --force if you want to delete the old tileset.
2019-10-15T19:15:14.96+0000 [APP/TASK/task/0] ERR bin/tippecanoe: database is locked

(--force flag doesn't help and countries-z3.mbtiles doesn't exist at all)
Hope this help.

[runeanielsen]

@gladdiologist did you ever figure this issue out? Thanks in advance.