yahoo-eng-team team mailing list archive

Thread
Date
[Bug 2100892] [NEW] nova-manage db sync fails: cannot drop index uuid because other objects depend on it

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Rafa <2100892@xxxxxxxxxxxxxxxxxx>
Date: Tue, 04 Mar 2025 19:15:41 -0000
Reply-to: Bug 2100892 <2100892@xxxxxxxxxxxxxxxxxx>
Sender: noreply@xxxxxxxxxxxxx
Public bug reported:

I´m trying to upgrade to Antelope and have a problem when executing the
db migrations. `nova-manage db sync` fails when upgrading from Zed to
Antelope (same for Yoga --> Antelope)

- Nova: 27.4.0
- Database: PostgreSQL 16
- Operating System: Ubuntu 22.04
- OpenStack Zed --> Antelope


Full Log. /var/log/nova-manage.log:
```
2025-03-04 11:42:14.963 2519974 INFO alembic.runtime.migration [None req-0e1f6874-3bac-49db-b525-94aebf9e0b51 - - - - - -] Context impl PostgresqlImpl.
2025-03-04 11:42:14.964 2519974 INFO alembic.runtime.migration [None req-0e1f6874-3bac-49db-b525-94aebf9e0b51 - - - - - -] Will assume transactional DDL.
2025-03-04 11:42:14.967 2519974 INFO alembic.runtime.migration [None req-0e1f6874-3bac-49db-b525-94aebf9e0b51 - - - - - -] Running upgrade ccb0fa1a2252 -> 960aac0e09ea, de-duplicate_indexes_in_instances__console_auth_tokens
2025-03-04 11:42:14.970 2519974 WARNING oslo_db.sqlalchemy.exc_filters [None req-0e1f6874-3bac-49db-b525-94aebf9e0b51 - - - - - -] DBAPIError exception wrapped.: psycopg2.errors.DependentObjectsStillExist: cannot drop index uuid because other objects depend on it
DETAIL:  constraint block_device_mapping_instance_uuid_fkey on table block_device_mapping depends on index uuid
constraint consoles_instance_uuid_fkey on table consoles depends on index uuid
constraint fixed_ips_instance_uuid_fkey on table fixed_ips depends on index uuid
constraint instance_actions_instance_uuid_fkey on table instance_actions depends on index uuid
constraint instance_extra_instance_uuid_fkey on table instance_extra depends on index uuid
constraint instance_faults_instance_uuid_fkey on table instance_faults depends on index uuid
constraint instance_info_caches_instance_uuid_fkey on table instance_info_caches depends on index uuid
constraint instance_metadata_instance_uuid_fkey on table instance_metadata depends on index uuid
constraint instance_system_metadata_instance_uuid_fkey on table instance_system_metadata depends on index uuid
constraint migrations_instance_uuid_fkey on table migrations depends on index uuid
constraint security_group_instance_association_instance_uuid_fkey on table security_group_instance_association depends on index uuid
constraint virtual_interfaces_instance_uuid_fkey on table virtual_interfaces depends on index uuid
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters     self.dialect.do_execute(
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters     cursor.execute(statement, parameters)
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters psycopg2.errors.DependentObjectsStillExist: cannot drop index uuid because other objects depend on it
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters DETAIL:  constraint block_device_mapping_instance_uuid_fkey on table block_device_mapping depends on index uuid
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint consoles_instance_uuid_fkey on table consoles depends on index uuid
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint fixed_ips_instance_uuid_fkey on table fixed_ips depends on index uuid
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint instance_actions_instance_uuid_fkey on table instance_actions depends on index uuid
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint instance_extra_instance_uuid_fkey on table instance_extra depends on index uuid
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint instance_faults_instance_uuid_fkey on table instance_faults depends on index uuid
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint instance_info_caches_instance_uuid_fkey on table instance_info_caches depends on index uuid
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint instance_metadata_instance_uuid_fkey on table instance_metadata depends on index uuid
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint instance_system_metadata_instance_uuid_fkey on table instance_system_metadata depends on index uuid
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint migrations_instance_uuid_fkey on table migrations depends on index uuid
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint security_group_instance_association_instance_uuid_fkey on table security_group_instance_association depends on index uuid
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint virtual_interfaces_instance_uuid_fkey on table virtual_interfaces depends on index uuid
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters HINT:  Use DROP ... CASCADE to drop the dependent objects too.
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters
2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters
```

** 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/2100892

Title:
  nova-manage db sync fails: cannot drop index uuid because other
  objects depend on it

Status in OpenStack Compute (nova):
  New

Bug description:
  I´m trying to upgrade to Antelope and have a problem when executing
  the db migrations. `nova-manage db sync` fails when upgrading from Zed
  to Antelope (same for Yoga --> Antelope)

  - Nova: 27.4.0
  - Database: PostgreSQL 16
  - Operating System: Ubuntu 22.04
  - OpenStack Zed --> Antelope

  
  Full Log. /var/log/nova-manage.log:
  ```
  2025-03-04 11:42:14.963 2519974 INFO alembic.runtime.migration [None req-0e1f6874-3bac-49db-b525-94aebf9e0b51 - - - - - -] Context impl PostgresqlImpl.
  2025-03-04 11:42:14.964 2519974 INFO alembic.runtime.migration [None req-0e1f6874-3bac-49db-b525-94aebf9e0b51 - - - - - -] Will assume transactional DDL.
  2025-03-04 11:42:14.967 2519974 INFO alembic.runtime.migration [None req-0e1f6874-3bac-49db-b525-94aebf9e0b51 - - - - - -] Running upgrade ccb0fa1a2252 -> 960aac0e09ea, de-duplicate_indexes_in_instances__console_auth_tokens
  2025-03-04 11:42:14.970 2519974 WARNING oslo_db.sqlalchemy.exc_filters [None req-0e1f6874-3bac-49db-b525-94aebf9e0b51 - - - - - -] DBAPIError exception wrapped.: psycopg2.errors.DependentObjectsStillExist: cannot drop index uuid because other objects depend on it
  DETAIL:  constraint block_device_mapping_instance_uuid_fkey on table block_device_mapping depends on index uuid
  constraint consoles_instance_uuid_fkey on table consoles depends on index uuid
  constraint fixed_ips_instance_uuid_fkey on table fixed_ips depends on index uuid
  constraint instance_actions_instance_uuid_fkey on table instance_actions depends on index uuid
  constraint instance_extra_instance_uuid_fkey on table instance_extra depends on index uuid
  constraint instance_faults_instance_uuid_fkey on table instance_faults depends on index uuid
  constraint instance_info_caches_instance_uuid_fkey on table instance_info_caches depends on index uuid
  constraint instance_metadata_instance_uuid_fkey on table instance_metadata depends on index uuid
  constraint instance_system_metadata_instance_uuid_fkey on table instance_system_metadata depends on index uuid
  constraint migrations_instance_uuid_fkey on table migrations depends on index uuid
  constraint security_group_instance_association_instance_uuid_fkey on table security_group_instance_association depends on index uuid
  constraint virtual_interfaces_instance_uuid_fkey on table virtual_interfaces depends on index uuid
  HINT:  Use DROP ... CASCADE to drop the dependent objects too.
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1802, in _execute_context
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters     self.dialect.do_execute(
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 732, in do_execute
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters     cursor.execute(statement, parameters)
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters psycopg2.errors.DependentObjectsStillExist: cannot drop index uuid because other objects depend on it
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters DETAIL:  constraint block_device_mapping_instance_uuid_fkey on table block_device_mapping depends on index uuid
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint consoles_instance_uuid_fkey on table consoles depends on index uuid
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint fixed_ips_instance_uuid_fkey on table fixed_ips depends on index uuid
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint instance_actions_instance_uuid_fkey on table instance_actions depends on index uuid
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint instance_extra_instance_uuid_fkey on table instance_extra depends on index uuid
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint instance_faults_instance_uuid_fkey on table instance_faults depends on index uuid
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint instance_info_caches_instance_uuid_fkey on table instance_info_caches depends on index uuid
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint instance_metadata_instance_uuid_fkey on table instance_metadata depends on index uuid
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint instance_system_metadata_instance_uuid_fkey on table instance_system_metadata depends on index uuid
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint migrations_instance_uuid_fkey on table migrations depends on index uuid
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint security_group_instance_association_instance_uuid_fkey on table security_group_instance_association depends on index uuid
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters constraint virtual_interfaces_instance_uuid_fkey on table virtual_interfaces depends on index uuid
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters HINT:  Use DROP ... CASCADE to drop the dependent objects too.
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters
  2025-03-04 11:42:14.970 2519974 ERROR oslo_db.sqlalchemy.exc_filters
  ```

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