neutron-fwaas Percona-XtraDB-Cluster prohibits use of DML command on a table (neutron.firewall_group_port_associations_v2) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER'
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Ubuntu Cloud Archive |
New
|
Undecided
|
Unassigned | ||
neutron-fwaas (Ubuntu) |
New
|
Undecided
|
Unassigned |
Bug Description
When trying to delete a heat stack in Stein fails, because neutron-server couldn't update firewall groups, the stack trace found in the logs is:
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
[...]
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
2020-02-11 13:14:21.356 1998511 ERROR neutron_
no longer affects: | neutron |
This error is similar to the one reported in Octavia https:/ /bugs.launchpad .net/ubuntu/ +source/ octavia/ +bug/1826875 , but in the case of neutron the table firewall_ group_port_ associations_ v2 has a primary key defined:
firewall_ group_port_ associations_ v2 | CREATE TABLE `firewall_ group_port_ associations_ v2` ( group_id` varchar(36) NOT NULL, group_id` ,`port_ id`), roupportassocia tion0port_ id` (`port_id`), group_port_ associations_ v2_ibfk_ 1` FOREIGN KEY (`firewall_ group_id` ) REFERENCES `firewall_ groups_ v2` (`id`) ON DELETE CASCADE, group_port_ associations_ v2_ibfk_ 2` FOREIGN KEY (`port_id`) REFERENCES `ports` (`id`) ON DELETE CASCADE
`firewall_
`port_id` varchar(36) NOT NULL,
PRIMARY KEY (`firewall_
UNIQUE KEY `uniq_firewallg
CONSTRAINT `firewall_
CONSTRAINT `firewall_
) ENGINE=InnoDB DEFAULT CHARSET=utf8