I am exporting a large dataset to Geopackages divided into municipality, county and nationwide datasets. Only for some of the largest ones I get errors like this:
2026-03-14 21:22:05|3087.0| 4.4|ERROR |OGCGEOPACKAGE writer: sqlite3_exec(DETACH DATABASE "temp_rtree_48b1c18db46d5df6f87d84127b4186ce") failed: database temp_rtree_48b1c18db46d5df6f87d84127b4186ce is locked
As far as I can see, the produced geopackage works fine and the content is complete. But an additional file is left together with the zipped geopackage file.
The full file name of the extra file is something like Basisdata_0301_Oslo_25832_FKB-Gronnstruktur_GPKG.gpkg.tmp_rtree_bunnsjikt.db. Have anyone else seen this? Could this be related to some kind of size limitation of the Geopackage/SQLite format? Are there any workaround or solution? The FME version is 2024.2.3.
