Unable to evaluate predicate on Stacks chainstate: unable to retrieve block 157949

[Rapha-btc]

Describe the bug
Error message: Unable to evaluate predicate on Stacks chainstate: unable to retrieve block 157949

Transaction ID
Address
Block# 157949
Time stamp

To Reproduce
Check print screen of the chain hook params.

Params inside the screen but not visible:

SPP3HM2E4JXGT26G1QRWQ2YTR5WT040S5NKXZYFC.stx-ft-swap
https://backend-neon-ecru.vercel.app/api/chainhook/create-swap

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots

[Rapha-btc]

Same issue with this one:

SPP3HM2E4JXGT26G1QRWQ2YTR5WT040S5NKXZYFC.sub100neon-invader
https://backend-neon-ecru.vercel.app/api/chainhook/neon-sub100inv

[Rapha-btc]

This time I'm fetching a print event above. It returns the same error message. Please kindly advise. Thank you in advance.

[rafaelcr]

I think this could also be related to the TSV errors we've seen in other places @csgui , we should take a look at that mechanism asap

[csgui]

@rafaelcr Yes, this could be due to the corrupted TSV files we identified earlier.

One thing that can be done is switch all traffic to blue while we tackle this issue. If I'm not wrong it seems consistent.

[Rapha-btc]

Thanks for the support, fellows. Hopefully this helps improve Chainhook overall. It's shaping up to be a game-changer for Stacks, and Hiro offering it as a service is huge for builders!

[Rapha-btc]

Is there anything I can do on my side to test or help with this issue? Thank you.

[Rapha-btc]

Issue resolved! Thanks for your support. Not sure if it was fixed on your end or if my database redeployment did the trick, but either way, thanks!