Sporadic failure in tests on CI due to missing trie node JSON-RPC response

[Wodann]

The data::tests::full_block_* tests fail sporadically in CI, with the following errors:

Occurrence 1 (macOS):

---- data::tests::full_block_mainnet_19318016 stdout ----
Error: The response reported error `-32000`: `missing trie node 41c10bface9b142aaf6e4f20e97600744cbcbf2db34cf0ec03ede5e84eb29e98 (path ) state 0x41c10bface9b142aaf6e4f20e97600744cbcbf2db34cf0ec03ede5e84eb29e98 is not available, not found`. (optional data: None). Request: {"id":1452,"jsonrpc":"2.0","method":"eth_getStorageAt","params":["0xc49b737fa56f9142974a54f6c66055468ec631d0","0x360894a13ba1a3210667c828492db98dca3e2076cc3735a920a3ca505d382bbc","0x126c4ff"]

Occurrence 2 (Ubuntu):

---- data::tests::full_block_mainnet_cancun2 stdout ----
Error: The response reported error `-32000`: `missing trie node f90999ba63edf443f4c27152ca78f729afca615bc4637aaa44662dfdcb5c62c9 (path ) state 0xf90999ba63edf443f4c27152ca78f729afca615bc4637aaa44662dfdcb5c62c9 is not available, not found`. (optional data: None). Request: {"id":546,"jsonrpc":"2.0","method":"eth_getStorageAt","params":["0x2cfc3a07fd9ee6d3227b24fc4ee09b34ae1500b7","0x150595343228aa057f2d5dac3ed2d5618e3d52c474caabf780038e663d7cbf5f","0x12a7e3e"]}

The error is being bubbled up from our remote JSON-RPC requests when using Alchemy as a provider.

Definition of Done
Understand why the sporadic failure occurred and potentially create a fix