[Qgis-user] GeoPackage deadlocks (Andrea Peri)

[Andrea Peri]

>In both cases my gut feel is that the best solution might
>be to look into use detection. If GDAL (I assume) can be
>improved to detect that either file type is already open
>then it might be possible to simply ban a second user
>from opening the file at the same time. This might
>frustrate some users but most importantly it would
>make the application safer from an ICT perspective.

Hi, afaik, internet and http is a sessionless protocol so i guess is quite
impossible to gdal understand that an user (another user) is using a file.
To have this kind of communication is use a messaging queue manager like
jboss.

This is my personal opinion.
Regards,
Andrea.



Il ven 27 set 2019, 09:13 Paul Wittle <paul.wittle at dorsetcouncil.gov.uk> ha
scritto:

> Hi Andrea and Enrico,
>
> Thank you for providing an answer even if it was not what I was hoping to
> hear; it was the conclusion I'd reached myself.
>
> Has this issue been considered given the official move from shapefile to
> geopackage as the default format?
>
> My understanding was that shapefiles could be used over a network and
> whilst multiple people editing was dangerous it did not cause deadlocks.
>
> Combined with the issues relating to MapInfo tab files over a network I've
> got into some hot water over my attempt to get QGIS rolled out in our
> organisation now. I'm going to have to think carefully about my next steps
> as it can be difficult to educate large numbers of staff and the two issues
> mean that people using QGIS incorrectly can cause pretty big issues.
>
> To summarise,
>  - You open a geopackage and save to the network; someone else comes along
> and opens it in their QGIS and everything looks okay until the PCs
> deadlock...ICT help calls and data corruption may occur.
>  - You open a MapInfo tab file from the network and it looks fine (accept
> that it my draw in a user projection). MapInfo user receive errors but this
> is unknown to the QGIS user...ICT help calls result.
>
> Whilst I'm glad the forums have helped to diagnose both behaviours I would
> personally say that the issues pose a bit of a threat to software adoption
> by larger companies and institutions that may be using Windows networks and
> potentially migrating from MapInfo.
>
> In both cases my gut feel is that the best solution might be to look into
> use detection. If GDAL (I assume) can be improved to detect that either
> file type is already open then it might be possible to simply ban a second
> user from opening the file at the same time. This might frustrate some
> users but most importantly it would make the application safer from an ICT
> perspective.
>
> These are of course just my personal opinion from my particular use case
> so please don't be offended by them if you disagree but I'd be really happy
> to hear how others are approaching the issues and/or opposing views?
>
> Many thanks,
> Paul
>
> Message: 4
> Date: Thu, 26 Sep 2019 11:10:45 +0200
> From: Andrea Peri <aperi2007 at gmail.com>
> To: Enrico Fiore <enricofiore at libero.it>
> Cc: qgis-user <qgis-user at lists.osgeo.org>
> Subject: Re: [Qgis-user] GeoPackage deadlocks
> Message-ID:
>         <
> CABqTJk-1hD9AtUVhtiW81zW7xe_KPEfut7bjcxxgSz0Me56-PQ at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hi,
> Geopackage is an Exchange format. Is not affordable in a multiuser data
> entry environment.
> This require a dbms like postgres + postfis.
>
> Regards,
> Andrea.
>
>
> Il gio 26 set 2019, 10:18 Enrico Fiore <enricofiore at libero.it> ha scritto:
>
> > Hi,
> >
> > Is anyone else getting occasional deadlocks when using GeoPackages in
> > the Long Term Release of QGIS?
> >
> > We are using them over a Windows network so there are multiple users
> > trying to access the same GeoPackage files. It all seems fine and two
> > or more can open the file to look at but when someone edits it you
> > sometimes hit a deadlock where none of the QGIS applications will shut
> down.
> >
> > I have the same issue and the same scenario. Multiple users that
> > trying to access a the same GeoPackage file located in a server causes
> QGIS deadlock.
> >
> > The issue rises also if no geopackage layer are in editing mode, but
> > simply loaded in one QGIS view.
> >
> > There is a solution for this behaviour or is this a bug?
> >
> > Regards,
> >
> >
> > Enrico
> > _______________________________________________
> > 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/20190926/10ada3cf/attachment-0001.html
> >
>
> ------------------------------
>
> This e-mail and any files transmitted with it are intended solely for the
> use of the individual or entity to whom they are addressed. It may contain
> unclassified but sensitive or protectively marked material and should be
> handled accordingly. Unless you are the named addressee (or authorised to
> receive it for the addressee) you may not copy or use it, or disclose it to
> anyone else. If you have received this transmission in error please notify
> the sender immediately. All traffic may be subject to recording and/or
> monitoring in accordance with relevant legislation. Any views expressed in
> this message are those of the individual sender, except where the sender
> specifies and with authority, states them to be the views of Dorset
> Council. Dorset Council does not accept service of documents by fax or
> other electronic means. Virus checking: Whilst all reasonable steps have
> been taken to ensure that this electronic communication and its attachments
> whether encoded, encrypted or otherwise supplied are free from computer
> viruses, Dorset Council accepts no liability in respect of any loss, cost,
> damage or expense suffered as a result of accessing this message or any of
> its attachments. For information on how Dorset Council processes your
> information, please see www.dorsetcouncil.gov.uk/416433
> _______________________________________________
> 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/20190927/7e9b67f7/attachment.html>