Error when attempted to create secutity groups in more then one thread.
full log: http://logs.openstack.org/33/144633/45/check/gate-rally-dsvm-neutron-rally/0ed9492/logs/
ERROR neutron.api.v2.resource [req-f211be5c-0c2e-42d7-86e4-773a299f3e03 ctx_rally_08bdcaef529f4ebc8b24263106e2e2ff_user_1 ctx_rally_1e92a94e-1a15-47f3-84ab-e656556d2567_tenant_1] create failed
Traceback (most recent call last):
File "/opt/stack/new/neutron/neutron/api/v2/resource.py", line 83, in resource
result = method(request=request, **args)
File "/opt/stack/new/neutron/neutron/api/v2/base.py", line 452, in create
obj = obj_creator(request.context, **kwargs)
File "/opt/stack/new/neutron/neutron/db/securitygroups_db.py", line 127, in create_security_group
self._ensure_default_security_group(context, tenant_id)
File "/opt/stack/new/neutron/neutron/db/securitygroups_db.py", line 536, in _ensure_default_security_group
default_sg=True)
File "/opt/stack/new/neutron/neutron/db/securitygroups_db.py", line 156, in create_security_group
context.session.add(egress_rule)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 470, in __exit__
self.rollback()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 467, in __exit__
self.commit()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 377, in commit
self._prepare_impl()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 357, in _prepare_impl
self.session.flush()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1919, in flush
self._flush(objects)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2037, in _flush
transaction.rollback(_capture_exception=True)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2001, in _flush
flush_context.execute()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 372, in execute
rec.execute(self)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 526, in execute
uow
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 65, in save_obj
mapper, table, insert)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 570, in _emit_insert_statements
execute(statement, multiparams)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 729, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1155, in _handle_dbapi_exception
util.raise_from_cause(newraise, exc_info)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 436, in do_execute
cursor.execute(statement, parameters)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
DBDuplicateEntry: (IntegrityError) (1062, "Duplicate entry '08bdcaef529f4ebc8b24263106e2e2ff' for key 'PRIMARY'") 'INSERT INTO default_security_group (tenant_id, security_group_id) VALUES (%s, %s)' ('08bdcaef529f4ebc8b24263106e2e2ff', '23327aad-6c5b-40c0-8069-2401e09893d1')
This error points out that more than one default security group is trying to be created in one tenant. Having more than one default security group in one tenant is not allowed, for this goal was created default_ security_ group table. Please, give some more information how do you get this error.