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 <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.
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
--
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
