presto-ethereum icon indicating copy to clipboard operation
presto-ethereum copied to clipboard

Certain queries fail involving specific blocks and erc20

Open BenKnigge opened this issue 6 years ago • 2 comments

I've noticed that queries involving blocks 386620 and 392110 and erc20 fail. I have no idea.

Here are example queries

select * from ethereum.default.erc20 where erc20_blocknumber = 392110;

select * from ethereum.default.erc20 where erc20_blocknumber = 392110;

I do not believe that there are any erc20 token transactions in those blocks but I don't think that they should be resulting in an error either.

Ethereum node is parity 1.10.4

respose example from presto

presto> select * from ethereum.default.erc20 where erc20_blocknumber = 392110;

Query 20180807_224852_00845_hwt4f, FAILED, 1 node Splits: 17 total, 0 done (0.00%) 0:00 [0 rows, 0B] [0 rows/s, 0B/s]

Query 20180807_224852_00845_hwt4f failed: Index: 0, Size: 0

BenKnigge avatar Aug 07 '18 22:08 BenKnigge

same issue with block 505500

BenKnigge avatar Aug 08 '18 01:08 BenKnigge

These same blocks fail when the ethereum node is infura as well.

BenKnigge avatar Aug 08 '18 09:08 BenKnigge