[OSGeo-Discuss] SQLite databases locked

[Jonathan Moules]

Hi Meinrad,

I don't know anything about MapGuide, but I know a little about SQLite, 
so in lieu of anyone else answering...

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 
(https://stackoverflow.com/questions/3747232/how-expensive-sqlite3-connect-and-close-in-sqlite). 
So "prevention" of this locking is unlikely to be desirable.

Now if MapGuide has a way of "disconnecting" a layer, that's a question 
for someone who knows MapGuide.

(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" - 
https://mapguide.osgeo.org/)

Cheers,

Jonathan


On 2018-09-24 17:03, mwk5001 at gmx.ch wrote:
> Hi,
> 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.
> 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?
> Thank you and best regards,
> Meinrad
>
>
> _______________________________________________
> Discuss mailing list
> Discuss at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/discuss

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/discuss/attachments/20180925/33ac8a7d/attachment.html>