<html theme="themeKey88rand710" iconset="monochrome"><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head><body text="#000000">Hello Barry,<br>We plan to open an issue in GitHub and also provide the workaround that seemed to work in our case to help anyone that may face the same issue.<br>Best regards,<br>Marinos<br><br><br><div class="gmail_quote">On 15 January 2022 19:13:34 EET, "Barry O'Donovan (INEX)" <barry.odonovan@inex.ie> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Thanks for confirming Marinos.<br>
<br>
As it's a confirmed issue, can you open an issue in GitHub for this so
we can schedule and track it?<br>
<br>
Thanks,<br>
- Barry<br>
<br>
<br>
<span>Marinos Dimolianis wrote on 23/12/2021 13:49:</span><br>
<blockquote type="cite" cite="mid:2c929359-652d-eb45-031a-e345109dc3d8@netmode.ntua.gr">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<p>Hi Barry,</p>
<p>Thank you for your response.</p>
<p>We did an upgrade to version 6.2.0 and we were able to reproduce
the exact same issue.</p>
<p>BR,</p>
<p>Marinos<br>
</p>
<div class="moz-cite-prefix">On 12/22/2021 3:17 PM, Barry O'Donovan
(INEX) wrote:<br>
</div>
<blockquote type="cite" cite="mid:ee9c441f-836b-4a89-b036-f5e24cca9862@inex.ie"><meta http-equiv="Content-Type" content="text/html; charset=utf-8">
Hi Marinos,<br>
<br>
I think the first thing you need to do us upgrade to the current
release. There were a lot of bug fixes between 6.0.0 and the
current version.<br>
<br>
- Barry<br>
<br>
<br>
<span>Marinos Dimolianis wrote on 22/12/2021 11:53:</span><br>
<blockquote type="cite" cite="mid:005184e2-d3d5-8488-de47-b49f68e90105@netmode.ntua.gr"><meta http-equiv="content-type" content="text/html; charset=utf-8">
<p>Hi all, <br>
</p>
<p>We (in GRIX) upgraded recently IXPManager to version 6.0.0
and we bumped into a strange issue.</p>
<p>We changed the port of a resold customer to a new one and
also the corresponding fanout port of the reseller. <br>
</p>
<p>Upon saving the new changes we received the following SQL
error:</p>
<pre class="c-mrkdwn__pre" data-stringify-type="pre" style="box-sizing: inherit; margin: 4px 0px; padding: 8px; --saf-0:rgba(var(--sk_foreground_low,29,28,29),0.13); font-size: 12px; line-height: 1.50001; font-variant-ligatures: none; white-space: pre-wrap; overflow-wrap: break-word; word-break: normal; tab-size: 4; font-family: Monaco, Menlo, Consolas, "Courier New", monospace !important; border: 1px solid var(--saf-0); border-radius: 4px; background: rgba(var(--sk_foreground_min,29,28,29),0.04); counter-reset: list-0 0 list-1 0 list-2 0 list-3 0 list-4 0 list-5 0 list-6 0 list-7 0 list-8 0 list-9 0; color: rgb(29, 28, 29); font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">500
Server Error :: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`ixpmanager6`.`physicalinterface`, CONSTRAINT `FK_5FFF4D60BFDF15D5` FOREIGN KEY (`virtualinterfaceid`) REFERENCES `virtualinterface` (`id`) ON DELETE CASCADE) (SQL: update `physicalinterface` set `virtualinterfaceid` = 150, `speed` = 1000, `status` = 1, `duplex` = full, `physicalinterface`.`updated_at` = 2021-12-22 11:35:39 where `id` = 365)</pre>
<p>Since then, we are not able to edit the port configuration of
the resold customer, receiving the following:</p>
<p><img src="cid:part1.1B46C90D.E714B909@inex.ie" alt="" name="image.png" class=""></p>
<p>Any ideas?</p>
<p>BR,</p>
<p>Marinos<br>
</p>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
INEX IXP Manager mailing list
<a class="moz-txt-link-abbreviated moz-txt-link-freetext" href="mailto:ixpmanager@inex.ie" moz-do-not-send="true">ixpmanager@inex.ie</a>
Unsubscribe or change options here: <a class="moz-txt-link-freetext" href="https://www.inex.ie/mailman/listinfo/ixpmanager" moz-do-not-send="true">https://www.inex.ie/mailman/listinfo/ixpmanager</a>
</pre></blockquote>
<br>
<div class="moz-signature">-- <br>
<br>
Kind regards,
<br>
Barry O'Donovan
<br>
INEX <br>
<br>
<a class="moz-txt-link-freetext" href="https://www.inex.ie/support/" moz-do-not-send="true">https://www.inex.ie/support/</a>
<br>
+353 1 531 3339<br>
<br>
<br>
</div></blockquote>
</blockquote>
<br>
<div class="moz-signature">-- <br><br>
Kind regards,
<br>
Barry O'Donovan
<br>
INEX <br>
<br>
<a class="moz-txt-link-freetext" href="https://www.inex.ie/support/">https://www.inex.ie/support/</a>
<br>
+353 1 531 3339<br>
<br>
<br>
</div>
</blockquote></div><br>-- <br>Sent from my Android device with K-9 Mail. Please excuse my brevity.</body></html>