Solum

solum app delete fails

Bug #1589365 reported by caowei
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Solum
New
Undecided
caowei

Bug Description

solumuser@ubuntu:/opt/stack/solum/examples/apps$ solum app delete java2_app
ERROR: More than one App by that name. Retry with the UUID.
solumuser@ubuntu:/opt/stack/solum/examples/apps$ solum app list
+-----------+--------------------------------------+---------------------+----------------+--------------+
| name | id | created_at | description | languagepack |
+-----------+--------------------------------------+---------------------+----------------+--------------+
| cherrypy | 8fec4b8b-3d15-45fb-8604-1235dc16e8bc | 2016-06-04T13:43:29 | python web app | python |
| java2_app | 3f5d2354-e88c-48a0-b317-cff96462cafa | 2016-06-06T03:29:31 | Java2 web app | java2 |
| java2_app | b11062cb-5c9a-4b2a-8e96-e5fa9c22e197 | 2016-06-06T04:32:12 | Java2 web app | java2 |
| java_app | c1b7437c-f3fb-4932-95ff-0dd2ca73f7dd | 2016-06-04T13:40:04 | Java web app | java |
+-----------+--------------------------------------+---------------------+----------------+--------------+
solumuser@ubuntu:/opt/stack/solum/examples/apps$ solum app delete 3f5d2354-e88c-48a0-b317-cff96462cafa
solumuser@ubuntu:/opt/stack/solum/examples/apps$ solum app delete b11062cb-5c9a-4b2a-8e96-e5fa9c22e197
solumuser@ubuntu:/opt/stack/solum/examples/apps$ solum app list
+-----------+--------------------------------------+---------------------+----------------+--------------+
| name | id | created_at | description | languagepack |
+-----------+--------------------------------------+---------------------+----------------+--------------+
| cherrypy | 8fec4b8b-3d15-45fb-8604-1235dc16e8bc | 2016-06-04T13:43:29 | python web app | python |
| java2_app | 3f5d2354-e88c-48a0-b317-cff96462cafa | 2016-06-06T03:29:31 | Java2 web app | java2 |
| java_app | c1b7437c-f3fb-4932-95ff-0dd2ca73f7dd | 2016-06-04T13:40:04 | Java web app | java |
+-----------+--------------------------------------+---------------------+----------------+--------------+

solum-deployer.log

2016-06-05 21:36:38.180 44615 DEBUG oslo_messaging._drivers.amqpdriver [-] received message with unique_id: e5d2973a03274a0fb515e9dd4204bd8c __call__ /usr/local/lib/python2.7/dist-packages/oslo_messaging/_drivers/amqpdriver.py:198

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server [-] Exception during handling message

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server Traceback (most recent call last):

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/rpc/server.py", line 133, in _process_incoming

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server res = self.dispatcher.dispatch(message)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/rpc/dispatcher.py", line 153, in dispatch

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server return self._do_dispatch(endpoint, method, ctxt, args)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/rpc/dispatcher.py", line 122, in _do_dispatch

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server result = func(ctxt, **new_args)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/opt/stack/solum/solum/deployer/handlers/heat.py", line 386, in destroy_app

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server objects.registry.Workflow.destroy(app_id)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/opt/stack/solum/solum/objects/sqlalchemy/models.py", line 49, in _wrapper

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server return fun(*args, **kwargs)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/opt/stack/solum/solum/objects/sqlalchemy/workflow.py", line 122, in destroy

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server session.query(plan.Plan).filter_by(id=plan_id).delete()

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3073, in delete

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server delete_op.exec_()

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 1127, in exec_

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server self._do_exec()

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 1311, in _do_exec

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server mapper=self.mapper)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1034, in execute

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server bind, close_with_result=True).execute(clause, params or {})

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server return meth(self, multiparams, params)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server return connection._execute_clauseelement(self, multiparams, params)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server compiled_sql, distilled_params

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server context)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server util.raise_from_cause(newraise, exc_info)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server reraise(type(exception), exception, tb=exc_tb, cause=cause)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server context)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server cursor.execute(statement, parameters)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 161, in execute

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server result = self._query(query)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 317, in _query

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server conn.query(q)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server self._affected_rows = self._read_query_result(unbuffered=unbuffered)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server result.read()

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server first_packet = self.connection._read_packet()

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server packet.check_error()

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server err.raise_mysql_exception(self._data)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server _check_mysql_exception(errinfo)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server raise errorclass(errno, errorvalue)

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server DBReferenceError: (pymysql.err.IntegrityError) (1451, u'Cannot delete or update a parent row: a foreign key constraint fails (`solum`.`assembly`, CONSTRAINT `assembly_ibfk_1` FOREIGN KEY (`plan_id`) REFERENCES `plan` (`id`))') [SQL: u'DELETE FROM plan WHERE plan.id = %(id_1)s'] [parameters: {u'id_1': u'3f5d2354-e88c-48a0-b317-cff96462cafa'}]

2016-06-05 21:36:38.196 44615 ERROR oslo_messaging.rpc.server

caowei (caowei-e)
Changed in solum:
assignee: nobody → caowei (caowei-e)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.