<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <br>
    <blockquote type="cite" cite="mid:rmisfttniqr.fsf@s1.lexort.com">
      <pre class="moz-quote-pre" wrap="">So it looks like qgis is also resetting the mode to delete, or perhaps
GDAL is doing that.   I haven't found that in the sources so far.</pre>
    </blockquote>
    <br>
    <p>Both attempt at doing this:<br>
    </p>
    <p>- QGIS at
<a class="moz-txt-link-freetext" href="https://github.com/qgis/QGIS/blob/master/src/core/providers/ogr/qgsogrproviderutils.cpp#L1172">https://github.com/qgis/QGIS/blob/master/src/core/providers/ogr/qgsogrproviderutils.cpp#L1172</a>
      to #L1230 when it closes the last connection instance of a GPKG
      file<br>
    </p>
    <p>- and OGR too :
<a class="moz-txt-link-freetext" href="https://github.com/OSGeo/gdal/blob/master/ogr/ogrsf_frmts/sqlite/ogrsqlitedatasource.cpp#L367">https://github.com/OSGeo/gdal/blob/master/ogr/ogrsf_frmts/sqlite/ogrsqlitedatasource.cpp#L367</a></p>
    <p><br>
    </p>
    <p>Probably the most reasonable & simple change for QGIS would
      be turn WAL only when QGIS update mode is turned on. Would require
      testing that deadlocks don't occur with existing readers prior to
      turning WAL on (or accept that risk...)<br>
    </p>
    <p><br>
    </p>
    <blockquote type="cite" cite="mid:rmisfttniqr.fsf@s1.lexort.com">
      <pre class="moz-quote-pre" wrap="">
</pre>
      <br>
      <fieldset class="mimeAttachmentHeader"></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>
    <pre class="moz-signature" cols="72">-- 
<a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
  </body>
</html>