m2m edge for table referrer_references: ERROR: deadlock detected

[migmartri]

    --- FAIL: TestReferrerIntegration/TestExtractAndPersistsConcurrency (2.93s)
        referrer_integration_test.go:163: 
            	Error Trace:	/home/runner/work/chainloop/chainloop/app/controlplane/pkg/biz/referrer_integration_test.go:163
            	            				/opt/hostedtoolcache/go/1.24.4/x64/src/runtime/asm_amd64.s:1700
            	Error:      	Received unexpected error:
            	            	saving referrers: failed to create referrer relationship: add m2m edge for table referrer_references: ERROR: deadlock detected (SQLSTATE 40P01)
            	Test:       	TestReferrerIntegration/TestExtractAndPersistsConcurrency

https://github.com/chainloop-dev/chainloop/actions/runs/15985344988/job/45088807870

[migmartri]

after seeing it twice now I can see it fixed, so it's transient