Issue inserting into blockdata2 about ethgasstation-backend HOT 9 CLOSED

Hi- yes- we just pushed an upgrade to the backend which supports web3.py version 4 (which uses hexbytes to store transaction data). If you update the backend, it should work now.

from ethgasstation-backend.

Hi,

Thanks for the update!

I updated but still getting the same error.
I didn't include this in my last post:
[ERROR] Traceback (most recent call last): File "/home/jonathan/.local/lib/python3.5/site-packages/mysql/connector/conversion.py", line 184, in to_mysql return getattr(self, "_{0}_to_mysql".format(type_name))(value) AttributeError: 'MySQLConverter' object has no attribute '_hexbytes_to_mysql'

Do I need to update the mysql-connector-python?

Thanks

from ethgasstation-backend.

Wow- good timing- I just fixed this now after your note- can you update your repo again and see if it is fixed now? You don't need to update mysql-connector.

from ethgasstation-backend.

:) thanks. I'll give it a try now

from ethgasstation-backend.

from ethgasstation-backend.

It fixed the issue above but now I'm getting this error from one of the code changes you made recently:
[ERROR] Traceback (most recent call last):
File "/home/jonathan/ethgasstation-backend/egs/main.py", line 235, in update_dataframes
report = SummaryReport(last1500t, last1500b, block)
File "/home/jonathan/ethgasstation-backend/egs/report_generator.py", line 50, in init
self.post['cheapestTxID'] = (self.tx_df.loc[(self.tx_df['minedGasPrice']==self.post['cheapestTx']) & (self.tx_df['gas_offered'] == 21000)].index[0]).lower()
File "/home/jonathan/.local/lib/python3.5/site-packages/pandas/core/indexes/base.py", line 2069, in getitem
return getitem(key)
IndexError: index 0 is out of bounds for axis 0 with size 0

from ethgasstation-backend.

from ethgasstation-backend.

Yea, it keeps happening and it's not generating the .json files. I commented out that line for now to be able to get the files and noticed that self.post['avgTxFee'] = self.tx_df.loc[self.tx_df['gas_offered']==21000, 'minedGasPrice'].median() is returning NAN.

I tried to debug this and also noticed that web3.txpool.content is returning an empty array, I think this is a problem with my node and not your code.

from ethgasstation-backend.

from ethgasstation-backend.