Stats not updating?

Moderators: Site Moderators, PandeGroup

Re: Stats not updating?

Postby Luscious » Mon Sep 11, 2017 7:46 am

I really don't want to beat on a dead horse here but this is the 3rd interruption in as many weeks. Server infrastructure failing at that rate should be a red flag. Can we please get a long-term fix???
Luscious
 
Posts: 22
Joined: Sat Oct 13, 2012 6:38 am

Re: Stats not updating?

Postby kookykrazee » Mon Sep 11, 2017 12:16 pm

Fortunately, folding is still working, just stats are not updating :)
kookykrazee
 
Posts: 53
Joined: Sun May 16, 2010 1:44 am

Re: Stats not updating?

Postby JimboPalmer » Mon Sep 11, 2017 1:50 pm

Luscious wrote:I really don't want to beat on a dead horse here but this is the 3rd interruption in as many weeks. Server infrastructure failing at that rate should be a red flag. Can we please get a long-term fix???

I feel certain that if you fund it specifically, it will happen. I suspect that the Pande Groups funds are all tied up in studying proteins.

or

We do stuff for them, they do not have that priority toward us. The purpose of F@H is not the donors, it is the results.
Tsar of all the Rushers
I tried to remain childlike, all I achieved was childish.
A friend to those who want no friends
JimboPalmer
 
Posts: 535
Joined: Mon Feb 16, 2009 4:12 am
Location: Greenwood MS USA

Re: Stats not updating?

Postby Vig » Mon Sep 11, 2017 2:27 pm

JimboPalmer wrote:We do stuff for them, they do not have that priority toward us. The purpose of F@H is not the donors, it is the results.


While the purpose is the results, they come from the donors. You can't ignore the producers and still expect the production to continue.
Vig
 
Posts: 2
Joined: Mon Sep 11, 2017 2:25 pm

Re: Stats not updating?

Postby drougnor » Mon Sep 11, 2017 2:34 pm

A single process on a single server having issues is not evidence of 'server infrastructure failing'. All this is is an hourly query against the existing database for the most recent set of numbers (Points total, Work Units total) for each entity (Donor or Team) that gets stuffed into a single file for digestion by whatever means third party users put it to.

It's not doom and gloom for the project if this process keeps failing. It's merely annoying for those of us who are collecting the data for our own usage, and for those of us who have grown USED to the pretty presentation of that data in easy to digest graphs.

Yes, the data presented by the third party sites is beneficial for drawing new folks in as a means of providing new goals to work towards and gamifying the F@H experience. But let's not pretend that it's the End of Days for the project.

I only hope a solution is found sooner than later and IF that solution is to create another means for 3rd parties like me to get the stats, that it's easy to slot into my existing solution without having to retool a bunch of old code.

Until then, I'm happily folding along and will keep an eye on my stats system to see if the errors have stopped and will gladly return here to report any new errors that come along that AREN'T caused by my own system.

d
drougnor
 
Posts: 136
Joined: Tue Dec 29, 2009 2:21 am

Re: Stats not updating?

Postby Simplex0 » Mon Sep 11, 2017 5:11 pm

"A single process on a single server having issues is not evidence of 'server infrastructure failing'. "

Yes. Providing that this IS only a problem with a single server that occurs 1 - 2 times every week an have been going on for more than a year now and not the only problem we observe of a much bigger problem.

At least this problem that has been going on for more than a year now makes you wonder if they have enough money to run this project properly.
Simplex0
 
Posts: 26
Joined: Sun Oct 06, 2013 10:35 am

Re: Stats not updating?

Postby Joe_H » Mon Sep 11, 2017 6:14 pm

The stats database has been restarted. It may take a couple hours to catch up on the backlog of WU's waiting to be entered into it.

As has been posted before, they are in the process of moving to new equipment for the stats database and front end processing.
Image

iMac 2.8 i7 12 GB smp8, Mac Pro 2.8 quad 12 GB smp6
MacBook Pro 2.9 i7 8 GB smp3
Joe_H
Site Admin
 
Posts: 3899
Joined: Tue Apr 21, 2009 4:41 pm
Location: W. MA

Re: Stats not updating?

Postby drougnor » Mon Sep 11, 2017 6:29 pm

I can verify that the 2pm Eastern update posted and was pulled by my system. We're looking good for EOC to be able to post their first new numbers on their 3pm Central update.
drougnor
 
Posts: 136
Joined: Tue Dec 29, 2009 2:21 am

Re: Stats not updating?

Postby WhitehawkEQ » Mon Sep 11, 2017 8:48 pm

And as soon as it's up, it's down again. :x
Here's a thought, How about a backup stat server to take over when main stat server goes down?
WhitehawkEQ
 
Posts: 17
Joined: Sat May 14, 2011 11:50 pm

Re: Stats not updating?

Postby JimboPalmer » Mon Sep 11, 2017 9:18 pm

WhitehawkEQ wrote:And as soon as it's up, it's down again. :x
Here's a thought, How about a backup stat server to take over when main stat server goes down?

All it takes is your funding. If Pande Group had more funding, they would use it to do more Biochemistry.
JimboPalmer
 
Posts: 535
Joined: Mon Feb 16, 2009 4:12 am
Location: Greenwood MS USA

Re: Stats not updating?

Postby bruce » Mon Sep 11, 2017 9:19 pm

Syncing a main and a backup copy of the database would be problematic. Are you suggesting that in the event of a problem, the stats queries might revert to a copy that's an additional hour old? How would the 3rd party stats people deal with a flat-file that is earlier than the last one they downloaded?
bruce
 
Posts: 20839
Joined: Thu Nov 29, 2007 10:13 pm
Location: So. Cal.

Re: Stats not updating?

Postby SteveWillis » Mon Sep 11, 2017 9:25 pm

bruce wrote:Syncing a main and a backup copy of the database would be problematic. Are you suggesting that in the event of a problem, the stats queries might revert to a copy that's an additional hour old? How would the 3rd party stats people deal with a flat-file that is earlier than the last one they downloaded?


Mirroring. Fail over should be seamless. Expensive though, I'd imagine. But hey, I don't really know enough about it to have an opinion. :-)
Last edited by SteveWillis on Mon Sep 11, 2017 9:27 pm, edited 1 time in total.
Image
My thanks to my very indulgent wife
http://folding.extremeoverclocking.com/user_summary.php?s=&u=712804

3 AMD Linux rigs 3, 4, and 5 GPUs 7 X GTX 1080, 5 X GTX 1080 TI
SteveWillis
 
Posts: 240
Joined: Fri Apr 15, 2016 12:42 am

Re: Stats not updating?

Postby Vig » Mon Sep 11, 2017 9:25 pm

I believe he's talking about replication as opposed to one "coming up" only when the other one fails. Both servers pull stats from the database at the same time. Server 1 is usually used unless the system detects that it is down at which point Server 2's copy is used.

If the issue isn't with the servers, but instead with the database then that's not a viable option, but that doesn't seem like it is the case.
Vig
 
Posts: 2
Joined: Mon Sep 11, 2017 2:25 pm

Re: Stats not updating?

Postby SteveWillis » Mon Sep 11, 2017 9:29 pm

Anyway, I see it's back on line.
SteveWillis
 
Posts: 240
Joined: Fri Apr 15, 2016 12:42 am

Re: Stats not updating?

Postby bruce » Mon Sep 11, 2017 10:30 pm

Vig wrote:If the issue isn't with the servers, but instead with the database then that's not a viable option, but that doesn't seem like it is the case.

To me, that's unknown. Apparently the server recovers when rebooted. They're "old" servers and there's a plan to move the processing off of them.

Nevertheless, most of FAH's support is provided by students and the academic calendar indicates that we're between terms, so virtually everybody has left campus until the next term starts.
bruce
 
Posts: 20839
Joined: Thu Nov 29, 2007 10:13 pm
Location: So. Cal.

PreviousNext

Return to Issues with a specific server

Who is online

Users browsing this forum: No registered users and 1 guest

cron