As this issue contained tasks that take more than 2 weeks collectively, it has been split into two parts:

• State sync from local snapshot: Understand problem, explore solutions #9947
• State sync from local snapshot: Implementation #9948