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