[[Neutron]]

---

# Port stuck in migrating

Check whether DB has duplicate record:
```
MariaDB [neutron]> select * from ml2_port_bindings where port_id = "e87c2cab-e2e8-4e7b-9014-acdf5adfff0e";
+--------------------------------------+-----------------------------------+----------+-----------+----------------------------------------------------------------------------------+---------------------------------------------+----------+
| port_id                              | host                              | vif_type | vnic_type | profile                                                                          | vif_details                                 | status   |
+--------------------------------------+-----------------------------------+----------+-----------+----------------------------------------------------------------------------------+---------------------------------------------+----------+
| e87c2cab-e2e8-4e7b-9014-acdf5adfff0e | n13.compute.env.vps1-lej1.one.com | ovs      | normal    | {"os_vif_delegation": true}                                                      | {"port_filter": true, "connectivity": "l2"} | INACTIVE |
| e87c2cab-e2e8-4e7b-9014-acdf5adfff0e | n16.compute.env.vps1-lej1.one.com | ovs      | normal    | {"os_vif_delegation": true, "migrating_to": "n13.compute.env.vps1-lej1.one.com"} | {"port_filter": true, "connectivity": "l2"} | ACTIVE   |
+--------------------------------------+-----------------------------------+----------+-----------+----------------------------------------------------------------------------------+---------------------------------------------+----------+
2 rows in set (0.000 sec)
```

Delete the that is INACTIVE
```
MariaDB [neutron]> delete from ml2_port_bindings where port_id = "e87c2cab-e2e8-4e7b-9014-acdf5adfff0e" and host = "n13.compute.env.vps1-lej1.one.com";
Query OK, 1 row affected (0.001 sec)
```

Now update port binding
```
.venv ❯ os3 port set --host n13.compute.env.vps1-lej1.one.com e87c2cab-e2e8-4e7b-9014-acdf5adfff0e
```

Update binding_profile:

```
osc main*​​ 2s
.venv ❯ os3 port set --no-binding-profile e87c2cab-e2e8-4e7b-9014-acdf5adfff0e
```

```
osc main*​​ 2s
.venv ❯ os3 port set --binding-profile os_vif_delegation=True e87c2cab-e2e8-4e7b-9014-acdf5adfff0e
```

Check the port status afterward, is it DOWN? Perhaps migrate the VM.