[Qgis-user] GeoPackage-Hickups

Mon Apr 29 00:58:10 PDT 2019

Hi,

I think I encountered point 2 the other day using QGIS 2 and although it was the old version I still found it a bit worrying as the fault appeared to be with the GeoPackage format rather than the software (although I'm sure the software is heavily involved really).

I tried to add a virtual column to a GeoPackage table which others also had open and it resulted in the file becoming locked. QGIS wouldn't close even with windows end task!

In the end I had to do a hard reboot (holding the off button) and the others had to reboot their PCs and the file unlocked restoring the data.

All in all, I found it extremely worrying and hope that it was just a one off really; anything that can lock a PC, even against end task; is in my opinion a potentially dangerous format.

It was a fix already dealt with or a problem with the GeoPackage spec that is already in hand then that is all fine but if not; I hope it doesn't happen again.

Cheers,
Paul

-----Original Message-----
From: Qgis-user <qgis-user-bounces at lists.osgeo.org> On Behalf Of qgis-user-request at lists.osgeo.org
Sent: 27 April 2019 20:00
To: qgis-user at lists.osgeo.org
Subject: Qgis-user Digest, Vol 158, Issue 35

Send Qgis-user mailing list submissions to
        qgis-user at lists.osgeo.org

To subscribe or unsubscribe via the World Wide Web, visit
        https://lists.osgeo.org/mailman/listinfo/qgis-user
or, via email, send a message with subject or body 'help' to
        qgis-user-request at lists.osgeo.org

You can reach the person managing the list at
        qgis-user-owner at lists.osgeo.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of Qgis-user digest..."

Today's Topics:

   1. GeoPackage-Hickups (Bernd Vogelgesang)
   2. Re: GeoPackage-Hickups (Matthias Kuhn)
   3. RETORNANDO AO GEOPROCESSAMENTO (Ruy Edy Iglesias da Silveira)

----------------------------------------------------------------------

Message: 1
Date: Sat, 27 Apr 2019 15:57:18 +0200
From: Bernd Vogelgesang <bernd.vogelgesang at gmx.de>
To: qgis-user <qgis-user at lists.osgeo.org>
Subject: [Qgis-user] GeoPackage-Hickups
Message-ID: <b42341ec-c813-36d7-041a-ed0a41df5389 at gmx.de>
Content-Type: text/plain; charset=utf-8; format=flowed

Hi,

I try to use Geopackage as my standard format for a while, but so far my joy is only moderate.

1. Is it default behaviour, that when I make one layer of this GeoPackage editable, all other layers become editable as well?

2. Mostly I add or modify data in a non-spatial table with a relation to a point layer. "Most" of the time this works quite ok, but quite often the save of the changes is not possible, cause OGR claims that the database is locked. Toggle the edit status or refreshing the database in DB Manager does not help, so most of the time I have to shut down QGIS to be able to work on. Is there a "trick" to unlock the database without having to shut down the application? (btw. the files are stored on a synology network drive)

QGIS 3.6.2 on Linux Mint

Cheers,
Bernd

------------------------------

Message: 2
Date: Sat, 27 Apr 2019 16:20:17 +0200
From: Matthias Kuhn <matthias at opengis.ch>
To: Bernd Vogelgesang <bernd.vogelgesang at gmx.de>, qgis-user
        <qgis-user at lists.osgeo.org>
Subject: Re: [Qgis-user] GeoPackage-Hickups
Message-ID: <7fd75d08-b974-b500-a74a-9835f14088a5 at opengis.ch>
Content-Type: text/plain; charset="utf-8"

Hi Bernd,

1. Only when you have set "automatically create transaction groups if possible" in the project properties

2. Might possibly be resolved by #1 as well

Matthias

On 4/27/19 3:57 PM, Bernd Vogelgesang wrote:
> Hi,
>
> I try to use Geopackage as my standard format for a while, but so far
> my joy is only moderate.
>
> 1. Is it default behaviour, that when I make one layer of this
> GeoPackage editable, all other layers become editable as well?
>
> 2. Mostly I add or modify data in a non-spatial table with a relation
> to a point layer. "Most" of the time this works quite ok, but quite
> often the save of the changes is not possible, cause OGR claims that
> the database is locked. Toggle the edit status or refreshing the
> database in DB Manager does not help, so most of the time I have to
> shut down QGIS to be able to work on. Is there a "trick" to unlock the
> database without having to shut down the application? (btw. the files
> are stored on a synology network drive)
>
> QGIS 3.6.2 on Linux Mint
>
> Cheers,
> Bernd
> _______________________________________________
> 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
>
--
Matthias Kuhn
matthias at opengis.ch <mailto:matthias at opengis.ch>
+41 (0)76 435 67 63 <tel:+41764356763>
OPENGIS.ch Logo <http://www.opengis.ch>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190427/94bd49fd/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 6671 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190427/94bd49fd/attachment-0001.png>

------------------------------

Message: 3
Date: Sat, 27 Apr 2019 15:56:10 -0300
From: Ruy Edy Iglesias da Silveira <ruyedy at gmail.com>
To: qgis-user at lists.osgeo.org
Subject: [Qgis-user] RETORNANDO AO GEOPROCESSAMENTO
Message-ID:
        <CAK7xtTgYCqPDXKAHtsVaqBi0mke68kWVFcN2oy_ruf3N9ECW4w at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

RUY Edy Iglesias da Silveira
Vicente da Fontoura,2758/1502
Porto Alegre-RS

cel (51)982076276
Ruy  Edy Iglesias da Silveira
ruyedy at gmail.com
(51)30226012
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190427/0234c8bb/attachment-0001.html>

------------------------------

Subject: Digest Footer

_______________________________________________
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

------------------------------

End of Qgis-user Digest, Vol 158, Issue 35
******************************************
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