OpenStack: How to Manually Delete Orphaned Neutron Port

Jan 30, 2016 Cloud Computing

openstack
From time to time, especially during testing and automated script tenant deployment, my OpenStack cloud installation gets disordered. Situations when I am unable to delete neutron port in Horizon dashboard are pretty common phenomenon, this most likely leads to problem with deleting network which the problematic port belongs to.
In such cases we may need to edit OpenStack database, which is MariaDB, and manually delete orphaned neutron port related record from MariaDB ports table.

Error: Failed to delete port
Error: Failed to delete port: Port d06e19fc-c637-402b-85a2-3519c69a1035 has owner network:router_interface and therefore cannot be deleted directly via the port API.

Steps to remove blocked neutron port:

1. Source admin keystone file on controller node

[root@controller ~]# source /root/keystonerc_admin

2. Verify once again orphaned neutron port using OpenStack CLI commands

[root@controller ~(keystone_admin)]# neutron port-list | grep d06e19fc-c637-402b-85a2-3519c69a1035

3. Log in to Openstack MariaDB database on Controller node

[root@controller ~(keystone_admin)]# mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 160448
Server version: 5.5.40-MariaDB-wsrep MariaDB Server, wsrep_25.11.r4026

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

4. Switch to neutron database

MariaDB [(none)]> use neutron;

5. Delete orphaned port from ports table

MariaDB [neutron]> delete from ports where id='d06e19fc-c637-402b-85a2-3519c69a1035';

That’s it, neutron port has been deleted, you can now delete the blocked network, which the orphaned port belonged to.

One thought on “OpenStack: How to Manually Delete Orphaned Neutron Port”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.