daily_user_summary issue.

Moderators: Site Moderators, FAHC Science Team

Post Reply
FldngForGrandparents
Posts: 69
Joined: Sun Feb 28, 2016 10:06 pm

daily_user_summary issue.

Post by FldngForGrandparents »

There appears to be several users with no usernames in the daily file. Example lines:

Code: Select all

253622370	1237512	0	
	32546224	30680	0
	3494627	621	70911
	2200813	636	231781
Which looks to be the credit and not the username for the first field. This has been there for a long time it seems.
Image

Dedicated to my grandparents who have passed away from Alzheimer's

Dedicated folding rig on Linux Mint 19.1:
2 - GTX 980 OC +200
1 - GTX 980 Ti OC +20
4 - GTX 1070 FE OC +200
3 - GTX 1080 OC +140
1 - GTX 1080Ti OC +120
FldngForGrandparents
Posts: 69
Joined: Sun Feb 28, 2016 10:06 pm

Re: daily_user_summary issue.

Post by FldngForGrandparents »

Additionally looks like a team entry that doesn't exist:

2244970
4294967295


Not to mention some crazy character usernames that don't translate so well.

`�

The database could really use a cleanup of garbage usernames
Image

Dedicated to my grandparents who have passed away from Alzheimer's

Dedicated folding rig on Linux Mint 19.1:
2 - GTX 980 OC +200
1 - GTX 980 Ti OC +20
4 - GTX 1070 FE OC +200
3 - GTX 1080 OC +140
1 - GTX 1080Ti OC +120
bruce
Posts: 20824
Joined: Thu Nov 29, 2007 10:13 pm
Location: So. Cal.

Re: daily_user_summary issue.

Post by bruce »

Not to mention some crazy character usernames that don't translate so well.

`�

The database could really use a cleanup of garbage usernames
FAH has, in fact, asked that names be limited to standard western characters, but not everybody uses the same alphabet so others creep in from time to time. If that was actually your name, would you want your credits deleted?

The FAH policy is that once points are credited, no edits will be make to the database. (We frequently do get requests to merge two accounts where there was a minor misspelling and those requests are invariable denied.)
FldngForGrandparents
Posts: 69
Joined: Sun Feb 28, 2016 10:06 pm

Re: daily_user_summary issue.

Post by FldngForGrandparents »

Understood. But most of them haven't added credits in years. What about the other errors above that where there is no usernames in the summary file?
Image

Dedicated to my grandparents who have passed away from Alzheimer's

Dedicated folding rig on Linux Mint 19.1:
2 - GTX 980 OC +200
1 - GTX 980 Ti OC +20
4 - GTX 1070 FE OC +200
3 - GTX 1080 OC +140
1 - GTX 1080Ti OC +120
FldngForGrandparents
Posts: 69
Joined: Sun Feb 28, 2016 10:06 pm

Re: daily_user_summary issue.

Post by FldngForGrandparents »

Or this new issue:

anonymous 12812668353 63324110 0
anonymous 140 3 0

Two anonymous users on the same team. Obviously the first is correct one. But this is just the small issues I am finding with something so simple. Makes me worried about how the data is being handled.
Image

Dedicated to my grandparents who have passed away from Alzheimer's

Dedicated folding rig on Linux Mint 19.1:
2 - GTX 980 OC +200
1 - GTX 980 Ti OC +20
4 - GTX 1070 FE OC +200
3 - GTX 1080 OC +140
1 - GTX 1080Ti OC +120
FldngForGrandparents
Posts: 69
Joined: Sun Feb 28, 2016 10:06 pm

Re: daily_user_summary issue.

Post by FldngForGrandparents »

These summary files are completely broken. Whoever runs stats sites off these are not going to be accurate.

keith099 2378224865 43323 3074
keith099 110484639 64065 3074

jims85montess 74591948 1688 111065
jims85montess 6205067 605 111065
jims85montess 2425431 318 0
jims85montess 665216 182 0

Two entries on the same team. Did this person lose some PPD? If you look at FAH stats it gets even more hosed:

3,331 jims85montess 74,591,948 1,688 111065
31,113 jims85montess 2,971,743 294 0

Where is this 2,971,743? Not in the summary file anywhere. This is just for starters. I have many more I can list. This doesn't seem to emulate what http://folding.stanford.edu/stats/donors shows.
Image

Dedicated to my grandparents who have passed away from Alzheimer's

Dedicated folding rig on Linux Mint 19.1:
2 - GTX 980 OC +200
1 - GTX 980 Ti OC +20
4 - GTX 1070 FE OC +200
3 - GTX 1080 OC +140
1 - GTX 1080Ti OC +120
toTOW
Site Moderator
Posts: 6349
Joined: Sun Dec 02, 2007 10:38 am
Location: Bordeaux, France
Contact:

Re: daily_user_summary issue.

Post by toTOW »

Sometimes, people use their email as username, but to protect privacy, nothing is printed in public strating with the @. Those users are probably folding with different emails which explains the "duplicates".
Image

Folding@Home beta tester since 2002. Folding Forum moderator since July 2008.
Joe_H
Site Admin
Posts: 7927
Joined: Tue Apr 21, 2009 4:41 pm
Hardware configuration: Mac Pro 2.8 quad 12 GB smp4
MacBook Pro 2.9 i7 8 GB smp2
Location: W. MA

Re: daily_user_summary issue.

Post by Joe_H »

FldngForGrandparents wrote: Two entries on the same team. Did this person lose some PPD? If you look at FAH stats it gets even more hosed:

3,331 jims85montess 74,591,948 1,688 111065
31,113 jims85montess 2,971,743 294 0

Where is this 2,971,743? Not in the summary file anywhere. This is just for starters. I have many more I can list. This doesn't seem to emulate what http://folding.stanford.edu/stats/donors shows.
If you do a Donor Statistics search on this user you will find that the first entry is for Team 111065, the second for Team 0 and therefore not the same team. That second entry will be in every list as it dates back to last year when it appears this user decided to join a specific team.
Image

iMac 2.8 i7 12 GB smp8, Mac Pro 2.8 quad 12 GB smp6
MacBook Pro 2.9 i7 8 GB smp3
FldngForGrandparents
Posts: 69
Joined: Sun Feb 28, 2016 10:06 pm

Re: daily_user_summary issue.

Post by FldngForGrandparents »

Joe_H wrote:
FldngForGrandparents wrote: Two entries on the same team. Did this person lose some PPD? If you look at FAH stats it gets even more hosed:

3,331 jims85montess 74,591,948 1,688 111065
31,113 jims85montess 2,971,743 294 0

Where is this 2,971,743? Not in the summary file anywhere. This is just for starters. I have many more I can list. This doesn't seem to emulate what http://folding.stanford.edu/stats/donors shows.
If you do a Donor Statistics search on this user you will find that the first entry is for Team 111065, the second for Team 0 and therefore not the same team. That second entry will be in every list as it dates back to last year when it appears this user decided to join a specific team.
Yes I understand they are on different teams. It was the entries in the file that are odd:

jims85montess 74591948 1688 111065
jims85montess 6205067 605 111065
jims85montess 2425431 318 0
jims85montess 665216 182 0


Same user, two teams, with two entries per team for the same user. But where is the 2,971,743 that shows for this user on the donor stats page?
Image

Dedicated to my grandparents who have passed away from Alzheimer's

Dedicated folding rig on Linux Mint 19.1:
2 - GTX 980 OC +200
1 - GTX 980 Ti OC +20
4 - GTX 1070 FE OC +200
3 - GTX 1080 OC +140
1 - GTX 1080Ti OC +120
FldngForGrandparents
Posts: 69
Joined: Sun Feb 28, 2016 10:06 pm

Re: daily_user_summary issue.

Post by FldngForGrandparents »

Never mind I found the entry for the above. It is a case issue. And that makes sense with the email part. But now the question is how to handle this in a stats page since there is no way to decipher the differences in the summary file.

I see that http://folding.extremeoverclocking.com/ ... =&u=717577 merges the entries together for the user. Is that valid or should the second one just be dropped?

Thanks.
Image

Dedicated to my grandparents who have passed away from Alzheimer's

Dedicated folding rig on Linux Mint 19.1:
2 - GTX 980 OC +200
1 - GTX 980 Ti OC +20
4 - GTX 1070 FE OC +200
3 - GTX 1080 OC +140
1 - GTX 1080Ti OC +120
Joe_H
Site Admin
Posts: 7927
Joined: Tue Apr 21, 2009 4:41 pm
Hardware configuration: Mac Pro 2.8 quad 12 GB smp4
MacBook Pro 2.9 i7 8 GB smp2
Location: W. MA

Re: daily_user_summary issue.

Post by Joe_H »

That is the choice of the person running EOC stats as all the information available publicly is the username, team membership and points earned. PG does not merge them in the official stats as the stored value includes any part after and including an "@". Notice that the EOC stats do not merge his entries under the default team with these two entries.

If you do a "Starts with" search on this username, a total of 5 entries can be found through http://folding.stanford.edu/stats/donors.

Code: Select all

3,332	jims85montess	74,591,948	1,688	111065
20,171	jims85montess	6,205,067	605	111065
31,118	jims85montess	2,971,743	294	0
34,875	jims85montess	2,425,431	318	0
70,542	jims85montess	665,216	182	0
That indicates at least three different email addresses were appended to the username at various points in time.
Image

iMac 2.8 i7 12 GB smp8, Mac Pro 2.8 quad 12 GB smp6
MacBook Pro 2.9 i7 8 GB smp3
Post Reply