Persistent Connections (May 20 2009)

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

Author	Message
Matt Lebofsky Volunteer moderator Project administrator Project developer Project scientist Send message Joined: 1 Mar 99 Posts: 1375 Credit: 74,079 RAC: 0	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
	ID: 897428 ·

Ageless Send message Joined: 9 Jun 99 Posts: 11633 Credit: 1,984,663 RAC: 4,166	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 - BOINC FAQ Service - BOINC User Wiki Real is just a matter of perception.
	ID: 897433 ·

Johnney Guinness Volunteer tester Send message Joined: 11 Sep 06 Posts: 2944 Credit: 2,304,282 RAC: 244	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 ____________
	ID: 897538 ·

S@NL - Eesger Send message Joined: 7 Oct 01 Posts: 384 Credit: 27,160,778 RAC: 31,798	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
	ID: 897928 ·

perryjay Send message Joined: 20 Aug 02 Posts: 3359 Credit: 9,605,189 RAC: 9,967	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
	ID: 897933 ·

Johnney Guinness Volunteer tester Send message Joined: 11 Sep 06 Posts: 2944 Credit: 2,304,282 RAC: 244	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! ____________
	ID: 898041 ·

msattler Volunteer tester Send message Joined: 9 Jul 00 Posts: 34120 Credit: 341,923,067 RAC: 537,567	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...... ____________ ****** "Ask not, what your kitty can do for you. Ask what you can do for your kitty." As it is kitten, so shall it be done.
	ID: 898043 ·

[seti.international] Philip J. Fry Volunteer tester Send message Joined: 6 Apr 07 Posts: 6566 Credit: 50,685,298 RAC: 20,161	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'.. ;-) ____________ >Das Deutsche Cafe. The German Cafe.<
	ID: 898683 ·

aad Send message Joined: 3 Apr 99 Posts: 93 Credit: 154,616,175 RAC: 37,634	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 ____________
	ID: 898783 ·

Martin Johnson Send message Joined: 9 Jun 01 Posts: 201 Credit: 221,655 RAC: 64	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.
	ID: 898889 ·

[seti.international] Philip J. Fry Volunteer tester Send message Joined: 6 Apr 07 Posts: 6566 Credit: 50,685,298 RAC: 20,161	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.. ____________ >Das Deutsche Cafe. The German Cafe.<
	ID: 898968 ·

Pooh Bear 27 Volunteer tester Send message Joined: 14 Jul 03 Posts: 3217 Credit: 1,000,061 RAC: 0	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. ____________
	ID: 898980 ·

KWSN Ekky Ekky Ekky Send message Joined: 25 May 99 Posts: 898 Credit: 6,104,044 RAC: 11,730	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! ____________
	ID: 899002 ·

Robi Send message Joined: 24 Oct 00 Posts: 31 Credit: 196,878 RAC: 0	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
	ID: 899044 ·

RandyC Send message Joined: 20 Oct 99 Posts: 714 Credit: 1,704,345 RAC: 0	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!
	ID: 899056 ·

Martin Johnson Send message Joined: 9 Jun 01 Posts: 201 Credit: 221,655 RAC: 64	Message 899239 - Posted: 25 May 2009, 4:32:59 UTC
	Oh dear, now it's OFFLINE again !
	ID: 899239 ·

S@NL - Eesger Send message Joined: 7 Oct 01 Posts: 384 Credit: 27,160,778 RAC: 31,798	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
	ID: 899353 ·

KWSN Ekky Ekky Ekky Send message Joined: 25 May 99 Posts: 898 Credit: 6,104,044 RAC: 11,730	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) ____________
	ID: 899370 ·

Rick Send message Joined: 27 Mar 01 Posts: 8 Credit: 20,810,808 RAC: 10,981	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.
	ID: 899544 ·

Martin Johnson Send message Joined: 9 Jun 01 Posts: 201 Credit: 221,655 RAC: 64	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?
	ID: 899633 ·

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