Bug report #12133

Attempting to preview PostGIS external rasters crashes QGIS

Added by Paolo Cavallini over 5 years ago. Updated almost 5 years ago.

Status:Closed
Priority:High
Assignee:-
Category:DB Manager
Affected QGIS version:2.6.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:up/downstream
Crashes QGIS or corrupts data:No Copied to github as #:20327

Description

Loading it does not crash, but it does not show anything meaningful either.

History

#1 Updated by Martin Dobias over 5 years ago

Do you mean that external raster == stored out of DB?

Could you please check the backtrace - the crash may be inside GDAL, I think it does not support out of DB rasters yet.

#2 Updated by Paolo Cavallini over 5 years ago

Yes, I mean imported through the -R option.
Are you sure GDAL does not support them?

#4 Updated by Even Rouault over 5 years ago

I confirm out-db PostGIS raster are not supported yet in GDAL. After the fix in GDAL trunk (http://trac.osgeo.org/gdal/changeset/28530 that was a fix for a regression in trunk only and should put GDAL in the state of GDAL 1.11), I cannot get crashes however, just blank images with error messages in the console. Paolo mentionned to me he uses GDAL 1.10.1 : there have been significant rework in GDAL 1.11 in the PostGIS raster driver that might explain GDAL 1.11 and later being at least more robust when ingesting out-db raster.

#5 Updated by Jürgen Fischer almost 5 years ago

  • Resolution set to up/downstream
  • Status changed from Open to Closed

I can't produce a crash either - only black images. So it's a dependency issue (GDAL complains ERROR 1: This raster has outdb storage. This feature isn't still available).

Also available in: Atom PDF