Hi Willy,

I know this is a real pain for db administrators, as I am one myself...

I have a Quad that became unreliable through overheating, and boinc files suffered after crashing, so was allocated a new ID a few times.
I have merged it on the projects it was working on, but the legacy remains on BoincStats... my host list is a mess!
All of the 5 Q6600 machines running Linux, are in fact the same machine!

Is there any reasonably easy way you can reconcile and merge these into one to recover its identity and history? Perhaps a table of aliases to reunify?
I'm sure that many others would benefit too.

Cheers,
Andy.

You need to perform these merges at each project site. Otherwise, the next time that project exports stats, any modifications done here at BOINCstats will be overwritten by the newly updated stats.

Unfortunately, some projects do not clean up their databases, and results that were abandoned years ago stick around, making deleting or merging the hosts for those results impossible. (Climate Prediction, I'm looking at you.) You may be stuck with some of these phantom hosts for a while.

-Dave

I was having the same problem. I have 2 machines each with 3 different host IDs listed in my host list. I merged, but the old ones remain. I believe at least 2 of the 4 old host IDs are because of CPDN.

Would it be fair to say that the newest host ID for each computer is registering the correct stats, and the old ones are copies of stats that tranferred, but were not deleted? Or did those stats never properly transfer to the new ID?

I ask because if it is the former I am not so annoyed. If it is the latter then I am very annoyed because it makes host comparison very difficult.

-Ian

When you attach a host to a project, crunch some tasks, detach, and reattach, the project sometimes thinks its not the same computer, so the credit goes to the new host from now on, but the credit gained before the detach stays with the old computer. So the credit doesn't properly transfer, or actually, the new host shouldn't be created. Sometimes you can merge them but not if the results stick around.