yahoo-eng-team team mailing list archive

Thread
Date
[Bug 2016397] Re: openstack quota set error and also no quota info in horizon

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Launchpad Bug Tracker <2016397@xxxxxxxxxxxxxxxxxx>
Date: Sun, 02 Jul 2023 04:17:13 -0000
Reply-to: Bug 2016397 <2016397@xxxxxxxxxxxxxxxxxx>
Sender: noreply@xxxxxxxxxxxxx
[Expired for OpenStack Compute (nova) because there has been no activity
for 60 days.]

** Changed in: nova
       Status: Incomplete => Expired

-- 
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):
  Expired

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
References

[Bug 2016397] [NEW] openstack quota set error and also no quota info in horizon
From: Khawar Nehal, 2023-04-15