Bug report #7392

DB manager error after deleting layers

Added by Giovanni Manghi about 11 years ago. Updated almost 10 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:DB Manager
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:worksforme
Crashes QGIS or corrupts data:No Copied to github as #:16363

Description

In qgis master I get often the following when deleting layers. After that the connection to the db is lost.

Traceback (most recent call last):
File "C:\\OSGeo4W\\apps\\qgis-dev\\python\\plugins\\db_manager\\db_manager.py", line 83, in itemChanged
self.refreshTabs()
File "C:\\OSGeo4W\\apps\\qgis-dev\\python\\plugins\\db_manager\\db_manager.py", line 134, in refreshTabs
self.info.showInfo( item )
File "C:\\OSGeo4W\\apps\\qgis-dev\\python\\plugins\\db_manager\\info_viewer.py", line 75, in showInfo
self._showTableInfo(item)
File "C:\\OSGeo4W\\apps\\qgis-dev\\python\\plugins\\db_manager\\info_viewer.py", line 132, in _showTableInfo
html += table.info().toHtml()
File "C:\\OSGeo4W\\apps\\qgis-dev\\python\\plugins\\db_manager\\db_plugins\\info_model.py", line 352, in toHtml
ret = self.getTableInfo()
File "C:\\OSGeo4W\\apps\\qgis-dev\\python\\plugins\\db_manager\\db_plugins\\postgis\\info_model.py", line 194, in getTableInfo
ret = TableInfo.getTableInfo(self)
File "C:\\OSGeo4W\\apps\\qgis-dev\\python\\plugins\\db_manager\\db_plugins\\info_model.py", line 292, in getTableInfo
spatial_info = self.spatialInfo()
File "C:\\OSGeo4W\\apps\\qgis-dev\\python\\plugins\\db_manager\\db_plugins\\postgis\\info_model.py", line 211, in spatialInfo
return VectorTableInfo.spatialInfo(self)
File "C:\\OSGeo4W\\apps\\qgis-dev\\python\\plugins\\db_manager\\db_plugins\\info_model.py", line 407, in spatialInfo
if not self.table.hasSpatialIndex():
File "C:\\OSGeo4W\\apps\\qgis-dev\\python\\plugins\\db_manager\\db_plugins\\plugin.py", line 829, in hasSpatialIndex
for idx in self.indexes():
File "C:\\OSGeo4W\\apps\\qgis-dev\\python\\plugins\\db_manager\\db_plugins\\plugin.py", line 687, in indexes
indexes = self.database().connector.getTableIndexes( (self.schemaName(), self.name) )
File "C:\\OSGeo4W\\apps\\qgis-dev\\python\\plugins\\db_manager\\db_plugins\\postgis\\connector.py", line 446, in getTableIndexes
self._execute(c, sql)
File "C:\\OSGeo4W\\apps\\qgis-dev\\python\\plugins\\db_manager\\db_plugins\\connector.py", line 76, in _execute
cursor.execute(unicode(sql))
SystemError: null argument to internal routine

History

#1 Updated by Giovanni Manghi almost 10 years ago

  • Resolution set to worksforme
  • Status changed from Open to Closed

it is a while that I don't see this issue. Assuming it is fixed.

Also available in: Atom PDF