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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
