Add RPC provider failover for block ingestor (#6430) #11453

Job	Run time
Subgraph Runner integration tests	2m 37s
Run integration tests	4m 28s
Check rustfmt style	20s
Run unit tests	3m 52s
Build in release mode	1m 46s
Clippy linting	2m 7s
	15m 10s

Provide feedback