Bug report #7146

DB manager does not remove Spatialite indexes and entry in "spatialite_hystory" after deleting a table

Added by Giovanni Manghi over 9 years ago. Updated over 4 years ago.

Category:DB Manager
Affected QGIS version:3.0.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:16210


The same issue seems to affect also the browser.

Add a ector to a SL datasource, and select to create also a spatial index.

Then remove the vector from the datasource, the tables idx_tablename_geom* are not removed, as it isn't the entry in the table "spatialite_hystory", so it not possible to re-add another vector with the same name.


#1 Updated by Giovanni Manghi about 9 years ago

  • Priority changed from High to Normal

#2 Updated by Giovanni Manghi about 8 years ago

  • Target version set to Version 2.4

#3 Updated by Jürgen Fischer about 8 years ago

  • Target version changed from Version 2.4 to Future Release - High Priority

#4 Updated by Giuseppe Sucameli over 6 years ago

  • Assignee set to Giuseppe Sucameli
  • Category changed from DB Manager to Data Provider/SpatiaLite
  • Status changed from Open to In Progress

The issue affects the importer feature (dataprovider).

#5 Updated by Giuseppe Sucameli over 6 years ago

  • Category changed from Data Provider/SpatiaLite to DB Manager

Similar issues are in both DBManager and SL dataprovider (importer), but the reported one occurs removing a vector table in DBManager. I'll file a new ticket for the importer (if not already there).

#6 Updated by R. R. over 5 years ago

Here on Win7 creating a new table with a previously used table name works, but the features are not displayed properly on the canvas. In QspatiaLite it's possible to delete unused indices as a workaorund.

See also: http://gis.stackexchange.com/questions/38955/why-is-this-spatialite-polygon-layer-not-displayed-properly

#7 Updated by Giovanni Manghi over 5 years ago

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

#8 Updated by Giovanni Manghi over 4 years ago

  • Affected QGIS version changed from master to 3.0.0
  • Description updated (diff)
  • Status changed from In Progress to Open
  • Assignee deleted (Giuseppe Sucameli)

Also available in: Atom PDF