[Qgis-user] GeoPackage deadlocks (Andrea Peri)

[Jonathan Moules]

 > Two processes accessing geopackage on a local computer can run into 
the same issue. SQlite is designed for a single user.

Interesting. SQlite can most definitely handle multiple users - 
certainly reading, and for writing if it's not over the network, I 
expect the processes are breaking one (or more) of the "do this to 
corrupt your database" rules.

On 17/10/2019 11:54, Patrick Dunford wrote:
> It's not a network issue and neither is it a Windows issue. Two 
> processes accessing geopackage on a local computer can run into the 
> same issue. SQlite is designed for a single user. It is very reliable 
> when used as designed.
>
> On 27/09/19 7:13 PM, Paul Wittle wrote:
>> 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
>>
> _______________________________________________
> 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