OpenStack Compute (nova)

openstack quota set error and also no quota info in horizon

Bug #2016397 reported by Khawar Nehal
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Compute (nova)
Expired
Undecided
Unassigned

Bug Description

openstack quota set --instances 5 Default

Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible.
<class 'sqlalchemy.exc.ProgrammingError'> (HTTP 500) (Request-ID: req-bbf4d179-d520-4a3b-aa49-9a7f4bfa113d)

Nova-api log

FROM quotas
WHERE quotas.project_id = %(project_id_1)s]
[parameters: {'project_id_1': 'default'}]
(Background on this error at: https://sqlalche.me/e/14/f405)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi Traceback (most recent call last):
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi self.dialect.do_execute(
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi cursor.execute(statement, parameters)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi result = self._query(query)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi conn.query(q)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi result.read()
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi first_packet = self.connection._read_packet()
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi packet.raise_for_error()
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi err.raise_mysql_exception(self._data)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi raise errorclass(errno, errval)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi pymysql.err.ProgrammingError: (1146, "Table 'nova_api.quotas' doesn't exist")
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi The above exception was the direct cause of the following exception:
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi Traceback (most recent call last):
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/nova/api/openstack/wsgi.py", line 664, in wrapped
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi return f(*args, **kwargs)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/nova/api/validation/__init__.py", line 110, in wrapper
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi return func(*args, **kwargs)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/nova/api/openstack/compute/quota_sets.py", line 170, in update
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi return self._update(req, id, body, [])
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/nova/api/validation/__init__.py", line 192, in wrapper
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi return func(*args, **kwargs)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/nova/api/validation/__init__.py", line 192, in wrapper
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi return func(*args, **kwargs)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/nova/api/openstack/compute/quota_sets.py", line 206, in _update
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi settable_quotas = QUOTAS.get_settable_quotas(context, project_id,
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/nova/quota.py", line 1059, in get_settable_quotas
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi return self._driver.get_settable_quotas(context, self._resources,
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/nova/quota.py", line 316, in get_settable_quotas
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi db_proj_quotas = objects.Quotas.get_all_by_project(context, project_id)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/nova/objects/quotas.py", line 432, in get_all_by_project
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi api_db_quotas_dict = cls._get_all_from_db_by_project(context,
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 1010, in wrapper
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi return fn(*args, **kwargs)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/nova/objects/quotas.py", line 115, in _get_all_from_db_by_project
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi rows = context.session.query(api_models.Quota).\
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 2773, in all
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi return self._iter().all()
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi result = self.session.execute(
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/session.py", line 1714, in execute
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi result = conn._execute_20(statement, params or {}, execution_options)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi return meth(self, args_10style, kwargs_10style, execution_options)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi return connection._execute_clauseelement(
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi ret = self._execute_context(
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi self._handle_dbapi_exception(
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 2122, in _handle_dbapi_exception
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi util.raise_(newraise, with_traceback=exc_info[2], from_=e)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi raise exception
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi self.dialect.do_execute(
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi cursor.execute(statement, parameters)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 163, in execute
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi result = self._query(query)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/cursors.py", line 321, in _query
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi conn.query(q)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 505, in query
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 724, in _read_query_result
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi result.read()
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 1069, in read
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi first_packet = self.connection._read_packet()
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/connections.py", line 676, in _read_packet
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi packet.raise_for_error()
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/protocol.py", line 223, in raise_for_error
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi err.raise_mysql_exception(self._data)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi File "/usr/lib/python3.9/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi raise errorclass(errno, errval)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'nova_api.quotas' doesn't exist")
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi [SQL: SELECT quotas.created_at AS quotas_created_at, quotas.updated_at AS quotas_updated_at, quotas.id AS quotas_id, quotas.project_id AS quotas_project_id, quotas.resource AS quotas_resource, quotas.hard_limit AS quotas_hard_limit
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi FROM quotas
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi WHERE quotas.project_id = %(project_id_1)s]
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi [parameters: {'project_id_1': 'default'}]
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi (Background on this error at: https://sqlalche.me/e/14/f405)
2023-04-16 04:22:06.087 5740 ERROR nova.api.openstack.wsgi
2023-04-16 04:22:06.090 5740 INFO nova.api.openstack.wsgi [None req-941c916b-d8b2-418c-a406-88752f0eda59 2181acbb5a16410cb49b938cc800f74a e9d6eeb527f345c78d51aa6b88ad252b - - default default] HTTP exception thrown: Unexpected API Error. Please report this at http://bugs.launchpad.net/nova/ and attach the Nova API log if possible.
<class 'sqlalchemy.exc.ProgrammingError'>
2023-04-16 04:22:06.091 5740 INFO nova.osapi_compute.wsgi.server [None req-941c916b-d8b2-418c-a406-88752f0eda59 2181acbb5a16410cb49b938cc800f74a e9d6eeb527f345c78d51aa6b88ad252b - - default default] 127.0.0.1 "PUT /v2.1/os-quota-sets/default HTTP/1.1" status: 500 len: 638 time: 0.3810115

Revision history for this message
Khawar Nehal (khawarnehal) wrote :
Revision history for this message
Artom Lifshitz (notartom) wrote :

The fact that the `quotas` table is missing is bizarre. Was this cloud upgraded from an old version? Is it possible that the table got accidentally deleted?

Changed in nova:
status: New → Incomplete
Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for OpenStack Compute (nova) because there has been no activity for 60 days.]

Changed in nova:
status: Incomplete → Expired
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.