-
Notifications
You must be signed in to change notification settings - Fork 802
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[stream] cli works well but no data in postgres #467
Comments
hope anyone could help, thank you so much |
There is no transaction in block 200000, maybe try another block number, e.g https://www.ondora.xyz/network/ethereum/blocks/18477299/interactions |
I get same error, please help |
Hi, I have encountered the same situation - whichever block i tried seems run successfully in terminal, but there's no data inserted in the database. And it seems like there's no error as well. Do you mind to give some advice on how to debug this? |
im trying to extract transactions data to my local postgres db
everything works well , but when a count rows data, its empty.
my enviroment
ethereumetl, version 2.3.1
os: macos apple m2
postgres version 15.4 , deploy in macos [localhost]
my command
ethereumetl stream --start-block 200000 -e transaction --provider-uri https://rpc.ankr.com/eth --output=postgresql+pg8000://postgres:[email protected]:5432/postgres
cli output
postgres output
no data, very sad !!!
postgres=# \d
List of relations
Schema | Name | Type | Owner
--------+--------------+-------+----------
public | transactions | table | postgres
public | users | table | postgres
(2 rows)
postgres=#
postgres=# select count(*) from transactions;
count
(1 row)
my try
postgres logs seems ok . no errors log
ethereum-etl cli stdout is also ok , no erros, just some INFO log for "INSERT INTO transactions xxxx"
The text was updated successfully, but these errors were encountered: