Skip to content

Instantly share code, notes, and snippets.

@Maxservais
Created August 26, 2025 09:38
Show Gist options
  • Select an option

  • Save Maxservais/bf91daafd2e9c7072a59897c56b96ffc to your computer and use it in GitHub Desktop.

Select an option

Save Maxservais/bf91daafd2e9c7072a59897c56b96ffc to your computer and use it in GitHub Desktop.
[bitusd-indexer] [2025-08-26 09:36:19] [09:36:19.345] INFO: handling block
[bitusd-indexer] [2025-08-26 09:36:19] component: "container"
[bitusd-indexer] [2025-08-26 09:36:19] indexer: "sepolia"
[bitusd-indexer] [2025-08-26 09:36:19] blockNumber: 1722828
[bitusd-indexer] [2025-08-26 09:36:19] [09:36:19.347] ERROR: error occurred during block processing
[bitusd-indexer] [2025-08-26 09:36:19] component: "container"
[bitusd-indexer] [2025-08-26 09:36:19] indexer: "sepolia"
[bitusd-indexer] [2025-08-26 09:36:19] blockNumber: 1722828
[bitusd-indexer] [2025-08-26 09:36:19] err: {
[bitusd-indexer] [2025-08-26 09:36:19] "type": "DatabaseError",
[bitusd-indexer] [2025-08-26 09:36:19] "message": "insert into \"_blocks\" (\"block_number\", \"hash\", \"indexer\") values ($1, $2, $3) - duplicate key value violates unique constraint \"_blocks_pkey\"",
[bitusd-indexer] [2025-08-26 09:36:19] "stack":
[bitusd-indexer] [2025-08-26 09:36:19] error: insert into "_blocks" ("block_number", "hash", "indexer") values ($1, $2, $3) - duplicate key value violates unique constraint "_blocks_pkey"
[bitusd-indexer] [2025-08-26 09:36:19] at Parser.parseErrorMessage (/workspace/node_modules/pg-protocol/dist/parser.js:287:98)
[bitusd-indexer] [2025-08-26 09:36:19] at Parser.handlePacket (/workspace/node_modules/pg-protocol/dist/parser.js:126:29)
[bitusd-indexer] [2025-08-26 09:36:19] at Parser.parse (/workspace/node_modules/pg-protocol/dist/parser.js:39:38)
[bitusd-indexer] [2025-08-26 09:36:19] at TLSSocket.<anonymous> (/workspace/node_modules/pg-protocol/dist/index.js:11:42)
[bitusd-indexer] [2025-08-26 09:36:19] at TLSSocket.emit (node:events:518:28)
[bitusd-indexer] [2025-08-26 09:36:19] at addChunk (node:internal/streams/readable:561:12)
[bitusd-indexer] [2025-08-26 09:36:19] at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
[bitusd-indexer] [2025-08-26 09:36:19] at Readable.push (node:internal/streams/readable:392:5)
[bitusd-indexer] [2025-08-26 09:36:19] at TLSWrap.onStreamRead (node:internal/stream_base_commons:189:23)
[bitusd-indexer] [2025-08-26 09:36:19] "length": 220,
[bitusd-indexer] [2025-08-26 09:36:19] "name": "error",
[bitusd-indexer] [2025-08-26 09:36:19] "severity": "ERROR",
[bitusd-indexer] [2025-08-26 09:36:19] "code": "23505",
[bitusd-indexer] [2025-08-26 09:36:19] "detail": "Key (indexer, block_number)=(sepolia, 1722828) already exists.",
[bitusd-indexer] [2025-08-26 09:36:19] "schema": "public",
[bitusd-indexer] [2025-08-26 09:36:19] "table": "_blocks",
[bitusd-indexer] [2025-08-26 09:36:19] "constraint": "_blocks_pkey",
[bitusd-indexer] [2025-08-26 09:36:19] "file": "nbtinsert.c",
[bitusd-indexer] [2025-08-26 09:36:19] "line": "666",
[bitusd-indexer] [2025-08-26 09:36:19] "routine": "_bt_check_unique"
[bitusd-indexer] [2025-08-26 09:36:19] }
[bitusd-indexer] [2025-08-26 09:36:21] [09:36:20.815] INFO: handling block
[bitusd-indexer] [2025-08-26 09:36:21] component: "container"
[bitusd-indexer] [2025-08-26 09:36:21] indexer: "sepolia"
[bitusd-indexer] [2025-08-26 09:36:21] blockNumber: 1722828
[bitusd-indexer] [2025-08-26 09:36:21] [09:36:20.818] ERROR: error occurred during block processing
[bitusd-indexer] [2025-08-26 09:36:21] component: "container"
[bitusd-indexer] [2025-08-26 09:36:21] indexer: "sepolia"
[bitusd-indexer] [2025-08-26 09:36:21] blockNumber: 1722828
[bitusd-indexer] [2025-08-26 09:36:21] err: {
[bitusd-indexer] [2025-08-26 09:36:21] "type": "DatabaseError",
[bitusd-indexer] [2025-08-26 09:36:21] "message": "insert into \"_blocks\" (\"block_number\", \"hash\", \"indexer\") values ($1, $2, $3) - duplicate key value violates unique constraint \"_blocks_pkey\"",
[bitusd-indexer] [2025-08-26 09:36:21] "stack":
[bitusd-indexer] [2025-08-26 09:36:21] error: insert into "_blocks" ("block_number", "hash", "indexer") values ($1, $2, $3) - duplicate key value violates unique constraint "_blocks_pkey"
[bitusd-indexer] [2025-08-26 09:36:21] at Parser.parseErrorMessage (/workspace/node_modules/pg-protocol/dist/parser.js:287:98)
[bitusd-indexer] [2025-08-26 09:36:21] at Parser.handlePacket (/workspace/node_modules/pg-protocol/dist/parser.js:126:29)
[bitusd-indexer] [2025-08-26 09:36:21] at Parser.parse (/workspace/node_modules/pg-protocol/dist/parser.js:39:38)
[bitusd-indexer] [2025-08-26 09:36:21] at TLSSocket.<anonymous> (/workspace/node_modules/pg-protocol/dist/index.js:11:42)
[bitusd-indexer] [2025-08-26 09:36:21] at TLSSocket.emit (node:events:518:28)
[bitusd-indexer] [2025-08-26 09:36:21] at addChunk (node:internal/streams/readable:561:12)
[bitusd-indexer] [2025-08-26 09:36:21] at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
[bitusd-indexer] [2025-08-26 09:36:21] at Readable.push (node:internal/streams/readable:392:5)
[bitusd-indexer] [2025-08-26 09:36:21] at TLSWrap.onStreamRead (node:internal/stream_base_commons:189:23)
[bitusd-indexer] [2025-08-26 09:36:21] "length": 220,
[bitusd-indexer] [2025-08-26 09:36:21] "name": "error",
[bitusd-indexer] [2025-08-26 09:36:21] "severity": "ERROR",
[bitusd-indexer] [2025-08-26 09:36:21] "code": "23505",
[bitusd-indexer] [2025-08-26 09:36:21] "detail": "Key (indexer, block_number)=(sepolia, 1722828) already exists.",
[bitusd-indexer] [2025-08-26 09:36:21] "schema": "public",
[bitusd-indexer] [2025-08-26 09:36:21] "table": "_blocks",
[bitusd-indexer] [2025-08-26 09:36:21] "constraint": "_blocks_pkey",
[bitusd-indexer] [2025-08-26 09:36:21] "file": "nbtinsert.c",
[bitusd-indexer] [2025-08-26 09:36:21] "line": "666",
[bitusd-indexer] [2025-08-26 09:36:21] "routine": "_bt_check_unique"
[bitusd-indexer] [2025-08-26 09:36:21] }
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment