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

[smatiush]

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]

.. same issue here.

[marcovc]

Me too.

[arisAlexis]

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

[samlaf]

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]

any update on this?