IntersectMBO / IntersectMBO/cardano-db-sync
drep_distr table data discrepancy between seemingly identical 13.6.0.5/10.1.4 setups
- Dominant language
- Haskell
- Stars
- 318
- Forks
- 168
- PR merge metrics
- No merged PRs in 30d
Description
**OS**
Your OS: Debian 12
**Versions**
The `db-sync` version (eg `cardano-db-sync --version`):
PostgreSQL version: cardano-db-sync 13.6.0.5 - linux-x86_64 - ghc-8.10
git revision cb61094c82254464fc9de777225e04d154d9c782
**Build/Install Method**
The method you use to build or install `cardano-db-sync`:
Provided continuous-integration binaries
**Run method**
The method you used to run `cardano-db-sync` (eg Nix/Docker/systemd/none):
systemd
**Additional context**
The discrepancy was first reported for drep with id drep1yttcav7gh3xlkqd876gmgma32c7qj555ajnn3fnp9kl6l4g97vcyz , but later when comparing the drep_distr values between couple of similar setups (same version of node and db sync), the earlier discrepancy I discovered was in epoch 538, involving drep with id drep1ytuvz8hq2qmcdvy9rs4erpfhge5gypfut9yva9tjj2vw66g73ge5q. On the problematic instance, the drep's voting power was reported as being between 1k and 2k Ada, meanwhile on all the others I saw it was between 1 and 2 million Ada.
For epoch 538, drep_distr value of 1,093,348,347,589 in 'good' db, 1,476,287,731 in 'problematic' one.
Epoch stake entries for the 1m stake account that's delegating to this drep seem to be the same on both instances. as do epoch_stake amounts for all stake accounts (11) delegating to that drep for epochs 536 -> 540
cardano-cli conway query drep-stake-distribution output on both machines returns the same value for that drep.
Difference between epoch's sum of voting power (group by epoch_no of drep_distr table data) was 1.09 mil at 538, and was up to 2 million at epoch 554
Contributor guide
Assessment
This issue has not been assessed yet.