Valid, confirmed results not being added to totals

I can confirm that the problem is a real one:

mysql> select sum(result.granted_credit) from result join workunit where result.hostid=104724 and workunit.id=result.workunitid and workunit.canonical_resultid!=0;+----------------------------+
| sum(result.granted_credit) |
+----------------------------+
| 1265.2366171823 |
+----------------------------+
1 row in set (0.01 sec)

whereas the total credit shown for the machine is 1179.21. The difference is exactly the 86.03 of missing credit.

I'll talk with David Anderson about this and see if I can understand what's gone wrong. It may be some subtle database-access/locking related bug.

Thanks very much for pointing this out. You have sharp eyes!

Cheers,
Bruce

> I'm not sure how extensive a problem this is as it's difficult to track. My
> most recently added machine received new work units which (since it's fairly
> fast) were all adding up as valid and pending, so I've been keeping an eye on
> it to see when the first "granted credits" would appear. So far so good...
>
> On the 16th a granted credit of 86.03 was awarded, but the total credits for
> the machine was still being reported as 0.00. I figured that this was simply
> due to a delay in the results server. Then yesterday a second result was
> granted 78.12 credit, and the TOTAL for the machine was quickly updated to
> 78.12. As you can see the older result was never credited. Does any one have
> an explanation of how this could possibly be happening?
>
> Here's the link to the machine:
>
> http://einstein.phys.uwm.edu//host/104724
>
> notice: Total Credit - 78.12
>
> Here's the link to the results:
>
> http://einstein.phys.uwm.edu//host/104724/tasks
>
> 15 Apr 2005 21:25:58 UTC / 17 Apr 2005 12:19:32 UTC / Success / 19,446.45 /
> 70.86 / 78.12
>
> 15 Apr 2005 13:27:42 UTC / 16 Apr 2005 18:54:45 UTC / Success / 19,451.25 /
> 70.88 / 86.03
>
> As of now it still hasn't been fixed.
> Thanks!
>
>