GIVpower is acting strange

[divine-comedian]

We've had several user reports of GIVpower acting strange.

Some projects not changing rank at the beginning of a new round, when the estimate has show for several rounds that the project's rank would increase. Several projects have their estimated rank the same as many other projects.

Some projects or specific boosting have their amount shows as NaN

@RamRamez Did some investigation and here are his findings:

This is the first time I'm working on Givpower, the logic is complicated and I'm reading the codes trying to understand.

Different tables are involved in calculating givpower rank:

power_snapshot
power_round
power_balance_snapshot
power_boosting_snapshot
project_power_view
last_snapshot_project_power_view
user_project_power_view
project_user_instant_power_view

etc...

The problem in staging is the totalPower field is zero for all projects in project_power_view table.

project_power_view table is a materialized view calculating totalPower by having power_balance_snapshot, power_boosting_snapshot and power_snapshot tables.

The current power round is 44197 but we don't have this roundNumber in power_snapshot table. The newest round in power_snapshot table is 35864 and we don't have any data for rounds after that.

Also other tables like power_balance_snapshot and power_boosting_snapshot have data until 35864 round, and there's no data for rounds after that.

We should investigate further, find out what's wrong with GIVpower and execute the required fixes to bring it back to normal.

cc: @laurenluz

[aminlatifi]

The problem was a wrong power boosting record from a user who never have had a positive givpower balance 0xa198b3e3028882122d6365a2290906074aad3431

I removed his boosting record and the state would be fine after the cronjob is executed again.

[aminlatifi]

Giveth/impact-graph#1655

[aminlatifi]

@RamRamez staging issue must be fixed now. The issue was database name was changed from staging -> staging2 and the db cron job was not updated to point to that db.

[RamRamez]

@aminlatifi the totalPower in projectPowerView is still zero for all projects on staging and givPower is not shown on UI.

Maybe we should refresh all views manually?

https://staging.giveth.io/project/a-delicious-help?tab=givpower

[aminlatifi]

@aminlatifi the totalPower in projectPowerView is still zero for all projects on staging and givPower is not shown on UI.

Maybe we should refresh all views manually?

https://staging.giveth.io/project/a-delicious-help?tab=givpower

It's fixed now. It need some time

[RamRamez]

@aminlatifi totalPower is still zero for all projects. Also UI not showing the GIVPower.

[mohammadranjbarz]

@aminlatifi totalPower is still zero for all projects. Also UI not showing the GIVPower.

@RamRamez Are you sure? It's ok for my project

[aminlatifi]

Staging balance aggregator has issue in querying subgraph

Fetch id 0xdaea66adc97833781139373df5b3bced3fdda5b1-100 - subgraph url https://api.studio.thegraph.com/query/76292/giveconomy-staging-gnosischain/version/latest - last update time 1719241855 - skip 0 - take 500 |  
-- | --
  |   | [Nest] 1  - 06/26/2024, 8:50:34 AM   DEBUG [FetchAgent] |  
  |   | [Nest] 1  - 06/26/2024, 8:50:34 AM   DEBUG [FetchAgent] Fetching id 0xdaea66adc97833781139373df5b3bced3fdda5b1-100 |  
  |   | [Nest] 1  - 06/26/2024, 8:50:25 AM   ERROR [FetchAgent] AxiosError: Request failed with status code 410 |  
  |   | [Nest] 1  - 06/26/2024, 8:50:25 AM   ERROR [FetchAgent] Error on fetch id 0x632ac305ed88817480d12155a7f1244cc182c298-420 -

@mhmdksh can you look at this?

[RamRamez]

@aminlatifi totalPower is still zero for all projects. Also UI not showing the GIVPower.

@RamRamez Are you sure? It's ok for my project

@mohammadranjbarz GIVPower not showing is on staging only

[aminlatifi]

@aminlatifi totalPower is still zero for all projects. Also UI not showing the GIVPower.

@RamRamez Are you sure? It's ok for my project

@mohammadranjbarz GIVPower not showing is on staging only

It's fixed now.

[RamRamez]

@aminlatifi Thanks, it's ok now

[maryjaf]

Some projects not changing rank at the beginning of a new round, when the estimate has show for several rounds that the project's rank would increase. Several projects have their estimated rank the same as many other projects.

The rank of this project changed to 19

https://giveth.io/project/diamante-luz-center-for-regenerative-living-0?tab=givpower