[ixpmanager] IXPManager 6.0.0 - Issue with Fanout port

[Marinos Dimolianis]

Hello Barry,
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.
Best regards,
Marinos


On 15 January 2022 19:13:34 EET, "Barry O'Donovan (INEX)" <barry.odonovan at inex.ie> wrote:
>Thanks for confirming Marinos.
>
>As it's a confirmed issue, can you open an issue in GitHub for this so 
>we can schedule and track it?
>
>Thanks,
>  - Barry
>
>
>Marinos Dimolianis wrote on 23/12/2021 13:49:
>>
>> Hi Barry,
>>
>> Thank you for your response.
>>
>> We did an upgrade to version 6.2.0 and we were able to reproduce the 
>> exact same issue.
>>
>> BR,
>>
>> Marinos
>>
>> On 12/22/2021 3:17 PM, Barry O'Donovan (INEX) wrote:
>>> Hi Marinos,
>>>
>>> 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.
>>>
>>>  - Barry
>>>
>>>
>>> Marinos Dimolianis wrote on 22/12/2021 11:53:
>>>>
>>>> Hi all,
>>>>
>>>> We (in GRIX) upgraded recently IXPManager to version 6.0.0 and we 
>>>> bumped into a strange issue.
>>>>
>>>> We changed the port of a resold customer to a new one and also the 
>>>> corresponding fanout port of the reseller.
>>>>
>>>> Upon saving the new changes we received the following SQL error:
>>>>
>>>> 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)
>>>>
>>>> Since then, we are not able to edit the port configuration of the 
>>>> resold customer, receiving the following:
>>>>
>>>> Any ideas?
>>>>
>>>> BR,
>>>>
>>>> Marinos
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> INEX IXP Manager mailing list
>>>> ixpmanager at inex.ie
>>>> Unsubscribe or change options
>here:https://www.inex.ie/mailman/listinfo/ixpmanager
>>>
>>> -- 
>>>
>>> Kind regards,
>>> Barry O'Donovan
>>> INEX
>>>
>>> https://www.inex.ie/support/
>>> +353 1 531 3339
>>>
>>>
>
>-- 
>
>Kind regards,
>Barry O'Donovan
>INEX
>
>https://www.inex.ie/support/
>+353 1 531 3339

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.inex.ie/pipermail/ixpmanager/attachments/20220115/5fa1eb2a/attachment.htm>