[Qgis-user] GeoPackage deadlocks (Andrea Peri)

[Paul Wittle]

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