Bug 920139
| Summary: | mysql CASCADE on delete is not working | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Red Hat OpenStack | Reporter: | Ofer Blaut <oblaut> | ||||
| Component: | openstack-quantum | Assignee: | Gary Kotton <gkotton> | ||||
| Status: | CLOSED ERRATA | QA Contact: | Ofer Blaut <oblaut> | ||||
| Severity: | high | Docs Contact: | |||||
| Priority: | high | ||||||
| Version: | 2.0 (Folsom) | CC: | chrisw, gkotton, twilson, ykaul | ||||
| Target Milestone: | snapshot5 | Keywords: | Triaged | ||||
| Target Release: | 2.1 | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | openstack-quantum-2012.2.3-7.el6ost | Doc Type: | Bug Fix | ||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2013-04-04 18:01:34 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Attachments: |
|
||||||
Also need to check mysql> select * from ipallocations; ( to see DHCP ip is removed as well ) mysql> select * from ipavailabilityranges; quantum net-create ext_net --router:external=True same for external networks mysql> select * from externalnetworks; +--------------------------------------+ | network_id | +--------------------------------------+ | 4b9bf7e1-ee6e-46d4-9833-db0a3ade049e | | 4f889a3d-f1b1-496d-aa8c-1a466888fb6d | | d555283e-9032-42a4-b99a-da7f30672858 | +--------------------------------------+ Tested openstack-quantum-2012.2.3-8.el6ost.noarch net/subnets/dhcp ips were removed correctly from the tables Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. http://rhn.redhat.com/errata/RHBA-2013-0706.html |
Created attachment 708350 [details] OVS_DB Description of problem: network and cascade subnets details are not deleted from OVS_Quantum DB after thy are deleted from CLI Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: Two options : 1. check number of networks in select * from ovs_network_bindings 2. quantum net-create test1 3. quantum net-delete test1 4. check number of networks in select * from ovs_network_bindings , has increased 1. quantum net-create test-3 2. quantum subnet-create test-3 18.18.18.0/24 3. quantum net-delete test-3 4. Check subnet is deleted from quantum subnet-list and OVS DB select * from ipallocationpools; Actual results: Expected results: Additional info: