I was just going to say, I think it's situations like this why PostGIS
exists.
On 8/13/24 3:41 AM, Francesco Pelullo via QGIS-User wrote:
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
<qgis-user@lists.osgeo.org> 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
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
