Skip to content

Instantly share code, notes, and snippets.

@isSerge
Last active March 7, 2023 13:03
Show Gist options
  • Save isSerge/7d2277638db6e59bc195be75a920b78a to your computer and use it in GitHub Desktop.
Save isSerge/7d2277638db6e59bc195be75a920b78a to your computer and use it in GitHub Desktop.
Subsquid timeout error
% make process
query: SELECT * FROM current_schema()
query: SELECT version();
query: SELECT * FROM "information_schema"."tables" WHERE "table_schema" = 'public' AND "table_name" = 'migrations'
query: SELECT * FROM "migrations" "migrations" ORDER BY "id" DESC
No migrations are pending
17:01:56 INFO sqd:processor last processed block was 99
17:01:56 INFO sqd:processor processing blocks from 100
17:01:56 DEBUG sqd:processor:archive-request http request
httpRequestId: 0
httpRequestUrl: https://archive.gemini-2a.subspace.network/api
httpRequestMethod: POST
httpRequestHeaders: [["content-type","application/json"],["x-squid-id","gen-u99PlCoM5k"]]
httpRequestBody: {"query":"query { status { head } }"}
17:01:57 DEBUG sqd:processor:archive-request http headers
httpRequestId: 0
httpResponseUrl: https://archive.gemini-2a.subspace.network/api
httpResponseStatus: 200
httpResponseHeaders: {}
17:01:57 DEBUG sqd:processor:archive-request http body
httpRequestId: 0
httpResponseBody: {"data":{"status":{"head":2444514}}}
17:01:57 INFO sqd:processor prometheus metrics are served at port 3000
17:01:57 DEBUG sqd:processor:archive-request http request
httpRequestId: 1
httpRequestUrl: https://archive.gemini-2a.subspace.network/api
httpRequestMethod: POST
httpRequestHeaders: [["content-type","application/json"],["x-squid-id","gen-u99PlCoM5k"]]
httpRequestBody: {"query":"query {\n status {\n head\n }\n batch(fromBlock: 100, toBlock: 2444514, includeAllBlocks: true, events: [{name: \"*\"}], calls: [{name: \"*\"}]) {\n header {\n id\n height\n hash\n parentHash\n timestamp\n specId\n stateRoot\n extrinsicsRoot\n validator\n }\n events\n calls\n extrinsics\n }\n}\n"}
17:02:17 WARN sqd:processor:archive-request request will be retried in 10 ms
httpRequestId: 1
reason: HttpTimeoutError: request timed out after 20000 ms
17:02:37 WARN sqd:processor:archive-request request will be retried in 100 ms
httpRequestId: 1
reason: HttpTimeoutError: request timed out after 20000 ms
17:02:57 WARN sqd:processor:archive-request request will be retried in 500 ms
httpRequestId: 1
reason: HttpTimeoutError: request timed out after 20000 ms
17:03:03 DEBUG sqd:processor:archive-request http headers
httpRequestId: 1
httpResponseUrl: https://archive.gemini-2a.subspace.network/api
httpResponseStatus: 200
httpResponseHeaders: {}
17:03:03 DEBUG sqd:processor:archive-request http body
httpRequestId: 1
httpResponseBody: {"data":null,"errors":[{"message":"pool timed out while waiting for an open connection","locations":[{"line":2,"column":5}],"path":["status"]}]}
17:03:03 FATAL sqd:processor GraphqlError: GraphQL error: pool timed out while waiting for an open connection
at ArchiveClient.graphqlRequest (/Users/apple/Documents/blockexplorer/squid-blockexplorer/node_modules/@subsquid/util-internal-http-client/lib/client.js:270:19)
at processTicksAndRejections (node:internal/process/task_queues:96:5)
at async /Users/apple/Documents/blockexplorer/squid-blockexplorer/node_modules/@subsquid/substrate-processor/lib/ingest.js:52:32
messages: [{"message":"pool timed out while waiting for an open connection","locations":[{"line":2,"column":5}],"path":["status"]}]
archiveQuery: query {
status {
head
}
batch(fromBlock: 100, toBlock: 2444514, includeAllBlocks: true, events: [{name: "*"}], calls: [{name: "*"}]) {
header {
id
height
hash
parentHash
timestamp
specId
stateRoot
extrinsicsRoot
validator
}
events
calls
extrinsics
}
}
batchRange: {"from":100}
archiveHeight: 2444514
make: *** [process] Error 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment