Data Inconsistency

[Stamp9]

Notes of tests and experiments on data integrity and consistency.
Ground-truth: Erigon (for now... can traces be inconsistent between clients?)

Progress:

• script for counting all traces: Mónica
• script for counting traces from successful txs: Mónica
• reason for inconsistency: Raphina

[Stamp9]

*Allium

Data related to trace_type “reward” seems not included in the raw traces table
https://app.allium.so/explorer/queries/ZcKFkSnTAsZPn5OyhJtS

[Stamp9]

*Dune

No data(showing as 0x0000000000000000000000000000000000000000)about "from" when it comes to self-destruct

https://dune.com/queries/4567851

[mokita-j]

Number of traces in 2024:
Erigon:

• without precompile: 2475695430
• with precompile: 2668441480

Platform	total	error 1 (%)	error 2 (%)	possible reason
Dune	2475696345	+915 (3.7e-5)	-192745135 (7.2)
BigQuery	2475702798	+7368 (30e-5)	-192738682 (7.2)
Allium	2668410818	+192715388 (7.8)	-30662(1.1e-5)	precompiled contracts(192745595)

Number of traces from successful txs in 2024:

Platform	Total
Dune	2403309008
BigQuery	2403320652
Allium	2594777631
Erigon with trace_transaction

Number of traces of 1001 blocks [18908895,18909895]

Platform	total	possible reason
Dune	812020
BigQuery	812020
Allium	863647*	precompiled contracts(51627)
Erigon (without/with precompiles)	812020/863648

• Allium misses create2 trace from tx 0xe1baceed5cd5a4f59ee1c87d944c994adcb8af57552c3f2a096de7a2fd30e31c (Fail with error 'ERC1167: create2 failed')

[Stamp9]

precompiled contracts information in 2024:

Platform	with precompile?	number
Dune	Maybe..	132
BigQuery
Allium	Yes	192745595
Erigon	Yes and No

[Stamp9]

case:
The info for creation of 0xfda30bd691a84be099ab920517717d355e435d05
Reverted on blocksec:
https://app.blocksec.com/explorer/tx/eth/0x2e09f9ec5d32e11104cd195c9373c1ba543106965372093c50bb8b2095bad8ab?line=0
Success = 0 on Alliun: https://app.allium.so/explorer/queries/yiRvWlS010A6cHiVQPUL
Success = True on Dune Traces: https://dune.com/queries/4595643
Success is null on Dune transaction_table: https://dune.com/queries/4595652/7660399/

Went through on Etherscan:
https://etherscan.io/tx/0x2e09f9ec5d32e11104cd195c9373c1ba543106965372093c50bb8b2095bad8ab

[monperrus]

what?????

[Stamp9]

what?????

Yea.. have not figured out why yet, is it possible cause it is a very old one(2015-12-13 19:50:19 (UTC))?

[monperrus]

oh yes, could be the reason.

[Stamp9]

Case:
Internal txns missing, for example:

https://snowtrace.io/address/0x06450dEe7FD2Fb8E39061434BAbCFC05599a6Fb8/internalTx?page=57&nexttoken=last
Blockscout:
https://eth.blockscout.com/address/0x06450dEe7FD2Fb8E39061434BAbCFC05599a6Fb8?tab=internal_txns&page=2&next_page_params=%257B%2522block_number%2522%253A21780797%252C%2522index%2522%253A13%252C%2522items_count%2522%253A50%252C%2522transaction_index%2522%253A5%257D
Etherscan:
https://etherscan.io/txsInternal?a=0x06450dee7fd2fb8e39061434babcfc05599a6fb8

[mokita-j]

Case: Internal txns missing, for example:

https://snowtrace.io/address/0x06450dEe7FD2Fb8E39061434BAbCFC05599a6Fb8/internalTx?page=57&nexttoken=last https://etherscan.io/txsInternal?a=0x06450dee7fd2fb8e39061434babcfc05599a6fb8

I don't think they are the same contract, since they are on different chains.
The snowtrace's one refers to c-chain, while the etherscan's points to ethereum.

[Stamp9]

https://snowtrace.io/address/0x06450dEe7FD2Fb8E39061434BAbCFC05599a6Fb8/internalTx?page=57&nexttoken=last

Right, thanks for pointing out!! Should be this one:

https://eth.blockscout.com/address/0x06450dEe7FD2Fb8E39061434BAbCFC05599a6Fb8?tab=internal_txns&page=2&next_page_params=%257B%2522block_number%2522%253A21780797%252C%2522index%2522%253A13%252C%2522items_count%2522%253A50%252C%2522transaction_index%2522%253A5%257D

[mokita-j]

https://etherscan.io/txsInternal?a=0x06450dee7fd2fb8e39061434babcfc05599a6fb8

There might be a bug in Coinbase's code that deals with XEN Crypto token.
Because all of its transactions with this token have been reverted.
All the transactions are initiated by a coinbase EOA (0x7830c87c02e56aff27fa8ab1241711331fa86f43).
The Coinbase 10 contract is not open-sourced and according to Dedaub, it sends ETH to other addresses without checking if the call was successful or not.

coinbase10_dedaub.txt

[Stamp9]

Dune ethereum.signatures table incompetence:
FunctionUpdate and CommitMessage can not be found.

[Stamp9]

NethermindEth/nethermind#8205 (comment)

thanks @hzysvilla