Crash due to integer out of range
Another crash cause
processor-1 | {"level":5,"time":1729200054142,"ns":"sqd:processor","err":{"stack":"QueryFailedError: value \"2163069901\" is out of range for type integer\n at PostgresQueryRunner.query (/squid/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async InsertQueryBuilder.execute (/squid/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)\n at async StoreWithCache.insert (/squid/node_modules/.pnpm/@subsquid+typeorm-store@1.5.1_@subsquid+big-decimal@1.0.0_typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5_/node_modules/@subsquid/typeorm-store/lib/store.js:88:17)\n at async /squid/node_modules/.pnpm/@belopash+typeorm-store@1.5.0_@subsquid+typeorm-config@4.1.1_typeorm@0.3.20_ioredis@5.4.1_pg@_yb6gpcigrhh2fl26pnhshf3tbu/node_modules/@belopash/typeorm-store/lib/store.js:219:21","query":"INSERT INTO \"universal_dividend\"(\"id\", \"block_number\", \"timestamp\", \"amount\", \"monetary_mass\", \"members_count\", \"event_id\") VALUES ($1, $2, $3, $4, $5, $6, $7)","parameters":["0003501642-13521-000001",3501642,"2024-10-17T21:20:54.001Z",2163069901,"841340712106256",2944,"0003501642-13521-000001"],"driverError":{"stack":"error: value \"2163069901\" is out of range for type integer\n at /squid/node_modules/.pnpm/pg@8.11.5/node_modules/pg/lib/client.js:526:17\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async PostgresQueryRunner.query (/squid/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:184:25)\n at async InsertQueryBuilder.execute (/squid/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)\n at async StoreWithCache.insert (/squid/node_modules/.pnpm/@subsquid+typeorm-store@1.5.1_@subsquid+big-decimal@1.0.0_typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5_/node_modules/@subsquid/typeorm-store/lib/store.js:88:17)\n at async /squid/node_modules/.pnpm/@belopash+typeorm-store@1.5.0_@subsquid+typeorm-config@4.1.1_typeorm@0.3.20_ioredis@5.4.1_pg@_yb6gpcigrhh2fl26pnhshf3tbu/node_modules/@belopash/typeorm-store/lib/store.js:219:21","length":148,"name":"error","severity":"ERROR","code":"22003","where":"unnamed portal parameter $4 = '...'","file":"numutils.c","line":"226","routine":"pg_strtoint32"},"length":148,"severity":"ERROR","code":"22003","where":"unnamed portal parameter $4 = '...'","file":"numutils.c","line":"226","routine":"pg_strtoint32"}}{
"level": 5,
"time": 1729200054142,
"ns": "sqd:processor",
"err": {
"stack": "QueryFailedError: value \"2163069901\" is out of range for type integer\n at PostgresQueryRunner.query (/squid/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async InsertQueryBuilder.execute (/squid/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)\n at async StoreWithCache.insert (/squid/node_modules/.pnpm/@subsquid+typeorm-store@1.5.1_@subsquid+big-decimal@1.0.0_typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5_/node_modules/@subsquid/typeorm-store/lib/store.js:88:17)\n at async /squid/node_modules/.pnpm/@belopash+typeorm-store@1.5.0_@subsquid+typeorm-config@4.1.1_typeorm@0.3.20_ioredis@5.4.1_pg@_yb6gpcigrhh2fl26pnhshf3tbu/node_modules/@belopash/typeorm-store/lib/store.js:219:21",
"query": "INSERT INTO \"universal_dividend\"(\"id\", \"block_number\", \"timestamp\", \"amount\", \"monetary_mass\", \"members_count\", \"event_id\") VALUES ($1, $2, $3, $4, $5, $6, $7)",
"parameters": [
"0003501642-13521-000001",
3501642,
"2024-10-17T21:20:54.001Z",
2163069901,
"841340712106256",
2944,
"0003501642-13521-000001"
],
"driverError": {
"stack": "error: value \"2163069901\" is out of range for type integer\n at /squid/node_modules/.pnpm/pg@8.11.5/node_modules/pg/lib/client.js:526:17\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async PostgresQueryRunner.query (/squid/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:184:25)\n at async InsertQueryBuilder.execute (/squid/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)\n at async StoreWithCache.insert (/squid/node_modules/.pnpm/@subsquid+typeorm-store@1.5.1_@subsquid+big-decimal@1.0.0_typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5_/node_modules/@subsquid/typeorm-store/lib/store.js:88:17)\n at async /squid/node_modules/.pnpm/@belopash+typeorm-store@1.5.0_@subsquid+typeorm-config@4.1.1_typeorm@0.3.20_ioredis@5.4.1_pg@_yb6gpcigrhh2fl26pnhshf3tbu/node_modules/@belopash/typeorm-store/lib/store.js:219:21",
"length": 148,
"name": "error",
"severity": "ERROR",
"code": "22003",
"where": "unnamed portal parameter $4 = '...'",
"file": "numutils.c",
"line": "226",
"routine": "pg_strtoint32"
},
"length": 148,
"severity": "ERROR",
"code": "22003",
"where": "unnamed portal parameter $4 = '...'",
"file": "numutils.c",
"line": "226",
"routine": "pg_strtoint32"
}
}QueryFailedError: value "2163069901" is out of range for type integer
at PostgresQueryRunner.query (/squid/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async InsertQueryBuilder.execute (/squid/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)
at async StoreWithCache.insert (/squid/node_modules/.pnpm/@subsquid+typeorm-store@1.5.1_@subsquid+big-decimal@1.0.0_typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5_/node_modules/@subsquid/typeorm-store/lib/store.js:88:17)
at async /squid/node_modules/.pnpm/@belopash+typeorm-store@1.5.0_@subsquid+typeorm-config@4.1.1_typeorm@0.3.20_ioredis@5.4.1_pg@_yb6gpcigrhh2fl26pnhshf3tbu/node_modules/@belopash/typeorm-store/lib/store.js:219:21