IntersectMBO / cardano-db-sync

A component that follows the Cardano chain and stores blocks and transactions in PostgreSQL
Apache License 2.0
290 stars 162 forks source link

Unique key in pool_metadata_ref causes missing metadata #1714

Closed kderme closed 3 months ago

kderme commented 4 months ago

An example where this bug occurs is pool pool1ndxf966uknq89g8xvurh0cduskr2yq4ua678qt5pkyc4u6eq0mv in preprod. It has 3 certificate, let's call them A B and A again. The second time A is submitted, it's metadata is not inserted because of the unique key. Smash assumes that B is the latest submitted metadata, so it never tries to fetch A again.

kderme commented 3 months ago

Done by https://github.com/IntersectMBO/cardano-db-sync/pull/1757