Pages: [1]
donkoch
BAM!ID: 177292
Joined: 2014-12-19
Posts: 3
Credits: 77,867,697
World-rank: 13,727

2025-06-09 15:38:07

BOINC stats for any project only shows the same 186 users. I'm guessing that any user not in that list is getting the "User ID doesn't exist in or doesn't have any credit." mesage.
I think this qualifies as a bug.
donkoch
BAM!ID: 177292
Joined: 2014-12-19
Posts: 3
Credits: 77,867,697
World-rank: 13,727

2025-06-09 15:39:33

Even the forums show a positive point count. Makes me think it's a web issue rather than a database issue.
Stony666
 
BAM!ID: 2330
Joined: 2006-06-18
Posts: 4
Credits: 14,192,260,157
World-rank: 311

2025-06-09 16:59:21

Hi,

the members of the teams are mixed up, klicking in team members schows different team and many more...
gemini8
Forum moderator - Tester - Volunteer tester
BAM!ID: 101557
Joined: 2011-06-14
Posts: 112
Credits: 4,995,009,091
World-rank: 685

2025-06-09 17:32:20

No need to panic.
Boincstats is encountering issues due to some database mayhem.
There has been work on it, but it overlapped with the daily statistics update.
Nothing can be done about the stats immediately.
If the fixes done work out nicely everything should be fine tomorrow around this time of day.
If not, there will be additional maintainance.
- - - - - - - - - - -
Greetings, Jens
Stony666
 
BAM!ID: 2330
Joined: 2006-06-18
Posts: 4
Credits: 14,192,260,157
World-rank: 311

2025-06-09 18:12:28

gemini8 wrote:

No need to panic.
Boincstats is encountering issues due to some database mayhem.
There has been work on it, but it overlapped with the daily statistics update.
Nothing can be done about the stats immediately.
If the fixes done work out nicely everything should be fine tomorrow around this time of day.
If not, there will be additional maintainance.

Hi Jens,

thx for the info.
Hope to see you in august in Dresden again.
Bye Jörg
[BOINCstats] Willy
 
Forum moderator - Administrator - Developer - Tester - Translator
BAM!ID: 1
Joined: 2006-01-09
Posts: 9452
Credits: 353,172,950
World-rank: 4,955

2025-06-09 18:20:56

Is it still messed up? Because it should be fine now.
Please do not PM, IM or email me for support (they will go unread/ignored). Use the forum for support.
TPCBF
BAM!ID: 94441
Joined: 2010-12-21
Posts: 189
Credits: 0
World-rank: 0

2025-06-09 18:34:39

[BOINCstats Willy wrote:

Is it still messed up? Because it should be fine now.
Beside some weird negative numbers in the top BOINC Combined row, it seems to be fine again...
Aurimas
 
BAM!ID: 84116
Joined: 2010-04-13
Posts: 46
Credits: 2,094,410,488
World-rank: 1,342

2025-06-09 20:10:56
last modified: 2025-06-09 20:14:38

[BOINCstats Willy wrote:

Is it still messed up? Because it should be fine now.

I still have -200,585,407 and 630 world positions up at this time, that indicates, that other users also have problems wit credits.

https://www.boincstats.com/stats/-1/user/detail/13056/lastDays

Looks like ALL points of RETIRED projects is gone.

[BOINCstats] Willy
 
Forum moderator - Administrator - Developer - Tester - Translator
BAM!ID: 1
Joined: 2006-01-09
Posts: 9452
Credits: 353,172,950
World-rank: 4,955

2025-06-09 21:35:05

I'll have it sorted out first thing tomorrow morning..
Please do not PM, IM or email me for support (they will go unread/ignored). Use the forum for support.
Cruncher Pete
 
BAM!ID: 241537
Joined: 2021-11-03
Posts: 20
Credits: 660,210,921,683
World-rank: 9

2025-06-10 01:19:19

I am still down 653Billion .
[BOINCstats] Willy
 
Forum moderator - Administrator - Developer - Tester - Translator
BAM!ID: 1
Joined: 2006-01-09
Posts: 9452
Credits: 353,172,950
World-rank: 4,955

2025-06-10 05:19:12

It's also not yet tomorrow morning here.
Please do not PM, IM or email me for support (they will go unread/ignored). Use the forum for support.
[BOINCstats] Willy
 
Forum moderator - Administrator - Developer - Tester - Translator
BAM!ID: 1
Joined: 2006-01-09
Posts: 9452
Credits: 353,172,950
World-rank: 4,955

2025-06-10 08:45:39

Repairs complete, stats are back to normal.

So what happened?

The MySQL version that BOINCstats runs on (5.7) has been declared end-of-life by Google Cloud, with the recommendation to upgrade to a new version. If not, some extra costs could be charged. I wasn't particularly keen on the upgrade since I'm almost end-of-life myself. So I didn't do it, but those extra costs turned out to be over €200 per month, which is a bit too much for me. That's why I spent this weekend trying to upgrade to the new version. This failed repeatedly (reasons complicated), so I ultimately decided not to upgrade but to migrate to the new MySQL 8.0. This worked, and through a brainwave, I decided not to switch everything over at once, but to also run the updates on the old 5.7 server. And that was lucky because MySQL 8 is stricter than MySQL 5.7, and inserting the retired projects failed on 8.0. However, because I also did the update on 5.7, I was able to transfer everything from 5.7 to 8.0. As a result, all the data is 100% correct again.
The update has since been adjusted and should now work fine on 8.0, but to be safe, I'm letting 5.7 run alongside it for a bit longer. Unfortunately, that costs something, but it's necessary for now.
Please do not PM, IM or email me for support (they will go unread/ignored). Use the forum for support.
Aurimas
 
BAM!ID: 84116
Joined: 2010-04-13
Posts: 46
Credits: 2,094,410,488
World-rank: 1,342

2025-06-10 14:05:24

[BOINCstats Willy wrote:

Repairs complete, stats are back to normal.

So what happened?

The MySQL version that BOINCstats....

Thank You!
Pages: [1]

Index :: BOINCstats Bug Report :: Boinc user stats completely broken.
Reason: