yahoo-eng-team team mailing list archive

[Jakub Libosvar <libosvar@xxxxxxxxxx>]

Public bug reported:

When deleting qos policy with existing rule, we fail and 404 is returned (which might by also error as I would expect 50x).
2015-08-17 16:34:50.869 21020 ERROR neutron.api.v2.resource DBReferenceError: (pymysql.err.IntegrityError) (1451, u'Cannot delete or update a parent row: a foreign key constraint fails (    `gfplmidcmm`.`qos_bandwidth_limit_rules`, CONSTRAINT `qos_bandwidth_limit_rules_ibfk_1` FOREIGN KEY (`qos_policy_id`) REFERENCES `qos_policies` (`id`))') [SQL: u'DELETE FROM qos_policies     WHERE qos_policies.id = %s'] [parameters: (u'2fa93316-4654-495d-a344-a18e9bfb6ac9',)]

** Affects: neutron
     Importance: Undecided
         Status: New


** Tags: neutron-qos

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1485926

Title:
  Delete qos policy fails due to missing ON DELETE CASCADE

Status in neutron:
  New

Bug description:
  When deleting qos policy with existing rule, we fail and 404 is returned (which might by also error as I would expect 50x).
  2015-08-17 16:34:50.869 21020 ERROR neutron.api.v2.resource DBReferenceError: (pymysql.err.IntegrityError) (1451, u'Cannot delete or update a parent row: a foreign key constraint fails (    `gfplmidcmm`.`qos_bandwidth_limit_rules`, CONSTRAINT `qos_bandwidth_limit_rules_ibfk_1` FOREIGN KEY (`qos_policy_id`) REFERENCES `qos_policies` (`id`))') [SQL: u'DELETE FROM qos_policies     WHERE qos_policies.id = %s'] [parameters: (u'2fa93316-4654-495d-a344-a18e9bfb6ac9',)]

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1485926/+subscriptions