Create a database transaction per ProofBlindedProviderFactory

[shekhirin]

Problem

We're seeing a bunch of Transaction lock is already acquired, blocking... errors coming from the State Root Task, because we create only one ProofBlindedProviderFactory that's being re-used across the accounts sparse trie, as well as all storage spars tries

reth/crates/engine/tree/src/tree/root.rs

Lines 804 to 811 in 740bf04

	let blinded_provider_factory = ProofBlindedProviderFactory::new(
	in_memory_trie_cursor.clone(),
	HashedPostStateCursorFactory::new(
	DatabaseHashedCursorFactory::new(provider_ro.tx_ref()),
	&config.state_sorted,
	),
	config.prefix_sets.clone(),
	);

Because we calculate storage trie roots in parallel, it's possible for two calls to the blinded provider factory use the same transaction, which causes that log and a bit of wait on the lock

reth/crates/engine/tree/src/tree/root.rs

Line 948 in 740bf04

storage_trie.root();

Solution

We should initialize a transaction per ProofBlindedProviderFactory, so that they're not re-used across different storage tries.