search

xiaoyao1991 / presto-ethereum

Presto Ethereum Connector -- SQL on Ethereum
Apache License 2.0
471 stars 56 forks source link

Certain queries fail involving specific blocks and erc20 #42

Open BenKnigge opened 6 years ago

BenKnigge commented 6 years ago

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 commented 6 years ago

same issue with block 505500

BenKnigge commented 6 years ago

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