This epic tracks all the effort needed to deliver the solution related to the bug described below.
The ovn-nbctl --wait=sb command could under certain conditions return earlier than the actual update is processed. The issue was discovered during review of https://patchwork.ozlabs.org/project/ovn/patch/20250915131602.54821-1-lucas.vdias@luizalabs.com/ the test would fail without the fix because northd entered commit fail loop. The expected behavior would be for the sync call to block until the timeout runs out. However the sync call was returning 0 and the test failed later on database check.

The root cause is that northd I-P wouldn't run, but there was still valid transaction for SB. The transaction commit would return UNCHANGED, however, UNCHANGED moves idl loop next_cfg to cur_cfg, which is used by the synchronization. The next northd loop would update the SB nb_cfg in a different transaction than the failing one. Resulting in sync returning early.