Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Clean up left over indices and alembic columns for migration 222 to 224 #80

Open
11 tasks
margrietpalm opened this issue Aug 28, 2024 · 3 comments
Open
11 tasks
Assignees

Comments

@margrietpalm
Copy link
Contributor

  • Several _alembic_tmp tables are not cleaned up correctly
    • _alembic_tmp_dry_weather_flow
    • _alembic_tmp_dry_weather_flow_map
    • _alembic_tmp_memory_control
    • _alembic_tmp_surface
    • _alembic_tmp_surface_map
    • _alembic_tmp_v2_connection_nodes
    • _alembic_tmp_v2_cross_section_location
  • Several spatial index related tables are in the spatialite without being recognized as such by QGIS (normally they are hidden). Seems to be some sort of remnant of something?
    • idx_v2_connection_nodes_the_geom_linestring
    • idx_v2_connection_nodes_the_geom_linestring_node
    • idx_v2_connection_nodes_the_geom_linestring_parent
    • idx_v2_connection_nodes_the_geom_linestring_rowid
@margrietpalm margrietpalm self-assigned this Aug 28, 2024
@margrietpalm
Copy link
Contributor Author

margrietpalm commented Aug 30, 2024

All these issues automagically diseappeared with all previous fixes (double check before closing!)

@leendertvanwolfswinkel
Copy link

leendertvanwolfswinkel commented Sep 3, 2024

I still see the issue with threedi-schema 0.224.1. Using this sqlite:
supermodel_Assen_langzame_afvoer.zip

image

@margrietpalm
Copy link
Contributor Author

margrietpalm commented Sep 5, 2024

In my qgis, with the 0.224.2.dev2 I see this on an upgraded version of the abovementioned model:

image.png

and

sqlite> select COUNT(name) from sqlite_master where name LIKE '\_%' ESCAPE '\';
0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants