Comment 4 for bug 2008716

I was not able to reproduce this issue in a local devstack using stable/yoga at 273831716780090677215ba70168bb74a2dae814:

$ cat bug-2008716-nova.conf
[api_database]
connection = mysql+pymysql://root:a@127.0.0.1/nova_api_2008716?charset=utf8

mysql> drop database nova_api_2008716;
Query OK, 32 rows affected (0.21 sec)

mysql> create database nova_api_2008716;
Query OK, 1 row affected (0.01 sec)

mysql> quit;
Bye

$ nova-manage --config-file bug-2008716-nova.conf api_db sync
Modules with known eventlet monkey patching issues were imported prior to eventlet monkey patching: urllib3. This warning can usually be ignored if the caller is only importing and not executing nova code.
/usr/lib/python3/dist-packages/secretstorage/dhcrypto.py:15: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead
  from cryptography.utils import int_from_bytes
/usr/lib/python3/dist-packages/secretstorage/util.py:19: CryptographyDeprecationWarning: int_from_bytes is deprecated, use int.from_bytes instead
  from cryptography.utils import int_from_bytes
2023-10-18 20:43:18.921 26615 INFO alembic.runtime.migration [-] Context impl MySQLImpl.
2023-10-18 20:43:18.922 26615 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.
2023-10-18 20:43:18.946 26615 INFO alembic.runtime.migration [-] Running upgrade -> d67eeaabee36, Initial version
2023-10-18 20:43:20.423 26615 INFO alembic.runtime.migration [-] Running upgrade d67eeaabee36 -> b30f573d3377, Remove unused build_requests columns

mysql> show columns from nova_api_2008716.build_requests;
+-----------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+--------------+------+-----+---------+----------------+
| created_at | datetime | YES | | NULL | |
| updated_at | datetime | YES | | NULL | |
| id | int | NO | PRI | NULL | auto_increment |
| project_id | varchar(255) | NO | MUL | NULL | |
| instance_uuid | varchar(36) | YES | UNI | NULL | |
| instance | mediumtext | YES | | NULL | |
| block_device_mappings | mediumtext | YES | | NULL | |
| tags | text | YES | | NULL | |
+-----------------------+--------------+------+-----+---------+----------------+
8 rows in set (0.01 sec)