Unhandled error when trying to delete wf that has triggers

Bug #1383170 reported by Anastasia Kuznetsova
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
python-mistralclient
Fix Released
Medium
Hardik Parekh
Liberty
Fix Released
Medium
Hardik Parekh

Bug Description

Steps to reproduce:
1. Create a simple wf
2. Create cron-trigger for this wf
3. Try to delete wf

Expected result:
Information message that we can't delete wf that has triggers and firstly user need to delete all triggers associated with it wf

Observed result:
mistral workflow-delete wf
(IntegrityError) (1451, 'Cannot delete or update a parent row: a foreign key constraint fails (`mistral`.`cron_triggers_v2`, CONSTRAINT `cron_triggers_v2_ibfk_1` FOREIGN KEY (`workflow_id`) REFERENCES `workflows_v2` (`id`))') 'DELETE FROM workflows_v2 WHERE workflows_v2.id = %s' ('7c95e1d3-6c07-4ac8-bdb3-edfb6ce9ec18',)

Changed in python-mistralclient:
importance: Undecided → Medium
milestone: none → 0.2
Revision history for this message
Renat Akhmerov (rakhmerov) wrote :

Need to think about other similar situations. For example, workbook -> workflows/actions relationship. The most preferred way is probably to warn the user about removing several objects and suggesting to pass an additional option, say -f (forced).

Changed in python-mistralclient:
assignee: nobody → Sirisha Devineni (sirisha-devineni)
Changed in python-mistralclient:
assignee: Sirisha Devineni (sirisha-devineni) → nobody
Changed in python-mistralclient:
milestone: kilo-1 → kilo-2
Changed in python-mistralclient:
milestone: kilo-2 → kilo-3
tags: added: low-hanging-fruit
no longer affects: python-mistralclient/kilo
Revision history for this message
Hardik Parekh (hardik-parekh047) wrote :
Revision history for this message
Anastasia Kuznetsova (akuznetsova) wrote :

Bug was fixed more than a year ago, thus bug is going to be moved to Fix Released.

Changed in python-mistralclient:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.