🐛 Ada holder voting power does not take into account unclaimed rewards OR gov action deposits paid

[Ryun1]

Area

Delegation Pillar

Domain

gov.tools

Which wallet were you using?

No response

Context

• Ada holder voting power is equal to;
  • total of lovelace UTxOs controlled by the stake account
  • total of unclaimed lovelace from the reward account (from staking rewards or treasury withdrawals)
  • total lovelace locked for governance action deposit
• see example stake credential (mine)
  • e1130796e23f5c56594f50ace2c3240923219fc69ee2cb6e2c8facec68

Steps to reproduce

1. check voting power for e1130796e23f5c56594f50ace2c3240923219fc69ee2cb6e2c8facec68

Actual behavior

resulting value it: wallet balance - unclaimed rewards

Expected behavior

resulting value it: wallet balance + unclaimed rewards

[bosko-m]

Im putting a P0 on this @Ryun1 .

[MSzalowski]

Fix candidate: #2145

I still look for another tables to collect the remaining lovelaces

[spannercode]

The current issue seems to be unsynced utxo_view of the dbsync. This has happened before. It might have been reverted when dbsync was upgraded.

Deleting the existing the utxo_view and recreating should fix the issue (excluding the unclaimed rewards part).
CC: @bosko-m