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` ( `firewall_group_id` varchar(36) NOT NULL, `port_id` varchar(36) NOT NULL, PRIMARY KEY (`firewall_group_id`,`port_id`), UNIQUE KEY `uniq_firewallgroupportassociation0port_id` (`port_id`), CONSTRAINT `firewall_group_port_associations_v2_ibfk_1` FOREIGN KEY (`firewall_group_id`) REFERENCES `firewall_groups_v2` (`id`) ON DELETE CASCADE, CONSTRAINT `firewall_group_port_associations_v2_ibfk_2` FOREIGN KEY (`port_id`) REFERENCES `ports` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
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