Bug report #18486

QGIS 2.18 / 3.0 Crashes Zooming Layer from MS SQL database.

Added by Alt Ident over 4 years ago. Updated almost 4 years ago.

Category:Data Provider/MSSQL
Affected QGIS version:2.18.17 Regression?:Yes
Operating System:Windows 10 Enterprise 64 bit Easy fix?:No
Pull Request or Patch supplied:No Resolution:no timely feedback
Crashes QGIS or corrupts data:Yes Copied to github as #:26374


The crash occurs zooming in or out (fast zooming, by scrolling mouse wheel) when using layers sourced from MS SQL database.

The crash does not happen if using non-SQL layers (e.g. Shapefiles).

This issue does NOT occur in QGIS version 2.14.17.

This issue does occur in QGIS 2.18.17 and 3.0.0.

I have tried changing all the rendering settings, however it still crashes.

I have supplied crash report below (from v3.0.0). I hope this is fixable as our company only uses MS SQL databases.

Crash ID: 815b7d05708a4749ca0cade8a6a302683d7bb05d

Stack Trace

RtlEnterCriticalSection :
ODBCSetTryWaitValue :
LockHandle :
SQLGetStmtAttrW :
isProvider :
isProvider :
isProvider :
QgsVectorLayerFeatureIterator::QgsVectorLayerFeatureIterator :
QgsVectorLayerFeatureSource::getFeatures :
QgsVectorLayerLabelProvider::registerFeature :
QgsMapRendererParallelJob::renderLayerStatic :
QgsMapRendererParallelJob::renderingFinished :
QgsArchive::zip :
QgsImageOperation::flipImage :
QtConcurrent::ThreadEngineBase::run :
QThreadPoolPrivate::reset :
QThread::start :
BaseThreadInitThunk :
RtlUserThreadStart :

QGIS Version: 3.0.0-Girona
QGIS code revision: 001c80b0c3
Compiled against Qt: 5.9.2
Running against Qt: 5.9.2
Compiled against GDAL: 2.2.3
Running against GDAL: 2.2.3

System Info
CPU Type: x86_64
Kernel Type: winnt
Kernel Version: 10.0.14393


#1 Updated by Nyall Dawson about 4 years ago

  • Status changed from Open to Feedback

Should be fixed in 3.3 master - please test

#2 Updated by Jürgen Fischer almost 4 years ago

Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.

#3 Updated by Nyall Dawson almost 4 years ago

  • Resolution set to no timely feedback
  • Status changed from Feedback to Closed

Also available in: Atom PDF