Older stats issue

[STE\/E]

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

[Bok]

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

[CanoeBeyond]

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...

[Max Tractor]

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

[Fire$torm]

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?

[Fire$torm]

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

[Bok]

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.

[Fire$torm]

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

[Bok]

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.

[uBronan]

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

[kim kaos]

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?

[gopher_yarrowzoo]

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.

[Bok]

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..

[uBronan]

Well aqua project is officially dead as i already knew.

[vaughan]

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.

[Bok]

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.

[AMDave]

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

[Bok]

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.

[AMDave]

Confirmed. They are all back now. Sigh. I wish I really was in the top 500. Thanks for the quick thrill

[Fire$torm]

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.

[Bok]

Not a pain, I'd rather know about it

Fixed.

[AMDave]

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?

[Bok]

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.

[AMDave]

confirmed fixed. Thanks.

[rilian]

trigggggggggggggls rating lost usernames

http://stats.free-dc.org/stats.php?p...bproj=trigggls

[AMDave]

confirmed. investigating.

[AMDave]

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.

[outlnder]

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.

[Bok]

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.

[outlnder]

Thanks for the near instant response.

[LAURENU2]

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

[gopher_yarrowzoo]

Hmm shouldn't be looking into it now

[AMDave]

Hmm shouldn't be looking into it now

Can I imagine some punctuation in there to make myself feel better? lol

[LAURENU2]

Hmm shouldn't be looking into it now

Seems better now.

[AMDave]

I concur. Seems like the blockage is gone.

[rilian]

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!!

[ChertseyAl]

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.

[Bok]

yes, there is still an issue with chartdirector failing to load as a dynamic extension.

[Bok]

and now fixed

[ChertseyAl]

Splendid!

Al.