Add RPC provider failover for block ingestor #11452

Job	Run time
Run integration tests	4m 19s
Clippy linting	2m 0s
Check rustfmt style	30s
Subgraph Runner integration tests	3m 11s
Run unit tests	4m 23s
Build in release mode	1m 45s
	16m 8s

Provide feedback