Stats Issues

[Bok]

They changed the badges?

I will look and update them.

[Mumps]

They changed the badges?

I will look and update them.

Hmmm, looks like something is broken with the WCG stats. It looks like the WCG exports have not made it into the Free-DC stats. All zeros for project total daily production. Last good import seems to have been 8/04.

http://stats.free-dc.org/stats.php?page=proj&proj=bwcg

[Bok]

I can not get the datafiles at all, they always crap out, tried going through at least 10 different proxies but still same problem. Somehow my ISP is blacklisted. So I gave up today and paid for a VPS out in the cloud. I'll have to script something to download automatically there, start u pa webserver and point an aname record to it, but it's a solution. In the meantime I downloaded the files manually on that machine and have just sftp'd them over. They are updating now.

[Yavanius]

http://www.free-dc.org/forum/showthread.php?53381-Site-Login-and-Consistency

Going from forum to stats doesn't log me in. There's no place to login into to stats. CPID Page, Your Page, Your CPID page, Your Stats Page... nothing asks for a login.

[RTS48]

I'm still unable to load my stats. Everything seems ok and I am using the same URL that has worked before but the screen just sits there saying 'Loading Stats' with a turning pinwheel.

[Bok]

http://www.free-dc.org/forum/showthread.php?53381-Site-Login-and-Consistency

Going from forum to stats doesn't log me in. There's no place to login into to stats. CPID Page, Your Page, Your CPID page, Your Stats Page... nothing asks for a login.

There has never been a place to login on stats. Never a need. At login if you check the 'Keep me logged in' on the forum it should pick up your cookie for the domain and then IF you have created an id in statstool it will use the data in there. Though I'm not sure statstool works all that well these days - I can create an entry manually.

[Bok]

I'm still unable to load my stats. Everything seems ok and I am using the same URL that has worked before but the screen just sits there saying 'Loading Stats' with a turning pinwheel.

Which page ? Link please.

[RTS48]

Here is the link to my Stats Bok

http://stats.free-dc.org/stats.php?page=user&proj=bwcg&name=618390

[Bok]

hmm, works fine for me. If you are able to debug the connection at all, perhaps with Chrome developer console it might show what is going on?

Also try the equivalent on stats6 - http://stats6.free-dc.org/user/bwcg/618390 and see if that works.

[Biggles]

Hi Bok,

First of all, thanks for all your hard work with these over the years. I've used your stats pages for somewhere in the region of 12 or 13 years now, which is slightly terrifying (in both that I'm getting old, and that my numbers are so bad for having been in DC that long).

Anyway, main reason for posting - user stats for a couple of projects that I checked (DPAD and Folding@Home) were playing up. They seem to have corrected themselves now, but on the project overview the users wasn't filling in, and if you went on to a team view, no data for members was showing, or anything at all on the users view. They are both showing now, but it seemed a bit odd and made me wonder if something was crashing. I first noticed the issue with DPAD last night, so 12-14 hours ago and it was still playing up in the last half hour. Anyway, I figured reporting it might ring a bell somewhere.

Cheers for everything.

[Bok]

might be a corrupt table on one of the databases, will run some checks and correct.

[RTS48]

hmm, works fine for me. If you are able to debug the connection at all, perhaps with Chrome developer console it might show what is going on?

Also try the equivalent on stats6 - http://stats6.free-dc.org/user/bwcg/618390 and see if that works.

Still doesn't work Bok - I have even tried in Safari (I use Firefox normally). No joy with either URL

[Bok]

PMing you with a different link

[RTS48]

I finally got there Bok - don't ask me what happened because I haven't a clue. I worked my way down to my stats page from the home screen and finally the stats appeared. I have now re-bookmarked the URL so I hope it all continues to work. Strangely enough, immediately after getting it to work on Firefox, the Safari screen appeared too - weird eh?

[Yavanius]

There has never been a place to login on stats. Never a need. At login if you check the 'Keep me logged in' on the forum it should pick up your cookie for the domain and then IF you have created an id in statstool it will use the data in there. Though I'm not sure statstool works all that well these days - I can create an entry manually.


Bok,

You're not understanding me here. :)

I have a stats id, but there's no way to get to it from the forum or from the stats page. It appears your stats page isn't quite a part of the main site. If you're in the forum or the stats page, there's no link to the main site where you can login and then you can go to your stats. NONE of the links as mentioned in the original post prompts you to login to access your stats. It just ignores the issue altogether and of course there's no data displayed although it happily displays pages.

You'd have to manually load the main site, login there, then click on stats at which point you would have your stats. At least I think it's suppose to work like that. I was just checking and I'm logged into the forums and the main site, but when I goto my stats from the main site, it still says I'm not logged in... I'm on a fresh browser, so it's not old pages in the cache...


Actually, I think you planned on eventually updating the website and getting things all cleaned up. ;)

[Dirk Broer]

Boinc Combined Score shows zero credits on one of the two servers for today, I get stuck at 2,767,034,383 (http://stats.free-dc.org/stats.php?page=userbycpid&cpid=76d20230028d9ceee3a1aa52fcf14dd4) as total score [BOINCstats shows 2,771,734,181.61 for me (http://boincstats.com/en/stats/-1/user/detail/76d20230028d9ceee3a1aa52fcf14dd4/)]

[Bok]

Bok,

You're not understanding me here. :)

I have a stats id, but there's no way to get to it from the forum or from the stats page. It appears your stats page isn't quite a part of the main site. If you're in the forum or the stats page, there's no link to the main site where you can login and then you can go to your stats. NONE of the links as mentioned in the original post prompts you to login to access your stats. It just ignores the issue altogether and of course there's no data displayed although it happily displays pages.

You'd have to manually load the main site, login there, then click on stats at which point you would have your stats. At least I think it's suppose to work like that. I was just checking and I'm logged into the forums and the main site, but when I goto my stats from the main site, it still says I'm not logged in... I'm on a fresh browser, so it's not old pages in the cache...


Actually, I think you planned on eventually updating the website and getting things all cleaned up. ;)

You are correct that the forum and the stats site are not really linked, they started off totally separate, I didn't even run the forum. Though they do these days run on the same webserver, but not the same database server. I don't really intend to link them any further that is already in place. the stats site looks for the bb_userid cookie from the free-dc.org domain - if it does not find that, or the cookie finds an id/pw combo that is not held in the statstool table it will show login. So check whether that cookie is showing.

As for rewrite, you can go to stats6. It will eventually be flipped over to be the main one, perhaps sooner rather than later, I unfortunately just have zero time to do much personal coding as I have a major project at work (American Airlines) I'm spearheading to move our financial systems out to the cloud...

[Bok]

Boinc Combined Score shows zero credits on one of the two servers for today, I get stuck at 2,767,034,383 (http://stats.free-dc.org/stats.php?page=userbycpid&cpid=76d20230028d9ceee3a1aa52fcf14dd4) as total score [BOINCstats shows 2,771,734,181.61 for me (http://boincstats.com/en/stats/-1/user/detail/76d20230028d9ceee3a1aa52fcf14dd4/)]

I've repaired a few crashed tables - it's always on the same disk/db so I think it may be going bad, though no indications from logs at all.

[Dirk Broer]

I've repaired a few crashed tables - it's always on the same disk/db so I think it may be going bad, though no indications from logs at all.

There might be a new table gone south: look at the MegaMileStones, Squarepants-wise. I used to have some 1386 and having a 30th ranking, now it is 552 and 15th.
http://stats.free-dc.org/mosttag.php?cpid=76d20230028d9ceee3a1aa52fcf14dd4&theme=30

[Bok]

nah, that's just because the user table was crashed when the MM script ran over night.

I'll run it manually now.

[guru]

Bok, let me know if you want to setup a west coast mirror for the stats. I have the bandwidth plus the computer power to do it. I can even setup remote access for you to work on the system.

[Dirk Broer]

Both combined score and my best project (BU) have gone on page=userbycpid on one server and the other is still showing 2,767,034,383 for me (should be some 2,778,290,643).
Looks like the mirror offer needs to be taken seriously.

[AMDave]

Anyone looking for a reason why BURP stats just jumped again should look here: http://burp.renderfarming.net/forum_thread.php?id=2101
BURP are still making corrections to their historical data.
Although this latest adjustment just cost me another Bok, I'm sure most will be glad to see the corrections to the scoring problems caused by the (now old) "CreditNew" algorithm.

[Yavanius]

the stats site looks for the bb_userid cookie from the free-dc.org domain - if it does not find that, or the cookie finds an id/pw combo that is not held in the statstool table it will show login. So check whether that cookie is showing.

As for rewrite, you can go to stats6.

Stats 6 shows not logged in too. Your Stats Page and Statstool don't exist.

I remember way back when I first joined you had to manually link my account to my CPID for some reason the server wasn't doing it automatically. I think you have to again because I'm not seeing anyway to get to my stats except by a manual lookup. :/

It's not the cookies and milk because I'm on a fresh browser. Actually, it was setup and then after the Windows Anniversary update that whole config was wiped out. Fortunately it was nothing critical on it.

[Dirk Broer]

Copied from another part of the forum:


My 'MM' badge suddenly looks gold instead of sapphire to me

[Bok]

I have no access to my servers till Saturday at the earliest I'm afraid. Vacation time..

[Dirk Broer]

I have no access to my servers till Saturday at the earliest I'm afraid. Vacation time..

I hope you've had a nice vacation. Did the 'MM' badge criteria change, or did I drop so much levels for this badge?
http://stats.free-dc.org/mosttag.php?cpid=76d20230028d9ceee3a1aa52fcf14dd4&theme=30

[Bok]

fixed

[No.15]

Users are not showing in poem stats. Guess it might be related to the recent issues poem had.
http://stats.free-dc.org/stats.php?page=proj&proj=poe

Thanks Bok for your work

[vaughan]

Hey bok,
The User stats seem to be out of action today whilst the Team stats appear OK.

[Bok]

yes, user table crashed again on one of the servers, fixed.

[Yavanius]

Bok,

I figured the issue with me not logging into the stats.

You have two logins. Not exactly sure how they tie in although both can access the forum.

You have the Login at the Top of the page. If you login into that it will NOT link into the Stats systems.

You have to go to the Main Free-DC page and use the login IN the page, NOT at the top. Only the one IN the page links to the stats system correctly (both stats and stats6).

If you use the top login, the system thinks you are logged in and there is no way to access the other login except to log out or close the browser (assuming you haven't told the site to remember you).

It might be a cookie issue. When I used the top login, I did not see that specific cookie you mentioned. I saw other cookies, but not that one for some reason even I had full access to the forum.

[Bok]

I only ever use the one at the top of the page and it works for me. It only stores the cookie if you check the 'Remember Me' box.

[Dirk Broer]

At least one of the stats servers has serious problems, as half of the day does not show combined scores. Some Mega Milestones (e.g. Vaio's and Clanks) have gone as well.

[Bok]

fixing.

[Dirk Broer]

Almost all seems fixed:D, it is only that half of the time Bitcoin Utopia appears on the place where Combined Score should be.

[Dirk Broer]

Other minor database anomalies:


There is a certain unnamed person, belonging to no team that has managed to have no less than 402 sub-projects with 1k or more credits (http://stats.free-dc.org/stats.php?page=mmakers&subproj=s1k). To the best of my knowledge an absolute impossibility.
Perhaps that same virtual person has no less than 125 sub-projects with 10k or more credits (http://stats.free-dc.org/stats.php?page=mmakers&subproj=s10k). To the best of my knowledge another absolute impossibility.
And does he/she also has 74 sub-projects with 25k or more credits (http://stats.free-dc.org/stats.php?page=mmakers&subproj=s25k)?
And 45 sub-projects with 50k or more credits (http://stats.free-dc.org/stats.php?page=mmakers&subproj=s50k)?

[Bok]

cleaned up some old data in the subproject tables and re-ran the mm's

[Dirk Broer]

cleaned up some old data in the subproject tables and re-ran the mm's

That was a VERY thorough cleaning! Though sub-project stats still work -as do the signatures- the main stats are blanco.

[vaughan]

bok are you having hardware problems again? Stats when I've checked over past few days shows many blank screens.

[Dirk Broer]

Back to square one....

[Bok]

One of the drives is acting up. I need to get a new drive in and copy everything over from that particular db, just have very little time to get to it.

[Dirk Broer]

The rotten drive -I do hope it is the rotten one- has seven projects less for me than the other drive (75 vs 82), resulting in an ever going up-and-down, credit-wise.

[Bok]

oh, hadn't realised that. But I know how that happened. Will fix today.

[Yavanius]

The rotten drive -

Well take it out and go down to CompUSA and get a new one.
Oh wait, they're closed down too...
Go down to Circuit City then.
Oh they're closed down too...

Well gee, it's getting harder and harder to drive down to your local electronics store and get a new hard drive isn't it?

[Bok]

I already replaced that drive, only have one spare now.

[Bok]

The rotten drive -I do hope it is the rotten one- has seven projects less for me than the other drive (75 vs 82), resulting in an ever going up-and-down, credit-wise.

This should be fixed now.

[Dirk Broer]

One of the two stats servers has lost names, countries and day totals

[vaughan]

Stats seem very slow today, mainly the CPID.

[Dirk Broer]

The affected server now also lost the Bitcoin Utopia scores, at least: it is not showing them on the CPID page.
My signature shows a combined score alternating between 3,586,369,210 (wrong) and a score more than 1,000,000 higher

[Bok]

Just got home from vacation. Will take a look.

[Dirk Broer]

Stats can't be reached today

[Nflight]

Apparently, it started today about 10 AM EST, since then the web page layout exists but, the actual contents of the stats material is missing.

[Dirk Broer]

All looks right again except for LHC Dev@Home, where scores at the project keep growing but export of stats seems to have halted.

[Dirk Broer]

Sub-project stats show up as empty today

[MarkRBright]

This may be nothing - almost literally - but is the phantom person at the top of the SubTrigggls MM table a real person - whoever it is has no name or team but does appear to accumulated 7 SubTrigggls!
http://stats.free-dc.org/stats.php?page=mmakers&subproj=strigggls

[Dirk Broer]

This may be nothing - almost literally - but is the phantom person at the top of the SubTrigggls MM table a real person - whoever it is has no name or team but does appear to accumulated 7 SubTrigggls!
http://stats.free-dc.org/stats.php?page=mmakers&subproj=strigggls

Bok must be working on it as the stats now give a time-out

Edit: Stats are up again, but mystery cruncher is still heading the SubTrigggls MM table...

[Dirk Broer]

Sub-project stats show up as empty today

And are doing so again. As it goes on and off, one of the two stats servers seems to be acting up.

[Bok]

Something in mysql got hung up and it ran out of threads which was causing the churn. I believe I fixed it yesterday by restarting mysql, have you noticed any issues since?

[Dirk Broer]

I don't see the subproject scores right at this moment, nothing has changed it seems. One server seems to lack the info, or tries to find it where it isn't.

[Nflight]

The cat has a furball stuck in its throat, some of the background is visual the rest is not filling in. Cough cat, get that furball out of your throat and let us see our stats! :hiya: