[Bug 1902521] Re: Issue while deleting volume-type
Rajat Dhasmana
1902521 at bugs.launchpad.net
Mon Nov 2 13:35:44 UTC 2020
Hi,
I see one error line[1] that seems strange for an actual deployment,
most probably you're running this with devstack and didn't run the stack
script instead used git pull and cinder service restart to update your
code in existing deployed system.
This should be fixed by running ``cinder-manage db sync`` command (which
is always run when we upgrade to a new version).
If the above isn't true, let me know your deployment type and also are
you trying to delete the ``default_volume_type`` set in cinder.conf or
the last volume type in the deployment (these cases seems unlikely
seeing the error msg)
[1] 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")
--
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:
New
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