Add RPC provider failover for block ingestor #11344

Job	Run time
Run integration tests	4m 2s
Run unit tests	4m 3s
Check rustfmt style	23s
Clippy linting	2m 18s
Build in release mode	1m 36s
Subgraph Runner integration tests	3m 29s
	15m 51s

Provide feedback