Persistent Connections (May 20 2009)


log in

Advanced search

Message boards : Technical News : Persistent Connections (May 20 2009)

Author Message
Profile Matt Lebofsky
Volunteer moderator
Project administrator
Project developer
Project scientist
Avatar
Send message
Joined: 1 Mar 99
Posts: 1389
Credit: 74,079
RAC: 0
United States
Message 897428 - Posted: 20 May 2009, 21:47:21 UTC

Another short note just to check in. Good news is that I finally was able to get more than just 1 or 2 files up from HPSS for Astropulse to chew on. In fact, I got 4 files! Well, that's still not very much, but more are on the way. We'll really have to get crackin' on the data recorder issues once this week is through.

It also seems that we have continuing problem with these difficult web queries clobbering us from time to time. I put a "hack" in place yesterday that I thought was helping, but Dave noted our problem may be from persistent mysql connections. Since php is embedded in apache, whenever it starts up it opens a database connection and keeps it open through multiple page requests. While we put explicit code to use the replica on the result pages, apparently php won't flip from master to replica (or vice versa) during these persistent connections, so we need better logic to handle all that. In the meantime it seems like we're in another ugly long query phase clogging the pipes. Still very annoying.

This is my last tech news item until next week, probably. Will be busy tomorrow with the big event and all.

- 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

Profile Ageless
Avatar
Send message
Joined: 9 Jun 99
Posts: 12288
Credit: 2,576,721
RAC: 816
Netherlands
Message 897433 - Posted: 20 May 2009, 21:56:58 UTC - in response to Message 897428.

Are you ready for a little side-concert on the Picnic and handing out autographs afterwards? Stock up on pens, markers and pencils. You may need them. ;-)
____________
Jord

Fighting for the correct use of the apostrophe, together with Weird Al Yankovic

Profile Johnney Guinness
Volunteer tester
Avatar
Send message
Joined: 11 Sep 06
Posts: 3092
Credit: 2,494,254
RAC: 2,541
Ireland
Message 897538 - Posted: 21 May 2009, 1:16:49 UTC
Last modified: 21 May 2009, 1:18:18 UTC

Matt!

Just wanted to say "Good luck!" and "We're all counting on you!"



To quote a famous movie...LOL

John....LOL
____________

Profile S@NL - Eesger - www.knoop.nl
Avatar
Send message
Joined: 7 Oct 01
Posts: 384
Credit: 36,329,172
RAC: 20,243
Netherlands
Message 897928 - Posted: 21 May 2009, 22:26:07 UTC

Pitty, the stream doesn't seem to be stable.. Guess I'll have to go for the rerun ;)
____________
The SETI@Home Gauntlet 2012 april 16 - 30| info / chat | STATS

Profile perryjay
Volunteer tester
Avatar
Send message
Joined: 20 Aug 02
Posts: 3377
Credit: 15,333,969
RAC: 11,545
United States
Message 897933 - Posted: 21 May 2009, 22:40:51 UTC - in response to Message 897928.

The stream is back up now

____________


PROUD MEMBER OF Team Starfire World BOINC

Profile Johnney Guinness
Volunteer tester
Avatar
Send message
Joined: 11 Sep 06
Posts: 3092
Credit: 2,494,254
RAC: 2,541
Ireland
Message 898041 - Posted: 22 May 2009, 3:18:24 UTC - in response to Message 897538.

Matt!

Just wanted to say "Good luck!" and "We're all counting on you!"




John!

____________

msattlerProject donor
Volunteer tester
Avatar
Send message
Joined: 9 Jul 00
Posts: 38925
Credit: 579,173,572
RAC: 511,695
United States
Message 898043 - Posted: 22 May 2009, 3:21:02 UTC - in response to Message 898041.

Matt!

Just wanted to say "Good luck!" and "We're all counting on you!"




John!

And Don't Call Me Shirley......

____________
*********************************************
Embrace your inner kitty...ya know ya wanna!

I have met a few friends in my life.
Most were cats.

Profile [seti.international] Dirk SadowskiProject donor
Volunteer tester
Avatar
Send message
Joined: 6 Apr 07
Posts: 7062
Credit: 60,022,278
RAC: 21,402
Germany
Message 898683 - Posted: 23 May 2009, 16:29:12 UTC
Last modified: 23 May 2009, 16:38:33 UTC




'Happy birthday' to the 10th from the whole team seti.international .










It's looking like the replica database is offline since 22 May 2009 16:52:33 UTC.

Although if you celebrate the SETI@home birthday.. with BBQ and some [alcohol/non alcohol ;-)] drinks.. maybe it's possible to 'kick' the server? :-)


Cheers. :-)



EDIT:
BTW.
In the NC forum the panic 'spread'.. ;-)

____________
BR



>Das Deutsche Cafe. The German Cafe.<

aad
Send message
Joined: 3 Apr 99
Posts: 93
Credit: 159,418,648
RAC: 41,852
Netherlands
Message 898783 - Posted: 23 May 2009, 22:17:34 UTC - in response to Message 898683.
Last modified: 23 May 2009, 22:18:17 UTC


It's looking like the replica database is offline since 22 May 2009 16:52:33 UTC.
.. maybe it's possible to 'kick' the server? :-)


Ah...!
That's why I still see the same numbers for a day now; Pending credit: 1,369,991.60
____________

Martin Johnson
Send message
Joined: 9 Jun 01
Posts: 201
Credit: 224,995
RAC: 0
United Kingdom
Message 898889 - Posted: 24 May 2009, 6:52:10 UTC

Are we ever going to be able to look at our database again? Please put something back on line.

Profile [seti.international] Dirk SadowskiProject donor
Volunteer tester
Avatar
Send message
Joined: 6 Apr 07
Posts: 7062
Credit: 60,022,278
RAC: 21,402
Germany
Message 898968 - Posted: 24 May 2009, 14:35:53 UTC
Last modified: 24 May 2009, 14:39:02 UTC


I guess earliest at Monday lunchtime (PST, Pacific Standard Time) [~ 20:00 UTC] the replica database will be online again.. maybe need also some time for to 'recovery' for to show the correct data then on the webside..

____________
BR



>Das Deutsche Cafe. The German Cafe.<

Profile Pooh Bear 27
Volunteer tester
Avatar
Send message
Joined: 14 Jul 03
Posts: 3221
Credit: 2,218,412
RAC: 8,696
United States
Message 898980 - Posted: 24 May 2009, 15:14:13 UTC - in response to Message 898968.


I guess earliest at Monday lunchtime (PST, Pacific Standard Time) [~ 20:00 UTC] the replica database will be online again.. maybe need also some time for to 'recovery' for to show the correct data then on the webside..

Since Monday is a National Holiday, my bet it won't be done until after the outage on Tuesday.
____________

Profile KWSN Ekky Ekky Ekky
Avatar
Send message
Joined: 25 May 99
Posts: 922
Credit: 11,382,919
RAC: 13,110
United Kingdom
Message 899002 - Posted: 24 May 2009, 16:21:50 UTC

I can manage without stats and tables just as long as work keeps getting to me and I can send results back. That is happening OK so everything that matters is actually working and certainly my RAC figure keeps changing so things are definitely OK back at the ranch. We just can't see what's going on.
Just wait to see the huge boost in credit come Tuesday!
____________

Profile Robi
Send message
Joined: 24 Oct 00
Posts: 33
Credit: 278,313
RAC: 296
United States
Message 899044 - Posted: 24 May 2009, 18:12:39 UTC - in response to Message 898968.

As of 13:00 CDT the replica seems to be running again.
Just a matter of time until the results show up on the user pages.

Happy memorial day, congratulations to a great landing of STS 125 and congratulations to Jenson Button, Rubens Barrichello (and his birthday yesterday) and BrawnGP to their 1-2 win in Monaco.
oh, and happy belated birthday, Seti at Home!


____________
Robi

Profile RandyC
Avatar
Send message
Joined: 20 Oct 99
Posts: 714
Credit: 1,704,345
RAC: 0
United States
Message 899056 - Posted: 24 May 2009, 18:59:09 UTC - in response to Message 899044.

As of 13:00 CDT the replica seems to be running again.
Just a matter of time until the results show up on the user pages.


It's only 46 hrs behind...let's see how fast it can catch up!

Martin Johnson
Send message
Joined: 9 Jun 01
Posts: 201
Credit: 224,995
RAC: 0
United Kingdom
Message 899239 - Posted: 25 May 2009, 4:32:59 UTC

Oh dear, now it's OFFLINE again !

Profile S@NL - Eesger - www.knoop.nl
Avatar
Send message
Joined: 7 Oct 01
Posts: 384
Credit: 36,329,172
RAC: 20,243
Netherlands
Message 899353 - Posted: 25 May 2009, 15:48:54 UTC

And online (again)
181,101 seconds behind => 50.3 hours to go ;)
____________
The SETI@Home Gauntlet 2012 april 16 - 30| info / chat | STATS

Profile KWSN Ekky Ekky Ekky
Avatar
Send message
Joined: 25 May 99
Posts: 922
Credit: 11,382,919
RAC: 13,110
United Kingdom
Message 899370 - Posted: 25 May 2009, 16:17:04 UTC

Some hae tasks that canna crunch,
And some wad crunch that want it;
But we hae tasks, and we can crunch,
And sae the Lord be thankit.

(With apologies to the Scottish Covenanters)
____________

Profile Rick
Send message
Joined: 27 Mar 01
Posts: 8
Credit: 21,615,319
RAC: 0
United States
Message 899544 - Posted: 25 May 2009, 23:53:45 UTC

Here's to hoping AP chews on lots of data this week. My q6600 is ready to chew on some results.

Martin Johnson
Send message
Joined: 9 Jun 01
Posts: 201
Credit: 224,995
RAC: 0
United Kingdom
Message 899633 - Posted: 26 May 2009, 5:27:22 UTC
Last modified: 26 May 2009, 5:39:48 UTC

And now the Replica updating has stuck. Or has everything?

Message boards : Technical News : Persistent Connections (May 20 2009)

Copyright © 2014 University of California