hirosystems / chainhook

Extract transactions from Stacks and Bitcoin and build event driven re-org resistant indexers and databases.
GNU General Public License v3.0
155 stars 63 forks source link

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

Closed Rapha-btc closed 3 months ago

Rapha-btc commented 3 months ago

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.

Screenshot 2024-07-17 at 12 49 44 PM

Params inside the screen but not visible:

Screenshot 2024-07-17 at 4 09 07 PM

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 image

Rapha-btc commented 3 months ago
Screenshot 2024-07-17 at 5 17 18 PM Screenshot 2024-07-17 at 5 17 29 PM

Same issue with this one:

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

Rapha-btc commented 3 months ago

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

rafaelcr commented 3 months ago

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 commented 3 months ago

@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 commented 3 months ago

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 commented 3 months ago

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

Rapha-btc commented 3 months ago

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!

Screenshot 2024-07-21 at 5 34 52 PM