[mysql8] Unknown column 'public' in 'firewall_rules_v2'
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
neutron |
Fix Released
|
High
|
James Page | ||
neutron-fwaas (Ubuntu) |
Fix Released
|
High
|
James Page |
Bug Description
I installed a fresh openstack test cluster in eoan today (October 3).
Neutron database initialization with the command:
sudo su -s /bin/sh -c "neutron-db-manage
--config-file /etc/neutron/
--config-file /etc/neutron/
upgrade head" neutron
failed with error message:
oslo_db.
In mysql the table and the column exist, with a constraint on the column:
CONSTRAINT `firewall_
manually updating the column in mysql failed with the same error message.
mysql> ALTER TABLE firewall_rules_v2 CHANGE public shared BOOL NULL;
ERROR 1054 (42S22): Unknown column 'public' in 'check constraint firewall_
I guessed the constraint did not like it if the name of the column was changed.
I removed the column 'private' and created it again, without the constraint. The the alter table command worked fine.
After doing the same for the private columns in tables firewall_groups_v2 and firewall_
neutron 2:15.0.
mysql-server 8.0.16-0ubuntu3
Changed in neutron-fwaas (Ubuntu): | |
status: | Confirmed → Triaged |
importance: | Undecided → High |
assignee: | nobody → James Page (james-page) |
Changed in neutron-fwaas (Ubuntu): | |
status: | Triaged → In Progress |
Changed in neutron: | |
status: | In Progress → Fix Released |
Status changed to 'Confirmed' because the bug affects multiple users.