🐛 SPO vote total on mainnet is incorrect

[Ryun1]

Area

Voting Pillar

Domain

gov.tools

Which wallet were you using?

No response

Context

• GovTool SPO vote totals for Plomin hardfork action are incorrect
  • https://gov.tools/governance_actions/0b19476e40bbbb5e1e8ce153523762e2b6859e7ecacbaf06eae0ee6a447e79b9#0
• when compared to other tooling
  • https://adastat.net/governances/0b19476e40bbbb5e1e8ce153523762e2b6859e7ecacbaf06eae0ee6a447e79b900

Steps to reproduce

Go to https://gov.tools/governance_actions/0b19476e40bbbb5e1e8ce153523762e2b6859e7ecacbaf06eae0ee6a447e79b9#0

compare to https://adastat.net/governances/0b19476e40bbbb5e1e8ce153523762e2b6859e7ecacbaf06eae0ee6a447e79b900

Actual behavior

very misaligned values

Expected behavior

very similar values

[Ryun1]

Is SPO vote totals, calculated on the fly or once per epoch?

[MSzalowski]

Once per epoch

[Ryun1]

The next boundary is tomorrow night
so lets wait see on Friday if the totals between GovTool and other sites are closer aligned

[MSzalowski]

We have a bug. We are using drep_distr amounts for calculating the total stake for spos but as table name states drep_distr is for DReps not SPOs, meaning the values taken from that table wouldn't be correct even after next boundary.

It looks like it is quite critical bug, that we should address as P0, and push it to main ASAP.

What do you think @bosko-m ?