Write transactions to static files on insert_historical_block

[joshieDo]

Describe the feature

Writing transactions to static files on insert_historical_block tried on #11523 (05cf701) triggered a bunch of errors in other tests.

Many tests across the test-suite are assuming that transactions are on database instead of static files. This should change especially with the introduction of the new engine, given that transactions will start getting written directly to static files. (they already do during staged sync)

When done, remove the transaction writer from provider_with_chain_spec_and_random_blocks introduced on the above PR.

We probably want to do this crate by crate if there are a lot of tests involved that need to be changed.

Additional context

No response

[github-actions]

This issue is stale because it has been open for 21 days with no activity.