Comment 1 for bug 1862836

Revision history for this message
Felipe Reyes (freyes) wrote :

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