Bug report #13907

PostgreSQL triggers - QGIS freezes when saving layer edits

Added by Paul Kanelli almost 5 years ago. Updated over 4 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Data Provider/PostGIS
Affected QGIS version:2.12.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:invalid
Crashes QGIS or corrupts data:No Copied to github as #:21929

Description

Using PostgreSQL triggers saving layer edits gets slower and slower every time when saving a layer edit. The problem occurs after a few up to a few dozen saved layer edits. Finally QGIS freezes completely.

I've tried the posted triggers in the folowing link:

http://gis.stackexchange.com/questions/160320/how-to-use-interacting-postgresql-postgis-triggers-in-qgis

History

#1 Updated by Paul Kanelli over 4 years ago

  • Assignee deleted (Jürgen Fischer)
  • Target version set to Version 2.14

Seems it is not a PostgSQL trigger issue. On Windows 7 QGIS 2.12.3 gets slower every time when saving a layer edit. Can someone edit the title?

#2 Updated by Paul Kanelli over 4 years ago

Layer is a PostgreSQL/PostGIS table.

#3 Updated by Sandro Santilli over 4 years ago

  • Crashes QGIS or corrupts data changed from Yes to No
  • Status changed from Open to Feedback

Do I understand correctly it still happens without any trigger defined ?
What kind of edits do you make ?
Can you provide a step-by-step guide on how to reproduce ?

I'm unchecking "causes crash or corruption" as I understand there's no corruption and no crash (but a freeze, which may be prevented by closing qgis after some edits, and re-opening, right ?)

#4 Updated by Paul Kanelli over 4 years ago

Meanwhile I suppose it's neither a trigger nor a PostGIS issue. Most of the time I'm just adding new features. QGIS gets slower every time saving layer edits. After restarting QGIS everything is fine again until saving a few layer edits. I will provide a step by step guide within the next few days.

#5 Updated by Nyall Dawson over 4 years ago

Try disabling all plugins. This behaviour is typical of badly behaved plugins.

#6 Updated by Paul Kanelli over 4 years ago

  • Status changed from Feedback to Closed

I've uninstalled all plugins and now everything seems to work. Many thanks!

#7 Updated by Giovanni Manghi over 4 years ago

  • Resolution set to invalid

Also available in: Atom PDF