Yeah, it sees the transceiver but no carrier. If the card is in Auto or IB mode that would probably be the issue. IB mode for sure would be a problem; I've seen reports that Mellanox cards in Auto mode does not play nice with Ethernet switches.
mlxconfig -d <device id> set LINK_TYPE_P1=2 (LINK_TYPE_P2 for port 2 if present)
It will show you the current current config, proposed new config, and a confirm prompt.
I have CX354 (CX3-Pro) cards, so older, running in Windows.
More mlxconfig stuff; including SR-IOV VF configuration on the card itself: Using mlxconfig - MFT v4.11.0 - NVIDIA Networking Docs
mlxconfig -d <device id> set LINK_TYPE_P1=2 (LINK_TYPE_P2 for port 2 if present)
It will show you the current current config, proposed new config, and a confirm prompt.
I have CX354 (CX3-Pro) cards, so older, running in Windows.
More mlxconfig stuff; including SR-IOV VF configuration on the card itself: Using mlxconfig - MFT v4.11.0 - NVIDIA Networking Docs