Add flag for disabling read tx timeout on BlockchainProvider

[Rjected]

We need a flag on the legacy blockchain provider that will disable the database transaction timeout whenever a transaction is created. This should cause it to call the disable_long_read_transaction_safety method whenever new db providers are created, like we do for state root in the old engine:

reth/crates/blockchain-tree/src/blockchain_tree.rs

Line 1240 in 47efb60

.disable_long_read_transaction_safety();

This should allow long running RPCs to be called without timing out when the legacy engine is used.

[mattsse]

I assume this should only affect the StateProviders?

[Rjected]

I assume this should only affect the StateProviders?

If possible, yes

[mattsse]

I think we can solve this with a function on StateProvider?

[Rjected]

I think we can solve this with a function on StateProvider?

It would be fine if we did that on the state provider structs, but all the ProviderFactory methods that return state providers, return StateProviderBox

[Rjected]

fixed by #11856