Bug report #17034

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

Added by Even Rouault about 1 year ago. Updated about 1 year ago.

Status:Closed
Priority:Normal
Assignee:Even Rouault
Category:Data Provider/OGR
Affected QGIS version:2.18.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No

Description

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 (136 KB) Even Rouault, 2017-08-18 04:50 PM

Associated revisions

Revision 54811776
Added by Even Rouault about 1 year ago

[OGR provider] Avoid 'database locked' issues when editing several layers of the same GeoPackage (fixes #17034)

Revision 53add698
Added by Even Rouault about 1 year ago

[OGR provider] Avoid 'database locked' issues when editing several layers of the same GeoPackage (fixes #17034)

History

#1 Updated by Even Rouault about 1 year ago

  • % Done changed from 0 to 100
  • Status changed from Open to Closed

#2 Updated by Even Rouault about 1 year ago

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

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

#3 Updated by Giovanni Manghi about 1 year ago

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.

Also available in: Atom PDF