Comment 21 for bug 1709774

stack@ubuntu:~/devstack$ neutron port-list -- --device_owner=network:router_centralized_snat
neutron CLI is deprecated and will be removed in the future. Use openstack CLI instead.
+--------------------------------------+------+-----------+-------------------+-----------------------------------------------------------------------------------+
| id | name | tenant_id | mac_address | fixed_ips |
+--------------------------------------+------+-----------+-------------------+-----------------------------------------------------------------------------------+
| 6df031ec-abc1-45ee-bee9-70c5ea1f1947 | | | fa:16:3e:40:51:f9 | {"subnet_id": "2f8ecc6d-0656-474d-80dd-d5b819db944d", "ip_address": "10.16.6.12"} |
| 94258ba0-46d7-477a-9f32-437241436dc7 | | | fa:16:3e:99:c8:ed | {"subnet_id": "220742b6-4a34-44d5-97cb-654fead798ac", "ip_address": "10.16.5.7"} |
| ab4a9b89-967d-474c-a958-684144ed704e | | | fa:16:3e:cd:ea:63 | {"subnet_id": "2f8ecc6d-0656-474d-80dd-d5b819db944d", "ip_address": "10.16.6.11"} |

After creating the 10.16.6.12, it is supposed to update the RouterPort table successfully, but something is causing it to fail and then triggers this retry as shown below.

DEBUG neutron.scheduler.dhcp_agent_scheduler [None req-962cb19b-c845-48ae-8c0a-1b564d4d74a4 admin
admin] Network 0c1c7014-ef35-4d03-b5f0-fbff5f793a0f is already hosted by enough agents. {{(pid=30818) _get_dhcp_agents_hosting_network /opt/stack/neutron/neutron/scheduler/dhcp_agent_scheduler.py:243}}
WARNING neutron.db.l3_dvr_db [None req-962cb19b-c845-48ae-8c0a-1b564d4d74a4 admin admin] ### SNAT Port created: {'status': 'DOWN', 'binding:host_id': '', 'description': '', 'allowed_address_pairs': [], 'tags': [], 'extra_dhcp_opts': [], 'updated_at': '2017-08-16T22:05:57Z', 'device_owner': 'network:router_centralized_snat', 'revision_number': 3, 'binding:profile': {}, 'port_security_enabled': False, 'fixed_ips': [{'subnet_id': u'2f8ecc6d-0656-474d-80dd-d5b819db944d', 'ip_address': u'10.16.6.12'}], 'id': '6df031ec-abc1-45ee-bee9-70c5ea1f1947', 'security_groups': [], 'device_id': u'a53c639a-cb21-4143-835a-22813a89c8f6', 'name': '', 'admin_state_up': True, 'network_id': u'0c1c7014-ef35-4d03-b5f0-fbff5f793a0f', 'tenant_id': '', 'binding:vif_details': {}, 'binding:vnic_type': 'normal', 'binding:vif_type': 'unbound', 'mac_address': 'fa:16:3e:40:51:f9', 'project_id': '', 'created_at': '2017-08-16T22:05:57Z'}

After the port got created it is triggering a Retry.

DEBUG neutron.db.api [None req-962cb19b-c845-48ae-8c0a-1b564d4d74a4 admin admin] Retry wrapper got retriable exception: UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matched. {{(pid=30818) wrapped /opt/stack/neutron/neutron/db/api.py:128}}