How to fix whale-api with an invalid block

[Stonygan]

Is there any way to remove an invalid block from the whale DB without using a snapshot:

defi-whale | 2023-07-05T11:58:37.587979000Z [Nest] 1 - 07/05/2023, 11:58:37 AM LOG [RPCBlockProvider] Cleanup - hash: 5f7e05b1f5dd4ee77cafadfe59228d9a3a480bf2a92c98b64392e04126af355f - height: 3079656 - status: ERROR
defi-whale | 2023-07-05T11:58:37.588384000Z [Nest] 1 - 07/05/2023, 11:58:37 AM LOG [RPCBlockProvider] Invalidate - hash: 5f7e05b1f5dd4ee77cafadfe59228d9a3a480bf2a92c98b64392e04126af355f - height: 3079656
defi-whale | 2023-07-05T11:58:37.603283000Z [Nest] 1 - 07/05/2023, 11:58:37 AM ERROR [RPCBlockProvider] failed exceptionally
defi-whale | 2023-07-05T11:58:37.603573000Z [Nest] 1 - 07/05/2023, 11:58:37 AM ERROR [RPCBlockProvider] Error: module.indexer: attempting to sync:invalidate but type:Transaction with id:f5676769f6de119a9578265fcadea08d305ec4dcf1e80536bc4e51f1fac93383 cannot be found in the index

The AIN-node software performs this rollback independently and searches for the longest chain.

[github-actions]

@Stonygan: Thanks for opening an issue, it is currently awaiting triage.

The triage/accepted label can be added by foundation members by writing /triage accepted in a comment.

Details

I am a bot created to help the BirthdayResearch developers manage community feedback and contributions. You can check out my manifest file to understand my behavior and what I can do. If you want to use this for your project, you can check out the BirthdayResearch/oss-governance-bot repository.

[github-actions]

@Stonygan: There are no 'area' labels on this issue. Adding an appropriate label will greatly expedite the process for us. You can add as many area as you see fit. If you are unsure what to do you can ignore this!

You can add area labels by leaving a /area comment.

Details

I am a bot created to help the BirthdayResearch developers manage community feedback and contributions. You can check out my manifest file to understand my behavior and what I can do. If you want to use this for your project, you can check out the BirthdayResearch/oss-governance-bot repository.