Sorry @sahid-ferdjaoui I missed your questions:


Re: Package version where we hitted the bug:


ubuntu@juju-45ee93-2-lxd-2:~$ dpkg -s nova-common
Package: nova-common
Status: install ok installed
Priority: extra
Section: net
Installed-Size: 505
Maintainer: Ubuntu Developers <email address hidden>
Architecture: all
Source: nova
Version: 2:19.0.0-0ubuntu2~cloud0
Replaces: nova-ajax-console-proxy (<< 2:18.0.0~b2-0ubuntu3~), nova-api (<< 2:18.0.0~b2-0ubuntu3~), nova-api-metadata (<< 2:18.0.0~b2-0ubuntu3~), nova-api-os-compute (<< 2:18.0.0~b2-0ubuntu3~), nova-cells (<< 2:18.0.0~b2-0ubuntu3~), nova-compute (<< 2:18.0.0~b2-0ubuntu3~), nova-compute-libvirt (<< 2:18.0.0~b2-0ubuntu3~), nova-compute-vmware (<< 2:18.0.0~b2-0ubuntu3~), nova-conductor (<< 2:18.0.0~b2-0ubuntu3~), nova-console (<< 2:18.0.0~b2-0ubuntu3~), nova-consoleauth (<< 2:18.0.0~b2-0ubuntu3~), nova-network (<< 2:18.0.0~b2-0ubuntu3~), nova-novncproxy (<< 2:18.0.0~b2-0ubuntu3~), nova-placement-api (<< 2:18.0.0~b2-0ubuntu3~), nova-scheduler (<< 2:18.0.0~b2-0ubuntu3~), nova-serialproxy (<< 2:18.0.0~b2-0ubuntu3~), nova-spiceproxy (<< 2:18.0.0~b2-0ubuntu3~), nova-xvpvncproxy (<< 2:18.0.0~b2-0ubuntu3~), python-nova (<< 2:18.0.0-0ubuntu2~)
Depends: adduser
Breaks: nova-ajax-console-proxy (<< 2:18.0.0~b2-0ubuntu3~), nova-api (<< 2:18.0.0~b2-0ubuntu3~), nova-api-metadata (<< 2:18.0.0~b2-0ubuntu3~), nova-api-os-compute (<< 2:18.0.0~b2-0ubuntu3~), nova-cells (<< 2:18.0.0~b2-0ubuntu3~), nova-compute (<< 2:18.0.0~b2-0ubuntu3~), nova-compute-libvirt (<< 2:18.0.0~b2-0ubuntu3~), nova-compute-vmware (<< 2:18.0.0~b2-0ubuntu3~), nova-conductor (<< 2:18.0.0~b2-0ubuntu3~), nova-console (<< 2:18.0.0~b2-0ubuntu3~), nova-consoleauth (<< 2:18.0.0~b2-0ubuntu3~), nova-network (<< 2:18.0.0~b2-0ubuntu3~), nova-novncproxy (<< 2:18.0.0~b2-0ubuntu3~), nova-placement-api (<< 2:18.0.0~b2-0ubuntu3~), nova-scheduler (<< 2:18.0.0~b2-0ubuntu3~), nova-serialproxy (<< 2:18.0.0~b2-0ubuntu3~), nova-spiceproxy (<< 2:18.0.0~b2-0ubuntu3~), nova-xvpvncproxy (<< 2:18.0.0~b2-0ubuntu3~), python-nova (<< 2:18.0.0-0ubuntu2~)
Conffiles:
 /etc/logrotate.d/nova-common c8b4e3ac8388c4395b7fb8af33068753
 /etc/nova/api-paste.ini adfc3bc985a189b27e45b7be66d1a296
 /etc/nova/logging.conf dd4cdd10a6db5e711c519067603dcec2
 /etc/nova/nova.conf 0473e0723f12e4b51c44fb3209ca0a35
 /etc/nova/rootwrap.conf 90396580aced374b1ac7e25b49a68bb1
 /etc/nova/rootwrap.d/api-metadata.filters 973935718801ea5e303bf167809b66f2
 /etc/nova/rootwrap.d/compute.filters 6b66ceadead04371d5437e3e11407851
 /etc/nova/rootwrap.d/network.filters 58e5367d0ed714b5780be81f7a004bb5
 /etc/sudoers.d/nova_sudoers e06b72d1c3653b1eca9747f8423a1d16
Description: OpenStack Compute - common files
 OpenStack is a reliable cloud infrastructure. Its mission is to produce
 the ubiquitous cloud computing platform that will meet the needs of public
 and private cloud providers regardless of size, by being simple to implement
 and massively scalable.
 .
 OpenStack Compute, codenamed Nova, is a cloud computing fabric controller. In
 addition to its "native" API (the OpenStack API), it also supports the Amazon
 EC2 API.
 .
 Nova is intended to be modular and easy to extend and adapt. It supports many
 different hypervisors (KVM and Xen to name a few), different database backends
 (SQLite, MySQL, and PostgreSQL, for instance), different types of user
 databases (LDAP or SQL), etc.
 .
 This package contains things that are needed by all parts of Nova.
Homepage: https://launchpad.net/nova
Original-Maintainer: Openstack Maintainers <email address hidden>


Then, after install the python3 mysql package I think this is the expected results:


root@juju-45ee93-2-lxd-2:/home/ubuntu# nova-manage db online_data_migrations
Deprecated: Option "logdir" from group "DEFAULT" is deprecated. Use option "log-dir" from group "DEFAULT".
Running batches of 50 until complete
10 rows matched query fill_virtual_interface_list, 0 migrated
8 rows matched query populate_user_id, 8 migrated
+---------------------------------------------+--------------+-----------+
|                  Migration                  | Total Needed | Completed |
+---------------------------------------------+--------------+-----------+
|         create_incomplete_consumers         |      0       |     0     |
| delete_build_requests_with_no_instance_uuid |      0       |     0     |
|         fill_virtual_interface_list         |      10      |     0     |
|             migrate_empty_ratio             |      0       |     0     |
|          migrate_keypairs_to_api_db         |      0       |     0     |
|       migrate_quota_classes_to_api_db       |      0       |     0     |
|        migrate_quota_limits_to_api_db       |      0       |     0     |
|          migration_migrate_to_uuid          |      0       |     0     |
|     populate_missing_availability_zones     |      0       |     0     |
|          populate_queued_for_delete         |      0       |     0     |
|               populate_user_id              |      8       |     8     |
|                populate_uuids               |      0       |     0     |
|     service_uuids_online_data_migration     |      0       |     0     |
+---------------------------------------------+--------------+-----------+


Then...

root@juju-45ee93-2-lxd-2:/home/ubuntu# nova-manage db sync
Deprecated: Option "logdir" from group "DEFAULT" is deprecated. Use option "log-dir" from group "DEFAULT".
root@juju-45ee93-2-lxd-2:/home/ubuntu# nova-manage db online_data_migrations
Deprecated: Option "logdir" from group "DEFAULT" is deprecated. Use option "log-dir" from group "DEFAULT".
Running batches of 50 until complete
+---------------------------------------------+--------------+-----------+
|                  Migration                  | Total Needed | Completed |
+---------------------------------------------+--------------+-----------+
|         create_incomplete_consumers         |      0       |     0     |
| delete_build_requests_with_no_instance_uuid |      0       |     0     |
|         fill_virtual_interface_list         |      0       |     0     |
|             migrate_empty_ratio             |      0       |     0     |
|          migrate_keypairs_to_api_db         |      0       |     0     |
|       migrate_quota_classes_to_api_db       |      0       |     0     |
|        migrate_quota_limits_to_api_db       |      0       |     0     |
|          migration_migrate_to_uuid          |      0       |     0     |
|     populate_missing_availability_zones     |      0       |     0     |
|          populate_queued_for_delete         |      0       |     0     |
|               populate_user_id              |      0       |     0     |
|                populate_uuids               |      0       |     0     |
|     service_uuids_online_data_migration     |      0       |     0     |
+---------------------------------------------+--------------+-----------+

Thanks for the hint, the bug is resolved after install the library.