Bug report #19663

QGIS Hangs when saving edits on a Postgis Layer

Added by Erica Roberts almost 6 years ago. Updated over 5 years ago.

Category:Data Provider/PostGIS
Affected QGIS version:2.18.22 Regression?:No
Operating System:Windows 10 Pro, 64Bit Easy fix?:No
Pull Request or Patch supplied:No Resolution:no timely feedback
Crashes QGIS or corrupts data:Yes Copied to github as #:27488


I am working with a PostGIS layer which has 13 000+ records. I use Google Satelite imagery from the OpenLayers Plugin. I have one other PostGIS layer in the project and one other shapefile. While editing the PostGIS layer and saving multiple times, I have no problems. After about an hour (this varies) QGIS for some reason would start hanging when I try to save the edits on the PostGIS layer. After the first hang, it might respond again and manage to finish the save, but sometimes it doesn't and crashes completely. After the first hang, it could still work, but then it would nearly hang every time I save the PostGIS layer edits. I do not loose any data and no data becomes corrupt, but I have to restart QGIS then at least 5 times a day. I have checked the layer is indexed in PostGIS and it has the spatial reference information in the Geometry field. This is just a simple linestring.

PC038.LOG Magnifier - BugReview file during crash (886 KB) Erica Roberts, 2018-08-21 12:53 PM


#1 Updated by Giovanni Manghi almost 6 years ago

  • Priority changed from Normal to High
  • Status changed from Open to Feedback

Does it hangs after an idle period since the last edit/save?

#2 Updated by Jürgen Fischer over 5 years ago

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

#3 Updated by Giovanni Manghi over 5 years ago

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

Also available in: Atom PDF