Rally

  1. Bug #1568344
  2. Activity log

Activity log for bug #1568344

Date Who What changed Old value New value Message
2016-04-09 17:31:47 amir gohar bug added bug
2016-04-11 06:41:53 amir gohar tags delete deployment mysql
2016-04-11 06:42:21 amir gohar description Rally 0.3.3 Steps t reproduce: 1- Add a deployment 2- run a task 3- delete a deployment it will fail with following trace: webv2_1 | api.Deployment.destroy(uuid) webv2_1 | File "/usr/local/lib/python2.7/site-packages/rally/api.py", line 93, in destroy webv2_1 | deployment.delete() webv2_1 | File "/usr/local/lib/python2.7/site-packages/rally/common/objects/deploy.py", line 94, in delete webv2_1 | db.deployment_delete(self.deployment["uuid"]) webv2_1 | File "/usr/local/lib/python2.7/site-packages/rally/common/db/api.py", line 234, in deployment_delete webv2_1 | return get_impl().deployment_delete(uuid) webv2_1 | File "/usr/local/lib/python2.7/site-packages/rally/common/db/sqlalchemy/api.py", line 310, in deployment_delete webv2_1 | filter_by(uuid=uuid).delete(synchronize_session=False)) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3048, in delete webv2_1 | delete_op.exec_() webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 1127, in exec_ webv2_1 | self._do_exec() webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 1311, in _do_exec webv2_1 | mapper=self.mapper) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1034, in execute webv2_1 | bind, close_with_result=True).execute(clause, params or {}) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute webv2_1 | return meth(self, multiparams, params) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection webv2_1 | return connection._execute_clauseelement(self, multiparams, params) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement webv2_1 | compiled_sql, distilled_params webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context webv2_1 | context) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception webv2_1 | util.raise_from_cause(newraise, exc_info) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause webv2_1 | reraise(type(exception), exception, tb=exc_tb, cause=cause) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context webv2_1 | context) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute webv2_1 | cursor.execute(statement, parameters) webv2_1 | File "/usr/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute webv2_1 | self.errorhandler(self, exc, value) webv2_1 | File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler webv2_1 | raise errorclass, errorvalue webv2_1 | DBReferenceError: (_mysql_exceptions.IntegrityError) (1451, 'Cannot delete or update a parent row: a foreign key constraint fails (`rally`.`tasks`, CONSTRAINT `tasks_ibfk_1` FOREIGN KEY (`deployment_uuid`) REFERENCES `deployments` (`uuid`))') [SQL: u'DELETE FROM deployments WHERE deployments.uuid = %s'] [parameters: ('e41071a8-5d75-4709-ad0a-f1ca00cf9026',)] Rally 0.3.3 Steps t reproduce: 1- Add a deployment 2- run a task 3- delete a deployment this only happens in mysql...it works fine with sqllitedb it will fail with following trace: webv2_1 | api.Deployment.destroy(uuid) webv2_1 | File "/usr/local/lib/python2.7/site-packages/rally/api.py", line 93, in destroy webv2_1 | deployment.delete() webv2_1 | File "/usr/local/lib/python2.7/site-packages/rally/common/objects/deploy.py", line 94, in delete webv2_1 | db.deployment_delete(self.deployment["uuid"]) webv2_1 | File "/usr/local/lib/python2.7/site-packages/rally/common/db/api.py", line 234, in deployment_delete webv2_1 | return get_impl().deployment_delete(uuid) webv2_1 | File "/usr/local/lib/python2.7/site-packages/rally/common/db/sqlalchemy/api.py", line 310, in deployment_delete webv2_1 | filter_by(uuid=uuid).delete(synchronize_session=False)) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 3048, in delete webv2_1 | delete_op.exec_() webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 1127, in exec_ webv2_1 | self._do_exec() webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 1311, in _do_exec webv2_1 | mapper=self.mapper) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/orm/session.py", line 1034, in execute webv2_1 | bind, close_with_result=True).execute(clause, params or {}) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute webv2_1 | return meth(self, multiparams, params) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection webv2_1 | return connection._execute_clauseelement(self, multiparams, params) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement webv2_1 | compiled_sql, distilled_params webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context webv2_1 | context) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception webv2_1 | util.raise_from_cause(newraise, exc_info) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause webv2_1 | reraise(type(exception), exception, tb=exc_tb, cause=cause) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context webv2_1 | context) webv2_1 | File "/usr/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute webv2_1 | cursor.execute(statement, parameters) webv2_1 | File "/usr/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute webv2_1 | self.errorhandler(self, exc, value) webv2_1 | File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler webv2_1 | raise errorclass, errorvalue webv2_1 | DBReferenceError: (_mysql_exceptions.IntegrityError) (1451, 'Cannot delete or update a parent row: a foreign key constraint fails (`rally`.`tasks`, CONSTRAINT `tasks_ibfk_1` FOREIGN KEY (`deployment_uuid`) REFERENCES `deployments` (`uuid`))') [SQL: u'DELETE FROM deployments WHERE deployments.uuid = %s'] [parameters: ('e41071a8-5d75-4709-ad0a-f1ca00cf9026',)]
2016-04-11 11:46:04 Rodion Promyshlennikov rally: assignee Rodion Promyshlennikov (rpromyshlennikov)
2016-04-11 15:31:03 Rodion Promyshlennikov rally: status New Confirmed
2016-04-11 19:09:20 Rodion Promyshlennikov rally: status Confirmed In Progress
2016-05-30 13:26:01 Tom Patzig bug added subscriber Tom Patzig