>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.wit...@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 <aperi2...@gmail.com> > To: Enrico Fiore <enricofi...@libero.it> > Cc: qgis-user <qgis-user@lists.osgeo.org> > Subject: Re: [Qgis-user] GeoPackage deadlocks > Message-ID: > < > cabqtjk-1hd9atuvhtiw81zw7xe_kpefut7bjcxxgsz0me56...@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 <enricofi...@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@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@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user