hi, On Tue, Apr 4, 2017 at 4:09 PM, Gary Kotton <gkot...@vmware.com> wrote: > Hi, > > The problem that we have is that any foreign key usage under transactions is > now broken. An example of an exception that is raised is: > > > > DBReferenceError: (sqlite3.IntegrityError) FOREIGN KEY constraint failed > [SQL: u'INSERT INTO neutron_nsx_firewall_section_mappings (created_at, > updated_at, neutron_id, nsx_id) VALUES (?, ?, ?, ?)'] [parameters: > ('2017-04-04 06:48:25.595118', None, '6a086bf1-b1c9-495f-bfca-810d6638e3fa', > '2563cd05-edd9-4c7f-9708-857a129e2642')] > > > > This is a major refactor in the plugin (which I guess is part and parcel of > rolling with the punches). I am just concerned if we are the only folks that > have affected by this.
networking-midonet is affected as well. > > Thanks > > Gary > > > > From: Gary Kotton <gkot...@vmware.com> > Reply-To: OpenStack List <openstack-dev@lists.openstack.org> > Date: Monday, April 3, 2017 at 3:14 PM > > > To: OpenStack List <openstack-dev@lists.openstack.org> > Subject: Re: [openstack-dev] [neutron] Engine facade > > > > Hi, > > We needed to make all of those changes to just get the plugin to pass unit > tests and CI. We are still seeing lots of issues and need to look deeper. > The façade changes have caused a lot of instability issues. I am not 100% > sure why. Issues that we have seen: > > 1. object creation under a transaction broke > > 2. deleting DB entries under transaction also broke > > Thanks > > Gary > > > > > > From: Anna Taraday <akamyshnik...@mirantis.com> > Reply-To: OpenStack List <openstack-dev@lists.openstack.org> > Date: Monday, April 3, 2017 at 11:53 AM > To: OpenStack List <openstack-dev@lists.openstack.org> > Subject: Re: [openstack-dev] [neutron] Engine facade > > > > Hi! > > I'm a little confused change https://review.openstack.org/#/c/452539/ is > about switching for new facade, does the master branch fails the same? > > > > On Mon, Apr 3, 2017 at 8:35 AM Gary Kotton <gkot...@vmware.com> wrote: > > Yes, sorry my bad for not adding it - > http://logs.openstack.org/39/452539/2/check/gate-vmware-nsx-python27-ubuntu-xenial/14c019c/testr_results.html.gz > > Please see the test test_create_port_dns_name > > Thanks > > Gary > > > > From: Kevin Benton <ke...@benton.pub> > Reply-To: OpenStack List <openstack-dev@lists.openstack.org> > Date: Monday, April 3, 2017 at 12:56 AM > To: OpenStack List <openstack-dev@lists.openstack.org> > Subject: Re: [openstack-dev] [neutron] Engine facade > > > > Do you have a link to a traceback? > > > > On Apr 2, 2017 09:25, "Gary Kotton" <gkot...@vmware.com> wrote: > > Hi, > > The change https://review.openstack.org/#/c/402750/ has broken the > vmware-nsx plugin. I am not sure if this has had effect on any other > decomposed plugins. > > One of the issues that we have is when we create a PortDNS object under a > transaction we get an exception: DBReferenceError: (sqlite3.IntegrityError) > FOREIGN KEY constraint failed [SQL: u'INSERT INTO portdnses (port_id, > current_dns_name, current_dns_domain, previous_dns_name, > previous_dns_domain, dns_name) VALUES (?, ?, ?, ?, ?, ?)'] [parameters: > ('2f2039ac-e7e6-4cc3-a8a0-3298089d4afb', u'', u'', u'', u'', > u'port-dns-name')] > > Any ideas? > > Thanks > > Gary > > > __________________________________________________________________________ > OpenStack Development Mailing List (not for usage questions) > Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > > __________________________________________________________________________ > OpenStack Development Mailing List (not for usage questions) > Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > > -- > > Regards, > Ann Taraday > > > __________________________________________________________________________ > OpenStack Development Mailing List (not for usage questions) > Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > __________________________________________________________________________ OpenStack Development Mailing List (not for usage questions) Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev