Open Stack

Hi!

This errors does not mean that foreign key usage is broken. This means that
there is a mess with transactions. As you paste small piece of trace it is
hard to say why this happen, but during my work I saw such errors and
resolve them. And probably you need to revisit your unit tests.

Please, send me email directly with links for traces, does this happen on
master branch, does it happen on one of your changes - it is hard to guess.


On Tue, Apr 4, 2017 at 11:16 AM Gary Kotton <gkotton at 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.

Thanks

Gary



*From: *Gary Kotton <gkotton at vmware.com>
*Reply-To: *OpenStack List <openstack-dev at lists.openstack.org>
*Date: *Monday, April 3, 2017 at 3:14 PM


*To: *OpenStack List <openstack-dev at 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 <akamyshnikova at mirantis.com>
*Reply-To: *OpenStack List <openstack-dev at lists.openstack.org>
*Date: *Monday, April 3, 2017 at 11:53 AM
*To: *OpenStack List <openstack-dev at 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 <gkotton at 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 <kevin at benton.pub>
*Reply-To: *OpenStack List <openstack-dev at lists.openstack.org>
*Date: *Monday, April 3, 2017 at 12:56 AM
*To: *OpenStack List <openstack-dev at 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" <gkotton at 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-request at 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-request at 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-request at lists.openstack.org?subject:unsubscribe
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev

-- 
Regards,
Ann Taraday
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20170404/8b0407f8/attachment.html>