Comments (8)
My hope is @PiispaH already fixed this with spine-tools/Spine-Database-API@7fa4b1e
It is somewhat clear to me how things would get messy the way you @jkiviluo describe, prior to the changes introduced by @PiispaH in the above commit.
Should we try and save the corrupted DBs? there might be a way...
from spine-toolbox.
No need on my part - I've already remade the DB. So, unless someone requests that, let's not waste time trying to do that. Presumably there are so many ways things can go wrong that it can be futile.
from spine-toolbox.
With data included, I got this error (and commit apparently failed. EDIT: apparently succeeded despite the message):
DBAPIError while inserting entity_class items: ('UNIQUE constraint failed: entity_class_dimension.entity_class_id, entity_class_dimension.dimension_id, entity_class_dimension.position',)
from spine-toolbox.
Might be related to #2293 and #2296
from spine-toolbox.
Right. And the data wasn't actually committed. I closed and opened the DB editor, but that's not enough (apparently stuff remains in the memory). Only closing and starting Toolbox revealed that new entity class and it's data were not in the DB.
from spine-toolbox.
What are steps to reproduce this? I just added and committed an empty multi-D class with no problem?
from spine-toolbox.
It works for me too, if I start from an empty DB. But fails on the attached one. Of course, maybe it's due to corrupt DB that wouldn't happen anymore, so not sure if should be debugged (and I would just need to reimplement my DB).
generic_energy_data_specification.sqlite.txt
from spine-toolbox.
I tried to look into this, since it's stopping me from progressing. It seems like the referential integrity between entity_class and entity_class_dimension tables is not working. I have rows in entity_class_dimension that have entity_class_ids not found in entity_class (since the database has seen deletion of entity_classes). This causes the error message when trying to insert records that would re-use the entity_class_id numbers.
I don't know where to fix this... Probably somewhere in the database definition, but I leave it to you @manuelma. I'll try to fix my database manually meanwhile.
from spine-toolbox.
Related Issues (20)
- Allow only right dataformat for parameters in DB editor
- Hierarchy of parameters
- Create workflow editor 'user mode'
- 'Manage plugins' window not showing text HOT 1
- Julia Installer wizard does not work in Windows bundle HOT 5
- Bundling SpineOpt and Julia installation inside Toolbox
- Limit the width of items in tree views
- Don't select tree items in db editor when right clicking on them HOT 11
- Traceback when importing in DB editor
- Editing index name in a map does not change the index name
- Selection changes when alternatives are dragged in scenario tree
- Importer not importing entities if not a set number of columns
- the latest dev not working with conda python 3.12
- Two databases open, only entities from another DB show
- Entity groups for N-D entity classes HOT 1
- Toolbox silent exit when refreshing DB
- Activating and deactivating scenario filters in db breaks graph view
- QSpinBoxes are unusable on Win11 HOT 1
- Default Python on bundled app should point to the embedded Python HOT 1
- Ship a Python kernel with the bundled app HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from spine-toolbox.