search

Uniswap / v2-subgraph

Uniswap V2 subgraph 📊
https://thegraph.com/explorer/subgraph/uniswap/uniswap-v2
GNU General Public License v3.0
404 stars 739 forks source link

Failed to get entities from store: canceling statement due to conflict with recover #78

Open smatiush opened 3 years ago

smatiush commented 3 years ago

hi, I'm trying to do a time-traveler query, to retrieve some info from uniswap subgraph. i need to retrieve the historical state of that contract, to achieving this i run a while len(results_query["swaps"]) > 0:, at every iteration the last block get fetched from the query and added to the next query that need to be executed. after 2580 row, Failed to get entities from store: canceling statement due to conflict with recovery. I'm asking for some explanation of the error or some troubleshooting technics. i have another question about the subgraph, it have rate limit? thanks, have a good day

QUERY: query trades($blockNum: Int=11814699) { swaps(where:{pair: "0xa478c2975ab1ea89e8196811f51a7b7ade33eb11"}, orderBy: timestamp, orderDirection: desc, first:15, block: {number:$blockNum}) { id timestamp amount0In amount1In amount0Out amount1Out } transaction { blockNumber } } }

ramtej commented 3 years ago

.. same issue here.

marcovc commented 3 years ago

Me too.

arisAlexis commented 3 years ago

I get this while looping all pairs and when the offset gets to 3000

samlaf commented 2 years ago

Also running into this issue. Any hint as to what is happening and how to stop it? It returns a failing postgresql statement, so probably has to do with that database. Might be nice to wrap the error and give a nicer error message to users.

menaitm commented 2 years ago

any update on this?