Public bug reported: Hi,
During testing neutron-bgp-agent I've found a bug in neutron DB while creating bgpspeaker: Command execution with debug >> root@openstack-controller:/home/debian# openstack --debug bgp speaker create --ip-version 4 --local-as 1234 bgpspeaker START with options: ['--debug', 'bgp', 'speaker', 'create', '--ip-version', '4', '--local-as', '1234', 'bgpspeaker'] options: Namespace(access_key='', access_secret='***', access_token='***', access_token_endpoint='', access_token_type='', application_credential_id='', application_credential_name='', application_credential_secret='***', auth_type='', auth_url='http://185.21.196.179:35357/v3', cacert=None, cert='', client_id='', client_secret='***', cloud='', code='', consumer_key='', consumer_secret='***', debug=True, default_domain='default', default_domain_id='', default_domain_name='', deferred_help=False, discovery_endpoint='', domain_id='', domain_name='', endpoint='', identity_provider='', identity_provider_url='', insecure=None, interface='', key='', log_file=None, openid_scope='', os_beta_command=False, os_compute_api_version='', os_dns_api_version='2', os_identity_api_version='3', os_image_api_version='', os_key_manager_api_version='1', os_network_api_version='', os_object_api_version='', os_project_id=None, os_project_name=None, os_volume_api_version='', passcode='', password='***', profile='', project_domain_id='', project_domain_name='Default', project_id='', project_name='admin', protocol='', redirect_uri='', region_name='', remote_project_domain_id='', remote_project_domain_name='', remote_project_id='', remote_project_name='', service_provider='', service_provider_endpoint='', service_provider_entity_id='', system_scope='', timing=False, token='***', trust_id='', url='', user_domain_id='', user_domain_name='Default', user_id='', username='admin', verbose_level=3, verify=None) Auth plugin password selected auth_config_hook(): {'network_api_version': '2', 'disable_vendor_agent': {}, 'image_api_version': '2', 'debug': True, 'status': 'active', 'auth_type': 'password', 'floating_ip_source': 'neutron', 'key_manager_api_version': '1', 'metering_api_version': '2', 'cacert': None, 'timing': False, 'block_storage_api_version': '2', 'workflow_api_version': '2', 'auth_url': 'http://185.21.196.179:35357/v3', 'image_format': 'qcow2', 'deferred_help': False, 'cert': None, 'beta_command': False, 'identity_api_version': '3', 'verify': True, 'orchestration_api_version': '1', 'baremetal_api_version': '1', 'application_catalog_api_version': '1', 'key': None, 'dns_api_version': '2', 'secgroup_source': 'neutron', 'message': '', 'image_api_use_tasks': False, 'container_api_version': '1', 'baremetal_status_code_retries': '5', 'region_name': '', 'clustering_api_version': '1', 'default_domain': 'default', 'volume_api_version': '2', 'api_timeout': None, 'verbose_level': 3, 'interface': None, 'networks': [], 'container_infra_api_version': '1', 'compute_api_version': '2', 'auth': {'project_name': 'admin', 'project_domain_name': 'Default', 'user_domain_name': 'Default'}, 'object_store_api_version': '1', 'username': 'admin', 'password': '***', 'database_api_version': '1.0'} defaults: {'network_api_version': '2', 'application_catalog_api_version': '1', 'image_api_version': '2', 'image_api_use_tasks': False, 'auth_type': 'password', 'floating_ip_source': 'neutron', 'key_manager_api_version': 'v1', 'metering_api_version': '2', 'cacert': None, 'block_storage_api_version': '2', 'workflow_api_version': '2', 'verify': True, 'key': None, 'cert': None, 'identity_api_version': '2.0', 'orchestration_api_version': '1', 'status': 'active', 'baremetal_api_version': '1', 'disable_vendor_agent': {}, 'container_infra_api_version': '1', 'secgroup_source': 'neutron', 'message': '', 'dns_api_version': '2', 'container_api_version': '1', 'baremetal_status_code_retries': 5, 'image_format': 'qcow2', 'volume_api_version': '2', 'api_timeout': None, 'interface': None, 'clustering_api_version': '1', 'compute_api_version': '2', 'object_store_api_version': '1', 'database_api_version': '1.0'} cloud cfg: {'network_api_version': '2', 'orchestration_api_version': '1', 'message': '', 'debug': True, 'dns_api_version': '2', 'auth_type': 'password', 'floating_ip_source': 'neutron', 'key_manager_api_version': '1', 'metering_api_version': '2', 'cacert': None, 'timing': False, 'block_storage_api_version': '2', 'workflow_api_version': '2', 'auth_url': 'http://185.21.196.179:35357/v3', 'image_format': 'qcow2', 'key': None, 'cert': None, 'beta_command': False, 'identity_api_version': '3', 'verify': True, 'disable_vendor_agent': {}, 'status': 'active', 'baremetal_api_version': '1', 'application_catalog_api_version': '1', 'deferred_help': False, 'container_infra_api_version': '1', 'secgroup_source': 'neutron', 'image_api_version': '2', 'image_api_use_tasks': False, 'container_api_version': '1', 'baremetal_status_code_retries': '5', 'region_name': '', 'clustering_api_version': '1', 'default_domain': 'default', 'volume_api_version': '2', 'api_timeout': None, 'verbose_level': 3, 'interface': None, 'networks': [], 'compute_api_version': '2', 'auth': {'project_name': 'admin', 'project_domain_name': 'Default', 'user_domain_name': 'Default'}, 'object_store_api_version': '1', 'username': 'admin', 'password': '***', 'database_api_version': '1.0'} network API version 2, cmd group openstack.network.v2 image API version 2, cmd group openstack.image.v2 identity API version 3, cmd group openstack.identity.v3 volume API version 2, cmd group openstack.volume.v2 compute API version 2, cmd group openstack.compute.v2 object_store API version 1, cmd group openstack.object_store.v1 neutronclient API version 2, cmd group openstack.neutronclient.v2 dns API version 2, cmd group openstack.dns.v2 key_manager API version 1, cmd group openstack.key_manager.v1 Auth plugin password selected auth_config_hook(): {'network_api_version': '2', 'disable_vendor_agent': {}, 'image_api_version': '2', 'debug': True, 'status': 'active', 'auth_type': 'password', 'floating_ip_source': 'neutron', 'key_manager_api_version': '1', 'metering_api_version': '2', 'cacert': None, 'timing': False, 'block_storage_api_version': '2', 'workflow_api_version': '2', 'auth_url': 'http://185.21.196.179:35357/v3', 'image_format': 'qcow2', 'deferred_help': False, 'cert': None, 'beta_command': False, 'identity_api_version': '3', 'verify': True, 'orchestration_api_version': '1', 'baremetal_api_version': '1', 'application_catalog_api_version': '1', 'key': None, 'dns_api_version': '2', 'secgroup_source': 'neutron', 'message': '', 'image_api_use_tasks': False, 'container_api_version': '1', 'baremetal_status_code_retries': '5', 'region_name': '', 'clustering_api_version': '1', 'default_domain': 'default', 'volume_api_version': '2', 'api_timeout': None, 'verbose_level': 3, 'interface': None, 'networks': [], 'container_infra_api_version': '1', 'compute_api_version': '2', 'auth': {'project_name': 'admin', 'project_domain_name': 'Default', 'user_domain_name': 'Default'}, 'object_store_api_version': '1', 'username': 'admin', 'password': '***', 'database_api_version': '1.0'} Auth plugin password selected auth_config_hook(): {'network_api_version': '2', 'disable_vendor_agent': {}, 'image_api_version': '2', 'debug': True, 'status': 'active', 'auth_type': 'password', 'floating_ip_source': 'neutron', 'key_manager_api_version': '1', 'metering_api_version': '2', 'cacert': None, 'timing': False, 'block_storage_api_version': '2', 'workflow_api_version': '2', 'auth_url': 'http://185.21.196.179:35357/v3', 'image_format': 'qcow2', 'deferred_help': False, 'cert': None, 'beta_command': False, 'identity_api_version': '3', 'verify': True, 'orchestration_api_version': '1', 'baremetal_api_version': '1', 'application_catalog_api_version': '1', 'key': None, 'dns_api_version': '2', 'secgroup_source': 'neutron', 'message': '', 'image_api_use_tasks': False, 'container_api_version': '1', 'baremetal_status_code_retries': '5', 'region_name': '', 'clustering_api_version': '1', 'default_domain': 'default', 'volume_api_version': '2', 'api_timeout': None, 'verbose_level': 3, 'interface': None, 'networks': [], 'container_infra_api_version': '1', 'compute_api_version': '2', 'auth': {'project_name': 'admin', 'project_domain_name': 'Default', 'user_domain_name': 'Default'}, 'object_store_api_version': '1', 'username': 'admin', 'password': '***', 'database_api_version': '1.0'} command: bgp speaker create -> neutronclient.osc.v2.dynamic_routing.bgp_speaker.CreateBgpSpeaker (auth=True) Auth plugin password selected auth_config_hook(): {'network_api_version': '2', 'disable_vendor_agent': {}, 'image_api_version': '2', 'debug': True, 'status': 'active', 'auth_type': 'password', 'floating_ip_source': 'neutron', 'key_manager_api_version': '1', 'metering_api_version': '2', 'additional_user_agent': [('osc-lib', '1.11.1')], 'cacert': None, 'timing': False, 'block_storage_api_version': '2', 'workflow_api_version': '2', 'auth_url': 'http://185.21.196.179:35357/v3', 'image_format': 'qcow2', 'deferred_help': False, 'cert': None, 'beta_command': False, 'identity_api_version': '3', 'verify': True, 'orchestration_api_version': '1', 'baremetal_api_version': '1', 'application_catalog_api_version': '1', 'key': None, 'dns_api_version': '2', 'secgroup_source': 'neutron', 'message': '', 'image_api_use_tasks': False, 'container_api_version': '1', 'baremetal_status_code_retries': '5', 'region_name': '', 'clustering_api_version': '1', 'default_domain': 'default', 'volume_api_version': '2', 'api_timeout': None, 'verbose_level': 3, 'interface': None, 'networks': [], 'container_infra_api_version': '1', 'compute_api_version': '2', 'auth': {'project_name': 'admin', 'project_domain_name': 'Default', 'user_domain_name': 'Default'}, 'object_store_api_version': '1', 'username': 'admin', 'password': '***', 'database_api_version': '1.0'} Using auth plugin: password Using parameters {'auth_url': 'http://185.21.196.179:35357/v3', 'user_domain_name': 'Default', 'project_name': 'admin', 'project_domain_name': 'Default', 'username': 'admin', 'password': '***'} Get auth_ref REQ: curl -g -i -X GET http://185.21.196.179:35357/v3 -H "Accept: application/json" -H "User-Agent: openstacksdk/0.17.2 keystoneauth1/3.10.0 python-requests/2.18.4 CPython/3.5.3" Starting new HTTP connection (1): 185.21.196.179 http://185.21.196.179:35357 "GET /v3 HTTP/1.1" 200 255 RESP: [200] Connection: Keep-Alive Content-Length: 255 Content-Type: application/json Date: Tue, 12 Mar 2019 15:19:21 GMT Keep-Alive: timeout=5, max=100 Server: Apache/2.4.25 (Debian) Vary: X-Auth-Token x-openstack-request-id: req-32f8033d-6bee-423d-8127-07f7fcd0c070 RESP BODY: {"version": {"id": "v3.10", "media-types": [{"type": "application/vnd.openstack.identity-v3+json", "base": "application/json"}], "updated": "2018-02-28T00:00:00Z", "links": [{"href": "http://185.21.196.179:35357/v3/";, "rel": "self"}], "status": "stable"}} GET call to http://185.21.196.179:35357/v3 used request id req-32f8033d-6bee-423d-8127-07f7fcd0c070 Making authentication request to http://185.21.196.179:35357/v3/auth/tokens http://185.21.196.179:35357 "POST /v3/auth/tokens HTTP/1.1" 201 5931 {"token": {"user": {"name": "admin", "domain": {"name": "Default", "id": "default"}, "password_expires_at": null, "id": "c6fa01a00b7244e7b6e2a5ea5a1fb5a5"}, "expires_at": "2019-03-12T16:19:22.000000Z", "methods": ["password"], "project": {"name": "admin", "domain": {"name": "Default", "id": "default"}, "id": "0ed98ec832f848bbb8146b4fe6070110"}, "catalog": [{"name": "cinder", "type": "volume", "endpoints": [{"interface": "public", "url": "http://openstack-ctrl:8776/v1/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "191e22cf410245c895b51ec60161b273"}, {"interface": "internal", "url": "http://openstack-ctrl:8776/v1/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "47d650a5e6fc4adc9e5408118484e878"}, {"interface": "admin", "url": "http://openstack-ctrl:8776/v1/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "6211b0a6000c4c3d8d20af141c62c542"}], "id": "1496ac366cf54ccfa34f0b74e6b5327b"}, {"name": "keystone", "type": "identity", "endpoints": [{"interface": "admin", "url": "http://185.21.196.179:35357";, "region": "RegionOne", "region_id": "RegionOne", "id": "458b1b0362c24847831390b5438c5273"}, {"interface": "internal", "url": "http://185.21.196.179:5000";, "region": "RegionOne", "region_id": "RegionOne", "id": "5fe62f4856434ec29fb57a8bc1a5c17b"}, {"interface": "public", "url": "http://185.21.196.179:5000";, "region": "RegionOne", "region_id": "RegionOne", "id": "f256f2dcbe8941bcab1cb5daacd08980"}], "id": "20e519cf86b44c6ab7dc9ff53ece9586"}, {"name": "cinderv2", "type": "volumev2", "endpoints": [{"interface": "public", "url": "http://openstack-ctrl:8776/v2/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "05dbc54e8ef247ffb4d5ceb5161c851c"}, {"interface": "internal", "url": "http://openstack-ctrl:8776/v2/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "638b4e4b382b4129889c83d8e8594c66"}, {"interface": "admin", "url": "http://openstack-ctrl:8776/v2/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "f183da1d224b408b849946fad60f2d16"}], "id": "5ab6dbf774cb45cd95be5980e1ad6187"}, {"name": "nova", "type": "compute", "endpoints": [{"interface": "admin", "url": "http://openstack-ctrl:8774/v2.1";, "region": "RegionOne", "region_id": "RegionOne", "id": "382d8910a9dc43678f9ac1ddf193d3d4"}, {"interface": "public", "url": "http://openstack-ctrl:8774/v2.1";, "region": "RegionOne", "region_id": "RegionOne", "id": "9782b188ba05407fb7203376f47fcccc"}, {"interface": "internal", "url": "http://openstack-ctrl:8774/v2.1";, "region": "RegionOne", "region_id": "RegionOne", "id": "e12d91ee2bb34b57ad42c7e3b9f02866"}], "id": "8cf4a0cd8cf2495eacb11d6415695fda"}, {"name": "glance", "type": "image", "endpoints": [{"interface": "admin", "url": "http://openstack-ctrl:9292";, "region": "RegionOne", "region_id": "RegionOne", "id": "51be68af2fa9484faae789dd56ebd23b"}, {"interface": "public", "url": "http://openstack-ctrl:9292";, "region": "RegionOne", "region_id": "RegionOne", "id": "8c0b02bf1f994a6aa2233e3e33940dae"}, {"interface": "internal", "url": "http://openstack-ctrl:9292";, "region": "RegionOne", "region_id": "RegionOne", "id": "bba6ebf69ede4c8eba1fdbdad55f4f22"}], "id": "8fe4d5dcb0204a5087adcd0073346bf3"}, {"name": "neutron", "type": "network", "endpoints": [{"interface": "public", "url": "http://openstack-ctrl:9696";, "region": "RegionOne", "region_id": "RegionOne", "id": "33d2e1ea0ebe4cfc87c59e4b27272378"}, {"interface": "internal", "url": "http://openstack-ctrl:9696";, "region": "RegionOne", "region_id": "RegionOne", "id": "4f07e2f4aec7493cae10f17395d46e8e"}, {"interface": "admin", "url": "http://openstack-ctrl:9696";, "region": "RegionOne", "region_id": "RegionOne", "id": "d9b51ba2d3634d5ea05f6b46f4613942"}], "id": "ce6f8812a4ef4b369d47eb87a89dc5b5"}, {"name": "cinderv3", "type": "volumev3", "endpoints": [{"interface": "internal", "url": "http://openstack-ctrl:8776/v3/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "0771b5102bfb4f48be67fbbe9f9ce2f7"}, {"interface": "admin", "url": "http://openstack-ctrl:8776/v3/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "7a648e58f3a64bf2a4d4c7eb343fa38e"}, {"interface": "public", "url": "http://openstack-ctrl:8776/v3/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "eb7261817134450b8693fc58bbbae500"}], "id": "d4c68f82b820476e97d74391a6fd33af"}, {"name": "placement", "type": "placement", "endpoints": [{"interface": "public", "url": "http://openstack-ctrl:8778";, "region": "RegionOne", "region_id": "RegionOne", "id": "4867006d05004fe289aab41bfd5f4c8c"}, {"interface": "internal", "url": "http://openstack-ctrl:8778";, "region": "RegionOne", "region_id": "RegionOne", "id": "5df408799f99448890162c218172c6b2"}, {"interface": "admin", "url": "http://openstack-ctrl:8778";, "region": "RegionOne", "region_id": "RegionOne", "id": "cff60d89d851414392d6bfbf1fbd5c1e"}], "id": "f9f33557e82f4ea2a59039961d8dd697"}], "roles": [{"name": "reader", "id": "80c0d6badde1499fb2a273fdaf060658"}, {"name": "admin", "id": "55110b9ad0b54dba94f7f621536c6f80"}, {"name": "owner", "id": "d4b49337958f423589c233d2340ba71a"}, {"name": "heat_stack_owner", "id": "c7bd19ade07a465f80c3407143e7fa28"}, {"name": "ResellerAdmin", "id": "1c3c5f787f0e4ff2834433a71a7de50f"}, {"name": "rating", "id": "bddecdae15ba42d0b9218ed700364f6f"}, {"name": "service", "id": "0c68f680a8c441e5aaa6d8224b8c31ae"}, {"name": "member", "id": "8c72aab03b71436e82f92da894eb063d"}, {"name": "KeystoneServiceAdmin", "id": "9e79266c095e49179dc465827351ed3a"}, {"name": "KeystoneAdmin", "id": "146ab8e647474b3fa53e250f2a2858fe"}], "is_domain": false, "audit_ids": ["NRyAoEaUSFiJjjnFqZu4oQ"], "issued_at": "2019-03-12T15:19:22.000000Z"}} run(Namespace(advertise_floating_ip_host_routes=False, advertise_tenant_networks=False, columns=[], fit_width=False, formatter='table', ip_version=4, local_as='1234', max_width=0, name='bgpspeaker', no_advertise_floating_ip_host_routes=False, no_advertise_tenant_networks=False, noindent=False, prefix='', print_empty=False, project=None, project_domain=None, variables=[])) Instantiating neutron client: <class 'neutronclient.v2_0.client.Client'> Making authentication request to http://185.21.196.179:35357/v3/auth/tokens http://185.21.196.179:35357 "POST /v3/auth/tokens HTTP/1.1" 201 5931 {"token": {"user": {"name": "admin", "domain": {"name": "Default", "id": "default"}, "password_expires_at": null, "id": "c6fa01a00b7244e7b6e2a5ea5a1fb5a5"}, "expires_at": "2019-03-12T16:19:23.000000Z", "methods": ["password"], "project": {"name": "admin", "domain": {"name": "Default", "id": "default"}, "id": "0ed98ec832f848bbb8146b4fe6070110"}, "catalog": [{"name": "cinder", "type": "volume", "endpoints": [{"interface": "public", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v1/0ed98ec832f848bbb8146b4fe6070110";, "id": "191e22cf410245c895b51ec60161b273", "region_id": "RegionOne"}, {"interface": "internal", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v1/0ed98ec832f848bbb8146b4fe6070110";, "id": "47d650a5e6fc4adc9e5408118484e878", "region_id": "RegionOne"}, {"interface": "admin", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v1/0ed98ec832f848bbb8146b4fe6070110";, "id": "6211b0a6000c4c3d8d20af141c62c542", "region_id": "RegionOne"}], "id": "1496ac366cf54ccfa34f0b74e6b5327b"}, {"name": "keystone", "type": "identity", "endpoints": [{"interface": "admin", "region": "RegionOne", "url": "http://185.21.196.179:35357";, "id": "458b1b0362c24847831390b5438c5273", "region_id": "RegionOne"}, {"interface": "internal", "region": "RegionOne", "url": "http://185.21.196.179:5000";, "id": "5fe62f4856434ec29fb57a8bc1a5c17b", "region_id": "RegionOne"}, {"interface": "public", "region": "RegionOne", "url": "http://185.21.196.179:5000";, "id": "f256f2dcbe8941bcab1cb5daacd08980", "region_id": "RegionOne"}], "id": "20e519cf86b44c6ab7dc9ff53ece9586"}, {"name": "cinderv2", "type": "volumev2", "endpoints": [{"interface": "public", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v2/0ed98ec832f848bbb8146b4fe6070110";, "id": "05dbc54e8ef247ffb4d5ceb5161c851c", "region_id": "RegionOne"}, {"interface": "internal", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v2/0ed98ec832f848bbb8146b4fe6070110";, "id": "638b4e4b382b4129889c83d8e8594c66", "region_id": "RegionOne"}, {"interface": "admin", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v2/0ed98ec832f848bbb8146b4fe6070110";, "id": "f183da1d224b408b849946fad60f2d16", "region_id": "RegionOne"}], "id": "5ab6dbf774cb45cd95be5980e1ad6187"}, {"name": "nova", "type": "compute", "endpoints": [{"interface": "admin", "region": "RegionOne", "url": "http://openstack-ctrl:8774/v2.1";, "id": "382d8910a9dc43678f9ac1ddf193d3d4", "region_id": "RegionOne"}, {"interface": "public", "region": "RegionOne", "url": "http://openstack-ctrl:8774/v2.1";, "id": "9782b188ba05407fb7203376f47fcccc", "region_id": "RegionOne"}, {"interface": "internal", "region": "RegionOne", "url": "http://openstack-ctrl:8774/v2.1";, "id": "e12d91ee2bb34b57ad42c7e3b9f02866", "region_id": "RegionOne"}], "id": "8cf4a0cd8cf2495eacb11d6415695fda"}, {"name": "glance", "type": "image", "endpoints": [{"interface": "admin", "region": "RegionOne", "url": "http://openstack-ctrl:9292";, "id": "51be68af2fa9484faae789dd56ebd23b", "region_id": "RegionOne"}, {"interface": "public", "region": "RegionOne", "url": "http://openstack-ctrl:9292";, "id": "8c0b02bf1f994a6aa2233e3e33940dae", "region_id": "RegionOne"}, {"interface": "internal", "region": "RegionOne", "url": "http://openstack-ctrl:9292";, "id": "bba6ebf69ede4c8eba1fdbdad55f4f22", "region_id": "RegionOne"}], "id": "8fe4d5dcb0204a5087adcd0073346bf3"}, {"name": "neutron", "type": "network", "endpoints": [{"interface": "public", "region": "RegionOne", "url": "http://openstack-ctrl:9696";, "id": "33d2e1ea0ebe4cfc87c59e4b27272378", "region_id": "RegionOne"}, {"interface": "internal", "region": "RegionOne", "url": "http://openstack-ctrl:9696";, "id": "4f07e2f4aec7493cae10f17395d46e8e", "region_id": "RegionOne"}, {"interface": "admin", "region": "RegionOne", "url": "http://openstack-ctrl:9696";, "id": "d9b51ba2d3634d5ea05f6b46f4613942", "region_id": "RegionOne"}], "id": "ce6f8812a4ef4b369d47eb87a89dc5b5"}, {"name": "cinderv3", "type": "volumev3", "endpoints": [{"interface": "internal", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v3/0ed98ec832f848bbb8146b4fe6070110";, "id": "0771b5102bfb4f48be67fbbe9f9ce2f7", "region_id": "RegionOne"}, {"interface": "admin", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v3/0ed98ec832f848bbb8146b4fe6070110";, "id": "7a648e58f3a64bf2a4d4c7eb343fa38e", "region_id": "RegionOne"}, {"interface": "public", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v3/0ed98ec832f848bbb8146b4fe6070110";, "id": "eb7261817134450b8693fc58bbbae500", "region_id": "RegionOne"}], "id": "d4c68f82b820476e97d74391a6fd33af"}, {"name": "placement", "type": "placement", "endpoints": [{"interface": "public", "region": "RegionOne", "url": "http://openstack-ctrl:8778";, "id": "4867006d05004fe289aab41bfd5f4c8c", "region_id": "RegionOne"}, {"interface": "internal", "region": "RegionOne", "url": "http://openstack-ctrl:8778";, "id": "5df408799f99448890162c218172c6b2", "region_id": "RegionOne"}, {"interface": "admin", "region": "RegionOne", "url": "http://openstack-ctrl:8778";, "id": "cff60d89d851414392d6bfbf1fbd5c1e", "region_id": "RegionOne"}], "id": "f9f33557e82f4ea2a59039961d8dd697"}], "roles": [{"name": "rating", "id": "bddecdae15ba42d0b9218ed700364f6f"}, {"name": "KeystoneAdmin", "id": "146ab8e647474b3fa53e250f2a2858fe"}, {"name": "ResellerAdmin", "id": "1c3c5f787f0e4ff2834433a71a7de50f"}, {"name": "owner", "id": "d4b49337958f423589c233d2340ba71a"}, {"name": "service", "id": "0c68f680a8c441e5aaa6d8224b8c31ae"}, {"name": "reader", "id": "80c0d6badde1499fb2a273fdaf060658"}, {"name": "admin", "id": "55110b9ad0b54dba94f7f621536c6f80"}, {"name": "member", "id": "8c72aab03b71436e82f92da894eb063d"}, {"name": "heat_stack_owner", "id": "c7bd19ade07a465f80c3407143e7fa28"}, {"name": "KeystoneServiceAdmin", "id": "9e79266c095e49179dc465827351ed3a"}], "is_domain": false, "audit_ids": ["ugkxsdTcQ66b-7MS9yGp5A"], "issued_at": "2019-03-12T15:19:23.000000Z"}} REQ: curl -g -i -X POST http://openstack-ctrl:9696/v2.0/bgp-speakers -H "Accept: application/json" -H "Content-Type: application/json" -H "User-Agent: python-neutronclient" -H "X-Auth-Token: {SHA1}7767213b7aede6958380f93fe01ead564c501885" -d '{"bgp_speaker": {"name": "bgpspeaker", "local_as": "1234", "ip_version": 4}}' Starting new HTTP connection (1): openstack-ctrl http://openstack-ctrl:9696 "POST /v2.0/bgp-speakers HTTP/1.1" 500 None RESP: [500] Connection: close Content-Type: application/json x-openstack-request-id: req-f8d27b19-8b1f-45d4-8ab8-b419c9e655b1 RESP BODY: {"NeutronError": {"message": "Request Failed: internal server error while processing your request.", "type": "HTTPInternalServerError", "detail": ""}} POST call to network for http://openstack-ctrl:9696/v2.0/bgp-speakers used request id req-f8d27b19-8b1f-45d4-8ab8-b419c9e655b1 Error message: {"NeutronError": {"message": "Request Failed: internal server error while processing your request.", "type": "HTTPInternalServerError", "detail": ""}} Request Failed: internal server error while processing your request. Neutron server returns request_ids: ['req-f8d27b19-8b1f-45d4-8ab8-b419c9e655b1'] Traceback (most recent call last): File "/usr/lib/python3/dist-packages/cliff/app.py", line 400, in run_subcommand result = cmd.run(parsed_args) File "/usr/lib/python3/dist-packages/osc_lib/command/command.py", line 41, in run return super(Command, self).run(parsed_args) File "/usr/lib/python3/dist-packages/cliff/display.py", line 116, in run column_names, data = self.take_action(parsed_args) File "/usr/lib/python3/dist-packages/neutronclient/osc/v2/dynamic_routing/bgp_speaker.py", line 152, in take_action obj = client.create_bgp_speaker(body)[constants.BGP_SPEAKER] File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 2006, in create_bgp_speaker return self.post(self.bgp_speakers_path, body=body) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 359, in post headers=headers, params=params) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 294, in do_request self._handle_fault_response(status_code, replybody, resp) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 269, in _handle_fault_response exception_handler_v20(status_code, error_body) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 93, in exception_handler_v20 request_ids=request_ids) neutronclient.common.exceptions.InternalServerError: Request Failed: internal server error while processing your request. Neutron server returns request_ids: ['req-f8d27b19-8b1f-45d4-8ab8-b419c9e655b1'] clean_up CreateBgpSpeaker: Request Failed: internal server error while processing your request. Neutron server returns request_ids: ['req-f8d27b19-8b1f-45d4-8ab8-b419c9e655b1'] Traceback (most recent call last): File "/usr/lib/python3/dist-packages/osc_lib/shell.py", line 135, in run ret_val = super(OpenStackShell, self).run(argv) File "/usr/lib/python3/dist-packages/cliff/app.py", line 279, in run result = self.run_subcommand(remainder) File "/usr/lib/python3/dist-packages/osc_lib/shell.py", line 175, in run_subcommand ret_value = super(OpenStackShell, self).run_subcommand(argv) File "/usr/lib/python3/dist-packages/cliff/app.py", line 400, in run_subcommand result = cmd.run(parsed_args) File "/usr/lib/python3/dist-packages/osc_lib/command/command.py", line 41, in run return super(Command, self).run(parsed_args) File "/usr/lib/python3/dist-packages/cliff/display.py", line 116, in run column_names, data = self.take_action(parsed_args) File "/usr/lib/python3/dist-packages/neutronclient/osc/v2/dynamic_routing/bgp_speaker.py", line 152, in take_action obj = client.create_bgp_speaker(body)[constants.BGP_SPEAKER] File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 2006, in create_bgp_speaker return self.post(self.bgp_speakers_path, body=body) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 359, in post headers=headers, params=params) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 294, in do_request self._handle_fault_response(status_code, replybody, resp) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 269, in _handle_fault_response exception_handler_v20(status_code, error_body) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 93, in exception_handler_v20 request_ids=request_ids) neutronclient.common.exceptions.InternalServerError: Request Failed: internal server error while processing your request. Neutron server returns request_ids: ['req-f8d27b19-8b1f-45d4-8ab8-b419c9e655b1'] END return value: 1 Current DB table bgp_speakers : MariaDB [neutron]> show create table bgp_speakers; +--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | bgp_speakers | CREATE TABLE `bgp_speakers` ( `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `local_as` int(11) NOT NULL, `ip_version` int(11) NOT NULL, `tenant_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `advertise_floating_ip_host_routes` tinyint(1) NOT NULL, `advertise_tenant_networks` tinyint(1) NOT NULL, PRIMARY KEY (`id`), KEY `ix_bgp_speakers_tenant_id` (`tenant_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci | +--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [neutron]> As you can see project_id not present in db, instead of , there is tenant_id. I think it is needed to do DB migration for this column and rename it. After alter table everything is working as expected. ALTER TABLE bgp_speakers CHANGE COLUMN tenant_id project_id varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL; ALTER TABLE bgp_peers CHANGE COLUMN tenant_id project_id varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL; Tested on rocky Thanks ** Affects: neutron Importance: Undecided Status: New -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1819724 Title: Database inconsistency in neutron.bgp_speakers Status in neutron: New Bug description: Hi, During testing neutron-bgp-agent I've found a bug in neutron DB while creating bgpspeaker: Command execution with debug >> root@openstack-controller:/home/debian# openstack --debug bgp speaker create --ip-version 4 --local-as 1234 bgpspeaker START with options: ['--debug', 'bgp', 'speaker', 'create', '--ip-version', '4', '--local-as', '1234', 'bgpspeaker'] options: Namespace(access_key='', access_secret='***', access_token='***', access_token_endpoint='', access_token_type='', application_credential_id='', application_credential_name='', application_credential_secret='***', auth_type='', auth_url='http://185.21.196.179:35357/v3', cacert=None, cert='', client_id='', client_secret='***', cloud='', code='', consumer_key='', consumer_secret='***', debug=True, default_domain='default', default_domain_id='', default_domain_name='', deferred_help=False, discovery_endpoint='', domain_id='', domain_name='', endpoint='', identity_provider='', identity_provider_url='', insecure=None, interface='', key='', log_file=None, openid_scope='', os_beta_command=False, os_compute_api_version='', os_dns_api_version='2', os_identity_api_version='3', os_image_api_version='', os_key_manager_api_version='1', os_network_api_version='', os_object_api_version='', os_project_id=None, os_project_name=None, os_volume_api_version='', passcode='', password='***', profile='', project_domain_id='', project_domain_name='Default', project_id='', project_name='admin', protocol='', redirect_uri='', region_name='', remote_project_domain_id='', remote_project_domain_name='', remote_project_id='', remote_project_name='', service_provider='', service_provider_endpoint='', service_provider_entity_id='', system_scope='', timing=False, token='***', trust_id='', url='', user_domain_id='', user_domain_name='Default', user_id='', username='admin', verbose_level=3, verify=None) Auth plugin password selected auth_config_hook(): {'network_api_version': '2', 'disable_vendor_agent': {}, 'image_api_version': '2', 'debug': True, 'status': 'active', 'auth_type': 'password', 'floating_ip_source': 'neutron', 'key_manager_api_version': '1', 'metering_api_version': '2', 'cacert': None, 'timing': False, 'block_storage_api_version': '2', 'workflow_api_version': '2', 'auth_url': 'http://185.21.196.179:35357/v3', 'image_format': 'qcow2', 'deferred_help': False, 'cert': None, 'beta_command': False, 'identity_api_version': '3', 'verify': True, 'orchestration_api_version': '1', 'baremetal_api_version': '1', 'application_catalog_api_version': '1', 'key': None, 'dns_api_version': '2', 'secgroup_source': 'neutron', 'message': '', 'image_api_use_tasks': False, 'container_api_version': '1', 'baremetal_status_code_retries': '5', 'region_name': '', 'clustering_api_version': '1', 'default_domain': 'default', 'volume_api_version': '2', 'api_timeout': None, 'verbose_level': 3, 'interface': None, 'networks': [], 'container_infra_api_version': '1', 'compute_api_version': '2', 'auth': {'project_name': 'admin', 'project_domain_name': 'Default', 'user_domain_name': 'Default'}, 'object_store_api_version': '1', 'username': 'admin', 'password': '***', 'database_api_version': '1.0'} defaults: {'network_api_version': '2', 'application_catalog_api_version': '1', 'image_api_version': '2', 'image_api_use_tasks': False, 'auth_type': 'password', 'floating_ip_source': 'neutron', 'key_manager_api_version': 'v1', 'metering_api_version': '2', 'cacert': None, 'block_storage_api_version': '2', 'workflow_api_version': '2', 'verify': True, 'key': None, 'cert': None, 'identity_api_version': '2.0', 'orchestration_api_version': '1', 'status': 'active', 'baremetal_api_version': '1', 'disable_vendor_agent': {}, 'container_infra_api_version': '1', 'secgroup_source': 'neutron', 'message': '', 'dns_api_version': '2', 'container_api_version': '1', 'baremetal_status_code_retries': 5, 'image_format': 'qcow2', 'volume_api_version': '2', 'api_timeout': None, 'interface': None, 'clustering_api_version': '1', 'compute_api_version': '2', 'object_store_api_version': '1', 'database_api_version': '1.0'} cloud cfg: {'network_api_version': '2', 'orchestration_api_version': '1', 'message': '', 'debug': True, 'dns_api_version': '2', 'auth_type': 'password', 'floating_ip_source': 'neutron', 'key_manager_api_version': '1', 'metering_api_version': '2', 'cacert': None, 'timing': False, 'block_storage_api_version': '2', 'workflow_api_version': '2', 'auth_url': 'http://185.21.196.179:35357/v3', 'image_format': 'qcow2', 'key': None, 'cert': None, 'beta_command': False, 'identity_api_version': '3', 'verify': True, 'disable_vendor_agent': {}, 'status': 'active', 'baremetal_api_version': '1', 'application_catalog_api_version': '1', 'deferred_help': False, 'container_infra_api_version': '1', 'secgroup_source': 'neutron', 'image_api_version': '2', 'image_api_use_tasks': False, 'container_api_version': '1', 'baremetal_status_code_retries': '5', 'region_name': '', 'clustering_api_version': '1', 'default_domain': 'default', 'volume_api_version': '2', 'api_timeout': None, 'verbose_level': 3, 'interface': None, 'networks': [], 'compute_api_version': '2', 'auth': {'project_name': 'admin', 'project_domain_name': 'Default', 'user_domain_name': 'Default'}, 'object_store_api_version': '1', 'username': 'admin', 'password': '***', 'database_api_version': '1.0'} network API version 2, cmd group openstack.network.v2 image API version 2, cmd group openstack.image.v2 identity API version 3, cmd group openstack.identity.v3 volume API version 2, cmd group openstack.volume.v2 compute API version 2, cmd group openstack.compute.v2 object_store API version 1, cmd group openstack.object_store.v1 neutronclient API version 2, cmd group openstack.neutronclient.v2 dns API version 2, cmd group openstack.dns.v2 key_manager API version 1, cmd group openstack.key_manager.v1 Auth plugin password selected auth_config_hook(): {'network_api_version': '2', 'disable_vendor_agent': {}, 'image_api_version': '2', 'debug': True, 'status': 'active', 'auth_type': 'password', 'floating_ip_source': 'neutron', 'key_manager_api_version': '1', 'metering_api_version': '2', 'cacert': None, 'timing': False, 'block_storage_api_version': '2', 'workflow_api_version': '2', 'auth_url': 'http://185.21.196.179:35357/v3', 'image_format': 'qcow2', 'deferred_help': False, 'cert': None, 'beta_command': False, 'identity_api_version': '3', 'verify': True, 'orchestration_api_version': '1', 'baremetal_api_version': '1', 'application_catalog_api_version': '1', 'key': None, 'dns_api_version': '2', 'secgroup_source': 'neutron', 'message': '', 'image_api_use_tasks': False, 'container_api_version': '1', 'baremetal_status_code_retries': '5', 'region_name': '', 'clustering_api_version': '1', 'default_domain': 'default', 'volume_api_version': '2', 'api_timeout': None, 'verbose_level': 3, 'interface': None, 'networks': [], 'container_infra_api_version': '1', 'compute_api_version': '2', 'auth': {'project_name': 'admin', 'project_domain_name': 'Default', 'user_domain_name': 'Default'}, 'object_store_api_version': '1', 'username': 'admin', 'password': '***', 'database_api_version': '1.0'} Auth plugin password selected auth_config_hook(): {'network_api_version': '2', 'disable_vendor_agent': {}, 'image_api_version': '2', 'debug': True, 'status': 'active', 'auth_type': 'password', 'floating_ip_source': 'neutron', 'key_manager_api_version': '1', 'metering_api_version': '2', 'cacert': None, 'timing': False, 'block_storage_api_version': '2', 'workflow_api_version': '2', 'auth_url': 'http://185.21.196.179:35357/v3', 'image_format': 'qcow2', 'deferred_help': False, 'cert': None, 'beta_command': False, 'identity_api_version': '3', 'verify': True, 'orchestration_api_version': '1', 'baremetal_api_version': '1', 'application_catalog_api_version': '1', 'key': None, 'dns_api_version': '2', 'secgroup_source': 'neutron', 'message': '', 'image_api_use_tasks': False, 'container_api_version': '1', 'baremetal_status_code_retries': '5', 'region_name': '', 'clustering_api_version': '1', 'default_domain': 'default', 'volume_api_version': '2', 'api_timeout': None, 'verbose_level': 3, 'interface': None, 'networks': [], 'container_infra_api_version': '1', 'compute_api_version': '2', 'auth': {'project_name': 'admin', 'project_domain_name': 'Default', 'user_domain_name': 'Default'}, 'object_store_api_version': '1', 'username': 'admin', 'password': '***', 'database_api_version': '1.0'} command: bgp speaker create -> neutronclient.osc.v2.dynamic_routing.bgp_speaker.CreateBgpSpeaker (auth=True) Auth plugin password selected auth_config_hook(): {'network_api_version': '2', 'disable_vendor_agent': {}, 'image_api_version': '2', 'debug': True, 'status': 'active', 'auth_type': 'password', 'floating_ip_source': 'neutron', 'key_manager_api_version': '1', 'metering_api_version': '2', 'additional_user_agent': [('osc-lib', '1.11.1')], 'cacert': None, 'timing': False, 'block_storage_api_version': '2', 'workflow_api_version': '2', 'auth_url': 'http://185.21.196.179:35357/v3', 'image_format': 'qcow2', 'deferred_help': False, 'cert': None, 'beta_command': False, 'identity_api_version': '3', 'verify': True, 'orchestration_api_version': '1', 'baremetal_api_version': '1', 'application_catalog_api_version': '1', 'key': None, 'dns_api_version': '2', 'secgroup_source': 'neutron', 'message': '', 'image_api_use_tasks': False, 'container_api_version': '1', 'baremetal_status_code_retries': '5', 'region_name': '', 'clustering_api_version': '1', 'default_domain': 'default', 'volume_api_version': '2', 'api_timeout': None, 'verbose_level': 3, 'interface': None, 'networks': [], 'container_infra_api_version': '1', 'compute_api_version': '2', 'auth': {'project_name': 'admin', 'project_domain_name': 'Default', 'user_domain_name': 'Default'}, 'object_store_api_version': '1', 'username': 'admin', 'password': '***', 'database_api_version': '1.0'} Using auth plugin: password Using parameters {'auth_url': 'http://185.21.196.179:35357/v3', 'user_domain_name': 'Default', 'project_name': 'admin', 'project_domain_name': 'Default', 'username': 'admin', 'password': '***'} Get auth_ref REQ: curl -g -i -X GET http://185.21.196.179:35357/v3 -H "Accept: application/json" -H "User-Agent: openstacksdk/0.17.2 keystoneauth1/3.10.0 python-requests/2.18.4 CPython/3.5.3" Starting new HTTP connection (1): 185.21.196.179 http://185.21.196.179:35357 "GET /v3 HTTP/1.1" 200 255 RESP: [200] Connection: Keep-Alive Content-Length: 255 Content-Type: application/json Date: Tue, 12 Mar 2019 15:19:21 GMT Keep-Alive: timeout=5, max=100 Server: Apache/2.4.25 (Debian) Vary: X-Auth-Token x-openstack-request-id: req-32f8033d-6bee-423d-8127-07f7fcd0c070 RESP BODY: {"version": {"id": "v3.10", "media-types": [{"type": "application/vnd.openstack.identity-v3+json", "base": "application/json"}], "updated": "2018-02-28T00:00:00Z", "links": [{"href": "http://185.21.196.179:35357/v3/";, "rel": "self"}], "status": "stable"}} GET call to http://185.21.196.179:35357/v3 used request id req-32f8033d-6bee-423d-8127-07f7fcd0c070 Making authentication request to http://185.21.196.179:35357/v3/auth/tokens http://185.21.196.179:35357 "POST /v3/auth/tokens HTTP/1.1" 201 5931 {"token": {"user": {"name": "admin", "domain": {"name": "Default", "id": "default"}, "password_expires_at": null, "id": "c6fa01a00b7244e7b6e2a5ea5a1fb5a5"}, "expires_at": "2019-03-12T16:19:22.000000Z", "methods": ["password"], "project": {"name": "admin", "domain": {"name": "Default", "id": "default"}, "id": "0ed98ec832f848bbb8146b4fe6070110"}, "catalog": [{"name": "cinder", "type": "volume", "endpoints": [{"interface": "public", "url": "http://openstack-ctrl:8776/v1/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "191e22cf410245c895b51ec60161b273"}, {"interface": "internal", "url": "http://openstack-ctrl:8776/v1/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "47d650a5e6fc4adc9e5408118484e878"}, {"interface": "admin", "url": "http://openstack-ctrl:8776/v1/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "6211b0a6000c4c3d8d20af141c62c542"}], "id": "1496ac366cf54ccfa34f0b74e6b5327b"}, {"name": "keystone", "type": "identity", "endpoints": [{"interface": "admin", "url": "http://185.21.196.179:35357";, "region": "RegionOne", "region_id": "RegionOne", "id": "458b1b0362c24847831390b5438c5273"}, {"interface": "internal", "url": "http://185.21.196.179:5000";, "region": "RegionOne", "region_id": "RegionOne", "id": "5fe62f4856434ec29fb57a8bc1a5c17b"}, {"interface": "public", "url": "http://185.21.196.179:5000";, "region": "RegionOne", "region_id": "RegionOne", "id": "f256f2dcbe8941bcab1cb5daacd08980"}], "id": "20e519cf86b44c6ab7dc9ff53ece9586"}, {"name": "cinderv2", "type": "volumev2", "endpoints": [{"interface": "public", "url": "http://openstack-ctrl:8776/v2/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "05dbc54e8ef247ffb4d5ceb5161c851c"}, {"interface": "internal", "url": "http://openstack-ctrl:8776/v2/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "638b4e4b382b4129889c83d8e8594c66"}, {"interface": "admin", "url": "http://openstack-ctrl:8776/v2/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "f183da1d224b408b849946fad60f2d16"}], "id": "5ab6dbf774cb45cd95be5980e1ad6187"}, {"name": "nova", "type": "compute", "endpoints": [{"interface": "admin", "url": "http://openstack-ctrl:8774/v2.1";, "region": "RegionOne", "region_id": "RegionOne", "id": "382d8910a9dc43678f9ac1ddf193d3d4"}, {"interface": "public", "url": "http://openstack-ctrl:8774/v2.1";, "region": "RegionOne", "region_id": "RegionOne", "id": "9782b188ba05407fb7203376f47fcccc"}, {"interface": "internal", "url": "http://openstack-ctrl:8774/v2.1";, "region": "RegionOne", "region_id": "RegionOne", "id": "e12d91ee2bb34b57ad42c7e3b9f02866"}], "id": "8cf4a0cd8cf2495eacb11d6415695fda"}, {"name": "glance", "type": "image", "endpoints": [{"interface": "admin", "url": "http://openstack-ctrl:9292";, "region": "RegionOne", "region_id": "RegionOne", "id": "51be68af2fa9484faae789dd56ebd23b"}, {"interface": "public", "url": "http://openstack-ctrl:9292";, "region": "RegionOne", "region_id": "RegionOne", "id": "8c0b02bf1f994a6aa2233e3e33940dae"}, {"interface": "internal", "url": "http://openstack-ctrl:9292";, "region": "RegionOne", "region_id": "RegionOne", "id": "bba6ebf69ede4c8eba1fdbdad55f4f22"}], "id": "8fe4d5dcb0204a5087adcd0073346bf3"}, {"name": "neutron", "type": "network", "endpoints": [{"interface": "public", "url": "http://openstack-ctrl:9696";, "region": "RegionOne", "region_id": "RegionOne", "id": "33d2e1ea0ebe4cfc87c59e4b27272378"}, {"interface": "internal", "url": "http://openstack-ctrl:9696";, "region": "RegionOne", "region_id": "RegionOne", "id": "4f07e2f4aec7493cae10f17395d46e8e"}, {"interface": "admin", "url": "http://openstack-ctrl:9696";, "region": "RegionOne", "region_id": "RegionOne", "id": "d9b51ba2d3634d5ea05f6b46f4613942"}], "id": "ce6f8812a4ef4b369d47eb87a89dc5b5"}, {"name": "cinderv3", "type": "volumev3", "endpoints": [{"interface": "internal", "url": "http://openstack-ctrl:8776/v3/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "0771b5102bfb4f48be67fbbe9f9ce2f7"}, {"interface": "admin", "url": "http://openstack-ctrl:8776/v3/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "7a648e58f3a64bf2a4d4c7eb343fa38e"}, {"interface": "public", "url": "http://openstack-ctrl:8776/v3/0ed98ec832f848bbb8146b4fe6070110";, "region": "RegionOne", "region_id": "RegionOne", "id": "eb7261817134450b8693fc58bbbae500"}], "id": "d4c68f82b820476e97d74391a6fd33af"}, {"name": "placement", "type": "placement", "endpoints": [{"interface": "public", "url": "http://openstack-ctrl:8778";, "region": "RegionOne", "region_id": "RegionOne", "id": "4867006d05004fe289aab41bfd5f4c8c"}, {"interface": "internal", "url": "http://openstack-ctrl:8778";, "region": "RegionOne", "region_id": "RegionOne", "id": "5df408799f99448890162c218172c6b2"}, {"interface": "admin", "url": "http://openstack-ctrl:8778";, "region": "RegionOne", "region_id": "RegionOne", "id": "cff60d89d851414392d6bfbf1fbd5c1e"}], "id": "f9f33557e82f4ea2a59039961d8dd697"}], "roles": [{"name": "reader", "id": "80c0d6badde1499fb2a273fdaf060658"}, {"name": "admin", "id": "55110b9ad0b54dba94f7f621536c6f80"}, {"name": "owner", "id": "d4b49337958f423589c233d2340ba71a"}, {"name": "heat_stack_owner", "id": "c7bd19ade07a465f80c3407143e7fa28"}, {"name": "ResellerAdmin", "id": "1c3c5f787f0e4ff2834433a71a7de50f"}, {"name": "rating", "id": "bddecdae15ba42d0b9218ed700364f6f"}, {"name": "service", "id": "0c68f680a8c441e5aaa6d8224b8c31ae"}, {"name": "member", "id": "8c72aab03b71436e82f92da894eb063d"}, {"name": "KeystoneServiceAdmin", "id": "9e79266c095e49179dc465827351ed3a"}, {"name": "KeystoneAdmin", "id": "146ab8e647474b3fa53e250f2a2858fe"}], "is_domain": false, "audit_ids": ["NRyAoEaUSFiJjjnFqZu4oQ"], "issued_at": "2019-03-12T15:19:22.000000Z"}} run(Namespace(advertise_floating_ip_host_routes=False, advertise_tenant_networks=False, columns=[], fit_width=False, formatter='table', ip_version=4, local_as='1234', max_width=0, name='bgpspeaker', no_advertise_floating_ip_host_routes=False, no_advertise_tenant_networks=False, noindent=False, prefix='', print_empty=False, project=None, project_domain=None, variables=[])) Instantiating neutron client: <class 'neutronclient.v2_0.client.Client'> Making authentication request to http://185.21.196.179:35357/v3/auth/tokens http://185.21.196.179:35357 "POST /v3/auth/tokens HTTP/1.1" 201 5931 {"token": {"user": {"name": "admin", "domain": {"name": "Default", "id": "default"}, "password_expires_at": null, "id": "c6fa01a00b7244e7b6e2a5ea5a1fb5a5"}, "expires_at": "2019-03-12T16:19:23.000000Z", "methods": ["password"], "project": {"name": "admin", "domain": {"name": "Default", "id": "default"}, "id": "0ed98ec832f848bbb8146b4fe6070110"}, "catalog": [{"name": "cinder", "type": "volume", "endpoints": [{"interface": "public", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v1/0ed98ec832f848bbb8146b4fe6070110";, "id": "191e22cf410245c895b51ec60161b273", "region_id": "RegionOne"}, {"interface": "internal", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v1/0ed98ec832f848bbb8146b4fe6070110";, "id": "47d650a5e6fc4adc9e5408118484e878", "region_id": "RegionOne"}, {"interface": "admin", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v1/0ed98ec832f848bbb8146b4fe6070110";, "id": "6211b0a6000c4c3d8d20af141c62c542", "region_id": "RegionOne"}], "id": "1496ac366cf54ccfa34f0b74e6b5327b"}, {"name": "keystone", "type": "identity", "endpoints": [{"interface": "admin", "region": "RegionOne", "url": "http://185.21.196.179:35357";, "id": "458b1b0362c24847831390b5438c5273", "region_id": "RegionOne"}, {"interface": "internal", "region": "RegionOne", "url": "http://185.21.196.179:5000";, "id": "5fe62f4856434ec29fb57a8bc1a5c17b", "region_id": "RegionOne"}, {"interface": "public", "region": "RegionOne", "url": "http://185.21.196.179:5000";, "id": "f256f2dcbe8941bcab1cb5daacd08980", "region_id": "RegionOne"}], "id": "20e519cf86b44c6ab7dc9ff53ece9586"}, {"name": "cinderv2", "type": "volumev2", "endpoints": [{"interface": "public", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v2/0ed98ec832f848bbb8146b4fe6070110";, "id": "05dbc54e8ef247ffb4d5ceb5161c851c", "region_id": "RegionOne"}, {"interface": "internal", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v2/0ed98ec832f848bbb8146b4fe6070110";, "id": "638b4e4b382b4129889c83d8e8594c66", "region_id": "RegionOne"}, {"interface": "admin", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v2/0ed98ec832f848bbb8146b4fe6070110";, "id": "f183da1d224b408b849946fad60f2d16", "region_id": "RegionOne"}], "id": "5ab6dbf774cb45cd95be5980e1ad6187"}, {"name": "nova", "type": "compute", "endpoints": [{"interface": "admin", "region": "RegionOne", "url": "http://openstack-ctrl:8774/v2.1";, "id": "382d8910a9dc43678f9ac1ddf193d3d4", "region_id": "RegionOne"}, {"interface": "public", "region": "RegionOne", "url": "http://openstack-ctrl:8774/v2.1";, "id": "9782b188ba05407fb7203376f47fcccc", "region_id": "RegionOne"}, {"interface": "internal", "region": "RegionOne", "url": "http://openstack-ctrl:8774/v2.1";, "id": "e12d91ee2bb34b57ad42c7e3b9f02866", "region_id": "RegionOne"}], "id": "8cf4a0cd8cf2495eacb11d6415695fda"}, {"name": "glance", "type": "image", "endpoints": [{"interface": "admin", "region": "RegionOne", "url": "http://openstack-ctrl:9292";, "id": "51be68af2fa9484faae789dd56ebd23b", "region_id": "RegionOne"}, {"interface": "public", "region": "RegionOne", "url": "http://openstack-ctrl:9292";, "id": "8c0b02bf1f994a6aa2233e3e33940dae", "region_id": "RegionOne"}, {"interface": "internal", "region": "RegionOne", "url": "http://openstack-ctrl:9292";, "id": "bba6ebf69ede4c8eba1fdbdad55f4f22", "region_id": "RegionOne"}], "id": "8fe4d5dcb0204a5087adcd0073346bf3"}, {"name": "neutron", "type": "network", "endpoints": [{"interface": "public", "region": "RegionOne", "url": "http://openstack-ctrl:9696";, "id": "33d2e1ea0ebe4cfc87c59e4b27272378", "region_id": "RegionOne"}, {"interface": "internal", "region": "RegionOne", "url": "http://openstack-ctrl:9696";, "id": "4f07e2f4aec7493cae10f17395d46e8e", "region_id": "RegionOne"}, {"interface": "admin", "region": "RegionOne", "url": "http://openstack-ctrl:9696";, "id": "d9b51ba2d3634d5ea05f6b46f4613942", "region_id": "RegionOne"}], "id": "ce6f8812a4ef4b369d47eb87a89dc5b5"}, {"name": "cinderv3", "type": "volumev3", "endpoints": [{"interface": "internal", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v3/0ed98ec832f848bbb8146b4fe6070110";, "id": "0771b5102bfb4f48be67fbbe9f9ce2f7", "region_id": "RegionOne"}, {"interface": "admin", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v3/0ed98ec832f848bbb8146b4fe6070110";, "id": "7a648e58f3a64bf2a4d4c7eb343fa38e", "region_id": "RegionOne"}, {"interface": "public", "region": "RegionOne", "url": "http://openstack-ctrl:8776/v3/0ed98ec832f848bbb8146b4fe6070110";, "id": "eb7261817134450b8693fc58bbbae500", "region_id": "RegionOne"}], "id": "d4c68f82b820476e97d74391a6fd33af"}, {"name": "placement", "type": "placement", "endpoints": [{"interface": "public", "region": "RegionOne", "url": "http://openstack-ctrl:8778";, "id": "4867006d05004fe289aab41bfd5f4c8c", "region_id": "RegionOne"}, {"interface": "internal", "region": "RegionOne", "url": "http://openstack-ctrl:8778";, "id": "5df408799f99448890162c218172c6b2", "region_id": "RegionOne"}, {"interface": "admin", "region": "RegionOne", "url": "http://openstack-ctrl:8778";, "id": "cff60d89d851414392d6bfbf1fbd5c1e", "region_id": "RegionOne"}], "id": "f9f33557e82f4ea2a59039961d8dd697"}], "roles": [{"name": "rating", "id": "bddecdae15ba42d0b9218ed700364f6f"}, {"name": "KeystoneAdmin", "id": "146ab8e647474b3fa53e250f2a2858fe"}, {"name": "ResellerAdmin", "id": "1c3c5f787f0e4ff2834433a71a7de50f"}, {"name": "owner", "id": "d4b49337958f423589c233d2340ba71a"}, {"name": "service", "id": "0c68f680a8c441e5aaa6d8224b8c31ae"}, {"name": "reader", "id": "80c0d6badde1499fb2a273fdaf060658"}, {"name": "admin", "id": "55110b9ad0b54dba94f7f621536c6f80"}, {"name": "member", "id": "8c72aab03b71436e82f92da894eb063d"}, {"name": "heat_stack_owner", "id": "c7bd19ade07a465f80c3407143e7fa28"}, {"name": "KeystoneServiceAdmin", "id": "9e79266c095e49179dc465827351ed3a"}], "is_domain": false, "audit_ids": ["ugkxsdTcQ66b-7MS9yGp5A"], "issued_at": "2019-03-12T15:19:23.000000Z"}} REQ: curl -g -i -X POST http://openstack-ctrl:9696/v2.0/bgp-speakers -H "Accept: application/json" -H "Content-Type: application/json" -H "User-Agent: python-neutronclient" -H "X-Auth-Token: {SHA1}7767213b7aede6958380f93fe01ead564c501885" -d '{"bgp_speaker": {"name": "bgpspeaker", "local_as": "1234", "ip_version": 4}}' Starting new HTTP connection (1): openstack-ctrl http://openstack-ctrl:9696 "POST /v2.0/bgp-speakers HTTP/1.1" 500 None RESP: [500] Connection: close Content-Type: application/json x-openstack-request-id: req-f8d27b19-8b1f-45d4-8ab8-b419c9e655b1 RESP BODY: {"NeutronError": {"message": "Request Failed: internal server error while processing your request.", "type": "HTTPInternalServerError", "detail": ""}} POST call to network for http://openstack-ctrl:9696/v2.0/bgp-speakers used request id req-f8d27b19-8b1f-45d4-8ab8-b419c9e655b1 Error message: {"NeutronError": {"message": "Request Failed: internal server error while processing your request.", "type": "HTTPInternalServerError", "detail": ""}} Request Failed: internal server error while processing your request. Neutron server returns request_ids: ['req-f8d27b19-8b1f-45d4-8ab8-b419c9e655b1'] Traceback (most recent call last): File "/usr/lib/python3/dist-packages/cliff/app.py", line 400, in run_subcommand result = cmd.run(parsed_args) File "/usr/lib/python3/dist-packages/osc_lib/command/command.py", line 41, in run return super(Command, self).run(parsed_args) File "/usr/lib/python3/dist-packages/cliff/display.py", line 116, in run column_names, data = self.take_action(parsed_args) File "/usr/lib/python3/dist-packages/neutronclient/osc/v2/dynamic_routing/bgp_speaker.py", line 152, in take_action obj = client.create_bgp_speaker(body)[constants.BGP_SPEAKER] File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 2006, in create_bgp_speaker return self.post(self.bgp_speakers_path, body=body) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 359, in post headers=headers, params=params) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 294, in do_request self._handle_fault_response(status_code, replybody, resp) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 269, in _handle_fault_response exception_handler_v20(status_code, error_body) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 93, in exception_handler_v20 request_ids=request_ids) neutronclient.common.exceptions.InternalServerError: Request Failed: internal server error while processing your request. Neutron server returns request_ids: ['req-f8d27b19-8b1f-45d4-8ab8-b419c9e655b1'] clean_up CreateBgpSpeaker: Request Failed: internal server error while processing your request. Neutron server returns request_ids: ['req-f8d27b19-8b1f-45d4-8ab8-b419c9e655b1'] Traceback (most recent call last): File "/usr/lib/python3/dist-packages/osc_lib/shell.py", line 135, in run ret_val = super(OpenStackShell, self).run(argv) File "/usr/lib/python3/dist-packages/cliff/app.py", line 279, in run result = self.run_subcommand(remainder) File "/usr/lib/python3/dist-packages/osc_lib/shell.py", line 175, in run_subcommand ret_value = super(OpenStackShell, self).run_subcommand(argv) File "/usr/lib/python3/dist-packages/cliff/app.py", line 400, in run_subcommand result = cmd.run(parsed_args) File "/usr/lib/python3/dist-packages/osc_lib/command/command.py", line 41, in run return super(Command, self).run(parsed_args) File "/usr/lib/python3/dist-packages/cliff/display.py", line 116, in run column_names, data = self.take_action(parsed_args) File "/usr/lib/python3/dist-packages/neutronclient/osc/v2/dynamic_routing/bgp_speaker.py", line 152, in take_action obj = client.create_bgp_speaker(body)[constants.BGP_SPEAKER] File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 2006, in create_bgp_speaker return self.post(self.bgp_speakers_path, body=body) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 359, in post headers=headers, params=params) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 294, in do_request self._handle_fault_response(status_code, replybody, resp) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 269, in _handle_fault_response exception_handler_v20(status_code, error_body) File "/usr/lib/python3/dist-packages/neutronclient/v2_0/client.py", line 93, in exception_handler_v20 request_ids=request_ids) neutronclient.common.exceptions.InternalServerError: Request Failed: internal server error while processing your request. Neutron server returns request_ids: ['req-f8d27b19-8b1f-45d4-8ab8-b419c9e655b1'] END return value: 1 Current DB table bgp_speakers : MariaDB [neutron]> show create table bgp_speakers; +--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | bgp_speakers | CREATE TABLE `bgp_speakers` ( `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `local_as` int(11) NOT NULL, `ip_version` int(11) NOT NULL, `tenant_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `advertise_floating_ip_host_routes` tinyint(1) NOT NULL, `advertise_tenant_networks` tinyint(1) NOT NULL, PRIMARY KEY (`id`), KEY `ix_bgp_speakers_tenant_id` (`tenant_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci | +--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [neutron]> As you can see project_id not present in db, instead of , there is tenant_id. I think it is needed to do DB migration for this column and rename it. After alter table everything is working as expected. ALTER TABLE bgp_speakers CHANGE COLUMN tenant_id project_id varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL; ALTER TABLE bgp_peers CHANGE COLUMN tenant_id project_id varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL; Tested on rocky Thanks To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1819724/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
