[Bug] Subgraph hit error: internal constraint violated: Batches must go forward. Can't append a batch with block pointer...

Bug report

Subgraph failed after hitting this error:
Jul 14 00:13:20.858 ERRO Subgraph failed with non-deterministic error: Failed to transact block operations: internal constraint violated: Batches must go forward. Can't append a batch with block pointer #6265702 (c2d228257112989474262df4754e5bceae3932c36094aa32feb07c69da390797) to one with block pointer #6265702 (c2d228257112989474262df4754e5bceae3932c36094aa32feb07c69da390797), retry_delay_s: 213, attempt: 1, sgd: 365, component: SubgraphInstanceManager

The subgraph started syncing after restarting graph-node.

What caused this error and how can we avoid it in the future?

Some information to help us out

• Tick this box if this bug is caused by a regression found in the latest release.
• Tick this box if this bug is specific to the hosted service.
• I have searched the issue tracker to make sure this issue is not a duplicate.

OS information

Linux

報告された SubgraphInstanceManager の失敗と、ブロックバッチを追加するトランザクションから調査を始め、graph-node の再起動後に同一のブロックポインタが追加される理由に焦点を当てます。根本原因を特定し、エラーを回避または復旧するための検証済みの方法を文書化できれば完了です。