Bug report #7545

layer screen hangs on database lock

Added by Jaap Dekker about 11 years ago. Updated about 5 years ago.

Status:Closed
Priority:Low
Assignee:-
Category:Data Provider/PostGIS
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:end of life
Crashes QGIS or corrupts data:No Copied to github as #:16488

Description

The Qgis 1.8.0 postgis layers dialog does not respond (hangs until the transaction finishes) when a table (not the one that I want to view) in the same database is in use. When I look at the server status window of postgis I see under locks that there is an AccessShareLock that is not granted on the Query
SELECT DISTINCT CASE WHEN upper(geometrytype("the_geom")) IN ('POINT','MULTIPOINT','POINTM','MULTIPOINTM') THEN 'POINT' WHEN upper(geometrytype("the_geom")) IN ('LINESTRING','MULTILINESTRING','LINESTRINGM','MULTILINESTRINGM') THEN 'LINESTRING' WHEN u...

It looks like a process that tries to get the geometry types of all the tables in the database is causing this behaviour. Is it possible to disable this and only do it on the table that I want to view ?

History

#1 Updated by Giovanni Manghi almost 7 years ago

  • Easy fix? set to No
  • Regression? set to No

#2 Updated by Giovanni Manghi about 5 years ago

  • Resolution set to end of life
  • Status changed from Open to Closed

Also available in: Atom PDF