yahoo-eng-team team mailing list archive

[masterpe <1929563@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

We are using Openstack Train

When using the command

./nova-manage db archive_deleted_rows --all-cells --verbose --before
2021-05-01 --max_rows 1000 --purge

This run takes 19 minutes, without the --before option, this command
gets down to seconds.

It turns out when I look into the indexes of the tables I'm missing a
index on the deleted_at column.

For example when I use the SQL command:
SHOW INDEX FROM nova.instances;
I'm missing the index.

** Affects: nova
     Importance: Undecided
         Status: New

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

Title:
  Missing database index deleted_at column

Status in OpenStack Compute (nova):
  New

Bug description:
  We are using Openstack Train

  When using the command

  ./nova-manage db archive_deleted_rows --all-cells --verbose --before
  2021-05-01 --max_rows 1000 --purge

  This run takes 19 minutes, without the --before option, this command
  gets down to seconds.

  It turns out when I look into the indexes of the tables I'm missing a
  index on the deleted_at column.

  For example when I use the SQL command:
  SHOW INDEX FROM nova.instances;
  I'm missing the index.

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1929563/+subscriptions