Bug report #22009
Lock postgres/postgis on st_estimatedextent and st_makeenvelope
|Affected QGIS version:||3.6.2||Regression?:||Yes|
|Operating System:||OpenSuse leap 15 / Windows 10||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||29823|
We have a repetitive lock on postgres/postgis database using QGIS.
Some times using a postgis layer in QGIS it creates a lockin the database and QGIS can no longer use the layer and freeze to death.
Then we have two option, either kill the query on pgadmin dashboard or close and reopen QGIS to be able to work again.
This issue can appear many times in a day.
What we have managed to understand this far, is that the layer seems to lock when queries st_makeenvelope and st_estimatedextent are exectuted.
We've experienced thoses lock since the QGIS 3 version.
Hope you'll be able to solve that problem,
Thanks by advance