[Bug 1902521] Re: Issue while deleting volume-type
Rajat Dhasmana
1902521 at bugs.launchpad.net
Tue Nov 3 07:17:07 UTC 2020
** Changed in: cinder (Ubuntu)
Status: New => Invalid
--
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to cinder in Ubuntu.
https://bugs.launchpad.net/bugs/1902521
Title:
Issue while deleting volume-type
Status in cinder package in Ubuntu:
Invalid
Bug description:
Observed below error while deleting volume-type after deleting all
volumes using this volume-type.
abcd at devstack:~/devstack$ cinder type-delete volume_type_normal
Delete for volume type volume_type_normal failed: The server has either erred or is incapable of performing the requested operation. (HTTP 500) (Request-ID: req-a1d7f2eb-ed5b-487f-b6c9-cceb64da2080)
ERROR: Unable to delete any of the specified types.
Observed below error in cinder-api.log
Oct 27 08:03:19 ERROR cinder.api.middleware.fault [req-d79c91ca-a191-4fce-b3cd-81c790b6aea9 req-a1d7f2eb-ed5b-487f-b6c9-cceb64da2080 admin admin] Caught error: <class 'sqlalchemy.exc.ProgrammingError'> (pymysql.err.ProgrammingError) (1146, "Table 'cinder.default_volume_types' doesn't exist")
Oct 27 08:03:19 [SQL: SELECT default_volume_types.created_at AS default_volume_types_created_at, default_volume_types.updated_at AS default_volume_types_updated_at, default_volume_types.deleted_at AS default_volume_types_deleted_at, default_volume_types.deleted AS default_volume_types_deleted, default_volume_types.volume_type_id AS default_volume_types_volume_type_id, default_volume_types.project_id AS default_volume_types_project_id
Oct 27 08:03:19 FROM default_volume_types
Oct 27 08:03:19 WHERE default_volume_types.deleted = false AND default_volume_types.volume_type_id = %(volume_type_id_1)s]
Oct 27 08:03:19 [parameters: {'volume_type_id_1': 'dccdfe2e-4044-4460-8d56-b51c943a987c'}]
Oct 27 08:03:19 (Background on this error at: http://sqlalche.me/e/13/f405): sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.default_volume_types' doesn't exist")
Oct 27 08:03:19 [SQL: SELECT default_volume_types.created_at AS default_volume_types_created_at, default_volume_types.updated_at AS default_volume_types_updated_at, default_volume_types.deleted_at AS default_volume_types_deleted_at, default_volume_types.deleted AS default_volume_types_deleted, default_volume_types.volume_type_id AS default_volume_types_volume_type_id, default_volume_types.project_id AS default_volume_types_project_id
Oct 27 08:03:19 FROM default_volume_types
Oct 27 08:03:19 WHERE default_volume_types.deleted = false AND default_volume_types.volume_type_id = %(volume_type_id_1)s]
Oct 27 08:03:19 [parameters: {'volume_type_id_1': 'dccdfe2e-4044-4460-8d56-b51c943a987c'}]
Oct 27 08:03:19 (Background on this error at: http://sqlalche.me/e/13/f405)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault Traceback (most recent call last):
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1278, in _execute_context
Oct 27 08:03:19 ERROR cinder.api.middleware.fault cursor, statement, parameters, context
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/default.py", line 593, in do_execute
Oct 27 08:03:19 ERROR cinder.api.middleware.fault cursor.execute(statement, parameters)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/cursors.py", line 163, in execute
Oct 27 08:03:19 ERROR cinder.api.middleware.fault result = self._query(query)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/cursors.py", line 321, in _query
Oct 27 08:03:19 ERROR cinder.api.middleware.fault conn.query(q)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 505, in query
Oct 27 08:03:19 ERROR cinder.api.middleware.fault self._affected_rows = self._read_query_result(unbuffered=unbuffered)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 724, in _read_query_result
Oct 27 08:03:19 ERROR cinder.api.middleware.fault result.read()
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 1069, in read
Oct 27 08:03:19 ERROR cinder.api.middleware.fault first_packet = self.connection._read_packet()
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 676, in _read_packet
Oct 27 08:03:19 ERROR cinder.api.middleware.fault packet.raise_for_error()
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/protocol.py", line 223, in raise_for_error
Oct 27 08:03:19 ERROR cinder.api.middleware.fault err.raise_mysql_exception(self._data)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
Oct 27 08:03:19 ERROR cinder.api.middleware.fault raise errorclass(errno, errval)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault pymysql.err.ProgrammingError: (1146, "Table 'cinder.default_volume_types' doesn't exist")
Oct 27 08:03:19 ERROR cinder.api.middleware.fault
Oct 27 08:03:19 ERROR cinder.api.middleware.fault The above exception was the direct cause of the following exception:
Oct 27 08:03:19 ERROR cinder.api.middleware.fault
Oct 27 08:03:19 ERROR cinder.api.middleware.fault Traceback (most recent call last):
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/opt/stack/cinder/cinder/api/middleware/fault.py", line 85, in __call__
Oct 27 08:03:19 ERROR cinder.api.middleware.fault return req.get_response(self.application)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/request.py", line 1314, in send
Oct 27 08:03:19 ERROR cinder.api.middleware.fault application, catch_exc_info=False)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/request.py", line 1278, in call_application
Oct 27 08:03:19 ERROR cinder.api.middleware.fault app_iter = application(self.environ, start_response)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/dec.py", line 143, in __call__
Oct 27 08:03:19 ERROR cinder.api.middleware.fault return resp(environ, start_response)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/dec.py", line 129, in __call__
Oct 27 08:03:19 ERROR cinder.api.middleware.fault resp = self.call_func(req, *args, **kw)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/dec.py", line 193, in call_func
Oct 27 08:03:19 ERROR cinder.api.middleware.fault return self.func(req, *args, **kwargs)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/osprofiler/web.py", line 112, in __call__
Oct 27 08:03:19 ERROR cinder.api.middleware.fault return request.get_response(self.application)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/request.py", line 1314, in send
Oct 27 08:03:19 ERROR cinder.api.middleware.fault application, catch_exc_info=False)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/request.py", line 1278, in call_application
Oct 27 08:03:19 ERROR cinder.api.middleware.fault app_iter = application(self.environ, start_response)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/dec.py", line 129, in __call__
Oct 27 08:03:19 ERROR cinder.api.middleware.fault resp = self.call_func(req, *args, **kw)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/dec.py", line 193, in call_func
Oct 27 08:03:19 ERROR cinder.api.middleware.fault return self.func(req, *args, **kwargs)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/keystonemiddleware/auth_token/__init__.py", line 341, in __call__
Oct 27 08:03:19 ERROR cinder.api.middleware.fault response = req.get_response(self._app)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/request.py", line 1314, in send
Oct 27 08:03:19 ERROR cinder.api.middleware.fault application, catch_exc_info=False)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/request.py", line 1278, in call_application
Oct 27 08:03:19 ERROR cinder.api.middleware.fault app_iter = application(self.environ, start_response)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/dec.py", line 143, in __call__
Oct 27 08:03:19 ERROR cinder.api.middleware.fault return resp(environ, start_response)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/dec.py", line 143, in __call__
Oct 27 08:03:19 ERROR cinder.api.middleware.fault return resp(environ, start_response)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/routes/middleware.py", line 141, in __call__
Oct 27 08:03:19 ERROR cinder.api.middleware.fault response = self.app(environ, start_response)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/dec.py", line 143, in __call__
Oct 27 08:03:19 ERROR cinder.api.middleware.fault return resp(environ, start_response)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/dec.py", line 129, in __call__
Oct 27 08:03:19 ERROR cinder.api.middleware.fault resp = self.call_func(req, *args, **kw)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/webob/dec.py", line 193, in call_func
Oct 27 08:03:19 ERROR cinder.api.middleware.fault return self.func(req, *args, **kwargs)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/opt/stack/cinder/cinder/api/openstack/wsgi.py", line 839, in __call__
Oct 27 08:03:19 ERROR cinder.api.middleware.fault content_type, body, accept)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/opt/stack/cinder/cinder/api/openstack/wsgi.py", line 899, in _process_stack
Oct 27 08:03:19 ERROR cinder.api.middleware.fault action_result = self.dispatch(meth, request, action_args)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/opt/stack/cinder/cinder/api/openstack/wsgi.py", line 994, in dispatch
Oct 27 08:03:19 ERROR cinder.api.middleware.fault return method(req=request, **action_args)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/opt/stack/cinder/cinder/api/contrib/types_manage.py", line 148, in _delete
Oct 27 08:03:19 ERROR cinder.api.middleware.fault volume_types.destroy(context, vol_type['id'])
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/opt/stack/cinder/cinder/volume/volume_types.py", line 121, in destroy
Oct 27 08:03:19 ERROR cinder.api.middleware.fault context.elevated(), id)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/opt/stack/cinder/cinder/db/api.py", line 732, in get_all_projects_with_default_type
Oct 27 08:03:19 ERROR cinder.api.middleware.fault return IMPL.get_all_projects_with_default_type(context, volume_type_id)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/opt/stack/cinder/cinder/db/sqlalchemy/api.py", line 4356, in get_all_projects_with_default_type
Oct 27 08:03:19 ERROR cinder.api.middleware.fault filter_by(volume_type_id=volume_type_id).all()
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/orm/query.py", line 3341, in all
Oct 27 08:03:19 ERROR cinder.api.middleware.fault return list(self)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/orm/query.py", line 3503, in __iter__
Oct 27 08:03:19 ERROR cinder.api.middleware.fault return self._execute_and_instances(context)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/orm/query.py", line 3528, in _execute_and_instances
Oct 27 08:03:19 ERROR cinder.api.middleware.fault result = conn.execute(querycontext.statement, self._params)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1014, in execute
Oct 27 08:03:19 ERROR cinder.api.middleware.fault return meth(self, multiparams, params)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
Oct 27 08:03:19 ERROR cinder.api.middleware.fault return connection._execute_clauseelement(self, multiparams, params)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1133, in _execute_clauseelement
Oct 27 08:03:19 ERROR cinder.api.middleware.fault distilled_params,
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1318, in _execute_context
Oct 27 08:03:19 ERROR cinder.api.middleware.fault e, statement, parameters, cursor, context
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1509, in _handle_dbapi_exception
Oct 27 08:03:19 ERROR cinder.api.middleware.fault util.raise_(newraise, with_traceback=exc_info[2], from_=e)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/util/compat.py", line 178, in raise_
Oct 27 08:03:19 ERROR cinder.api.middleware.fault raise exception
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/base.py", line 1278, in _execute_context
Oct 27 08:03:19 ERROR cinder.api.middleware.fault cursor, statement, parameters, context
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/sqlalchemy/engine/default.py", line 593, in do_execute
Oct 27 08:03:19 ERROR cinder.api.middleware.fault cursor.execute(statement, parameters)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/cursors.py", line 163, in execute
Oct 27 08:03:19 ERROR cinder.api.middleware.fault result = self._query(query)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/cursors.py", line 321, in _query
Oct 27 08:03:19 ERROR cinder.api.middleware.fault conn.query(q)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 505, in query
Oct 27 08:03:19 ERROR cinder.api.middleware.fault self._affected_rows = self._read_query_result(unbuffered=unbuffered)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 724, in _read_query_result
Oct 27 08:03:19 ERROR cinder.api.middleware.fault result.read()
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 1069, in read
Oct 27 08:03:19 ERROR cinder.api.middleware.fault first_packet = self.connection._read_packet()
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/connections.py", line 676, in _read_packet
Oct 27 08:03:19 ERROR cinder.api.middleware.fault packet.raise_for_error()
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/protocol.py", line 223, in raise_for_error
Oct 27 08:03:19 ERROR cinder.api.middleware.fault err.raise_mysql_exception(self._data)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault File "/usr/local/lib/python3.6/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
Oct 27 08:03:19 ERROR cinder.api.middleware.fault raise errorclass(errno, errval)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'cinder.default_volume_types' doesn't exist")
Oct 27 08:03:19 ERROR cinder.api.middleware.fault [SQL: SELECT default_volume_types.created_at AS default_volume_types_created_at, default_volume_types.updated_at AS default_volume_types_updated_at, default_volume_types.deleted_at AS default_volume_types_deleted_at, default_volume_types.deleted AS default_volume_types_deleted, default_volume_types.volume_type_id AS default_volume_types_volume_type_id, default_volume_types.project_id AS default_volume_types_project_id
Oct 27 08:03:19 ERROR cinder.api.middleware.fault FROM default_volume_types
Oct 27 08:03:19 ERROR cinder.api.middleware.fault WHERE default_volume_types.deleted = false AND default_volume_types.volume_type_id = %(volume_type_id_1)s]
Oct 27 08:03:19 ERROR cinder.api.middleware.fault [parameters: {'volume_type_id_1': 'dccdfe2e-4044-4460-8d56-b51c943a987c'}]
Oct 27 08:03:19 ERROR cinder.api.middleware.fault (Background on this error at: http://sqlalche.me/e/13/f405)
Oct 27 08:03:19 ERROR cinder.api.middleware.fault
Oct 27 08:03:19 INFO cinder.api.middleware.fault [req-d79c91ca-a191-4fce-b3cd-81c790b6aea9 req-a1d7f2eb-ed5b-487f-b6c9-cceb64da2080 admin admin] http://192.168.126.5/volume/v3/a4d065d7f7f44922825054234698b130/types/dccdfe2e-4044-4460-8d56-b51c943a987c returned with HTTP f405
Oct 27 08:03:19 [pid: 23712|app: 0|req: 4/8] 192.168.126.5 () {64 vars in 1480 bytes} [Tue Oct 27 08:03:19 2020] DELETE /volume/v3/a4d065d7f7f44922825054234698b130/types/dccdfe2e-4044-4460-8d56-b51c943a987c => generated 128 bytes in 132 msecs (HTTP/1.1 500) 7 headers in 304 bytes (1 switches on core 0)
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/cinder/+bug/1902521/+subscriptions
More information about the Ubuntu-openstack-bugs
mailing list