Clean up legacy build error and build failure models #6005

Job	Run time
tests (postgres, debian, minio)	22m 28s
build-images (ubuntu-24.04, debian)	3m 52s
build-images (ubuntu-24.04-arm, debian)	2m 38s
tests (postgres, debian, local)	20m 57s
tests (postgres, ubi, local)	12m 6s
build-images (ubuntu-24.04-arm, ubi)	2m 48s
build-images (ubuntu-24.04, ubi)	2m 44s
	1h 7m 33s

Provide feedback