search

stampchain-io / btc_stamps

Bitcoin Stamps Indexer
https://stampchain.io
GNU Affero General Public License v3.0
9 stars 2 forks source link

Block Reorg Validation #313

Closed reinamora137 closed 1 week ago

reinamora137 commented 2 weeks ago

on a dev test the block reorg failed below. upon restart of the indexer it was successful. Perhaps the remote api endpoint from okx or stampscan was not yet updated.? Needs investigation. 

Rolling back to block 848476 to avoid problems.
[2024-06-18 13:10:53][WARNING] Purging SRC20Valid from database after block: 848476
[2024-06-18 13:10:53][WARNING] Purging SRC20 from database after block: 848476
[2024-06-18 13:10:58][WARNING] Purging StampTableV4 from database after block: 848476
[2024-06-18 13:10:58][WARNING] Purging transactions from database after block: 848476
[2024-06-18 13:10:58][WARNING] Purging blocks from database after block: 848476
[2024-06-18 13:10:58][INFO] Validating Balances Table..
[2024-06-18 13:11:09][WARNING] Purging and rebuilding balances table
[2024-06-18 13:11:12][WARNING] Inserting 117376 balances
Fetching CP Trx [848476..848478]: 100%|████████████████████████████████████████████████████████████████████████████████████████████| 3/3 [00:00<00:00, 155.33it/s]
Block: 848476 (12.97s, hashes: L:0bf54 / TX:91676 / M:1aba7 / S:15 / S20:15)
API ledger validation does not match ledger validation for block 848477
API ledger validation: geek,bc1qclzfn5wn9qaraazhcwkhrhw0ctx455p32z55ka,2000000;geek,bc1qzpwsyx7csavhj4cpeuwcyq30a6zz2mutmke0gp,125972000;luffy,bc1q05dfgsazzm4cscp
kag636zn688n757gvga9f0t,0;luffy,bc1q3a2ch62v2sz5h52vpt5d9zfffqkneh2935qc7t,110000;luffy,bc1q3hw8n3g3rlc72t77wy5l9rgg9c7j7gv2ejnnca,0;luffy,bc1q6yedevtvcnp98qt40sd
xlhc2at2qnslx8rrhnq,0;luffy,bc1qay74nc2djs2g5acqp72eyvlqp3ku7sj97jft8y,146350841.1807;luffy,bc1qgm02ld2k48gev5r4uvptsfqeese7qc8vfzuwpl,0;luffy,bc1qk0nekz6zttenhap
6vkmneklys696489y44eskq,0;luffy,bc1qp5mplpvpyyh2tama946y3munzaxs4ktg5t5925,26422000;nika,bc1q953l2m852degrlac3jrfqcka8wuwdhwrgjcfe6,132000000;nika,bc1qef9t4v023qh
hy3dqgr8rt572crwqp9pnsgqu62,380000000
Local Ledger validation: luffy,bc1q05dfgsazzm4cscpkag636zn688n757gvga9f0t,0;luffy,bc1q3a2ch62v2sz5h52vpt5d9zfffqkneh2935qc7t,110000;luffy,bc1q3hw8n3g3rlc72t77wy5l
9rgg9c7j7gv2ejnnca,0;luffy,bc1q6yedevtvcnp98qt40sdxlhc2at2qnslx8rrhnq,0;luffy,bc1qay74nc2djs2g5acqp72eyvlqp3ku7sj97jft8y,146350841.1807;luffy,bc1qgm02ld2k48gev5r4
uvptsfqeese7qc8vfzuwpl,0;luffy,bc1qk0nekz6zttenhap6vkmneklys696489y44eskq,0;luffy,bc1qp5mplpvpyyh2tama946y3munzaxs4ktg5t5925,26422000;nika,bc1q953l2m852degrlac3jr
fqcka8wuwdhwrgjcfe6,132000000;nika,bc1qef9t4v023qhhy3dqgr8rt572crwqp9pnsgqu62,380000000
Missing in Local Ledger: geek,bc1qclzfn5wn9qaraazhcwkhrhw0ctx455p32z55ka,2000000
Missing in Local Ledger: geek,bc1qzpwsyx7csavhj4cpeuwcyq30a6zz2mutmke0gp,125972000
Total mismatches: 2
reinamora137 commented 1 week ago

confirmed that the remote check on this block was not yet updated and balances were correct after reorg.