<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">I was just going to say, I think it's
situations like this why PostGIS exists. <br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">On 8/13/24 3:41 AM, Francesco Pelullo
via QGIS-User wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAH6xWvipzLQKMbNR=YiSGunME7mH3=SO5aXfAmq5pxPubXmP3Q@mail.gmail.com">
<div dir="auto">
<div>Hi Simon,</div>
<div dir="auto"><br>
</div>
<div dir="auto">We're usually store data in .gpkg on network
drive.</div>
<div dir="auto"><br>
</div>
<div dir="auto">Data access in read mode is very nice, also with
dozen concurrent users.</div>
<div dir="auto"><br>
</div>
<div dir="auto">Instead, writing data in .gpkg on network drive
can cause errors, specially if from two or more concurrent
users.</div>
<div dir="auto"><br>
</div>
<div dir="auto">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.</div>
<div dir="auto"><br>
</div>
<div dir="auto">My suggestion is: split .gpkg in smallest parts,
assign every area (or part) to a user, merge parts at the end.</div>
<div dir="auto"><br>
</div>
<div dir="auto">Or, use PostGIS.</div>
<div dir="auto"><br>
</div>
<div dir="auto">Regards </div>
<div dir="auto"><br>
</div>
<div dir="auto">Francesco</div>
<div dir="auto"><br>
</div>
<div dir="auto"><br>
<div class="gmail_quote" dir="auto">
<div dir="ltr" class="gmail_attr">Il mar 13 ago 2024, 09:30
Simon Gröchenig via QGIS-User <<a
href="mailto:qgis-user@lists.osgeo.org"
moz-do-not-send="true" class="moz-txt-link-freetext">qgis-user@lists.osgeo.org</a>>
ha scritto:<br>
</div>
<blockquote class="gmail_quote">
<div>
<div>
<p>Hi list,</p>
<p>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:</p>
<blockquote type="cite">
<p>Provider errors: OGR error committing
transaction: sqlite3_exec(COMMIT) failed: disk I/O
error</p>
</blockquote>
<p>No problems occur modifying the same GPKG when it
is located on a local drive.</p>
<p>I found the following 8-year-old qgis-user thread:
<a
href="https://qgis-user.osgeo.narkive.com/bjrGqIjn/something-to-think-about-geopackage-and-wal"
target="_blank" rel="noreferrer"
moz-do-not-send="true"
class="moz-txt-link-freetext">https://qgis-user.osgeo.narkive.com/bjrGqIjn/something-to-think-about-geopackage-and-wal</a></p>
<p>Is this thread related to the disk I/O error?</p>
<p>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?</p>
<p>Best regards<br>
Simon</p>
<p><br>
</p>
</div>
</div>
_______________________________________________<br>
QGIS-User mailing list<br>
<a href="mailto:QGIS-User@lists.osgeo.org" target="_blank"
rel="noreferrer" moz-do-not-send="true"
class="moz-txt-link-freetext">QGIS-User@lists.osgeo.org</a><br>
List info: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer noreferrer" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a
href="https://lists.osgeo.org/mailman/listinfo/qgis-user"
rel="noreferrer noreferrer" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</blockquote>
</div>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
QGIS-User mailing list
<a class="moz-txt-link-abbreviated" href="mailto:QGIS-User@lists.osgeo.org">QGIS-User@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
<p><br>
</p>
</body>
</html>