[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

Inizia dal fallimento segnalato di SubgraphInstanceManager e dalla transazione che aggiunge batch di blocchi, concentrandoti sul motivo per cui vengono aggiunti puntatori di blocco identici dopo i riavvii di graph-node. Il lavoro è considerato completato quando la causa principale è stata identificata e quando è stato documentato un modo verificato per evitare l’errore o recuperare da esso.