LHC@home

Some work units are "sticky", they keep getting sent out over and over again. From what I have seen so far, the reason for that are unrecognized download errors with BOINC 4.09 that have not the correct status and do not show an error although stderr.txt does contain an error message.

Now and then, those workunits just disappear - I guess that's when the Admin cleans up.

It would be better to delete those results that have :

- exit_status = 0 AND
- CPU_time = 0.0 AND
- claimed_credit = 0.0 AND
- client_state = 4 AND (the numeric representation of "Done")
- outcome = 1 AND (the numeric representation of "Success")
- stderr MATCHES "*download error*" (does this work on BLOBs? *)

so next time the validator will see that the work units are ready for validation.

An example for such a result : http://lhcathome.cern.ch/result.php?resultid=1244946


* I guess, as stderr is a BLOB, it will need a PHP program that extracts the field and scans the extracted contents for the text. It could then set the correct exit status that it should have for download errors.

But maybe it would work to just combine the other fields in the SELECT to give a good UPDATE statement for this problem.