Geopackage: database locked when editing and saving several layers of same file

[qgib]

Author Name: Even Rouault (@rouault)
Original Redmine Issue: 17034
Affected QGIS version: 2.18.0
Redmine category:data_provider/ogr
Assignee: Even Rouault

---

With the attached geopackage :

1. Open it with its 2 layers
2. Put the 2 layers in edition mode
3. Select one layer, move one vertex
4. Select the other layer, move one vertex
5. Save modifications in the 2 layers
6. Select one layer, move one vertex
7. Select the other layer, move one vertex
8. Save modifications in the 2 layers -> the "database is locked" message is emitted

---

• bug.gpkg (Even Rouault)

[qgib]

Author Name: Even Rouault (@rouault)

---

Applied in changeset 5481177.

---

• done_ratio was changed from 0 to 100
• status_id was changed from Open to Closed

[qgib]

Author Name: Even Rouault (@rouault)

---

Complementary OGR fix : https://trac.osgeo.org/gdal/changeset/39860

Either QGIS fix, OGR fix or both are needed for the bug fix

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Even Rouault wrote:

Complementary OGR fix : https://trac.osgeo.org/gdal/changeset/39860

Either QGIS fix, OGR fix or both are needed for the bug fix

thanks for the fix Even, much appreciated.

[Mangoesmapping-GeorgeCorea]

This is happening again in
3.12.3

[gioman]

This is happening again in
3.12.3

@georgecorea can't confirm here. What version are you using?

[Mangoesmapping-GeorgeCorea]

Hi I am using 3.12.3 It happens if I try to edit more than one file from a gpkg at the same time. One layer will save but the other gives a lock error. Best Regards

…

On Thu, 11 Jun 2020, 17:45 Giovanni Manghi, ***@***.***> wrote: This is happening again in 3.12.3 @georgecorea <https://github.com/georgecorea> can't confirm here. What version are you using? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#24933 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AKBN3O2KI5SCLJAULPCHZ63RWCDRLANCNFSM4N24XEXA> .

-- Although all care is taken to ensure the accuracy and completeness of the information in this document, no responsibility will be taken by Mangoesmapping, for any personal, professional or financial damage arising from the use of the document or any omissions, errors or inaccuracies contained therein.

[rouault]

@georgecorea Please provide a very detailed reproducing scenario (like was done in the initial comment #24933 (comment))

[LucySaluki]

I am getting the same issue in 3.16.6, scenario is
select polygon and make editable
click on node and move to new location
click at new location to set down the node - error message appears

[Mangoesmapping-GeorgeCorea]

This still happens in 3.18.2-Zürich. The process to reproduce the error is exactly the same as the original post about the issue. It only happens when more than one dataset in the same gpkg is edited (either concurrently or individually).