yahoo-eng-team team mailing list archive
-
yahoo-eng-team team
-
Mailing list archive
-
Message #91728
[Bug 2016397] [NEW] openstack quota set error and also no quota info in horizon
Public bug reported:
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
** Affects: nova
Importance: Undecided
Status: New
** Attachment added: "sos nova report"
https://bugs.launchpad.net/bugs/2016397/+attachment/5664328/+files/sosreport-localhost-2023-04-16-lcwgfbt.tar.xz
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/2016397
Title:
openstack quota set error and also no quota info in horizon
Status in OpenStack Compute (nova):
New
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
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/2016397/+subscriptions
Follow ups