yahoo-eng-team team mailing list archive
-
yahoo-eng-team team
-
Mailing list archive
-
Message #77454
[Bug 1819724] [NEW] Database inconsistency in neutron.bgp_speakers
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
Follow ups
