Open ThomasBlock opened 6 months ago
update: i changed rpc endpoint from besu to geth.
at first it did not boot:
[Nest] 16614 - 05/17/2024, 8:30:23 AM LOG [RouterExplorer] Mapped {/metrics, GET} route +2ms
getMinimumLiquidationCollateral null
[CRITICAL] unhandledRejection UpdateValuesMissingError: Cannot perform update query because update values are not defined. Call "qb.set(...)" method to specify updated values.
at UpdateQueryBuilder.createUpdateExpression (/root/ssv-liquidator/src/query-builder/UpdateQueryBuilder.ts:681:19)
at UpdateQueryBuilder.getQuery (/root/ssv-liquidator/src/query-builder/UpdateQueryBuilder.ts:53:21)
at UpdateQueryBuilder.getQueryAndParameters (/root/ssv-liquidator/src/query-builder/QueryBuilder.ts:507:28)
at UpdateQueryBuilder.execute (/root/ssv-liquidator/src/query-builder/UpdateQueryBuilder.ts:142:50)
at SystemService.save (/root/ssv-liquidator/src/modules/system/system.service.ts:39:7)
at WorkerService.onModuleInit (/root/ssv-liquidator/src/services/worker/worker.service.ts:20:5)
at async Promise.all (index 0)
at callModuleInitHook (/root/ssv-liquidator/node_modules/@nestjs/core/hooks/on-module-init.hook.js:43:5)
at NestApplication.callInitHook (/root/ssv-liquidator/node_modules/@nestjs/core/nest-application-context.js:224:13)
at NestApplication.init (/root/ssv-liquidator/node_modules/@nestjs/core/nest-application.js:98:9)
at NestApplication.listen (/root/ssv-liquidator/node_modules/@nestjs/core/nest-application.js:168:33)
at bootstrapApi (/root/ssv-liquidator/src/services/worker/worker.tsx:47:3)
at bootstrap (/root/ssv-liquidator/src/services/worker/worker.tsx:89:3)
i tried to delete data/local.db: better, but now it crashes after a minute
[Nest] 18023 - 05/17/2024, 8:40:31 AM LOG [NestApplication] Nest application successfully started +84ms
WebApp is running on port: 3000
Starting Liquidator worker
[Nest] 18023 - 05/17/2024, 8:40:31 AM LOG [NestFactory] Starting Nest application... +1ms
[Nest] 18023 - 05/17/2024, 8:40:32 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: system.type
[Nest] 18023 - 05/17/2024, 8:40:43 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 18023 - 05/17/2024, 8:41:35 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 18023 - 05/17/2024, 8:41:46 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 18023 - 05/17/2024, 8:42:24 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 18023 - 05/17/2024, 8:42:29 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 18023 - 05/17/2024, 8:42:35 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_BUSY: database is locked
[Nest] 18023 - 05/17/2024, 8:42:36 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_BUSY: database is locked
[Nest] 18023 - 05/17/2024, 8:42:37 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_BUSY: database is locked
QueryFailedError: SQLITE_BUSY: database is locked
at Statement.handler (/root/ssv-liquidator/src/driver/sqlite/SqliteQueryRunner.ts:113:26)
at Statement.replacement (/root/ssv-liquidator/node_modules/sqlite3/lib/trace.js:25:27) {
query: 'SELECT "System"."type" AS "System_type", "System"."payload" AS "System_payload" FROM "system" "System" WHERE ("System"."type" = ?) LIMIT 1',
parameters: [ 'GENERAL_LAST_BLOCK_NUMBER' ],
driverError: Error: SQLITE_BUSY: database is locked
--> in Database#all('SELECT "System"."type" AS "System_type", "System"."payload" AS "System_payload" FROM "system" "System" WHERE ("System"."type" = ?) LIMIT 1', [ 'GENERAL_LAST_BLOCK_NUMBER' ], [Function: handler])
at execute (/root/ssv-liquidator/src/driver/sqlite/SqliteQueryRunner.ts:77:46)
at /root/ssv-liquidator/src/driver/sqlite/SqliteQueryRunner.ts:137:19
at processTicksAndRejections (node:internal/process/task_queues:95:5) {
errno: 5,
code: 'SQLITE_BUSY',
__augmented: true
},
errno: 5,
code: 'SQLITE_BUSY',
__augmented: true
}
^C
lets try a nethermind node: seems unhealthy.. but at least IncorrectClusterState() is gone?
[Nest] 692 - 05/17/2024, 8:48:46 AM LOG [RouterExplorer] Mapped {/metrics, GET} route +2ms
[Nest] 692 - 05/17/2024, 8:48:46 AM LOG [NestApplication] Nest application successfully started +33ms
WebApp is running on port: 3000
Starting Liquidator worker
[Nest] 692 - 05/17/2024, 8:48:46 AM LOG [NestFactory] Starting Nest application... +2ms
[Nest] 692 - 05/17/2024, 8:48:47 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: system.type
[Nest] 692 - 05/17/2024, 8:48:54 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 692 - 05/17/2024, 8:48:55 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 692 - 05/17/2024, 8:49:25 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 692 - 05/17/2024, 8:49:31 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 692 - 05/17/2024, 8:49:33 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 692 - 05/17/2024, 8:50:05 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 692 - 05/17/2024, 8:50:08 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 692 - 05/17/2024, 8:50:18 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 692 - 05/17/2024, 8:50:19 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 692 - 05/17/2024, 8:50:43 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 692 - 05/17/2024, 8:50:44 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 692 - 05/17/2024, 8:50:48 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_BUSY: database is locked
[Nest] 692 - 05/17/2024, 8:50:49 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_BUSY: database is locked
[Nest] 692 - 05/17/2024, 8:50:56 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 692 - 05/17/2024, 8:50:58 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
[Nest] 692 - 05/17/2024, 8:51:12 AM ERROR [FetchTask] Sync updates error: QueryFailedError: SQLITE_CONSTRAINT: UNIQUE constraint failed: cluster.owner, cluster.operatorIds
Hi. I ran a testnet liquidator without problems i have my mainnet liquidator ruuning, but i am not sure if it is operational.. running two weeks without a liquidation
how can i fix
IncorrectClusterState
orcriticalStatus{app="liquidation-cli"} 1
?log:
and then i see a lot more of IncorrectClusterState in my logs..
metrics: