search

fetchai / ledger-subquery

This is the Fetch Ledger SubQuery project, an indexer for the Fetch network.
MIT License
2 stars 10 forks source link

Unexpected behavior in mainnet preview environment #188

Closed bryanchriswhite closed 1 year ago

bryanchriswhite commented 1 year ago

Background (WIP)

The GQL API will serve the playground UI but hangs while responding to any query.

The Subquery node seems to slow down in its progression through blocks and may even be experiencing restarts.

manjeet-fetchai commented 1 year ago

Observations:

Database:

2022-11-17 10:23:36.935 UTC [1] LOG:  database system is ready to accept connections
2022-11-21 00:22:34.439 UTC [16193] LOG:  unexpected EOF on client connection with an open transaction
2022-11-23 10:27:20.825 UTC [24969] LOG:  unexpected EOF on client connection with an open transaction
2022-11-07 16:36:18.581 UTC [20330] FATAL:  connection to client lost
2022-11-07 16:36:18.581 UTC [20330] STATEMENT:  WITH ranges AS (  SELECT pg_range.rngtypid, pg_type.typname AS rngtypname,         pg_type.typarray AS rngtyparray, pg_range.rngsubtype    FROM pg_range LEFT OUTER JOIN pg_type ON pg_type.oid = pg_range.rngtypid)SELECT pg_type.typname, pg_type.typtype, pg_type.oid, pg_type.typarray,       ranges.rngtypname, ranges.rngtypid, ranges.rngtyparray  FROM pg_type LEFT OUTER JOIN ranges ON pg_type.oid = ranges.rngsubtype WHERE (pg_type.typtype IN('b', 'e'));
2022-11-08 01:33:14.494 UTC [24443] LOG:  could not receive data from client: Connection reset by peer

Subquery Node:

2022-11-17T09:04:51.522Z <health> ERROR Indexer is not healthy
2022-11-17T09:05:01.547Z <health> ERROR Indexer is not healthy
2022-11-17T09:05:02.305Z <benchmark> INFO 0.00 bps, target: #8530213, current: #8479286, estimate time: unknown