I forgot to cite this important discussion : https://github.com/qgis/QGIS/issues/27899 that could help in some situations with the following environment variables :
OGR_SQLITE_JOURNAL=DELETE SQLITE_USE_OGR_VFS=YES Le mer. 6 mai 2020 à 12:47, Jésahel Benoist <[email protected]> a écrit : > > Le mer. 6 mai 2020 à 12:00, Stefan Keller <[email protected]> a écrit : > >> Jésahel wrote >> > I've created a script to deactivate wal on samba shares, because samba >> is the main issue. >> > It contains this only line : >> QSettings().setValue("/qgis/walForSqlite3", False) >> >> That's interesting. Are you sure it's Samba? >> SQLite FAQ [2] confirms that NFS has problems. >> Did not find issues on Samba, but file locking with fcntl is mentioned >> here [3]. > > > No, I was speaking specifically of my concern on samba shares, based on a > lot (a lot !) of reading/testing like > https://trac.osgeo.org/gdal/wiki/UserDocs/SQLite > https://www.sqlite.org/wal.html > > https://gis.stackexchange.com/questions/224188/geopackage-error-is-mounted-and-in-wal-mode-this-combination-is-not-allowed > > > I confirm multi-users reading is possible. > > If you have problems with WAL files (corrupted or unusable gpkg), you can > open the gpkg file with spatialite or another program and enter these SQL > queries : > PRAGMA integrity_check; > PRAGMA journal_mode = DELETE; > >
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
