value "10000000000000000000000" is out of range for type bigint

[yangwao]

@ beta

coming from rubick

https://squid.subsquid.io/rubick/v/009-rc0/graphql

{
    "errors": [
        {
            "message": "value \"10000000000000000000000\" is out of range for type bigint",
            "locations": [
                {
                    "line": 2,
                    "column": 3
                }
            ],
            "path": [
                "events"
            ],
            "extensions": {
                "code": "INTERNAL_SERVER_ERROR",
                "exception": {
                    "query": "SELECT\n    DISTINCT ne.id as id,\n    ne.name as name,\n    ne.issuer as issuer,\n    ne.metadata as metadata,\n    e.current_owner,\n    me.image as image,\n    me.animation_url,\n    MAX(e.timestamp) as timestamp,\n    MAX(e.meta::bigint) as value,\n    ne.collection_id as collection_id,\n    ce.name as collection_name\n\nFROM event e\n    JOIN nft_entity ne on e.nft_id = ne.id\n    LEFT join metadata_entity me on me.id = ne.metadata\n    LEFT JOIN collection_entity ce on ne.collection_id = ce.id\nWHERE\n    e.interaction = $1\n    AND ne.burned = false\n    \nGROUP BY ne.id, me.id, e.current_owner, me.image, ce.name\nORDER BY MAX(e.timestamp) DESC\nLIMIT $2 OFFSET $3",
                    "parameters": [
                        "LIST",
                        30,
                        0
                    ],
                    "driverError": {
                        "length": 131,
                        "name": "error",
                        "severity": "ERROR",
                        "code": "22003",
                        "where": "parallel worker",
                        "file": "int8.c",
                        "line": "116",
                        "routine": "scanint8"
                    },
                    "length": 131,
                    "severity": "ERROR",
                    "code": "22003",
                    "where": "parallel worker",
                    "file": "int8.c",
                    "line": "116",
                    "routine": "scanint8",
                    "stacktrace": [
                        "QueryFailedError: value \"10000000000000000000000\" is out of range for type bigint",
                        "    at PostgresQueryRunner.query (/squid/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211:19)",
                        "    at runMicrotasks (<anonymous>)",
                        "    at processTicksAndRejections (node:internal/process/task_queues:96:5)",
                        "    at async DataSource.query (/squid/node_modules/typeorm/data-source/DataSource.js:341:20)",
                        "    at async EventResolver.lastEvent (/squid/lib/server-extension/resolvers/event.js:33:24)"
                    ]
                }
            }
        }
    ],
    "data": null
}

Close issue if it's reported or being solved

[roiLeo]

might be same fix as #4894

[yangwao]

related? haven't manage to see which query is it

[daiagi]

it comes from line 58 in useCarousel.ts

  const { data: dataRmrk2, loading: loadingRmrk2 } = useChainEvents(
    'rmrk2',
    type
  )

[daiagi]

@vikiival this has been fixed by commit kodadot/rubick@4d91deb
in rubick hasn't it?

need to change url in constants.ts or something?

[vikiival]

the problem is that subquery has sort of caching I already redeployed that without any success

[vikiival]

everything was fixed here related to issue:

• 191 big int energy rubick#192

[vikiival]

Made hard reset

🦑 Releasing the squid at git@github.com:kodadot/rubick.git#293e682b1be6645abf671e6f307ee741b5668ec5
◷ You may now detach from the build process by pressing Ctrl + C. The Squid deployment will continue uninterrupted.
◷ The new squid will be available as soon as the deployment is complete.
◷ Preparing your squid... ⡿

[daiagi]

✅ wfm