<div dir="ltr">Hi!<br><br>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.<br><br>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. <br><div><br class="gmail_msg"><br class="gmail_msg"><div class="gmail_quote gmail_msg"><div dir="ltr" class="gmail_msg">On Tue, Apr 4, 2017 at 11:16 AM Gary Kotton <<a href="mailto:gkotton@vmware.com" class="gmail_msg" target="_blank">gkotton@vmware.com</a>> wrote:<br class="gmail_msg"></div><blockquote class="gmail_quote gmail_msg" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="white" lang="EN-US" link="blue" vlink="purple" class="gmail_msg">
<div class="m_1846757984325024509m_5883951325863318767WordSection1 gmail_msg">
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg">Hi,<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg">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:<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg"> 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')]<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg">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.<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg">Thanks<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg">Gary<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></span></p>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in" class="gmail_msg">
<p class="MsoNormal gmail_msg"><b class="gmail_msg"><span style="font-family:Calibri;color:black" class="gmail_msg">From: </span>
</b><span style="font-family:Calibri;color:black" class="gmail_msg">Gary Kotton <<a href="mailto:gkotton@vmware.com" class="gmail_msg" target="_blank">gkotton@vmware.com</a>><br class="gmail_msg">
<b class="gmail_msg">Reply-To: </b>OpenStack List <<a href="mailto:openstack-dev@lists.openstack.org" class="gmail_msg" target="_blank">openstack-dev@lists.openstack.org</a>><br class="gmail_msg">
<b class="gmail_msg">Date: </b>Monday, April 3, 2017 at 3:14 PM</span></p></div></div></div><div bgcolor="white" lang="EN-US" link="blue" vlink="purple" class="gmail_msg"><div class="m_1846757984325024509m_5883951325863318767WordSection1 gmail_msg"><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in" class="gmail_msg"><p class="MsoNormal gmail_msg"><span style="font-family:Calibri;color:black" class="gmail_msg"><br class="gmail_msg">
<b class="gmail_msg">To: </b>OpenStack List <<a href="mailto:openstack-dev@lists.openstack.org" class="gmail_msg" target="_blank">openstack-dev@lists.openstack.org</a>><br class="gmail_msg">
<b class="gmail_msg">Subject: </b>Re: [openstack-dev] [neutron] Engine facade<u class="gmail_msg"></u><u class="gmail_msg"></u></span></p></div></div></div><div bgcolor="white" lang="EN-US" link="blue" vlink="purple" class="gmail_msg"><div class="m_1846757984325024509m_5883951325863318767WordSection1 gmail_msg">
<div class="gmail_msg">
<p class="MsoNormal gmail_msg"><u class="gmail_msg"></u> <u class="gmail_msg"></u></p>
</div>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg">Hi, </span>
<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg">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:</span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg">1. object creation under a transaction broke</span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg">2. deleting DB entries under transaction also broke</span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg">Thanks</span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg">Gary</span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg"> </span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg"> </span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in" class="gmail_msg">
<p class="MsoNormal gmail_msg"><b class="gmail_msg"><span style="font-family:Calibri;color:black" class="gmail_msg">From: </span>
</b><span style="font-family:Calibri;color:black" class="gmail_msg">Anna Taraday <<a href="mailto:akamyshnikova@mirantis.com" class="gmail_msg" target="_blank">akamyshnikova@mirantis.com</a>><br class="gmail_msg">
<b class="gmail_msg">Reply-To: </b>OpenStack List <<a href="mailto:openstack-dev@lists.openstack.org" class="gmail_msg" target="_blank">openstack-dev@lists.openstack.org</a>><br class="gmail_msg">
<b class="gmail_msg">Date: </b>Monday, April 3, 2017 at 11:53 AM<br class="gmail_msg">
<b class="gmail_msg">To: </b>OpenStack List <<a href="mailto:openstack-dev@lists.openstack.org" class="gmail_msg" target="_blank">openstack-dev@lists.openstack.org</a>><br class="gmail_msg">
<b class="gmail_msg">Subject: </b>Re: [openstack-dev] [neutron] Engine facade</span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
</div>
<div class="gmail_msg">
<p class="MsoNormal gmail_msg"> <u class="gmail_msg"></u><u class="gmail_msg"></u></p>
</div>
<div class="gmail_msg">
<p class="MsoNormal gmail_msg">Hi!<br class="gmail_msg">
<br class="gmail_msg">
I'm a little confused change <a href="https://review.openstack.org/#/c/452539/" class="gmail_msg" target="_blank">https://review.openstack.org/#/c/452539/</a> is about switching for new facade, does the master branch fails the same?<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
</div>
<p class="MsoNormal gmail_msg"> <u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<div class="gmail_msg">
<div class="gmail_msg">
<p class="MsoNormal gmail_msg">On Mon, Apr 3, 2017 at 8:35 AM Gary Kotton <<a href="mailto:gkotton@vmware.com" class="gmail_msg" target="_blank">gkotton@vmware.com</a>> wrote:<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
</div>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt" class="gmail_msg">
<div class="gmail_msg">
<div class="gmail_msg">
<p class="MsoNormal gmail_msg"><span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg">Yes, sorry my bad for not adding it -
<a href="http://logs.openstack.org/39/452539/2/check/gate-vmware-nsx-python27-ubuntu-xenial/14c019c/testr_results.html.gz" class="gmail_msg" target="_blank">
http://logs.openstack.org/39/452539/2/check/gate-vmware-nsx-python27-ubuntu-xenial/14c019c/testr_results.html.gz</a></span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg">Please see the test
<b class="gmail_msg">test_create_port_dns_name</b></span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg">Thanks</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg">Gary</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><span style="font-size:11.0pt;font-family:Calibri" class="gmail_msg"> </span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in" class="gmail_msg">
<p class="MsoNormal gmail_msg"><span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><b class="gmail_msg"><span style="font-family:Calibri;color:black" class="gmail_msg">From:
</span></b></span><span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><span style="font-family:Calibri;color:black" class="gmail_msg">Kevin Benton <kevin@benton.pub></span></span><span style="font-family:Calibri;color:black" class="gmail_msg"><br class="gmail_msg">
<span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><b class="gmail_msg">Reply-To: </b>OpenStack List <<a href="mailto:openstack-dev@lists.openstack.org" class="gmail_msg" target="_blank">openstack-dev@lists.openstack.org</a>></span><br class="gmail_msg">
<span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><b class="gmail_msg">Date: </b>Monday, April 3, 2017 at 12:56 AM</span><br class="gmail_msg">
<span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><b class="gmail_msg">To: </b>OpenStack List <<a href="mailto:openstack-dev@lists.openstack.org" class="gmail_msg" target="_blank">openstack-dev@lists.openstack.org</a>></span><br class="gmail_msg">
<span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><b class="gmail_msg">Subject: </b>Re: [openstack-dev] [neutron] Engine facade</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
</div>
</div>
</div>
<div class="gmail_msg">
<div class="gmail_msg">
<div class="gmail_msg">
<p class="MsoNormal gmail_msg"> <u class="gmail_msg"></u><u class="gmail_msg"></u></p>
</div>
<div class="gmail_msg">
<p class="MsoNormal gmail_msg">Do you have a link to a traceback? <u class="gmail_msg"></u><u class="gmail_msg"></u></p>
</div>
<div class="gmail_msg">
<p class="MsoNormal gmail_msg"> <u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<div class="gmail_msg">
<p class="MsoNormal gmail_msg">On Apr 2, 2017 09:25, "Gary Kotton" <<a href="mailto:gkotton@vmware.com" class="gmail_msg" target="_blank">gkotton@vmware.com</a>> wrote:<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt" class="gmail_msg">
<div class="gmail_msg">
<div class="gmail_msg">
<p class="MsoNormal gmail_msg"><span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><span style="font-size:11.0pt" class="gmail_msg">Hi,</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><span style="font-size:11.0pt" class="gmail_msg">The change
<a href="https://review.openstack.org/#/c/402750/" class="gmail_msg" target="_blank">https://review.openstack.org/#/c/402750/</a> has broken the vmware-nsx plugin. I am not sure if this has had effect on any other decomposed plugins.</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><span style="font-size:11.0pt" class="gmail_msg">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')]</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><span style="font-size:11.0pt" class="gmail_msg">Any ideas?</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><span style="font-size:11.0pt" class="gmail_msg">Thanks</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
<p class="MsoNormal gmail_msg"><span class="m_1846757984325024509m_5883951325863318767gmailmsg gmail_msg"><span style="font-size:11.0pt" class="gmail_msg">Gary</span></span><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
</div>
</div>
<p class="MsoNormal gmail_msg" style="margin-bottom:12.0pt"><br class="gmail_msg">
__________________________________________________________________________<br class="gmail_msg">
OpenStack Development Mailing List (not for usage questions)<br class="gmail_msg">
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" class="gmail_msg" target="_blank">
OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br class="gmail_msg">
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" class="gmail_msg" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
</blockquote>
</div>
</div>
</div>
</div>
<p class="MsoNormal gmail_msg">__________________________________________________________________________<br class="gmail_msg">
OpenStack Development Mailing List (not for usage questions)<br class="gmail_msg">
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" class="gmail_msg" target="_blank">
OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br class="gmail_msg">
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" class="gmail_msg" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><u class="gmail_msg"></u><u class="gmail_msg"></u></p>
</blockquote>
</div>
<div class="gmail_msg">
<p class="MsoNormal gmail_msg">-- <u class="gmail_msg"></u><u class="gmail_msg"></u></p>
</div>
<div class="gmail_msg">
<div class="gmail_msg">
<p class="MsoNormal gmail_msg">Regards,<br class="gmail_msg">
Ann Taraday<u class="gmail_msg"></u><u class="gmail_msg"></u></p>
</div>
</div>
</div></div>
__________________________________________________________________________<br class="gmail_msg">
OpenStack Development Mailing List (not for usage questions)<br class="gmail_msg">
Unsubscribe: <a href="http://OpenStack-dev-request@lists.openstack.org?subject:unsubscribe" rel="noreferrer" class="gmail_msg" target="_blank">OpenStack-dev-request@lists.openstack.org?subject:unsubscribe</a><br class="gmail_msg">
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" rel="noreferrer" class="gmail_msg" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br class="gmail_msg">
</blockquote></div></div></div><div dir="ltr">-- <br></div><div data-smartmail="gmail_signature"><div dir="ltr">Regards,<br>Ann Taraday</div></div>