`Contract.Event.query` gets stuck and does not raise about ape-alchemy HOT 8 OPEN

I second this. Experiencing same issue on my laptop

from ape-alchemy.

more findings:
Contract("0x4d224452801ACEd8B2F0aebE155379bb5D594381").Transfer.query("transaction_hash", start_block=15000000) runs fine when connecting through geth uri, but when running that with default provider set to alchemy, again it freezes with no output/errors.

is there an inherent different way of connecting through ape-alchemy than through the normal, non-plugin geth way? i guess especially for get_contract_logs, does it behave differently using this plugin?

edit: ok wow looks like it came through after all! just suuuuper slow

from ape-alchemy.

@gosuto-inzasheru I believe these are symptoms of ApeWorX/ape#1119, just with a different provider causing the issue. when you don't restrict queries by block number, currently it queries all possible blocks for events in each transaction which is.... extremely slow, yes. will definitely want to refactor it to using filters and paging to make it speed up

@Ninjagod1251 let's confirm this is indeed the same behavior, and then we can close this in favor of the ape core issue because I don't think it's alchemy causing the problem here

from ape-alchemy.

ApeWorX/ape#1119 is definitely related, but i believe there is something inherently different about the way a .query gets made when ape-alchemy is installed:

$ ape plugins list   
Installed Plugins:
  arbitrum     0.5.1
  etherscan    0.5.4
$ ape console -v INFO

In [1]: import timeit;timeit.timeit('from ape import Contract;Contract("0x4d224452801ACEd8B2F0aeb
   ...: E155379bb5D594381").Transfer.query("transaction_hash", start_block=15000000)', number=3)
INFO: Cache database has not been initialized
Out[1]: 375.95413874601945

$ ape plugins list
Installed Plugins:
  alchemy      0.5.3
  arbitrum     0.5.1
  etherscan    0.5.4
$ ape console -v INFO

In [1]: import timeit;timeit.timeit('from ape import Contract;Contract("0x4d224452801ACEd8B2F0aeb
   ...: E155379bb5D594381").Transfer.query("transaction_hash", start_block=15000000)', number=3)
INFO: Cache database has not been initialized
Out[1]: 3181.283465335029

from ape-alchemy.

ApeWorX/ape#1119 is definitely related, but i believe there is something inherently different about the way a .query gets made when ape-alchemy is installed:

$ ape plugins list   
Installed Plugins:
  arbitrum     0.5.1
  etherscan    0.5.4
$ ape console -v INFO

In [1]: import timeit;timeit.timeit('from ape import Contract;Contract("0x4d224452801ACEd8B2F0aeb
   ...: E155379bb5D594381").Transfer.query("transaction_hash", start_block=15000000)', number=3)
INFO: Cache database has not been initialized
Out[1]: 375.95413874601945

$ ape plugins list
Installed Plugins:
  alchemy      0.5.3
  arbitrum     0.5.1
  etherscan    0.5.4
$ ape console -v INFO

In [1]: import timeit;timeit.timeit('from ape import Contract;Contract("0x4d224452801ACEd8B2F0aeb
   ...: E155379bb5D594381").Transfer.query("transaction_hash", start_block=15000000)', number=3)
INFO: Cache database has not been initialized
Out[1]: 3181.283465335029

This is very strange indeed! Are you using alchemy as your default network when executing example 2?

from ape-alchemy.

indeed, in both examples my ape config looks like this:

ethereum:
  default_network: mainnet
  mainnet:
    default_provider: alchemy
geth:
  ethereum:
    mainnet:
      uri: https://eth-mainnet.g.alchemy.com/v2/XXX

which in the first run gives ERROR: Failed setting default provider: Provider 'alchemy' not found in network 'mainnet'. right before connecting to the geth configured url. in the second run it connects to alchemy successfully (using the WEB3_ETHEREUM_MAINNET_ALCHEMY_API_KEY=XXX in my .env).

from ape-alchemy.

Gotcha, okay that makes more sense

from ape-alchemy.

Ah, reading this now it seems like this provider either needs to override Web3Provider.get_contract_logs to use the 2k block chunks:

https://github.com/ApeWorX/ape/blob/79a552f61080aff891bad4bf965bc96fca832c6c/src/ape/api/providers.py#L1020

or change block_page_size: int = 100 to block_page_size: int = 2000

from ape-alchemy.