Bug report #22017

[processing][xyz tiles] mbtile file gets locked

Added by Saber Razmjooei over 1 year ago. Updated over 1 year ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Processing/QGIS
Affected QGIS version:3.7(master) Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:29831

Description

Traceback (most recent call last):
File "C:/OSGEO4~1/apps/qgis-dev/./python/plugins\processing\algs\qgis\TilesXYZ.py", line 376, in processAlgorithm
writer.writeTile(tile, tile_img)
File "C:/OSGEO4~1/apps/qgis-dev/./python/plugins\processing\algs\qgis\TilesXYZ.py", line 195, in writeTile
self._initZoomLayer(tile.z)
File "C:/OSGEO4~1/apps/qgis-dev/./python/plugins\processing\algs\qgis\TilesXYZ.py", line 187, in _initZoomLayer
self._execute_sqlite("UPDATE metadata SET value='{}' WHERE name='bounds'".format(bounds))
File "C:/OSGEO4~1/apps/qgis-dev/./python/plugins\processing\algs\qgis\TilesXYZ.py", line 168, in _execute_sqlite
conn.execute(cmd)
sqlite3.OperationalError: database is locked

Execution failed after 15.32 seconds

History

#1 Updated by Saber Razmjooei over 1 year ago

  • Status changed from Open to Closed

Actually, this is a correct behaviour as Processing runs in parallel and the file gets locked by gdal to write the zoom levels.

Also available in: Atom PDF