search

terra-money / fcd-classic

Terra ETL + RestFul API Server
https://fcd.terra.dev/swagger
MIT License
63 stars 40 forks source link

Collector: ON CONFLICT DO UPDATE command cannot affect row a second time #179

Open rootedbox opened 2 years ago

rootedbox commented 2 years ago

The collector got stuck in an endless loop on block 7549547.. only thing I could do was insert a record in the block table manually for 7549547 so that it would keep going.

05-09 19:18 [INFO]: collectBlock: begin transaction for block 7549547 05-09 19:18 [ERROR]: ON CONFLICT DO UPDATE command cannot affect row a second time QueryFailedError: ON CONFLICT DO UPDATE command cannot affect row a second time at QueryFailedError.TypeORMError [as constructor] (/home/kuser/app/fcd/src/error/TypeORMError.ts:7:9) at new QueryFailedError (/home/kuser/app/fcd/src/error/QueryFailedError.ts:9:9) at PostgresQueryRunner. (/home/kuser/app/fcd/src/driver/postgres/PostgresQueryRunner.ts:263:19) at step (/home/kuser/app/fcd/node_modules/typeorm/node_modules/tslib/tslib.js:143:27) at Object.throw (/home/kuser/app/fcd/node_modules/typeorm/node_modules/tslib/tslib.js:124:57) at rejected (/home/kuser/app/fcd/node_modules/typeorm/node_modules/tslib/tslib.js:115:69) at runMicrotasks () at processTicksAndRejections (internal/process/task_queues.js:95:5)