Bug #2476
Deleting QubitObjectTermRelation is not deleting parent QubitObject
Status: | New | Start date: | ||
---|---|---|---|---|
Priority: | Low | Due date: | ||
Assignee: | - | % Done: | 0% | |
Category: | - | |||
Target version: | - | |||
Google Code Legacy ID: | atom-525 | Tested version: | ||
Sponsored: | Requires documentation: |
Description
This is causing an error when trying to re-load a dumped yaml data file.
To reproduce, from a standard ICA-AtoM install using the sampleData.yml data.
1) Delete all Information objects in the system (deleting the three
top-level objects will also delete their descendants)
2) Do a propel:data-dump as per
http://qubit-toolkit.org/wiki/index.php?title=Backup_and_restore_of_Qubit_data
3) Attempt to reload the data dump file with propel:build-all-load
You will receive a foreign key constraint failure when the load-data
process tries QubitObjectTermRelation object with no object_id.
The stub data in the dump.yml file looks like this:
---
QubitObjectTermRelation:
QubitObjectTermRelation_296:
class_name: QubitObjectTermRelation
QubitObjectTermRelation_297:
class_name: QubitObjectTermRelation
---
The same data in the mysql q_object table looks like this:
mysql> select * from q_object where class_name = 'QubitObjectTermRelation';class_name | id | QubitObjectTermRelation | 296 | |
QubitObjectTermRelation | 297 |
There are no corresponding rows in the q_object_term_relation table:
mysql> select * from q_object_term_relation;
Empty set (0.00 sec)
[g] Legacy categories: Component-YAML
History
#1 Updated by David Juhasz over 12 years ago
See also related /p/qubit-toolkit/issues/detail?id=526 regarding QubitEvent objects.
#2 Updated by David Juhasz over 12 years ago
The temporary fix is to delete the stub data in the yaml data dump file.
#3 Updated by Peter Van Garderen about 12 years ago
- Target version changed from Release 1.0.5 to Release 1.0.6
[g] Labels added: Milestone-Release-1.0.6
[g] Labels removed: Milestone-Release-1.0.5
[g] New owner: David Juhasz
#4 Updated by David Juhasz almost 12 years ago
- Target version set to Release 1.0.8
Move to 1.0.8
[g] Labels added: Milestone-Release-1.0.8
#5 Updated by David Juhasz over 11 years ago
- Target version set to Release 1.1
Bumped to Release 1.1
[g] Labels added: Milestone-Release-1.1
#6 Updated by Anonymous almost 11 years ago
- Priority set to Medium
[g] Labels added: Priority-Medium
#8 Updated by Evelyn McLellan over 10 years ago
- Target version set to Release 1.2
Moved to 1.2.
[g] Labels added: Milestone-Release-1.2
#9 Updated by David Juhasz over 9 years ago
- Target version set to Release 1.3
Roll over to Release 1.3
[g] Labels added: Milestone-Release-1.3
#10 Updated by David Juhasz almost 9 years ago
Reassign to David's new account.
[g] New owner: David Juhasz
#11 Updated by David Juhasz almost 5 years ago
- Assignee deleted (
David Juhasz)