So! All the recent headaches are due to continuing issues with the master science database. While all the data seems to be intact, there's something fundamentally wrong causing informix to keep hanging up (usually when we are continuing work on reconnecting the fragmented result tables).

During the previous recent crashes I would clean up what informix was complaining about in various error messages (always the result table indexes) but this time I'm in the process of doing a comprehensive check of everything in the database just to be sure. And, in fact, I'm seeing minor problems that I've been able to clean up thus far (once again, no loss in data - just internal bookkeeping and broken index issues).

I thought this full check would be done by now (ha ha) but it's not even close. Meanwhile we *should* be able to do Astropulse work, but the software blanking engine requires the master science database to do some integrity checks, so that is all offline as well.

There are ways to speed up such events in the future. We're working on enacting several improvements. Yes, we here are all beyond tired of our project grinding to a halt and things will change for the better.

- 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

Thanks for the update Matt.



May your fingers and mood recover quickly

---

Bob Smith
Member of Seti PIPPS (Pluto is a Planet Protest Society)
Somewhere in the (un)known Universe?

Thank you for the update, Matt.
And Godspeed the recovery.

It is good that your more thorough look at the DB issues is uncovering some things not previously noted.
And good as well that some new thoughts are being considered to make the DB work better for Set.

Best kitty juju for all your efforts being sent.........
Meow....meow.... meow......

---

"Freedom is just Chaos, with better lighting." Alan Dean Foster

Matt,

Thank you for your continued dedication and hard work!

Thanx for the update Matt.

---

rOZZ
Music
Pictures

Good luck. Thanks for the update .. as it snows here..

Thank you for the update.
This will give me a chance to clean up and reconfigure my PC's.

---

Best of luck ! We'll be waiting patiently. Take all the time you need, better a good fix than a quick fix...

---

I think what he is really trying to say, is that the SETI team is looking forward to may flowers!!!

Thanks for the update. I've been an on and off number cruncher since the projects inception. Personally, I appreciate all of the effort that the SETI research team puts into this project. It is a truly wonderful concept and I also know that many others are appreciative as well.

I wish you the best of luck on your endeavor. I hope that you have a speedy repair. We all know how frustrating software/hardware can be at times. Naturally, I want to be the person that finds the ET work unit....j/k LOL ;-)

Jeremy

Are workunits being distributed?

I have had computer issues recently, and think I have them cleared up, but reinstalling BOINC and attaching to the project downloads the pictures only, without even downloading the default client.

Also, is there a way to do a mass abort on any workunits not yet returned by my account? I lost a load of them several times in the past week or so. Probably 400 work units that were untouched in queue on my system got lost due to crashes that confused BOINC. If the inability to get it going again is related to that, please abort those work units and allow me to get things going again on my end. I do believe my computer is now stable.

Thanks,

Jim

---

Delidded i7-4790K (CLU/CLU) at 4.7GHz @ 1.310Vcore 24/7, 32GB DDR3-2400, Corsair H100i v2, Gigabyte Z97X-Gaming G1 WIFI-BK, MSI Radeon RX 480 Gaming 4G, HX-650 PSU, Corsair 750D

Are workunits being distributed?

I don't think so, no. I'm not totally sure if even "third-opinion" (when two tasks are inconclusive and get sent out again) are working presently.

Also, is there a way to do a mass abort on any workunits not yet returned by my account? I lost a load of them several times in the past week or so.

Maybe if you do 'detach' in BOINC Manager for this project.. that might let go of them, but I think that only works for whatever you have in your cache on that machine. With 'resend lost tasks' being turned-off server-side, there's nothing else you can do about those.. they'll expire and get sent out to a third person.

---

Linux laptop:
record uptime: 1511d 20h 19m (ended due to the power brick giving-up)

Are workunits being distributed?

I don't think so, no. I'm not totally sure if even "third-opinion" (when two tasks are inconclusive and get sent out again) are working presently.

Also, is there a way to do a mass abort on any workunits not yet returned by my account? I lost a load of them several times in the past week or so.

Maybe if you do 'detach' in BOINC Manager for this project.. that might let go of them, but I think that only works for whatever you have in your cache on that machine. With 'resend lost tasks' being turned-off server-side, there's nothing else you can do about those.. they'll expire and get sent out to a third person.

Since the problem that's holding us up is with the Science database, the BOINC database should be very quiet at the moment. I wonder whether Matt might consider turning 'resend lost results' back on during the break, to flush those and any others out of the system?

Welcome to the project Andrew!

---

rOZZ
Music
Pictures

Hi Matt,

I was wandering why I didn't get any new work. :-(

Keep up the good work.!!

---

Since the problem that's holding us up is with the Science database, the BOINC database should be very quiet at the moment. I wonder whether Matt might consider turning 'resend lost results' back on during the break, to flush those and any others out of the system?

He must have since when I just turned this computer on for the day a half hour ago, I picked up 45 new GPU tasks, and I had already been out of them for over a day. Of course half of them are already processed as I type. Cricket doesn't show much of anything going out now though.

Cheers, Keith

---

Seti@Home classic workunits:20,676 CPU time:74,226 hours

A proud member of the OFA (Old Farts Association)

Since the problem that's holding us up is with the Science database, the BOINC database should be very quiet at the moment. I wonder whether Matt might consider turning 'resend lost results' back on during the break, to flush those and any others out of the system?

He must have since when I just turned this computer on for the day a half hour ago, I picked up 45 new GPU tasks, and I had already been out of them for over a day. Of course half of them are already processed as I type. Cricket doesn't show much of anything going out now though.

No Keith, You just got lucky and did get tasks that someone else didn't finish.

'Resend lost task' is about when users computers somehow lost task in progress.

Yep, 'resend lost tasks' is still turned off. This host has 2 lost tasks attributed to it, the cache is empty yet there are still 2 tasks listed as in progress, http://setiathome.berkeley.edu/results.php?hostid=7258715. I've already cleared another host by detaching from the project and reattaching which resulted in 44 lost tasks being listed as Abandoned. Since the other host only has 2 lost tasks I'm going to let them just time out. Some hosts have Hundreds of lost tasks, one known host was in the thousands. It might make bookkeeping easier if these tasks were cleared from the database.

Well, it was just turned on;

Fri 10 Apr 2015 02:51:26 PM EDT | SETI@home | Sending scheduler request: To fetch work.
Fri 10 Apr 2015 02:51:26 PM EDT | SETI@home | Requesting new tasks for CPU and ATI
Fri 10 Apr 2015 02:51:26 PM EDT | SETI@home | [sched_op] CPU work request: 69120.00 seconds; 2.00 devices
Fri 10 Apr 2015 02:51:26 PM EDT | SETI@home | [sched_op] ATI work request: 34560.00 seconds; 2.00 devices
Fri 10 Apr 2015 02:51:28 PM EDT | SETI@home | Scheduler request completed: got 0 new tasks
Fri 10 Apr 2015 02:51:28 PM EDT | SETI@home | [sched_op] Server version 705
Fri 10 Apr 2015 02:51:28 PM EDT | SETI@home | Didn't resend lost task 14ja12aa.5456.23675.438086664199.12.61_1 (expired)
Fri 10 Apr 2015 02:51:28 PM EDT | SETI@home | Didn't resend lost task 06oc12aa.21007.19703.438086664206.12.28_1 (expired)
Fri 10 Apr 2015 02:51:28 PM EDT | SETI@home | Project has no tasks available

Too bad they were expired and not resent..

I suppose I had my preferences set wrong to have them resent, oh well.

They are being resent to this host though;
http://setiathome.berkeley.edu/results.php?hostid=7033569

Yep, 'resend lost tasks' is still turned off. This host has 2 lost tasks attributed to it, the cache is empty yet there are still 2 tasks listed as in progress, http://setiathome.berkeley.edu/results.php?hostid=7258715. I've already cleared another host by detaching from the project and reattaching which resulted in 44 lost tasks being listed as Abandoned. Since the other host only has 2 lost tasks I'm going to let them just time out. Some hosts have Hundreds of lost tasks, one known host was in the thousands. It might make bookkeeping easier if these tasks were cleared from the database.

Well, it was just turned on;

Fri 10 Apr 2015 02:51:26 PM EDT | SETI@home | Sending scheduler request: To fetch work.
Fri 10 Apr 2015 02:51:26 PM EDT | SETI@home | Requesting new tasks for CPU and ATI
Fri 10 Apr 2015 02:51:26 PM EDT | SETI@home | [sched_op] CPU work request: 69120.00 seconds; 2.00 devices
Fri 10 Apr 2015 02:51:26 PM EDT | SETI@home | [sched_op] ATI work request: 34560.00 seconds; 2.00 devices
Fri 10 Apr 2015 02:51:28 PM EDT | SETI@home | Scheduler request completed: got 0 new tasks
Fri 10 Apr 2015 02:51:28 PM EDT | SETI@home | [sched_op] Server version 705
Fri 10 Apr 2015 02:51:28 PM EDT | SETI@home | Didn't resend lost task 14ja12aa.5456.23675.438086664199.12.61_1 (expired)
Fri 10 Apr 2015 02:51:28 PM EDT | SETI@home | Didn't resend lost task 06oc12aa.21007.19703.438086664206.12.28_1 (expired)
Fri 10 Apr 2015 02:51:28 PM EDT | SETI@home | Project has no tasks available

Too bad they were expired and not resent..

No, Resend Lost Tasks is NOT turned on. That's why those tasks were expired and sent to another cruncher. And the Resend Lost Tasks function is completely Server side, there is nothing you can do with your preferences to affect it.

---

Donald
Infernal Optimist / Submariner, retired

Yep, 'resend lost tasks' is still turned off. This host has 2 lost tasks attributed to it, the cache is empty yet there are still 2 tasks listed as in progress, http://setiathome.berkeley.edu/results.php?hostid=7258715. I've already cleared another host by detaching from the project and reattaching which resulted in 44 lost tasks being listed as Abandoned. Since the other host only has 2 lost tasks I'm going to let them just time out. Some hosts have Hundreds of lost tasks, one known host was in the thousands. It might make bookkeeping easier if these tasks were cleared from the database.

Well, it was just turned on;

Fri 10 Apr 2015 02:51:26 PM EDT | SETI@home | Sending scheduler request: To fetch work.
Fri 10 Apr 2015 02:51:26 PM EDT | SETI@home | Requesting new tasks for CPU and ATI
Fri 10 Apr 2015 02:51:26 PM EDT | SETI@home | [sched_op] CPU work request: 69120.00 seconds; 2.00 devices
Fri 10 Apr 2015 02:51:26 PM EDT | SETI@home | [sched_op] ATI work request: 34560.00 seconds; 2.00 devices
Fri 10 Apr 2015 02:51:28 PM EDT | SETI@home | Scheduler request completed: got 0 new tasks
Fri 10 Apr 2015 02:51:28 PM EDT | SETI@home | [sched_op] Server version 705
Fri 10 Apr 2015 02:51:28 PM EDT | SETI@home | Didn't resend lost task 14ja12aa.5456.23675.438086664199.12.61_1 (expired)
Fri 10 Apr 2015 02:51:28 PM EDT | SETI@home | Didn't resend lost task 06oc12aa.21007.19703.438086664206.12.28_1 (expired)
Fri 10 Apr 2015 02:51:28 PM EDT | SETI@home | Project has no tasks available

Too bad they were expired and not resent..

No, Resend Lost Tasks is NOT turned on. That's why those tasks were expired and sent to another cruncher. And the Resend Lost Tasks function is completely Server side, there is nothing you can do with your preferences to affect it.

Right...
Try checking the Expiration date on those 2 tasks. It was in May. They were Expired because I had the preferences set to AstroPulse and 'accept work from other tasks' instead of Seti@home v7 when resend lost tasks was turned back on. If I would have had it set to AstroPulse & Seti@home v7 they would have been resent instead of expired. Someone around here mentioned we might get APs, so I changed the preferences the other day and forgot to change them back. It was only 2 tasks that I was going to let expire anyway, no big deal. The point is, Nothing would have happened to them if someone hadn't of turned on 'resent lost tasks' a couple hours ago...at least until May.
I'm probably one of the experts around here on how to get a task resent, you should try experimenting with it one day...

I'd still like someone to send some APs.