Skip to content
This repository has been archived by the owner on Jun 19, 2024. It is now read-only.

Error when syncing: Duplicate keys #17

Closed
bengtlofgren opened this issue Oct 10, 2023 · 0 comments · Fixed by #25
Closed

Error when syncing: Duplicate keys #17

bengtlofgren opened this issue Oct 10, 2023 · 0 comments · Fixed by #25

Comments

@bengtlofgren
Copy link
Contributor

When running the indexer, I sometimes run into:

Error: DB(Database(PgDatabaseError { severity: Error, code: "42P16", message: "multiple primary keys for table \"blocks\" are not allowed", detail: None, hint: None, position: None, where: None, schema: None, table: None, column: None, data_type: None, constraint: None, file: Some("index.c"), line: Some(223), routine: Some("index_check_primary_key") }))
make: *** [run_indexer] Error 1

and i can get around it by running the indexer again using make run_indexer. Any ideas as to why this happens/how it can be resolved?
@bengtlofgren bengtlofgren changed the title Duplicate keys: Error when syncing Error when syncing: Duplicate keys Oct 10, 2023
@rllola rllola mentioned this issue Oct 17, 2023
Merged
rllola added a commit that referenced this issue Oct 17, 2023
@rllola
fix: duplicate keys (#25)
948d647 
closes #17 

Fixing the query to determine if we have indexes or not on the blocks
table.
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

fix: duplicate keys Zondax/namadexer
1 participant
@bengtlofgren