Public bug reported:
Observed below error while deleting volume-type after deleting all
volumes using this volume-type.
abcd@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)
** Affects: cinder (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1902521
Title:
Issue while deleting volume-type
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/cinder/+bug/1902521/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
