[Bug 1784342] Re: AttributeError: 'Subnet' object has no attribute '_obj_network_id'
*** This bug is a duplicate of bug 1839658 *** https://bugs.launchpad.net/bugs/1839658 Anyone who comes across this issue, resulting in denial of service from neutron-server with the exceptions mentioned in the OP, it's reasonably painless to workaround; simply delete the subnet(s) with NULL network_id: delete from neutron.subnets where network_id is null; No need to restart neutron-server afterwards. Clearly this is just a workaround... -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1784342 Title: AttributeError: 'Subnet' object has no attribute '_obj_network_id' To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1784342/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1784342] Re: AttributeError: 'Subnet' object has no attribute '_obj_network_id'
*** This bug is a duplicate of bug 1839658 *** https://bugs.launchpad.net/bugs/1839658 Hi, James, do you know how to reproduce this error? I think the foreign- key will prevent the deletion from the networks table until the subnet was deleted, so it seems that the field network_id will not be null in any time. `https://review.opendev.org/#/c/677221/` this patch force `network_id` not to be null, but how it works? -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1784342 Title: AttributeError: 'Subnet' object has no attribute '_obj_network_id' To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1784342/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1784342] Re: AttributeError: 'Subnet' object has no attribute '_obj_network_id'
*** This bug is a duplicate of bug 1839658 *** https://bugs.launchpad.net/bugs/1839658 Ah - this behaviour was enforced @ train see bug 1839658 ** This bug has been marked a duplicate of bug 1839658 "subnet" register in the DB can have network_id=NULL -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1784342 Title: AttributeError: 'Subnet' object has no attribute '_obj_network_id' To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1784342/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1784342] Re: AttributeError: 'Subnet' object has no attribute '_obj_network_id'
I had a dig around in the database - the subnets table has a foreign key reference to the networks table: CONSTRAINT `subnets_ibfk_1` FOREIGN KEY (`network_id`) REFERENCES `networks` (`id`), which I believe would prevent the deletion of the network from the networks table until the subnet was deleted? -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1784342 Title: AttributeError: 'Subnet' object has no attribute '_obj_network_id' To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1784342/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1784342] Re: AttributeError: 'Subnet' object has no attribute '_obj_network_id'
Full create table command: CREATE TABLE `subnets` ( `project_id` varchar(255) DEFAULT NULL, `id` varchar(36) NOT NULL, `name` varchar(255) DEFAULT NULL, `network_id` varchar(36) NOT NULL, `ip_version` int(11) NOT NULL, `cidr` varchar(64) NOT NULL, `gateway_ip` varchar(64) DEFAULT NULL, `enable_dhcp` tinyint(1) DEFAULT NULL, `ipv6_ra_mode` enum('slaac','dhcpv6-stateful','dhcpv6-stateless') DEFAULT NULL, `ipv6_address_mode` enum('slaac','dhcpv6-stateful','dhcpv6-stateless') DEFAULT NULL, `subnetpool_id` varchar(36) DEFAULT NULL, `standard_attr_id` bigint(20) NOT NULL, `segment_id` varchar(36) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uniq_subnets0standard_attr_id` (`standard_attr_id`), KEY `network_id` (`network_id`), KEY `ix_subnets_subnetpool_id` (`subnetpool_id`), KEY `segment_id` (`segment_id`), KEY `ix_subnets_project_id` (`project_id`), CONSTRAINT `subnets_ibfk_1` FOREIGN KEY (`network_id`) REFERENCES `networks` (`id`), CONSTRAINT `subnets_ibfk_2` FOREIGN KEY (`standard_attr_id`) REFERENCES `standardattributes` (`id`) ON DELETE CASCADE, CONSTRAINT `subnets_ibfk_3` FOREIGN KEY (`segment_id`) REFERENCES `networksegments` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1784342 Title: AttributeError: 'Subnet' object has no attribute '_obj_network_id' To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1784342/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1784342] Re: AttributeError: 'Subnet' object has no attribute '_obj_network_id'
Status changed to 'Confirmed' because the bug affects multiple users. ** Changed in: neutron (Ubuntu) Status: New => Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1784342 Title: AttributeError: 'Subnet' object has no attribute '_obj_network_id' To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1784342/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1784342] Re: AttributeError: 'Subnet' object has no attribute '_obj_network_id'
subscribed field-high, added Ubuntu Neutron package, since this has occurred in multiple production sites. ** Also affects: neutron (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1784342 Title: AttributeError: 'Subnet' object has no attribute '_obj_network_id' To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1784342/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs