search

0xPolygonHermez / zkevm-node

Go implementation of a node that operates the Polygon zkEVM Network
Other
531 stars 685 forks source link

error: ERROR: duplicate key value violates unique constraint "transaction_pkey" (SQLSTATE 23505) #3498

Open yuanwj210 opened 6 months ago

yuanwj210 commented 6 months ago

hermeznetwork/zkevm-node:v0.6.4 hermeznetwork/zkevm-prover:v6.0.0 ERROR synchronizer/synchronizer.go:627 error: ERROR: duplicate key value violates unique constraint "transaction_pkey" (SQLSTATE 23505)

yuanwj210 commented 6 months ago

zkevm-state-db | 2024-03-25 05:31:57.937 UTC [27] LOG: checkpoint starting: time zkevm-state-db | 2024-03-25 05:32:05.031 UTC [576718] ERROR: duplicate key value violates unique constraint "transaction_pkey" zkevm-state-db | 2024-03-25 05:32:05.031 UTC [576718] DETAIL: Key (hash)=(0x43dd482c92bca3df462e6f69cbdeb8cfdef913335b80064c87f6e06cca4dc855) already exists. zkevm-state-db | 2024-03-25 05:32:05.031 UTC [576718] CONTEXT: COPY transaction, line 7 zkevm-state-db | 2024-03-25 05:32:05.031 UTC [576718] STATEMENT: copy "state"."transaction" ( "hash", "encoded", "decoded", "l2_block_num", "effective_percentage", "egp_log", "l2_hash" ) from stdin binary;

yuanwj210 commented 6 months ago

@fgimenez