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

[brianluong]

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

• [X] 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.
• [X] I have searched the issue tracker to make sure this issue is not a duplicate.

OS information

Linux

[azf20]

hey @brianluong did you do anything around the time this happened (e.g. pausing or reassigning the subgraph), or did this just happen spontaneously? cc @lutter as this is batching related

[brianluong]

@azf20 It seemed to happen spontaneously.

[github-actions[bot]]

Looks like this issue has been open for 6 months with no activity. Is it still relevant? If not, please remember to close it.