cant delete akanda ports

Bug #1481463 reported by Adam Gandelman
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Astara
Fix Released
High
Adam Gandelman
akanda
Fix Released
High
Adam Gandelman

Bug Description

Just noticed I can no longer delete an unused akanda port. After stopping the RUG:

adam@trusty:/opt/stack/akanda-neutron$ neutron port-list | grep AKANDA | head -n2
| 02f09b12-77dc-4f85-b42f-0176d41b5c86 | AKANDA:VRRP:1a85a349-6e2b-4593-a9f1-58fe8bdfbfc2 | fa:16:3e:36:4e:69 | {"subnet_id": "00000000-0000-0000-0000-000000000000", "ip_address": "fe80::f816:3eff:fe36:4e69"} |
| 526a5088-f919-4d02-b926-d07ea3c75ff9 | AKANDA:VRRP:1a85a349-6e2b-4593-a9f1-58fe8bdfbfc2 | fa:16:3e:63:f5:ce | {"subnet_id": "00000000-0000-0000-0000-000000000000", "ip_address": "fe80::f816:3eff:fe63:f5ce"} |
adam@trusty:/opt/stack/akanda-neutron$ neutron port-delete 02f09b12-77dc-4f85-b42f-0176d41b5c86
Request Failed: internal server error while processing your request.

The neutron log shows a database schema issue:

2015-08-04 12:39:31.636 TRACE neutron.api.v2.resource ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'neutron.portforwards' doesn't exist") [SQL: u'SELECT portforwards.tenant_id AS portforwards_tenant_id, portforwards.id AS portforwards_id, portforwards.name AS portforwards_name, portforwards.protocol AS portforwards_protocol, portforwards.public_port AS portforwards_public_port, portforwards.port_id AS portforwards_port_id, portforwards.private_port AS portforwards_private_port \nFROM portforwards \nWHERE %s = portforwards.port_id'] [parameters: (u'02f09b12-77dc-4f85-b42f-0176d41b5c86',)]
2015-08-04 12:39:31.636 TRACE neutron.api.v2.resource

Full traceback here http://paste.openstack.org/show/406933/

Its worth noting that some stuff changed in upstream neutron around extensions. I wonder if we need to tweak ours in some way to avoid port forwards?

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to akanda-neutron (master)

Fix proposed to branch: master
Review: https://review.openstack.org/209267

Changed in akanda:
status: New → In Progress
Changed in akanda:
milestone: none → liberty-rc2
importance: Undecided → High
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to akanda-neutron (master)

Reviewed: https://review.openstack.org/209267
Committed: https://git.openstack.org/cgit/stackforge/akanda-neutron/commit/?id=7b03eb97d3473f8277e08ddadded71ac18b5fe96
Submitter: Jenkins
Branch: master

commit 7b03eb97d3473f8277e08ddadded71ac18b5fe96
Author: Adam Gandelman <email address hidden>
Date: Tue Aug 4 14:44:02 2015 -0700

    Drop unused Neutron extensions

    These extensions are unmaintained and have accumulated siginifcant
    bitrot. Neutron upstream has changed how extensions work and now
    these unused things are starting to cause problems. Remove them until
    we can rebase them on the current Neutron code and repair them.

    Change-Id: I627bb0b878d4c6fccca1a7abad242df41ed29698
    Closes-bug: #1481463

Changed in akanda:
status: In Progress → Fix Committed
Sean Roberts (sarob)
Changed in akanda:
assignee: nobody → Adam Gandelman (gandelman-a)
milestone: liberty-rc2 → liberty-2
Sean Roberts (sarob)
Changed in akanda:
status: Fix Committed → Fix Released
Changed in astara:
milestone: none → 7.0.0
assignee: nobody → Adam Gandelman (gandelman-a)
importance: Undecided → High
status: New → Fix Released
Changed in akanda:
milestone: liberty-2 → 7.0.0
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.