[Qgis-user] Editing GPKG from network drive

[Francesco Pelullo]

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 at 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 at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240813/90f26c66/attachment.htm>