Package python3-neutron-vpnaas 24.0.1 is missing DB migrations
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Ubuntu Cloud Archive |
Fix Released
|
High
|
Unassigned | ||
| Caracal |
Triaged
|
High
|
Unassigned | ||
| Dalmatian |
Fix Released
|
High
|
Unassigned | ||
| neutron-vpnaas (Ubuntu) |
Fix Released
|
High
|
Unassigned | ||
| Noble |
Triaged
|
High
|
Unassigned | ||
| Oracular |
Fix Released
|
High
|
Unassigned | ||
Bug Description
We run Openstack Caracal on Ubuntu 22.04 and install the packages via the cloud archive.
The package "python3-
2024-09-11 15:28:40.339 1287225 CRITICAL neutron [None req-d756302c-
) (1054, "Unknown column 'vpnservices.
[SQL: SELECT vpnservices.
pnservices.status AS vpnservices_status, vpnservices.
pnservices_
FROM vpnservices]
The vpnservices table still has the inital schema and is missing the necessary migrations:
MariaDB [neutron]> DESCRIBE vpnservices;
+------
| Field | Type | Null | Key | Default | Extra |
+------
| tenant_id | varchar(255) | YES | | NULL | |
| id | varchar(36) | NO | PRI | NULL | |
| name | varchar(255) | YES | | NULL | |
| description | varchar(255) | YES | | NULL | |
| status | varchar(16) | NO | | NULL | |
| admin_state_up | tinyint(1) | NO | | NULL | |
| subnet_id | varchar(36) | NO | MUL | NULL | |
| router_id | varchar(36) | NO | MUL | NULL | |
+------
This should be fixable with "neutron-db-manage --subproject neutron-vpnaas upgrade head", but this command does not update the database.
When inspecting the directory that should contain the migration scripts, we can see that they are missing (note the absence of the "versions" folder).
root@dev-
total 20
drwxr-xr-x 3 root root 4096 Sep 11 13:56 ./
drwxr-xr-x 4 root root 4096 Sep 11 13:56 ../
-rw-r--r-- 1 root root 2536 Apr 3 13:51 env.py
-rw-r--r-- 1 root root 654 Apr 3 13:51 __init__.py
I could reproduce the issue by manually building the package via the following commands:
apt source python3-
apt build-dep python3-neutron
cd neutron-
debuild -us -uc
The output of that build also doesn't contain the database migration scripts, indicating some sort of error during the package build process.
The package for the Bobcat release works fine (23.0.0).
| Changed in neutron-vpnaas (Ubuntu Noble): | |
| status: | New → Triaged |
| Changed in neutron-vpnaas (Ubuntu Oracular): | |
| status: | Confirmed → Triaged |
| Changed in neutron-vpnaas (Ubuntu Noble): | |
| importance: | Undecided → High |
| Changed in neutron-vpnaas (Ubuntu Oracular): | |
| importance: | Undecided → High |
| Changed in neutron-vpnaas (Ubuntu Oracular): | |
| status: | Fix Released → Confirmed |
| status: | Confirmed → Fix Released |
| Changed in cloud-archive: | |
| status: | Triaged → Fix Committed |
Status changed to 'Confirmed' because the bug affects multiple users.