Computer Merging

Message boards : Number crunching : Computer Merging
Message board moderation

To post messages, you must log in.

AuthorMessage
Michael Crowdfunding Project Donor*Special Project $75 donorSpecial Project $250 donor
Volunteer tester
Avatar

Send message
Joined: 21 Aug 99
Posts: 4609
Credit: 7,427,891
RAC: 18
United States
Message 241981 - Posted: 4 Feb 2006, 3:33:38 UTC

Is this feature temporarily disabled..or permanent?
ID: 241981 · Report as offensive
Profile Fuzzy Hollynoodles
Volunteer tester
Avatar

Send message
Joined: 3 Apr 99
Posts: 9659
Credit: 251,998
RAC: 0
Message 241991 - Posted: 4 Feb 2006, 3:43:55 UTC - in response to Message 241981.  

Is this feature temporarily disabled..or permanent?


From Technical News:

February 1, 2006 - 22:30 UTC
We took the database crash on Monday as a reminder that we really should upgrade our MySQL engine. We were running 4.0. Today during the usual outage we upgraded to 4.1. After the usual data backup, the procedure couldn't have been simpler. Basically we untar'red the new version, moved the data symlink in place, and started it up.

We individually tested each back-end process and it all worked well, so we started everything up. Immediately the database server ground to a halt. We figured this had something to do with new innodb table locking issues and twiddled those parameters. We also rebuilt several indexes, all to no avail.

Eventually we discovered the one query that would appear behind which everything was piling up: the "merge hosts" update. This is a function on our web site to allow users to combine hosts that for one reason or another show up as multiple hosts in our database. Who could have predicted this would be the culprit? So we shut it off until we figure out exactly why. The reigning theory: this is the only update to an innodb table via php, and we may have to recompile php to pick up newer MySQL libs. Anyway, we're back up now, and will hopefully remain so for the night.

...



"I'm trying to maintain a shred of dignity in this world." - Me

ID: 241991 · Report as offensive
Michael Crowdfunding Project Donor*Special Project $75 donorSpecial Project $250 donor
Volunteer tester
Avatar

Send message
Joined: 21 Aug 99
Posts: 4609
Credit: 7,427,891
RAC: 18
United States
Message 241994 - Posted: 4 Feb 2006, 3:48:00 UTC

Thanks, hmmmm
ID: 241994 · Report as offensive
Michael Crowdfunding Project Donor*Special Project $75 donorSpecial Project $250 donor
Volunteer tester
Avatar

Send message
Joined: 21 Aug 99
Posts: 4609
Credit: 7,427,891
RAC: 18
United States
Message 242331 - Posted: 4 Feb 2006, 17:22:49 UTC

I hope they get it going again because I want to merge an older host with the same host but newer OS.
ID: 242331 · Report as offensive
Profile Matt Lebofsky
Volunteer moderator
Project administrator
Project developer
Project scientist
Avatar

Send message
Joined: 1 Mar 99
Posts: 1444
Credit: 957,058
RAC: 0
United States
Message 242336 - Posted: 4 Feb 2006, 17:25:12 UTC

It's temporarily offline - but the fix is low priority right now. Many other bigger fish to fry for the moment.

- Matt
-- BOINC/SETI@home network/web/science/development person
-- "Any idiot can have a good idea. What is hard is to do it." - Jeanne-Claude
ID: 242336 · Report as offensive
Profile Fuzzy Hollynoodles
Volunteer tester
Avatar

Send message
Joined: 3 Apr 99
Posts: 9659
Credit: 251,998
RAC: 0
Message 242337 - Posted: 4 Feb 2006, 17:25:28 UTC - in response to Message 242331.  

I hope they get it going again because I want to merge an older host with the same host but newer OS.


I'm sure it will, but give them some time, please. They're doing the best they can with the means they have.



"I'm trying to maintain a shred of dignity in this world." - Me

ID: 242337 · Report as offensive
Michael Crowdfunding Project Donor*Special Project $75 donorSpecial Project $250 donor
Volunteer tester
Avatar

Send message
Joined: 21 Aug 99
Posts: 4609
Credit: 7,427,891
RAC: 18
United States
Message 242340 - Posted: 4 Feb 2006, 17:26:41 UTC - in response to Message 242336.  

It's temporarily offline - but the fix is low priority right now. Many other bigger fish to fry for the moment.

- Matt


No worry at all...totally understand. I'm still crunching...and that's all I really want to do.

ID: 242340 · Report as offensive

Message boards : Number crunching : Computer Merging


 
©2025 University of California
 
SETI@home and Astropulse are funded by grants from the National Science Foundation, NASA, and donations from SETI@home volunteers. AstroPulse is funded in part by the NSF through grant AST-0307956.