Hi Simon, We're usually store data in .gpkg on network drive.
Data access in read mode is very nice, also with dozen concurrent users. Instead, writing data in .gpkg on network drive can cause errors, specially if from two or more concurrent users. This is because of limits of SQLite format. In past, there was suggestions about a "semaphore" file that prevents to edit .gpkg file, if another user is editing. My suggestion is: split .gpkg in smallest parts, assign every area (or part) to a user, merge parts at the end. Or, use PostGIS. Regards Francesco Il mar 13 ago 2024, 09:30 Simon Gröchenig via QGIS-User < [email protected]> ha scritto: > Hi list, > > a project partner "sometimes" struggles to edit GPKGs that are saved on a > network drive. Trying to modify the GPKG in QGIS results in the following > error: > > Provider errors: OGR error committing transaction: sqlite3_exec(COMMIT) > failed: disk I/O error > > No problems occur modifying the same GPKG when it is located on a local > drive. > > I found the following 8-year-old qgis-user thread: > https://qgis-user.osgeo.narkive.com/bjrGqIjn/something-to-think-about-geopackage-and-wal > > Is this thread related to the disk I/O error? > > I would also like to ask if GPKGs or SQLite-DBs are still unsave to use > from network drives!? Is there any current information about this somewhere? > > Best regards > Simon > > > _______________________________________________ > 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 >
_______________________________________________ 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
