Page 9 of 10 FirstFirst ... 5678910 LastLast
Results 321 to 360 of 390

Thread: Older stats issue

  1. #321
    I think their going to Roll back their Stats to the 19'th of June, at least that's what their talking about doing ...

  2. #322
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13
    Let's give them a few days. Eliminating from overall would likely slow down the calculations actually, but I'm always hesitant to alter the exported data in any way unless a project refuses to fix their obvious snafu's.

    Always better to get it fixed at the source...

    Bok

  3. #323
    Now where did I leave my car? CanoeBeyond's Avatar
    Join Date
    Jul 2008
    Posts
    32
    Quote Originally Posted by Bok View Post
    Let's give them a few days. Eliminating from overall would likely slow down the calculations actually, but I'm always hesitant to alter the exported data in any way unless a project refuses to fix their obvious snafu's.

    Always better to get it fixed at the source...

    Bok
    I agree. It's been 5 more days...

  4. #324
    Quote Originally Posted by Bok View Post
    Let's give them a few days. Eliminating from overall would likely slow down the calculations actually, but I'm always hesitant to alter the exported data in any way unless a project refuses to fix their obvious snafu's.

    Always better to get it fixed at the source...

    Bok
    they are not fixing the huge credit awards

    'Note that I am leaving alone the crazy credit assigned to returned tasks. Over time they will be removed from the DB.'

    http://aqua.dwavesys.com/forum_threa...rap=true#11743

  5. #325
    Registered User Fire$torm's Avatar
    Join Date
    Jan 2010
    Location
    U.S.A. Eastcoast
    Posts
    25
    Well they did the rollback ---> http://aqua.dwavesys.com/forum_threa...rap=true#11777

    I was wondering how long it will take to filter through the database? And since the next project export will have a large number of users in the negative, will this place an extra burden on your server?

  6. #326
    Registered User Fire$torm's Avatar
    Join Date
    Jan 2010
    Location
    U.S.A. Eastcoast
    Posts
    25
    Quote Originally Posted by Bok View Post
    hmm, first of all, not sure why this was captured as a 'moderation' post in the first place. Fixed that anyway.
    Hello again,

    Whated to let you know that my postings are still being moderated. Maybe because I do not Login and post that often?

    Thx,
    F$

    Edit: NM, this one posted immediately but I still do not see my previous post.

    It went something like this......

    Well, they did the rollback ---> http://aqua.dwavesys.com/forum_threa...rap=true#11777
    Last edited by Fire$torm; 07-15-2011 at 01:47 PM.

  7. #327
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13
    Quote Originally Posted by Fire$torm View Post
    Well they did the rollback ---> http://aqua.dwavesys.com/forum_threa...rap=true#11777

    I was wondering how long it will take to filter through the database? And since the next project export will have a large number of users in the negative, will this place an extra burden on your server?
    Nah, doesn't make any difference. The Aqua stats take less than a minute to fully parse and update into the database.

    Biggest problem is the milestones, I'm going to have to manually go in and delete a lot of milestones which have been posted. It's probably just a few sql statements though to delete all where the milestone is > current_credit.

    As for the moderated post, I've made a small settings change, will see if this helps.

  8. #328
    Registered User Fire$torm's Avatar
    Join Date
    Jan 2010
    Location
    U.S.A. Eastcoast
    Posts
    25

    Minor Aqua issue

    Quote Originally Posted by Bok View Post
    Nah, doesn't make any difference. The Aqua stats take less than a minute to fully parse and update into the database.

    Biggest problem is the milestones, I'm going to have to manually go in and delete a lot of milestones which have been posted. It's probably just a few sql statements though to delete all where the milestone is > current_credit.

    As for the moderated post, I've made a small settings change, will see if this helps.
    First, For me this is nothing more than a minor nuisance issue with the Aqua@Home stats so low priority here.

    Since the debacle Aqua had on the 7th of July, the Recent Milestones section on the main page of my Free-DC stats (User by CPID Stats) still show the following:

    Thursday, 7 July 2011 400,000,000
    Thursday, 7 July 2011 300,000,000
    Thursday, 7 July 2011 200,000,000
    Thursday, 7 July 2011 190,000,000
    Thursday, 7 July 2011 180,000,000
    Thursday, 7 July 2011 170,000,000
    Thursday, 7 July 2011 160,000,000
    Thursday, 7 July 2011 150,000,000
    Thursday, 7 July 2011 140,000,000
    Thursday, 7 July 2011 130,000,000




    But on my Aqua@Home user stats page, the above are not listed, which is as it should be, not listed.

    Sunday, 12 June 2011 7,000,000
    Tuesday, 31 May 2011 6,500,000
    Tuesday, 3 May 2011 6,000,000
    Monday, 25 April 2011 5,500,000
    Wednesday, 22 December 2010 5,000,000
    Thursday, 11 November 2010 4,500,000
    Tuesday, 26 October 2010 4,000,000
    Monday, 11 October 2010 3,500,000
    Wednesday, 8 September 2010 3,000,000
    Friday, 20 August 2010 2,500,000
    Sunday, 1 August 2010 2,000,000
    Friday, 30 July 2010 1,900,000
    Tuesday, 27 July 2010 1,800,000
    Monday, 26 July 2010 1,700,000



    So the question being, is there any chance you could zero out the Aqua@Home references for the 7th of July in regards to user by CPID Recent Milestones?

    Or would trying to fix that end up FUBAR'ing all the Free-DC cumulative stats?

    Thanks in advance,
    Fire$torm

    Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin

  9. #329
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13
    Should have it mostly done, certainly your's will be gone and the majority of the rest of them.

    Can't do this in one fell swoop as the cases where there are split CPID's occur also, though we could argue they should be deleted too.

  10. #330
    Crazy Old Man
    Join Date
    Feb 2009
    Location
    Netherlands
    Posts
    44
    I wonder if aqua ever returns to a active project since the project owners (d-wave) not responding or answering any emails.
    Its almost as if they disappeared since the aqua project administrator got fired nothing has been revealed or done to inform the distributed project community

  11. #331
    What happend - today I got this one: No host found with that cpid. Perhaps this project is not exporting stats yet - so now Im disapeard or what? - Whatr happend to the stats?

  12. #332
    Free-DC Retire gopher_yarrowzoo's Avatar
    Join Date
    Mar 2002
    Location
    Santa Ana, CA
    Posts
    3,978
    uBronan - no idea, but the stats were fixed I believe
    Kim kaos - what is your CPID / Aqua user name and i'll see what has happened to it, maybe it's got mangled somewhere.
    Retired from Free-DC...
    I don't have the time or money to help anymore...

  13. #333
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13
    Quote Originally Posted by kim kaos View Post
    What happend - today I got this one: No host found with that cpid. Perhaps this project is not exporting stats yet - so now Im disapeard or what? - Whatr happend to the stats?
    I'm guessing you came in from an external project site? If you can let me know where from and the host id I can check, if it has no credits then it's not exported in the XML feed from the project, but there could be a number of reasons, including as you say a project not exporting stats, like mopac@home or volpex..

  14. #334
    Crazy Old Man
    Join Date
    Feb 2009
    Location
    Netherlands
    Posts
    44
    Well aqua project is officially dead as i already knew.

  15. #335
    www.amdusers.com
    Join Date
    Apr 2002
    Location
    Sydney, Australia
    Posts
    264
    bok or gopher, when you can could you check the Poem@Home stats for my old XPS laptop computer number 68233 on Poem please? It has some bizarre multi-digit number that messes up the layout when you drill down to looking at that particular machine's stats. TIA.

  16. #336
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13
    hmm, not sure how that happened but it has numbers in the range - 7x10-189 in the columns for 28,27,26 & 25 days ago which is very odd.

    I've zeroed them out. Let me know if you see it again.

  17. #337
    Administrator AMDave's Avatar
    Join Date
    Sep 2004
    Location
    deep in a while-loop
    Posts
    1,947
    something borked in the last combined stats update
    about 377 participants just went 'missing' from the top 850 combined
    they will return when the problem is found and fixed
    . . . . . ___
    . . . . . . .\___/\______
    . . . . . . . \__AMD___\\__
    -----------------------------------------

  18. #338
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13
    There was an issue earlier today, caused when I fixed an old cpid for someone, I'd never realised but for some reason on one of the tables I was holding the cpid as a varchar(50) when it really should be a char(32). Somehow I updated it with an extra space and it caused a problem with a group by (and in effect lost 1/2 the rows). I fixed the table and restored the combined user table from the backup overnight.. This fixed it.

  19. #339
    Administrator AMDave's Avatar
    Join Date
    Sep 2004
    Location
    deep in a while-loop
    Posts
    1,947
    Confirmed. They are all back now. Sigh. I wish I really was in the top 500. Thanks for the quick thrill
    . . . . . ___
    . . . . . . .\___/\______
    . . . . . . . \__AMD___\\__
    -----------------------------------------

  20. #340
    Registered User Fire$torm's Avatar
    Join Date
    Jan 2010
    Location
    U.S.A. Eastcoast
    Posts
    25
    Hiya BOK. sorry to be a pain but I noticed today that on any of my Free-DC project User Stats pages all Host stats data is missing though the hosts table header is there.

    Just thought you should know.

    Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin

  21. #341
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13
    Not a pain, I'd rather know about it

    Fixed.

  22. #342
    Administrator AMDave's Avatar
    Join Date
    Sep 2004
    Location
    deep in a while-loop
    Posts
    1,947
    Test4Theory hasn't updated for a few days.
    I checked the tables.xml on their stats and it has been updating.
    Last stats export was at 1317569404 ... better known as Sun, 02 Oct 2011 15:30:04 GMT

    Looks like there could be an issue on this end?
    Last edited by AMDave; 10-03-2011 at 07:05 AM.
    . . . . . ___
    . . . . . . .\___/\______
    . . . . . . . \__AMD___\\__
    -----------------------------------------

  23. #343
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13
    Should be fixed. They changed their url recently and I fat fingered it when I altered it on this end. It'll update pretty soon.

  24. #344
    Administrator AMDave's Avatar
    Join Date
    Sep 2004
    Location
    deep in a while-loop
    Posts
    1,947
    confirmed fixed. Thanks.
    . . . . . ___
    . . . . . . .\___/\______
    . . . . . . . \__AMD___\\__
    -----------------------------------------

  25. #345

  26. #346
    Administrator AMDave's Avatar
    Join Date
    Sep 2004
    Location
    deep in a while-loop
    Posts
    1,947
    confirmed. investigating.
    . . . . . ___
    . . . . . . .\___/\______
    . . . . . . . \__AMD___\\__
    -----------------------------------------

  27. #347
    Administrator AMDave's Avatar
    Join Date
    Sep 2004
    Location
    deep in a while-loop
    Posts
    1,947
    Solution found & tested ok.
    The fix will be apparent on Stats in 3 hours.
    Correction - The fix is applied now.

    Thanks for the heads-up.

    Congrats on the #2 spot there btw.
    Last edited by AMDave; 10-16-2011 at 02:17 AM.
    . . . . . ___
    . . . . . . .\___/\______
    . . . . . . . \__AMD___\\__
    -----------------------------------------

  28. #348
    I'm not sure this is the correct thread anymore, but...

    I cannot get page 2 or higher in the Primegrid sub-project Woodall LLR. I don't get a "Next" or "Previous" header.

  29. #349
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13
    Indeed, looks like it was not on the list of pages which have this type of navigation. I've added it. It'll take some time for the caches to expire given it's a javascript change though.

  30. #350
    Thanks for the near instant response.

  31. #351
    =>Team Joker<= LAURENU2's Avatar
    Join Date
    Dec 2004
    Location
    Chicago IL USA
    Posts
    5,477
    Blog Entries
    1
    Whats up with the Loooong "Loading Stats Data..." 30 to 60 sec ?
    Is there a problem here

    http://stats.free-dc.org/stats.php?p...oj=poe&team=87

  32. #352
    Free-DC Retire gopher_yarrowzoo's Avatar
    Join Date
    Mar 2002
    Location
    Santa Ana, CA
    Posts
    3,978
    Hmm shouldn't be looking into it now
    Retired from Free-DC...
    I don't have the time or money to help anymore...

  33. #353
    Administrator AMDave's Avatar
    Join Date
    Sep 2004
    Location
    deep in a while-loop
    Posts
    1,947
    Quote Originally Posted by gopher_yarrowzoo View Post
    Hmm shouldn't be looking into it now
    Can I imagine some punctuation in there to make myself feel better? lol
    . . . . . ___
    . . . . . . .\___/\______
    . . . . . . . \__AMD___\\__
    -----------------------------------------

  34. #354
    =>Team Joker<= LAURENU2's Avatar
    Join Date
    Dec 2004
    Location
    Chicago IL USA
    Posts
    5,477
    Blog Entries
    1
    Quote Originally Posted by gopher_yarrowzoo View Post
    Hmm shouldn't be looking into it now
    Seems better now.

  35. #355
    Administrator AMDave's Avatar
    Join Date
    Sep 2004
    Location
    deep in a while-loop
    Posts
    1,947
    I concur. Seems like the blockage is gone.
    Click image for larger version. 

Name:	401414-man-with-a-toilet-plunger.jpg 
Views:	24 
Size:	9.5 KB 
ID:	1347
    . . . . . ___
    . . . . . . .\___/\______
    . . . . . . . \__AMD___\\__
    -----------------------------------------

  36. #356
    i have some historical jumping cause of some of my nodes were not attached to ukraine team or something

    http://stats.free-dc.org/stats.php?p...=maj&name=1534

    could this be removed completely from database ?

    thank you!!

  37. #357
    BOINC Gypsy ChertseyAl's Avatar
    Join Date
    Aug 2008
    Location
    London, Englandshire
    Posts
    209
    Don't know if it's just because you haven't got around to starting it up again after the recent outage, but the piecharts are no longer appearing. I just see ...

    usercpidperc
    usercpidracperc
    combuserdaily
    combusercumul
    usercombmonthly

    ... where they should be.

    Cheers,

    Al.

  38. #358
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13
    yes, there is still an issue with chartdirector failing to load as a dynamic extension.

  39. #359
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    21,730
    Blog Entries
    13
    and now fixed

  40. #360
    BOINC Gypsy ChertseyAl's Avatar
    Join Date
    Aug 2008
    Location
    London, Englandshire
    Posts
    209
    Splendid!

    Al.

Page 9 of 10 FirstFirst ... 5678910 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •