Oddbean new post about login | logout Today I learned there are duplicate transaction IDs on the Blockchain from the early days
Link?
Umm don't have a link but I'm importing all the transactions into the database and getting duplicate errors for some coinbase txns
Interesting, going into the rabbit hole now.
e3bf3d07d4b0375638d5f1db5255fe07ba2c4cb067cd81b84ee974b6585fb468
So is it duplicated hash?
Or hear it somewhere?
Yep, I learned about that when I wrote my first transaction indexer. 🫠
How did you handle it? Do you reassign your own txid? Or append height or something?
I think I just let it overwrite it ignore the error as long as the block height was below the BIP34 activation at height 227,836. IIRC the UTXO of the earlier duplicate transaction is unspendable and effectively overwritten.
