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

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......"The secret o' life is enjoying the passage of time." 1977, James Taylor
"With cats." 2018, kittyman

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 ;-)

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.

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)

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?

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.

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.

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.

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