Transaction index not properly working

[hclivess]

trafficstars

There is a problem in block 502141, all transactions are in the block but they are not indexed - and not reflected, which is critical.

Block in question: http://167.86.120.22:9173/get_block?hash=c9a319e69506d30e29dcd56cb755147c4a9d98d66fd5eb60b8068e902f88e928 Transactions are present in the raw block data

https://explorer.nodeisok.com/get_block_number?entry=502141 Links to txs exist but return 404, which means they are not present in the transaciton index. Also they are not reflected in accounts (!)

Risk: Critical - reindexing can lead to respending of the transaction absent from tx index and not reflected in balances but present in the block (top authority), forking

Suspects:

• Rollback mechanism, perhaps in combination with the recently introduced index partitioning
• executemany - there have been issues in the past with Bismuth

[hclivess]

Added infinite retries on db operations so locks don't skip them https://github.com/hclivess/nado/commit/80ee305cf629267913b8facaaea3d2646d926ade