<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>It turns out there's a MapGuide list - you may find it useful to
ask there:</p>
<p><a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/mapguide-users">https://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</p>
<br>
<div class="moz-cite-prefix">On 2018-09-25 18:30, Jonathan Moules
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:15fcdd5f-770f-56de-c70e-34a0ca63c5ec@lightpear.com">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<p>Hi Meinrad,</p>
<p>I don't know anything about MapGuide, but I know a little about
SQLite, so in lieu of anyone else answering...</p>
<p>A locked SQLite database is like a connection to a regular
(PostGIS/Oracle) database - the application will usually keep
the file locked open if it's going to be reading/writing from
the database because connecting to the SQLite database is
relatively expensive
(<a class="moz-txt-link-freetext"
href="https://stackoverflow.com/questions/3747232/how-expensive-sqlite3-connect-and-close-in-sqlite"
moz-do-not-send="true">https://stackoverflow.com/questions/3747232/how-expensive-sqlite3-connect-and-close-in-sqlite</a>).
So "prevention" of this locking is unlikely to be desirable.<br>
</p>
<p>Now if MapGuide has a way of "disconnecting" a layer, that's a
question for someone who knows MapGuide.</p>
<p>(Un-relatedly if there's anyone from OSGeo reading this - The
MapGuide website seems very outdated (10 year old
documentation!) and has a lot of dead OSGeo links, i.e. the
links in "OSGeo Community" - <a class="moz-txt-link-freetext"
href="https://mapguide.osgeo.org/" moz-do-not-send="true">https://mapguide.osgeo.org/</a>)<br>
</p>
<p>Cheers,</p>
<p>Jonathan<br>
</p>
<br>
<div class="moz-cite-prefix">On 2018-09-24 17:03, <a
class="moz-txt-link-abbreviated" href="mailto:mwk5001@gmx.ch"
moz-do-not-send="true">mwk5001@gmx.ch</a> wrote:<br>
</div>
<blockquote type="cite"
cite="mid:trinity-55319896-d791-4494-a28c-a22b0ec9fcac-1537804990501@3c-app-gmx-bs47">
<div style="font-family: Verdana;font-size: 12.0px;">
<div> </div>
<div class="signature">Hi,</div>
<div class="signature"> </div>
<div class="signature">I'm using SQLite FDO and have the
problem that the databases get locked by MapGuide Open
Source. If I want to replace a database, I need to restart
the MapGuide service first.</div>
<div class="signature"> </div>
<div class="signature">Is there a setting to prevent this? Or
a command to instruct MapGuide to release the lock on a
specific database? How do you handle this?</div>
<div class="signature"> </div>
<div class="signature">Thank you and best regards,</div>
<div class="signature">Meinrad</div>
</div>
<!--'"--><br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Discuss mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Discuss@lists.osgeo.org" moz-do-not-send="true">Discuss@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/discuss" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/discuss</a></pre>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>