I think their going to Roll back their Stats to the 19'th of June, at least that's what their talking about doing ...
Printable View
I think their going to Roll back their Stats to the 19'th of June, at least that's what their talking about doing ...
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
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?
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
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
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.
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
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?
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.
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..
Well aqua project is officially dead as i already knew.
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.
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.
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
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.
Confirmed. They are all back now. Sigh. I wish I really was in the top 500. Thanks for the quick thrill :)
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.
Not a pain, I'd rather know about it :)
Fixed.
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?
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.
confirmed fixed. Thanks.
trigggggggggggggls rating lost usernames :)
http://stats.free-dc.org/stats.php?p...bproj=trigggls
confirmed. investigating.
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.
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.
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.
Thanks for the near instant response.
Whats up with the Loooong "Loading Stats Data..." 30 to 60 sec ?
:umm: Is there a problem here
http://stats.free-dc.org/stats.php?p...oj=poe&team=87
Hmm shouldn't be looking into it now
I concur. Seems like the blockage is gone.
Attachment 1347
i have some historical jumping cause of some of my nodes were not attached to ukraine team or something :hair:
http://stats.free-dc.org/stats.php?p...=maj&name=1534
could this be removed completely from database ?
thank you!!
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.
yes, there is still an issue with chartdirector failing to load as a dynamic extension.
and now fixed :)
Splendid! :)
Al.