[QGIS-Developer] gpkg syncing issue

[Even Rouault]

On mercredi 13 mars 2019 17:44:11 CET Paolo Cavallini wrote:
> Hi all,
> when a geopackage is opened in QGIS, even if no change is made, the file
> is marked as changed. This can cause nightmares when syncing data,
> because if two users open a gpkg without editing, it is hard to decide
> what to do. Same for backups.
> Is there a way to avoid this?

Yes this is a known inconvenience (pretty sure there might be bugs open on 
this) due to opening GPKG files in write-ahead mode, so as to avoid issues in 
case of concurrent editing (probably helps also in situations of single 
editing where one thread does writing, and others are reading)

You can set the OGR_SQLITE_JOURNAL = DELETE environment variable, or the qgis/
walForSqlite3 = false setting to avoid that (but run in the possible above 
mentionned issues)

Even

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com