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 some
Hi Paul,
I do not know about QGIS crashes but I was bitten by GeoPackages on
Network File systems.
We collected some hints regarding GeoPackage in the GDAL/OGR Trac Wiki
https://trac.osgeo.org/gdal/wiki/UserDocs/SQLite
Regarding writing to GeoPackages/SQLite we found the following:
The "[...]
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 l
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 ha scritto:
> Hi,
>
> Is anyone else getting occasional deadlocks when using GeoPackages in the
>
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
>
>
> Il gio 17 ott 2019, 12:54 Patrick Dunford ha
> scritto:
>
>> 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
ser@lists.osgeo.org>
Bcc:
Date: Thu, 17 Oct 2019 13:09:43 +0200
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
Il gio 17 ott 2019, 12:54 Patrick Dunford mailto:enzedrailm...@gmail.com>> ha scritto:
It's not a network issue and neither is it a Win
On vendredi 25 octobre 2019 17:10:40 CEST Matthias Kuhn wrote:
> Hi all,
>
> We had the same experience in a project of ours. Multiple users with
> read-only access to a gpkg on a (Windows) network share. The results
> were freezes on unloading the layer (e.g. closing QGIS or opening
> another pro
I could provide some background information as we're working for about a
year in a multi-users (5 users) configuration mainly based on network
shared geopackages in a Windows environment. I've tried and tested a lot of
configurations and still looking for a near PostGIS solution only in terms
of ea
On vendredi 25 octobre 2019 22:51:39 CEST Jésahel Benoist wrote:
> I could provide some background information as we're working for about a
> year in a multi-users (5 users) configuration mainly based on network
> shared geopackages in a Windows environment. I've tried and tested a lot of
> configu
On 10/25/19 7:04 PM, Even Rouault wrote:
On vendredi 25 octobre 2019 17:10:40 CEST Matthias Kuhn wrote:
Hi all,
We had the same experience in a project of ours. Multiple users with
read-only access to a gpkg on a (Windows) network share. The results
were freezes on unloading the layer (e.g. clo
thanks,
Paul
Message: 4
Date: Thu, 26 Sep 2019 11:10:45 +0200
From: Andrea Peri
To: Enrico Fiore
Cc: qgis-user
Subject: Re: [Qgis-user] GeoPackage deadlocks
Message-ID:
Content-Type: text/plain; charset="utf-8"
Hi,
Geopackage is an Exchange format. Is not affordable in a
On Fri, Sep 27, 2019 at 9:13 AM Paul Wittle <
paul.wit...@dorsetcouncil.gov.uk> 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
uld 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 opposin
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
On Fri, Sep 27, 2019 at 9:13 AM Paul Wittle
mailto:paul.wit...@dorsetcouncil.gov.uk>>
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
y further relevant comments as I’ve not got it as well documented as I’d
> like. Sorry, time constraints in the office.
>
>
>
> Many thanks,
>
> Paul
>
>
>
>
>
> *From:* Alessandro Pasotti
> *Sent:* 27 September 2019 08:20
> *To:* Paul Wittle
> *Cc:* qg
To: Paul Wittle
Cc: Alessandro Pasotti ; qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
without resting importance to the issue, reading the bug report, I can read you
moved from oracle spatial to geopackage! why not postgis?
Luigi Pirelli
I hope that provides sufficient background but you can probably see it’s
> not going well really as I’ve had to change my advice three times already.
>
> Paul
>
>
>
> *From:* Luigi Pirelli
> *Sent:* 27 September 2019 08:59
> *To:* Paul Wittle
> *Cc:* Alessandro Pasot
Hi,
My understanding is that GeoPackage and Spatialite are both based on SQLite so
I’ve been assuming both may be susceptible to this bug?
Paul
From: Andrea Peri
Sent: 27 September 2019 09:25
To: Paul Wittle
Cc: Gino Pirelli ; qgis-user
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea
> Am 27.09.2019 um 10:24 schrieb Andrea Peri :
>
> Have you tried to use spatialite instead of geopackage. ?
Why not plain SQLite? Nobody needs and uses the spatial functions of
Spatialite, they are even not part of bloatware GPKG (sorry, the created
db-files are huge without any compression).
I suppose the question by Andrea was related if using a different qgis
provider continue to generate the deadlock
Luigi Pirelli
**
* LinkedIn: https://www.linkedin.com/in/luigipirelli
* Stackexchange:
: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
I suppose the question by Andrea was related if using a different qgis provider
continue to generate the deadlock
Luigi Pirelli
**
* LinkedIn
(A little late).
TL;DR: at least for QGIS, is - never multi-user edit
SQLite/SpatiaLite/GeoPackages on network file systems.
SQLite, (and therefore SpatiaLite and GeoPackage) has quite a few
caveats when it comes to multiple users trying to edit it at once.
https://www2.sqlite.org/howtocorr
To: Tobias Wendorff ; Andrea Peri
Cc: qgis-user ; Paul Wittle
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
(A little late).
TL;DR: at least for QGIS, is - never multi-user edit
SQLite/SpatiaLite/GeoPackages on network file systems.
SQLite, (and therefore SpatiaLite and
ality above
myself using Python.
Cheers,
Paul
From: Jonathan Moules
Sent: 07 October 2019 15:17
To: Tobias Wendorff ; Andrea Peri
Cc: qgis-user ; Paul Wittle
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
(A little late).
TL;DR: at least for QGIS, is - never multi-user edit
From: Qgis-user On Behalf Of Jonathan Moules
Sent: Monday, October 7, 2019 4:17 PM
To: Tobias Wendorff ; Andrea Peri
Cc: qgis-user ; Paul Wittle
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
(A little late).
TL;DR: at least for QGIS, is - never multi-user edit
SQLi
he
> functionality above myself using Python.
> >
> > Cheers,
> > Paul
> >
> > From: Jonathan Moules
> > Sent: 07 October 2019 15:17
> > To: Tobias Wendorff ; Andrea Peri <
> aperi2...@gmail.com>
> > Cc: qgis-user ; Paul Wittle <
> p.wit
?
greeting from Poland
Jarosław Sadowski
From: Qgis-user On Behalf Of Jonathan Moules
Sent: Monday, October 7, 2019 4:17 PM
To: Tobias Wendorff ; Andrea Peri
Cc: qgis-user ; Paul Wittle
Subject: Re: [Qgis-user] GeoPackage deadlocks (Andrea Peri)
(A little late).
TL;DR: at least for QGIS, is
ariaDB). Edition of data file content
over network don't look like a smart move to me.
HTH
>
>
> greeting from Poland
>
> Jarosław Sadowski
>
>
>
> From: Qgis-user On Behalf Of
> Jonathan Moules Sent: Monday, October 7, 2019 4:17 PM
> To: Tobias Wen
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
Il gio 17 ott 2019, 12:54 Patrick Dunford ha
scritto:
> 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.
>
Maybe i
> 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 (
As I'm a new user of this list, hi to everyone !
As we had this problem, here's a working trick well known but a bit hard to
find : https://issues.qgis.org/issues/20077#note-2
Even Rouault wrote
> il y a 12 mois
> Can you retry your tests by defining the following environment variables
> (may re
32 matches
Mail list logo