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-boun...@lists.osgeo.org> On Behalf Of
qgis-user-requ...@lists.osgeo.org
Sent: 27 April 2019 20:00
To: qgis-user@lists.osgeo.org
Subject: Qgis-user Digest, Vol 158, Issue 35
Send Qgis-user mailing list submissions to
qgis-user@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-requ...@lists.osgeo.org
You can reach the person managing the list at
qgis-user-ow...@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.vogelges...@gmx.de>
To: qgis-user <qgis-user@lists.osgeo.org>
Subject: [Qgis-user] GeoPackage-Hickups
Message-ID: <b42341ec-c813-36d7-041a-ed0a41df5...@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 <matth...@opengis.ch>
To: Bernd Vogelgesang <bernd.vogelges...@gmx.de>, qgis-user
<qgis-user@lists.osgeo.org>
Subject: Re: [Qgis-user] GeoPackage-Hickups
Message-ID: <7fd75d08-b974-b500-a74a-9835f1408...@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@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
--
Matthias Kuhn
matth...@opengis.ch <mailto:matth...@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 <ruy...@gmail.com>
To: qgis-user@lists.osgeo.org
Subject: [Qgis-user] RETORNANDO AO GEOPROCESSAMENTO
Message-ID:
<cak7xttgycqpdxkahtsvaqbi0mke68kwvfcn2oy_ruf3n9ec...@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
ruy...@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@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
_______________________________________________
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
