Database problems?

Message boards : Number crunching : Database problems?

Author Message
caferace
Send message
Joined: Jun 22 06
Posts: 10
Credit: 202,007
RAC: 0

2/16/2008 1:31:46 PM|malariacontrol.net beta|[file_xfer] Started upload of file wu_97_49_98324_0_1203021968_1_0
2/16/2008 1:31:51 PM|malariacontrol.net beta|[file_xfer] Finished upload of file wu_97_49_98324_0_1203021968_1_0
2/16/2008 1:31:51 PM|malariacontrol.net beta|[file_xfer] Throughput 1084 bytes/sec
2/16/2008 2:28:31 PM|malariacontrol.net beta|Sending scheduler request: Requested by user
2/16/2008 2:28:31 PM|malariacontrol.net beta|Reporting 2 tasks
2/16/2008 2:28:36 PM|malariacontrol.net beta|Scheduler RPC succeeded [server version 601]
2/16/2008 2:28:36 PM|malariacontrol.net beta|Message from server: Server can\'t open database
2/16/2008 2:28:36 PM|malariacontrol.net beta|New host venue:
2/16/2008 2:28:36 PM|malariacontrol.net beta|Deferring communication for 1 hr 0 min 0 sec
2/16/2008 2:28:36 PM|malariacontrol.net beta|Reason: requested by project
2/16/2008 2:40:21 PM|malariacontrol.net beta|Sending scheduler request: Requested by user
2/16/2008 2:40:21 PM|malariacontrol.net beta|Reporting 2 tasks
2/16/2008 2:40:26 PM|malariacontrol.net beta|Scheduler RPC succeeded [server version 601]
2/16/2008 2:40:26 PM|malariacontrol.net beta|Message from server: Server can\'t open database
2/16/2008 2:40:26 PM|malariacontrol.net beta|Deferring communication for 1 hr 0 min 0 sec
2/16/2008 2:40:26 PM|malariacontrol.net beta|Reason: requested by project
2/16/2008 3:15:46 PM|malariacontrol.net beta|Sending scheduler request: Requested by user
2/16/2008 3:15:46 PM|malariacontrol.net beta|Reporting 2 tasks
2/16/2008 3:15:51 PM|malariacontrol.net beta|Scheduler RPC succeeded [server version 601]
2/16/2008 3:15:51 PM|malariacontrol.net beta|Message from server: Server can\'t open database
2/16/2008 3:15:51 PM|malariacontrol.net beta|Deferring communication for 1 hr 0 min 0 sec
2/16/2008 3:15:51 PM|malariacontrol.net beta|Reason: requested by project
2/16/2008 3:45:16 PM|malariacontrol.net beta|Sending scheduler request: Requested by user
2/16/2008 3:45:16 PM|malariacontrol.net beta|Reporting 2 tasks
2/16/2008 3:45:21 PM|malariacontrol.net beta|Scheduler RPC succeeded [server version 601]
2/16/2008 3:45:21 PM|malariacontrol.net beta|Message from server: Server can\'t open database
2/16/2008 3:45:21 PM|malariacontrol.net beta|Deferring communication for 1 hr 0 min 0 sec
2/16/2008 3:45:21 PM|malariacontrol.net beta|Reason: requested by project

-jim
____________
ID: 5330 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile Red Atomic
Avatar
Send message
Joined: Jan 31 08
Posts: 3
Credit: 19,110
RAC: 0

I am also getting this message
____________

Red Atomic
The older I get, the better I was.
ID: 5331 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile KB7RZF
Avatar
Send message
Joined: Mar 7 06
Posts: 14
Credit: 127,628
RAC: 2,666

Add my name to the list.
ID: 5332 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile Buga1
Avatar
Send message
Joined: Jan 4 07
Posts: 5
Credit: 64,759
RAC: 0

Add Another. LOL

Hope to see it fixed soon.

Rick
ID: 5333 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile The Gas Giant
Avatar
Send message
Joined: Mar 7 06
Posts: 1213
Credit: 3,503,340
RAC: 1,667

Yup..me too.
ID: 5334 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile JLDun
Avatar
Send message
Joined: Feb 2 08
Posts: 112
Credit: 5,136
RAC: 0


2/16/2008 10:27:24 PM|malariacontrol.net beta|[sched_op_debug] Starting scheduler request
2/16/2008 10:27:35 PM|malariacontrol.net beta|Sending scheduler request: Requested by user. Requesting 0 seconds of work, reporting 7 completed tasks
2/16/2008 10:27:45 PM|malariacontrol.net beta|Scheduler request succeeded: got 0 new tasks
2/16/2008 10:27:45 PM|malariacontrol.net beta|[sched_ops_debug] Server version 601
2/16/2008 10:27:45 PM|malariacontrol.net beta|Message from server: Server can\'t open database
2/16/2008 10:27:45 PM|malariacontrol.net beta|Project requested delay of 3600.000000 seconds
2/16/2008 10:27:45 PM|malariacontrol.net beta|[sched_op_debug] Deferring communication for 1 hr 0 min 0 sec
2/16/2008 10:27:45 PM|malariacontrol.net beta|[sched_op_debug] Reason: requested by project



Did MC@H recently upgrade to Server 6.01?
____________
ID: 5335 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
dubit
Avatar
Send message
Joined: Mar 8 06
Posts: 14
Credit: 679,878
RAC: 378

I\'m sure they\'ll notice soon enough. They\'ve always been quick in the past to fix this sort of thing. I\'ve also noticed the web page itself not loading, but with a \"refresh\" it\'ll typically come up.
____________
ID: 5338 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Astro
Avatar
Send message
Joined: Jan 4 07
Posts: 19
Credit: 309,626
RAC: 0

Yup..me too.

and now for something completely different....


.....


\"I\'m not\"


.....

ok,,,,so I am,,,,but....

ID: 5339 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Christian Diepold
Send message
Joined: Jun 22 06
Posts: 11
Credit: 100,363
RAC: 0

... running out of work ... need ... work ... help ...
____________
ID: 5342 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
adrianxw
Avatar
Send message
Joined: Mar 8 06
Posts: 145
Credit: 474,763
RAC: 883

Seems fixed now.

17/02/2008 17:48:19|malariacontrol.net beta|Sending scheduler request: Requested by user. Requesting 354 seconds of work, reporting 1 completed tasks
17/02/2008 17:48:24|malariacontrol.net beta|Scheduler request succeeded: got 1 new tasks
17/02/2008 17:48:24|malariacontrol.net beta|New host venue: work
17/02/2008 17:48:26|malariacontrol.net beta|Started download of wu_86_232_98991_0_1203259350
17/02/2008 17:48:27|malariacontrol.net beta|Finished download of wu_86_232_98991_0_1203259350

____________
Wave upon wave of demented avengers march cheerfully out of obscurity into the dream.
ID: 5343 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile Andreas38871
Send message
Joined: Mar 8 06
Posts: 4
Credit: 394,390
RAC: 0

17.02.2008 17:55:03|malariacontrol.net beta|Sending scheduler request: Requested by user. Requesting 0 seconds of work, reporting 0 completed tasks
17.02.2008 17:55:08|malariacontrol.net beta|Scheduler request succeeded: got 0 new tasks
17.02.2008 17:55:08|malariacontrol.net beta|Message from server: Server can\'t open database

:-((((((

Andreas
____________
ID: 5344 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
biodoc
Send message
Joined: Jan 14 08
Posts: 17
Credit: 602,969
RAC: 0

I still have the problem too.
ID: 5345 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile Daniel
Avatar
Send message
Joined: Oct 25 07
Posts: 54
Credit: 51,927
RAC: 0

I am uploading okay, and downloading new work too it seems, but completed work will not report. Same error message as the others.
____________
Daniel
ID: 5346 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
waffleironhead
Send message
Joined: Jun 22 06
Posts: 1
Credit: 14,288
RAC: 0

I had luck getting rid of mt completed work units by using the \"update\" button. It took till the fourth try but it did work...
____________
ID: 5348 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile mikey
Avatar
Send message
Joined: Mar 23 07
Posts: 4120
Credit: 5,299,212
RAC: 1,698

I had luck getting rid of mt completed work units by using the \"update\" button. It took till the fourth try but it did work...


Mine is now working, all of it, sending completed units back and getting new work.
____________
ID: 5350 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
biodoc
Send message
Joined: Jan 14 08
Posts: 17
Credit: 602,969
RAC: 0

Same here. Everything seems normal again.

Although I don\'t see any more of the optimizer WU\'s.
ID: 5355 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Christian Diepold
Send message
Joined: Jun 22 06
Posts: 11
Credit: 100,363
RAC: 0

I have a really hard time getting new WUs. Is that some \"aftermath\" of the DC problems. It\'s just that my PCs don\'t request any new work. My QuadCore used to have around 3 days worth of cache and it\'s down to a few hours. Same goes for my other crunchers. How come?
____________
ID: 5371 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Tom Philippart
Send message
Joined: Jun 25 06
Posts: 29
Credit: 220,888
RAC: 0

Sadly the same problem here, I put 6 cores up over the weekend and they can hardly get any WUs, the time between requests went up to 24h due to all the problems!
____________
ID: 5382 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
rabrittain
Send message
Joined: Feb 3 08
Posts: 1
Credit: 122,110
RAC: 0

I\'m having the same problem. It seems to happen when we run the optimization wu\'s -- and I\'ve loaded up a bunch of them -- at least I have work -- but I have 12 copleted tasks spread across 2 machines -- I\'m living off of my pending credit.

:|
ID: 5388 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile Ratava
Avatar
Send message
Joined: Mar 7 06
Posts: 43
Credit: 773,606
RAC: 0

2/18/2008 11:01:58 PM||Starting BOINC client version 5.10.42 for windows_intelx86
2/18/2008 11:01:58 PM||log flags: task, file_xfer, sched_ops
2/18/2008 11:01:58 PM||Libraries: libcurl/7.18.0 OpenSSL/0.9.8e zlib/1.2.3 c-ares/1.5.1
2/18/2008 11:01:58 PM||Data directory: C:\\Program Files\\BOINC
2/18/2008 11:01:58 PM||Processor: 1 AuthenticAMD AMD Turion(tm) 64 Mobile Technology ML-30 [x86 Family 15 Model 36 Stepping 2]
2/18/2008 11:01:58 PM||Processor features: fpu tsc pae nx sse sse2 3dnow mmx
2/18/2008 11:01:58 PM||OS: Microsoft Windows XP: Home Edition, Service Pack 2, (05.01.2600.00)
2/18/2008 11:01:58 PM||Memory: 382.14 MB physical, 919.29 MB virtual
2/18/2008 11:01:58 PM||Disk: 53.34 GB total, 36.64 GB free
2/18/2008 11:01:58 PM||Local time is UTC -5 hours
2/18/2008 11:01:58 PM|malariacontrol.net beta|URL: https://malariacontrol.net/; Computer ID: 83549; location: (none); project prefs: default
2/18/2008 11:01:58 PM||General prefs: from malariacontrol.net beta (last modified 27-Jan-2008 09:38:20)
2/18/2008 11:01:58 PM||Host location: none
2/18/2008 11:01:58 PM||General prefs: using your defaults
2/18/2008 11:01:58 PM||Preferences limit memory usage when active to 382.14MB
2/18/2008 11:01:58 PM||Preferences limit memory usage when idle to 382.14MB
2/18/2008 11:01:58 PM||Preferences limit disk usage to 36.55GB
2/18/2008 11:01:59 PM|malariacontrol.net beta|Restarting task wu_102_516_98989_0_1203259338_2 using malariacontrol version 556
2/18/2008 11:02:19 PM|malariacontrol.net beta|Sending scheduler request: Requested by user. Requesting 0 seconds of work, reporting 5 completed tasks
2/18/2008 11:02:24 PM|malariacontrol.net beta|Scheduler request succeeded: got 0 new tasks
2/18/2008 11:02:24 PM|malariacontrol.net beta|Message from server: Server can\'t open database

____________
ID: 5389 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile JLDun
Avatar
Send message
Joined: Feb 2 08
Posts: 112
Credit: 5,136
RAC: 0

I had trouble- again- at about 9:30 AM Local, then retried off and on over the past hour, with the occasional Close/Restart of BOINC. It seems to be hit and miss...
____________
ID: 5392 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
caferace
Send message
Joined: Jun 22 06
Posts: 10
Credit: 202,007
RAC: 0

I had trouble- again- at about 9:30 AM Local, then retried off and on over the past hour, with the occasional Close/Restart of BOINC. It seems to be hit and miss...


Removing all boxes from project until something is done.

-jim
____________
ID: 5393 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile Ratava
Avatar
Send message
Joined: Mar 7 06
Posts: 43
Credit: 773,606
RAC: 0

2/19/2008 3:08:13 AM|malariacontrol.net beta|Message from server: Server error: feeder not running

____________
ID: 5394 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile The Gas Giant
Avatar
Send message
Joined: Mar 7 06
Posts: 1213
Credit: 3,503,340
RAC: 1,667

My boxes were having trouble up until 10 minutes ago...now all boxes are fed.
ID: 5395 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile [AF>WildWildWest] RLDF
Send message
Joined: Nov 5 07
Posts: 3
Credit: 4,252,642
RAC: 6

work for me now :)
ID: 5396 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
biodoc
Send message
Joined: Jan 14 08
Posts: 17
Credit: 602,969
RAC: 0

All my boxes have been reloaded now.

The Vista box reloaded with about half of optimizer WUs (ver 1.29) but 2 ubuntu linux boxes didn\'t receive any of the opt WUs. Is this just a coincidence?

I hope things are stable for awhile \'cause I\'m losing some teammates to other projects :^(
ID: 5397 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
RandyC
Avatar
Send message
Joined: Jun 23 06
Posts: 2695
Credit: 850,101
RAC: 1,184

All my boxes have been reloaded now.

The Vista box reloaded with about half of optimizer WUs (ver 1.29) but 2 ubuntu linux boxes didn\'t receive any of the opt WUs. Is this just a coincidence?

I hope things are stable for awhile \'cause I\'m losing some teammates to other projects :^(


I have just 1 WU right now...says 16 hrs to complete, but will probably be done in 1 1/2hr. Backup project will take up the slack.

ID: 5398 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile maire
Volunteer moderator
Project administrator
Project developer
Project scientist
Send message
Joined: Nov 7 05
Posts: 438
Credit: 118,258
RAC: 0

It seems that the server is running smoothly again and distributing work. Here is what caused the problems that started on the weekend and gradually got worse:

The server application that processes finished and validated optimizer workunits was making heavy use of the database. This lead to two different problems: First, the BOINC server programs were sometimes refused connections to the database, causing the error messages some of you posted here. Second, the program that creates new malariacontrol workunits also could not operate properly, therefore the queue of malariacontrol workunits was empty earlier today.
We have shut down the optimizer application as a consequence and will look for a solution to prevent this in the future before starting it again.

Nick
____________
Nicolas Maire
Swiss Tropical and Public Health Institute
http://www.swisstph.ch
ID: 5399 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
biodoc
Send message
Joined: Jan 14 08
Posts: 17
Credit: 602,969
RAC: 0

It seems that the server is running smoothly again and distributing work. Here is what caused the problems that started on the weekend and gradually got worse:

The server application that processes finished and validated optimizer workunits was making heavy use of the database. This lead to two different problems: First, the BOINC server programs were sometimes refused connections to the database, causing the error messages some of you posted here. Second, the program that creates new malariacontrol workunits also could not operate properly, therefore the queue of malariacontrol workunits was empty earlier today.
We have shut down the optimizer application as a consequence and will look for a solution to prevent this in the future before starting it again.

Nick


Thanks for the info Nick! I have a cache full of optimizer WUs. Should I abort them or just let them run as the day goes?

Again, we all appreciate your status post!!

ID: 5400 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile maire
Volunteer moderator
Project administrator
Project developer
Project scientist
Send message
Joined: Nov 7 05
Posts: 438
Credit: 118,258
RAC: 0


Thanks for the info Nick! I have a cache full of optimizer WUs. Should I abort them or just let them run as the day goes?

Again, we all appreciate your status post!!


Just let them run through, please! We\'ve just stopped creating new ones for the moment because of the load of the wu-creator on the db, the workunits themselves are ok.
Thanks
Nick
____________
Nicolas Maire
Swiss Tropical and Public Health Institute
http://www.swisstph.ch

ID: 5401 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Ageless
Avatar
Send message
Joined: Jun 29 06
Posts: 261
Credit: 146,907
RAC: 217

We have shut down the optimizer application as a consequence and will look for a solution to prevent this in the future before starting it again.

Nick

Split optimizer tasks separately? Or have it run off its own independent server?
____________
Jord.

BOINC FAQ Service

ID: 5403 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
opyrt
Send message
Joined: Jan 25 08
Posts: 2
Credit: 1,171,229
RAC: 0

Just wanted to let you know that the front page of malariacontrol.net states that these things happened 2007-01-19 & 2008-01-19... Which is one month off and one year and one month off :)
ID: 5404 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
biodoc
Send message
Joined: Jan 14 08
Posts: 17
Credit: 602,969
RAC: 0


Thanks for the info Nick! I have a cache full of optimizer WUs. Should I abort them or just let them run as the day goes?

Again, we all appreciate your status post!!


Just let them run through, please! We\'ve just stopped creating new ones for the moment because of the load of the wu-creator on the db, the workunits themselves are ok.
Thanks
Nick


Sounds good! All my boxes have been running smoothly all day.

Thanks again for the info.

Mark

ID: 5405 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile maire
Volunteer moderator
Project administrator
Project developer
Project scientist
Send message
Joined: Nov 7 05
Posts: 438
Credit: 118,258
RAC: 0


Split optimizer tasks separately? Or have it run off its own independent server?


We\'ll see if this is necessary, we hope we don\'t need new hardware. Up to now, it was always possible to identify and remove the bottleneck when we hit a performance problem.


Just wanted to let you know that the front page of malariacontrol.net states that these things happened 2007-01-19 & 2008-01-19... Which is one month off and one year and one month off :)


Time flies... Fixed this
Thanks
Nick
____________
Nicolas Maire
Swiss Tropical and Public Health Institute
http://www.swisstph.ch

ID: 5407 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
JO
Send message
Joined: Nov 10 07
Posts: 1
Credit: 0
RAC: 0

Good morning,

I live in Green Bay WI. My father suffered from Malaria for all the years I, we, had him. He was infected during the 2nd world war in Africa. I remember his boughts with it vividly. The terrible fever and chills. The pain and the recovery.
Because my father suffered from it before I was conceived, am I immune? Did I receive some gift?
Just wondering,
Jo
____________
Jaonne O'Brien
ID: 5819 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Chris Sutton
Send message
Joined: Nov 10 05
Posts: 297
Credit: 4,941,683
RAC: 0

Because my father suffered from it before I was conceived, am I immune? Did I receive some gift?
Just wondering,
Jo

No, I think I can say with certainty that you are not immune.

Malaria transmission between humans requires a vector, which in this case is the female Anopheles mosquito. Malaria causes the infected person (host) to become sick, but it does not, as far as I know, alter their genetic makeup by affecting their dna. This means that you, as a child of an infected individual, cannot acquire any immunity genetically from your parents. Similarly, you could not become infected by your parent, unless a mosquito transmits the infection.

If you\'re planning on visiting an area where malaria is endemic, please consult your GP and take the necessary precautions.

You can read more about malaria here: What is malaria?
and here: Malaria at Wikipedia

ID: 5820 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Profile maire
Volunteer moderator
Project administrator
Project developer
Project scientist
Send message
Joined: Nov 7 05
Posts: 438
Credit: 118,258
RAC: 0


Because my father suffered from it before I was conceived, am I immune?


No, there\'s no way you could benefit from the immunity that your father may have acquired. It is known that mothers in endemic regions pass some of their acquired immunity on to their babies (via antibodies), but this effect wanes within the first months of live of the newborn.

For a question like this one, could you please start a new thread under the appropriate topics next time?
Thanks
Nick
____________
Nicolas Maire
Swiss Tropical and Public Health Institute
http://www.swisstph.ch

ID: 5827 | Rating: 0 | rate: Rate + / Rate - Report as offensive    
Post to thread

Message boards : Number crunching : Database problems?

Return to malariacontrol.net main page


Copyright © 2013 africa@home