[Access] Add support for executing scripts across HCU boundaries on a single AN

[peterargue]

Problem Definition

From time to time, the version of cadence or FVM need to be upgraded to address security issues, or add new functionality. When this happens, all nodes interacting with execution state (Execution, verification and access nodes) perform what's call a "Height Coordinated Upgrade" to synchronize updating to the new version at the same block height. This ensures that transactions and scripts produce the same result on all nodes.

Currently, Access nodes can run a single version of cadence/FVM for use by script execution. This is fine for executing against the latest block, but poses problems for archival nodes that want to serve queries for previous blocks that cross HCU boundaries. The only way to address this today is to run a separate node for each range of blocks between HCUs, that's running the correct software versions, but this creates operational challenges.

Proposed Solution

Add support for executing script against different cadence/FVM versions on a single node.

Tasks

Beta Give feedback

1. [Access] Investigate options for running multiple FVM/cadence versions on single AN #6023
   Preserve S-Access +2