Public bug reported: Found this when testing the v6 prefix delegation patch https://review.openstack.org/#/c/185977/ and trying to use the debug- probe.
Got a DB error when trying to create a port where the subnet id is passed in fixed ips. Note this subnet has "subnetpool_id": "prefix_delegation". vagrant@node1:~$ curl -s -X GET http://192.168.2.2:9696/v2.0/subnets/a524ad8d-644d-4f89-ade8-960dcbd8fb72.json -H "User-Agent: python-neutronclient" -H "Accept: application/json" -H "X-Auth-Token: 246cf05ad88843d0b4e76ae6dda6e6b6" | python -m json.tool { "subnet": { "allocation_pools": [ { "end": "2222:2222:2222:3c0f:ffff:ffff:ffff:ffff", "start": "2222:2222:2222:3c0f::2" } ], "cidr": "2222:2222:2222:3c0f::/64", "dns_nameservers": [], "enable_dhcp": true, "gateway_ip": "2222:2222:2222:3c0f::1", "host_routes": [], "id": "a524ad8d-644d-4f89-ade8-960dcbd8fb72", "ip_version": 6, "ipv6_address_mode": "slaac", "ipv6_ra_mode": "slaac", "name": "sub6", "network_id": "26c63522-375a-49e8-8d37-bc0124c53076", "subnetpool_id": "prefix_delegation", "tenant_id": "48560abddfec4170bfdb5f6ed79e2847" } } vagrant@node1:~$ neutron port-create 26c63522-375a-49e8-8d37-bc0124c53076 --fixed_ips list=true type=dict subnet_id=a524ad8d-644d-4f89-ade8-960dcbd8fb72 Request Failed: internal server error while processing your request. 2015-08-13 06:34:08.363 DEBUG neutron.db.db_base_plugin_common [req-bfcdb604-1491-4108-912e-b960b4329d5d admin admin] Allocated IP 2222:2222:2222:3c0f:f816:3eff:fe3b:91c7 (26c63522-375a-49e8-8d37-bc0124c53076/a524ad8d-644d-4f89-ade8-960dcbd8fb72/0879bbc4-d3d0-4b57-ae6a-382757bcb330) _store_ip_allocation /opt/stack/neutron/neutron/db/db_base_plugin_common.py:68 2015-08-13 06:34:08.363 DEBUG neutron.db.db_base_plugin_common [req-bfcdb604-1491-4108-912e-b960b4329d5d admin admin] Allocated IP 2222:2222:2222:3c0f:f816:3eff:fe3b:91c7 (26c63522-375a-49e8-8d37-bc0124c53076/a524ad8d-644d-4f89-ade8-960dcbd8fb72/0879bbc4-d3d0-4b57-ae6a-382757bcb330) _store_ip_allocation /opt/stack/neutron/neutron/db/db_base_plugin_common.py:68 2015-08-13 06:34:08.370 ERROR neutron.api.v2.resource [req-bfcdb604-1491-4108-912e-b960b4329d5d admin admin] create failed 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource Traceback (most recent call last): 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/opt/stack/neutron/neutron/api/v2/resource.py", line 83, in resource 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource result = method(request=request, **args) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 146, in wrapper 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource ectxt.value = e.inner_exc 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 119, in __exit__ 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 136, in wrapper 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource return f(*args, **kwargs) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/opt/stack/neutron/neutron/api/v2/base.py", line 486, in create 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource obj = obj_creator(request.context, **kwargs) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/opt/stack/neutron/neutron/plugins/ml2/plugin.py", line 998, in create_port 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource result, mech_context = self._create_port_db(context, port) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/opt/stack/neutron/neutron/plugins/ml2/plugin.py", line 973, in _create_port_db 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource result = super(Ml2Plugin, self).create_port(context, port) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/opt/stack/neutron/neutron/db/db_base_plugin_v2.py", line 1018, in create_port 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self.ipam.allocate_ips_for_port_and_store(context, port, port_id) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 490, in __exit__ 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self.rollback() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource compat.reraise(exc_type, exc_value, exc_tb) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 487, in __exit__ 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self.commit() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 392, in commit 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self._prepare_impl() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self.session.flush() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2004, in flush 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self._flush(objects) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2122, in _flush 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource transaction.rollback(_capture_exception=True) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource compat.reraise(exc_type, exc_value, exc_tb) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2086, in _flush 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource flush_context.execute() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource rec.execute(self) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource uow 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource mapper, table, insert) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 728, in _emit_insert_statements 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource execute(statement, multiparams) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource return meth(self, multiparams, params) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource return connection._execute_clauseelement(self, multiparams, params) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource compiled_sql, distilled_params 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource context) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource util.raise_from_cause(newraise, exc_info) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource reraise(type(exception), exception, tb=exc_tb) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1116, in _execute_context 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource context) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 95, in do_executemany 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource rowcount = cursor.executemany(statement, parameters) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 155, in executemany 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self._get_db().encoding) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 190, in _do_execute_many 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource rows += self.execute(sql + postfix) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 134, in execute 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource result = self._query(query) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 282, in _query 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource conn.query(q) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 768, in query 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self._affected_rows = self._read_query_result(unbuffered=unbuffered) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 929, in _read_query_result 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource result.read() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1125, in read 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource first_packet = self.connection._read_packet() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 893, in _read_packet 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource packet.check_error() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 369, in check_error 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource err.raise_mysql_exception(self._data) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource _check_mysql_exception(errinfo) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource raise errorclass(errno, errorvalue) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource DBDuplicateEntry: (pymysql.err.IntegrityError) (1062, u"Duplicate entry '2222:2222:2222:3c0f:f816:3eff:fe3b:91c7-a524ad8d-644d-4f89-ade8-' for key 'PRIMARY'") [SQL: u'INSERT INTO ipallocations (port_id, ip_address, subnet_id, network_id) VALUES (%s, %s, %s, %s)'] [parameters: (('0879bbc4-d3d0-4b57-ae6a-382757bcb330', '2222:2222:2222:3c0f:f816:3eff:fe3b:91c7', u'a524ad8d-644d-4f89-ade8-960dcbd8fb72', u'26c63522-375a-49e8-8d37-bc0124c53076'), ('0879bbc4-d3d0-4b57-ae6a-382757bcb330', '2222:2222:2222:3c0f:f816:3eff:fe3b:91c7', u'a524ad8d-644d-4f89-ade8-960dcbd8fb72', u'26c63522-375a-49e8-8d37-bc0124c53076'))] 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource 2015-08-13 06:34:08.475 INFO neutron.wsgi [req-bfcdb604-1491-4108-912e-b960b4329d5d admin admin] 192.168.2.2 - - [13/Aug/2015 06:34:08] "POST /v2.0/ports.json HTTP/1.1" 500 383 0.248965 Creating a port without specifying the subnet works: vagrant@node1:~$ neutron port-create 26c63522-375a-49e8-8d37-bc0124c53076 Created a new port: .... And creating a port when the subnet has a blank subnetpool_id works vagrant@node1:~$ neutron port-create private --fixed_ips list=true type=dict subnet_id=a397013b-0dd2-47c7-ac5d-4e05943373fc Created a new port: ... ** Affects: neutron Importance: Undecided Status: New ** Tags: l3-ipam-dhcp ** Tags added: l3-ipam-dhcp -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1484379 Title: Passing PD subnet_id in fixed_ips to port-create causes DBDuplicateEntry Status in neutron: New Bug description: Found this when testing the v6 prefix delegation patch https://review.openstack.org/#/c/185977/ and trying to use the debug- probe. Got a DB error when trying to create a port where the subnet id is passed in fixed ips. Note this subnet has "subnetpool_id": "prefix_delegation". vagrant@node1:~$ curl -s -X GET http://192.168.2.2:9696/v2.0/subnets/a524ad8d-644d-4f89-ade8-960dcbd8fb72.json -H "User-Agent: python-neutronclient" -H "Accept: application/json" -H "X-Auth-Token: 246cf05ad88843d0b4e76ae6dda6e6b6" | python -m json.tool { "subnet": { "allocation_pools": [ { "end": "2222:2222:2222:3c0f:ffff:ffff:ffff:ffff", "start": "2222:2222:2222:3c0f::2" } ], "cidr": "2222:2222:2222:3c0f::/64", "dns_nameservers": [], "enable_dhcp": true, "gateway_ip": "2222:2222:2222:3c0f::1", "host_routes": [], "id": "a524ad8d-644d-4f89-ade8-960dcbd8fb72", "ip_version": 6, "ipv6_address_mode": "slaac", "ipv6_ra_mode": "slaac", "name": "sub6", "network_id": "26c63522-375a-49e8-8d37-bc0124c53076", "subnetpool_id": "prefix_delegation", "tenant_id": "48560abddfec4170bfdb5f6ed79e2847" } } vagrant@node1:~$ neutron port-create 26c63522-375a-49e8-8d37-bc0124c53076 --fixed_ips list=true type=dict subnet_id=a524ad8d-644d-4f89-ade8-960dcbd8fb72 Request Failed: internal server error while processing your request. 2015-08-13 06:34:08.363 DEBUG neutron.db.db_base_plugin_common [req-bfcdb604-1491-4108-912e-b960b4329d5d admin admin] Allocated IP 2222:2222:2222:3c0f:f816:3eff:fe3b:91c7 (26c63522-375a-49e8-8d37-bc0124c53076/a524ad8d-644d-4f89-ade8-960dcbd8fb72/0879bbc4-d3d0-4b57-ae6a-382757bcb330) _store_ip_allocation /opt/stack/neutron/neutron/db/db_base_plugin_common.py:68 2015-08-13 06:34:08.363 DEBUG neutron.db.db_base_plugin_common [req-bfcdb604-1491-4108-912e-b960b4329d5d admin admin] Allocated IP 2222:2222:2222:3c0f:f816:3eff:fe3b:91c7 (26c63522-375a-49e8-8d37-bc0124c53076/a524ad8d-644d-4f89-ade8-960dcbd8fb72/0879bbc4-d3d0-4b57-ae6a-382757bcb330) _store_ip_allocation /opt/stack/neutron/neutron/db/db_base_plugin_common.py:68 2015-08-13 06:34:08.370 ERROR neutron.api.v2.resource [req-bfcdb604-1491-4108-912e-b960b4329d5d admin admin] create failed 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource Traceback (most recent call last): 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/opt/stack/neutron/neutron/api/v2/resource.py", line 83, in resource 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource result = method(request=request, **args) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 146, in wrapper 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource ectxt.value = e.inner_exc 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 119, in __exit__ 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 136, in wrapper 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource return f(*args, **kwargs) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/opt/stack/neutron/neutron/api/v2/base.py", line 486, in create 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource obj = obj_creator(request.context, **kwargs) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/opt/stack/neutron/neutron/plugins/ml2/plugin.py", line 998, in create_port 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource result, mech_context = self._create_port_db(context, port) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/opt/stack/neutron/neutron/plugins/ml2/plugin.py", line 973, in _create_port_db 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource result = super(Ml2Plugin, self).create_port(context, port) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/opt/stack/neutron/neutron/db/db_base_plugin_v2.py", line 1018, in create_port 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self.ipam.allocate_ips_for_port_and_store(context, port, port_id) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 490, in __exit__ 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self.rollback() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource compat.reraise(exc_type, exc_value, exc_tb) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 487, in __exit__ 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self.commit() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 392, in commit 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self._prepare_impl() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self.session.flush() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2004, in flush 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self._flush(objects) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2122, in _flush 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource transaction.rollback(_capture_exception=True) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource compat.reraise(exc_type, exc_value, exc_tb) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2086, in _flush 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource flush_context.execute() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource rec.execute(self) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource uow 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource mapper, table, insert) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 728, in _emit_insert_statements 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource execute(statement, multiparams) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource return meth(self, multiparams, params) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource return connection._execute_clauseelement(self, multiparams, params) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource compiled_sql, distilled_params 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource context) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource util.raise_from_cause(newraise, exc_info) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource reraise(type(exception), exception, tb=exc_tb) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1116, in _execute_context 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource context) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/dialects/mysql/mysqldb.py", line 95, in do_executemany 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource rowcount = cursor.executemany(statement, parameters) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 155, in executemany 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self._get_db().encoding) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 190, in _do_execute_many 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource rows += self.execute(sql + postfix) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 134, in execute 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource result = self._query(query) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 282, in _query 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource conn.query(q) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 768, in query 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource self._affected_rows = self._read_query_result(unbuffered=unbuffered) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 929, in _read_query_result 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource result.read() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1125, in read 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource first_packet = self.connection._read_packet() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 893, in _read_packet 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource packet.check_error() 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 369, in check_error 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource err.raise_mysql_exception(self._data) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource _check_mysql_exception(errinfo) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource raise errorclass(errno, errorvalue) 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource DBDuplicateEntry: (pymysql.err.IntegrityError) (1062, u"Duplicate entry '2222:2222:2222:3c0f:f816:3eff:fe3b:91c7-a524ad8d-644d-4f89-ade8-' for key 'PRIMARY'") [SQL: u'INSERT INTO ipallocations (port_id, ip_address, subnet_id, network_id) VALUES (%s, %s, %s, %s)'] [parameters: (('0879bbc4-d3d0-4b57-ae6a-382757bcb330', '2222:2222:2222:3c0f:f816:3eff:fe3b:91c7', u'a524ad8d-644d-4f89-ade8-960dcbd8fb72', u'26c63522-375a-49e8-8d37-bc0124c53076'), ('0879bbc4-d3d0-4b57-ae6a-382757bcb330', '2222:2222:2222:3c0f:f816:3eff:fe3b:91c7', u'a524ad8d-644d-4f89-ade8-960dcbd8fb72', u'26c63522-375a-49e8-8d37-bc0124c53076'))] 2015-08-13 06:34:08.370 8032 ERROR neutron.api.v2.resource 2015-08-13 06:34:08.475 INFO neutron.wsgi [req-bfcdb604-1491-4108-912e-b960b4329d5d admin admin] 192.168.2.2 - - [13/Aug/2015 06:34:08] "POST /v2.0/ports.json HTTP/1.1" 500 383 0.248965 Creating a port without specifying the subnet works: vagrant@node1:~$ neutron port-create 26c63522-375a-49e8-8d37-bc0124c53076 Created a new port: .... And creating a port when the subnet has a blank subnetpool_id works vagrant@node1:~$ neutron port-create private --fixed_ips list=true type=dict subnet_id=a397013b-0dd2-47c7-ac5d-4e05943373fc Created a new port: ... To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1484379/+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
