GeoPackage database locked for writing
Closed this issue · 1 comments
bmcbride commented
I'm having trouble writing to an FDW table based on a GeoPackage file. It seems as if Postgres obtains a permanent lock on the SQLite database. SELECTs work fine, but I'm getting the below error when trying to UPDATE.
ERROR: GDAL AppDefined [1] failed to execute update : database is locked
SQL state: XX000
Has anyone else experienced this and are there any workarounds? Thanks!
bmcbride commented
Setting the GeoPackage SQLite Journal Mode to WAL seems to resolve the database locking issue I was experiencing.