Nova does not yet use alembic so it is interesting to see that the code
in your environment refers to the 'alembic_version' table. Could you
please check that the nova.conf on the machine that you use to run the
nova-manage command has a proper [database]connection and
[api_database]connection configuration?

I'm marking this as INVALID now as it is either a configuration issue or
a DB inconsistency created outside of nova. Feel free to set it back to
New if you disagree and has additional information.

** Changed in: nova
       Status: New => Invalid

-- 
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/1938633

Title:
  executing nova db purge command to purge records but getting keyError

Status in OpenStack Compute (nova):
  Invalid

Bug description:
  /usr/bin/nova-manage db archive_deleted_rows --purge --before
  "2021-07-18 13:32:23.310897"

  An error has occurred:
  Traceback (most recent call last):
    File "/usr/lib/python3.6/site-packages/nova/cmd/manage.py", line 2797, in 
main
      ret = fn(*fn_args, **fn_kwargs)
    File "/usr/lib/python3.6/site-packages/nova/cmd/manage.py", line 321, in 
archive_deleted_rows
      cell_name)
    File "/usr/lib/python3.6/site-packages/nova/cmd/manage.py", line 375, in 
_do_archive
      db.archive_deleted_rows(cctxt, max_rows, before=before_date)
    File "/usr/lib/python3.6/site-packages/nova/db/api.py", line 1313, in 
archive_deleted_rows
      before=before)
    File "/usr/lib/python3.6/site-packages/nova/db/sqlalchemy/api.py", line 
4335, in archive_deleted_rows
      before=before))
    File "/usr/lib/python3.6/site-packages/nova/db/sqlalchemy/api.py", line 
4204, in _archive_deleted_rows_for_table
      table = models.BASE.metadata.tables[tablename]
  KeyError: 'alembic_version'

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1938633/+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

Reply via email to