near / near-indexer-for-explorer

Watch NEAR network and store all the data from NEAR blockchain to PostgreSQL database
https://near-indexers.io/docs/projects/near-indexer-for-explorer
GNU General Public License v3.0
123 stars 56 forks source link

Some blocks in DB are broken #269

Closed telezhnaya closed 2 years ago

telezhnaya commented 2 years ago

We have an issue in blocks 47317863, 47317864, 47317865 with index_in_chunk column

We have 2 rows 6,7,8, etc here, at one chunk

select * from receipts join blocks on receipts.included_in_block_hash = blocks.block_hash
where block_height = 47317863
order by receipts.index_in_chunk;

I suggest to delete the info for these 3 blocks and write it again.

khorolets commented 2 years ago

I believe you've done it already, no?