Bug #2476

Deleting QubitObjectTermRelation is not deleting parent QubitObject

Added by David Juhasz over 12 years ago. Updated almost 5 years ago.

Status:NewStart date:
Priority:LowDue 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

#7 Updated by David Juhasz almost 11 years ago

  • Priority set to Low

[g] Labels added: Priority-Low

#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)

Also available in: Atom PDF