Older stats issue

**AMDave** · 03-14-2010, 08:44 AM

same email about 25 lines further down
sent you another email

**Bok** · 03-14-2010, 09:07 AM

ah, ok. I've added the test part in, we'll see if it retrieves the data ok now.

Bok

**AMDave** · 03-14-2010, 10:51 AM

ah no.
That will retrieve data from the test site.
You have my emails with the correct info.

**rilian** · 03-14-2010, 05:37 PM

usernames in DPAD team pages are not correct (team name disappeared like previously in Most__ stats)

http://stats.free-dc.org/stats.php?p...Team%20Ukraine

**LAURENU2** · 03-14-2010, 10:42 PM

Originally Posted by rilian

usernames in DPAD team pages are not correct (team name disappeared like previously in Most__ stats)

http://stats.free-dc.org/stats.php?p...Team%20Ukraine

They should learn to pay there Rent On Time

**rilian** · 03-15-2010, 05:44 AM

Originally Posted by LAURENU2

They should learn to pay there Rent On Time

do you accept payments in Cobblestones?

**Bok** · 03-15-2010, 09:24 AM

Originally Posted by rilian

usernames in DPAD team pages are not correct (team name disappeared like previously in Most__ stats)

http://stats.free-dc.org/stats.php?p...Team%20Ukraine

Teamname is not supposed to be part of the username here. Way back when it was agreed with DPAD (I think) that the teamname would be enclosed with [] and I would then safely strip those out which I do.. Yours and a few others seem to be enclosed with () which I've never stripped out. The teamname does get pulled out as it matches with one in the teamdata.

I think I'll just add a piece of code to regex out any /()/ that remain after the team is stripped..

Bok

**outlnder** · 03-20-2010, 04:11 PM

No stats today??

**Bok** · 03-20-2010, 05:48 PM

They are still running, but I chose to do some maintenance today on the gargantuan host weekly table to split it into years and it's taking a VERY long time to delete out the older years. In fact the query has been running for 12 hours now

This is causing major slowdowns on the rest of the updates.

In hindsight I should have just copied the table over to another machine and done it like that.

It had 750million rows in it and this one is the main cause of the 'sunday' slowdown so that will hopefully be a bit better tomorrow and LOT better next week once I finish.

So let's just hang on and hopefully it'll complete soon. If it's not finished in the next couple of hours though I'm going to kill it..

Bok

**John Galt 007** · 03-25-2010, 12:03 PM

Have they stopped exporting stats? Just a bit curious, as my stats haven't updated since this weekend. Thanks...

**Bok** · 03-25-2010, 12:16 PM

yup.

No changes to the xml in 3 days now.

**John Galt 007** · 03-25-2010, 03:36 PM

Originally Posted by Bok

yup.

No changes to the xml in 3 days now.

Guess there was a change now...stats updated...

Nice work, Bok...

Thanks...

**vaughan** · 04-02-2010, 10:05 PM

Bok something strange has happened to the BOINC Combined Users stats today. The first 18 people all scored 1 Billion points (well nine hundred and ninety eight thousand million or so in English or a Trillion points in US nomenclature)!

Edit: It appears to be Seti Beta that is the cause of the aberration.

**zombie67** · 04-02-2010, 11:24 PM

Originally Posted by vaughan

Bok something strange has happened to the BOINC Combined Users stats today. The first 18 people all scored 1 Billion points (well nine hundred and ninety eight thousand million or so in English or a Trillion points in US nomenclature)!

I saw that too. Something very odd.

**Bok** · 04-03-2010, 07:59 AM

yeah. Seti Beta has really fsck'd it up.

I'll fix those users up later today

**JohnWayne** · 05-14-2010, 10:41 PM

At http://stats.free-dc.org/stats.php?page=proj&proj=wie I've only been able to get "Page Cached 0 days,0 hours & 48 mins ago.." for over 3 days.

I have tried Firefox and IE8.

**Bok** · 05-15-2010, 07:22 AM

hmm, that's a little bizarre. I see the zero length cached page, but am unsure how it was created. I cleared it manually and it's loaded correctly now.

I need to spend a bit more time on this, perhaps add in a sanity check on the length of the cached file prior to writing it.

Let me know if it happens again

**vaughan** · 05-15-2010, 09:48 AM

This happens all the time, usually in the evenings here so I guess that's early hours of the morning your timezone.

Previously I recall something about its "normal" for it to occur for up to an hour.

**Bok** · 05-15-2010, 01:35 PM

ah, I see the problem. Should be fixed. Looks like only for this particular page. It shouldn't happen I don't think, but in this case I'd left the code in that script to write the cached page AND done an include which means the it's duplicated. It wrote it out correctly, then overwrote it with a blank file..

Let me know if you see it again...

Bok

**LAURENU2** · 05-30-2010, 10:52 AM

Are the Stats Down ?

**AMDave** · 05-30-2010, 10:58 AM

No.

They are just mildly depressed

/ed - something is hanging / taking too long ... needs a size-12 with Bok's foot in it

- ed/

**LAURENU2** · 05-30-2010, 11:46 AM

Any body have a shot of Prozac for Mr Stats

**Bok** · 05-30-2010, 03:04 PM

Looks ok now? Not sure what the problem was.

*EDIT* actually looking at the logs, it was the weekly rollover that took 2 1/2 hours. Mostly inserting the weekly user data as I stopped the weekly host data altogether. I'll optimize those tables this week.

**gopher_yarrowzoo** · 05-30-2010, 04:02 PM

Hmm pity you couldn't multi-thread it so that queries could continue but marked as (*) data maybe refreshing.

**Bok** · 05-30-2010, 04:37 PM

Queries do and always have been available still. All computations are done in a separate database (and physical Hard Drive) and once complete, replicated to the live web facing database.

**JohnWayne** · 07-03-2010, 07:42 PM

Can we get a kick start of the Wieferich stats,

Free-DC Logo
Wieferich@Home - Project Overview
Last Checked : Fri Jul 02, 17:12:30 2010 MST
Data Updated : Fri Jul 02, 17:12:30 2010 MST
Current Time : Sat Jul 03, 16:41:39 2010 MST

**the-mk** · 07-04-2010, 03:30 AM

a question to the stats-god: why do we have 3 "Mustard"s on http://stats.free-dc.org/stats.php?p...7&team=Free-DC ?

From the numbers produced, these 3 look like the same man:
"Participant #473,297" --> http://stats.free-dc.org/stats.php?p...=473297Free-DC
"Mustard" --> http://stats.free-dc.org/stats.php?p...=471588Free-DC , http://stats.free-dc.org/stats.php?p...=473390Free-DC , http://stats.free-dc.org/stats.php?p...=475132Free-DC (which seems to be the most recent)

**Bok** · 07-04-2010, 09:09 AM

nonboinc stats kicked.

I don't auto-delete users, so those are old ones. They are flagged for deletion though, so I've gone ahead and done that now.. give it a short time to replicate into live..

**Bok** · 07-04-2010, 12:45 PM

hmm, actually those are separate accounts for Mustard.

**JohnWayne** · 07-06-2010, 05:21 AM

Wieferich is at it again, er not doing it again.

**Bok** · 07-06-2010, 09:08 AM

yeah, see my last post on DPAD. As all of the nonboinc projects run in a loop, r5prp is causing a sticky.. I'll take it out or convert it to to die gracefully to allow the others to continue.

**zombie67** · 07-11-2010, 11:13 AM

No new stats today? Everything shows zeros.

**Bok** · 07-11-2010, 05:28 PM

Standard sunday service

It takes a few hours overnight on saturday to do the weekly stuff including backups.. usually about 9am PST it's updating again.

I've thinking about putting something in which shows what the current status is, but haven't quite got my head around how to display it..

**zombie67** · 07-11-2010, 11:14 PM

Originally Posted by Bok

Standard sunday service

It takes a few hours overnight on saturday to do the weekly stuff including backups.. usually about 9am PST it's updating again.

I've thinking about putting something in which shows what the current status is, but haven't quite got my head around how to display it..

D'oh! Sorry, my memory is shot. I think this question was already asked/answered. Sorry!

**LAURENU2** · 07-13-2010, 11:12 AM

How come mopac@home has Free-DC listed as a stat lister
But Free-DC does not have stats for Mopac

**Bok** · 07-13-2010, 02:13 PM

They aren't exporting their stats yet

**Maxwell** · 07-14-2010, 06:09 PM

Originally Posted by Bok

They aren't exporting their stats yet

Speaking of which, we need to give DistRTGen a kick in the hind end...

**Bok** · 07-14-2010, 09:07 PM

Yeah, Stats files are still there but have not been updated in a long time..

**alpha** · 07-30-2010, 04:04 AM

I think the Folding@home stats might be stuck:

Last Checked : Thu Jul 29, 12:20:37 2010 BST
Data Updated : Thu Jul 29, 12:20:37 2010 BST
Current Time : Fri Jul 30, 08:57:25 2010 BST

**Bok** · 07-30-2010, 07:52 AM

yup. Restarted the nonboinc ones

Thread: Older stats issue

Thread Tools

Rate This Thread

Display

Ibercivis

mopac@home

Posting Permissions