Unable to Merge Host


Advanced search

Message boards : Number crunching : Unable to Merge Host

Sort
Author Message
Profile Conan
Volunteer tester
Avatar

Joined: Sep 13 06
Posts: 219
ID: 100
Credit: 4,256,493
RAC: 0
Message 1546 - Posted 21 Nov 2006 14:44:07 UTC
Last modified: 21 Nov 2006 14:52:53 UTC

> Due to a Boinc hiccup I now have an extra computer that does not exist but Docking is using it.
I went into the 'merge host' function but no duplicate computer was listed so I was unable to merge the 2 hosts.
Host 410 (the original listing)
Host 989 (appeared from nowhere but is now the one being used).
They have the same specs with Boinc calling the Host a 'AuthenticAMD Dual Core AMD Opteron(tm) Processor 2'
(Boinc missed the 75 that goes on the end).

I would like the 2 hosts to be put together as one please.
This hiccup affected 4 of the projects I run on this computer and I was able to merge the extra host on both QMC and Einstein. I am unable to merge on Ralph and Docking.

Thanks and hope to hear from you soon.
____________

Profile Andre Kerstens
Forum moderator
Project tester
Volunteer tester
Avatar

Joined: Sep 11 06
Posts: 749
ID: 1
Credit: 15,199
RAC: 0
Message 1562 - Posted 21 Nov 2006 16:22:36 UTC - in response to Message ID 1546 .

Since the 989 host doesn't have any credit yet and isn't currently crunching, the easiest might be to delete it alltogether.

Andre

> Due to a Boinc hiccup I now have an extra computer that does not exist but Docking is using it.
I went into the 'merge host' function but no duplicate computer was listed so I was unable to merge the 2 hosts.
Host 410 (the original listing)
Host 989 (appeared from nowhere but is now the one being used).
They have the same specs with Boinc calling the Host a 'AuthenticAMD Dual Core AMD Opteron(tm) Processor 2'
(Boinc missed the 75 that goes on the end).

I would like the 2 hosts to be put together as one please.
This hiccup affected 4 of the projects I run on this computer and I was able to merge the extra host on both QMC and Einstein. I am unable to merge on Ralph and Docking.

Thanks and hope to hear from you soon.


____________
D@H the greatest project in the world... a while from now!
STE\/E [BlackOpsTeam]
Volunteer tester

Joined: Nov 14 06
Posts: 47
ID: 292
Credit: 10,082,802
RAC: 0
Message 1563 - Posted 21 Nov 2006 16:27:56 UTC - in response to Message ID 1562 .

Since the 989 host doesn't have any credit yet and isn't currently crunching, the easiest might be to delete it alltogether.


I think another Host will be created then when the Host contacts the Server again if he does that Andre ...
Profile Andre Kerstens
Forum moderator
Project tester
Volunteer tester
Avatar

Joined: Sep 11 06
Posts: 749
ID: 1
Credit: 15,199
RAC: 0
Message 1565 - Posted 21 Nov 2006 16:33:38 UTC - in response to Message ID 1563 .

If somebody can let me know how to safely merge hosts on the server side, I will happily do that :-)

Andre

Since the 989 host doesn't have any credit yet and isn't currently crunching, the easiest might be to delete it alltogether.


I think another Host will be created then when the Host contacts the Server again if he does that Andre ...


____________
D@H the greatest project in the world... a while from now!
Profile Atomic Booty
Volunteer tester
Avatar

Joined: Sep 13 06
Posts: 59
ID: 23
Credit: 30,370
RAC: 0
Message 1590 - Posted 22 Nov 2006 23:48:25 UTC

I had a similar problem a few months ago. My computer crashed for unrelated reasons, and BOINC freaked out. When I rebooted, I found that BOINC had dumped all of my WU's - including 2 mos of a CPDN model =( -and my computer was suddenly treated as a new host on all my projects. Merging my "new" host with its former self was uneventful in most places, but there were a couple projects that refused to recognize the fact that this was the same system. Since my cache was clear of WU's anyway (sob), I just reinstalled BOINC and that solved whatever kink had been preventing the merge. Hope that helps. Good luck on solving your problem.

Atomic
____________
KWSN - Asylum for the Cynically Insane

Profile Conan
Volunteer tester
Avatar

Joined: Sep 13 06
Posts: 219
ID: 100
Credit: 4,256,493
RAC: 0
Message 1636 - Posted 28 Nov 2006 7:43:33 UTC

Andre, any luck at getting the computer merge function to work?
____________

Profile Andre Kerstens
Forum moderator
Project tester
Volunteer tester
Avatar

Joined: Sep 11 06
Posts: 749
ID: 1
Credit: 15,199
RAC: 0
Message 1646 - Posted 29 Nov 2006 4:18:12 UTC - in response to Message ID 1636 .

I haven't gotten any response on my request on how to do this and I honestly don't know how to do this safely (without messing up your machines and credits in the database that is). If somebody can let me know a safe way to do this, I will...

AK

Andre, any luck at getting the computer merge function to work?


____________
D@H the greatest project in the world... a while from now!
Profile Krunchin-Keith [USA]
Volunteer tester
Avatar

Joined: Sep 13 06
Posts: 41
ID: 4
Credit: 1,539,093
RAC: 0
Message 1667 - Posted 30 Nov 2006 18:52:45 UTC

Andre and all,

This happens occasionally on all projects. The client for whatever reason goes wacko and when contacting the project is given a new host id. Sometimes the host information will allow merging and sometimes not. I have many 'old' hosts on projects that cannot be merged in any way with any current host. Its a BOINC thing. Its always been this way.

I don't know how you could safely merge them. It might mess up the database as you would have to possibly replace the old id with the new one whereever it exsisted, Just a guess. I suppose you could examine the code for the current merge function and try to figue out what it does, what piece of information it keys on to make the hosts be identical and mergable and replace this information in the old id record with information from the new id record which would then make that infomation match in both records and allow merging using the already exsisting fuction. Just a suggestion, I don't know if this is possible ?

I do know that the client should always be using the highest number. If the id number on the server does not match the id stored in the clinet the server will generate another new higher number.

This is something that needs to be addressed by the developers to fix so it works in all projects without having admin tamper with manual adjustments.

Profile Andre Kerstens
Forum moderator
Project tester
Volunteer tester
Avatar

Joined: Sep 11 06
Posts: 749
ID: 1
Credit: 15,199
RAC: 0
Message 1668 - Posted 1 Dec 2006 4:00:34 UTC - in response to Message ID 1667 .

Thanks Keith,

I will go through the merge code when I find some time. Good to see you back on the D@H forums :-)

Andre

Andre and all,

This happens occasionally on all projects. The client for whatever reason goes wacko and when contacting the project is given a new host id. Sometimes the host information will allow merging and sometimes not. I have many 'old' hosts on projects that cannot be merged in any way with any current host. Its a BOINC thing. Its always been this way.

I don't know how you could safely merge them. It might mess up the database as you would have to possibly replace the old id with the new one whereever it exsisted, Just a guess. I suppose you could examine the code for the current merge function and try to figue out what it does, what piece of information it keys on to make the hosts be identical and mergable and replace this information in the old id record with information from the new id record which would then make that infomation match in both records and allow merging using the already exsisting fuction. Just a suggestion, I don't know if this is possible ?

I do know that the client should always be using the highest number. If the id number on the server does not match the id stored in the clinet the server will generate another new higher number.

This is something that needs to be addressed by the developers to fix so it works in all projects without having admin tamper with manual adjustments.


____________
D@H the greatest project in the world... a while from now!
Profile Conan
Volunteer tester
Avatar

Joined: Sep 13 06
Posts: 219
ID: 100
Credit: 4,256,493
RAC: 0
Message 1671 - Posted 1 Dec 2006 10:20:25 UTC

I have just found another reason why I would like my hosts merged. BoincStats has deleted my 5,000+ cobblestones from my computer and replaced it with 170 cobblestones from the new host id. I am a bit disappointed in that, but as the stats are drawn from this site and it shows that host twice I am not sure why the credit and computer has been wiped (BoincStats only record this computer once).
I am also waiting for Ralph to add credit as it has the same problem as Docking and wont merge 9same computer).

I have faith that you will find a way Andre. Thanks again.
____________

Profile David Ball
Forum moderator
Volunteer tester
Avatar

Joined: Sep 18 06
Posts: 274
ID: 115
Credit: 1,634,401
RAC: 0
Message 1672 - Posted 1 Dec 2006 12:11:25 UTC

I seem to remember that on some projects you could not merge hosts until the old host had been idle for a month or so. Is there any chance that this is a configuration option on the BOINC server software, or could it just have been an older version of the server software?

One other possibility, and I can't say whether this will work or make things worse. What happens if Conan aborts all BOINC jobs on that machine, does an update so that the Docking@Home server knows the jobs are gone, shuts down the BOINC client, and manually edits the sched_request_docking.utep.edu.xml file and changes the machine number for the Docking@Home project back to the old machine number and restarts the BOINC client? Would that work? Would he have to delete the code_sign_key section or is that the same for all users? How about the authenticator? I didn't see the machine number in any of the other XML files.

This might really mess up Docking on that machine or it might solve the problem. Try at your own risk!!!

BTW, I don't know if I somehow encountered a bug in the BOINC server software, or the newer versions are supposed to work that way, but I had a Linux machine that I had given up on and detached from Docking. I later thought of some other things to try and attached the machine to Docking again. Somehow, it got the same machine number and I didn't have to do a merge. That was really unexpected. This happened weeks ago. When it was attached the second time, it did still have the same static IP, OS kernel version, CPU, Memory, etc as when it was detached. That might have been why it got the same machine number, but I was really surprised that I didn't have to merge it. Maybe it was just a fluke.

-- David

Profile Krunchin-Keith [USA]
Volunteer tester
Avatar

Joined: Sep 13 06
Posts: 41
ID: 4
Credit: 1,539,093
RAC: 0
Message 1679 - Posted 2 Dec 2006 2:48:29 UTC - in response to Message ID 1672 .

This same question-problem came up on MC.N just recently.

otax actually took the time to consult the wiki and came up with:

Merging Duplicate Host Records

This mechanism can lead to situations where the BOINC Database has multiple Host Records for a single Host. For example, this will occur if the Participant deletes the client_state.xml file.

The Participant can merge these duplicates to a single record using the "Merge Hosts" command on the Project's Web Site.

Other actions can also give rise to multiple Host IDs, including:

* Detaching and re-attaching to a Project.
* Running a new Version of the BOINC Client Software that changes the way that CPU names are identified. (cannot be merged)
* Adding a service pack update to Microsoft Windows�. (cannot be merged)
* Adding an additional Operating System to the computer and using multi-boot (e.g.: Microsoft Windows� and Linux).
* An update to the BIOS that changes the CPU identification. (cannot be merged)
* Extreme Over-Clocking that the CPU is mis-identified. (cannot be merged)
* Attempting to run the BOINC Client Software in Windows 2000� mode under Microsoft Windows XP�
* Significant changes to the computer's hardware configuration (CPU chip, adding Physical Memory, etc.) (cannot be merged)

I also have hosts on a project which I cannot merge, but don't know why I have extra hosts there and not on other projects, what ever changed causing new id's had to be something with their server and not my host as those hosts did not get new id's on other projects at the same time and it was more than one host.

I seem to remember that on some projects you could not merge hosts until the old host had been idle for a month or so. Is there any chance that this is a configuration option on the BOINC server software, or could it just have been an older version of the server software?

I Don't remember this. I've always been able to merge hosts immediately if they were could be, if the could not then they never could as I still have hosts on projects that have been idle for a year that can't be merged.

One other possibility, and I can't say whether this will work or make things worse. What happens if Conan aborts all BOINC jobs on that machine, does an update so that the Docking@Home server knows the jobs are gone, shuts down the BOINC client, and manually edits the sched_request_docking.utep.edu.xml file and changes the machine number for the Docking@Home project back to the old machine number and restarts the BOINC client? Would that work? Would he have to delete the code_sign_key section or is that the same for all users? How about the authenticator? I didn't see the machine number in any of the other XML files.

I don't think this would work, because whatever BOINC thinks changed (See above list) on the host to cause it to believe it was a different host would still be there and when trying to connect with the old id, the information would not match and you would end up with another new (third) id for the host. Good suggestion thou.
Try at your own risk!!!

Ditto

BTW, I don't know if I somehow encountered a bug in the BOINC server software, or the newer versions are supposed to work that way, but I had a Linux machine that I had given up on and detached from Docking. I later thought of some other things to try and attached the machine to Docking again. Somehow, it got the same machine number and I didn't have to do a merge. That was really unexpected. This happened weeks ago. When it was attached the second time, it did still have the same static IP, OS kernel version, CPU, Memory, etc as when it was detached. That might have been why it got the same machine number, but I was really surprised that I didn't have to merge it. Maybe it was just a fluke.

My guess would be when you detach some information or files are left behind. When you reattached the information needed is already present and matches so yes you got the same existing id. I think I've seen this before too, long ago. But the list above does include this, but it does not say that this will always cause a new id.

K-K
Profile Krunchin-Keith [USA]
Volunteer tester
Avatar

Joined: Sep 13 06
Posts: 41
ID: 4
Credit: 1,539,093
RAC: 0
Message 1680 - Posted 2 Dec 2006 2:53:56 UTC - in response to Message ID 1668 .

Thanks Keith,

I will go through the merge code when I find some time. Good to see you back on the D@H forums :-)

Andre


I've been in stealth mode, I've been here watching you but you just couldn't see me.

Actually I've had so few problems with your application there was no reason to report in. Thanks for doing a great job.

I just reappeared because I got board.
Profile Andre Kerstens
Forum moderator
Project tester
Volunteer tester
Avatar

Joined: Sep 11 06
Posts: 749
ID: 1
Credit: 15,199
RAC: 0
Message 1689 - Posted 3 Dec 2006 1:22:58 UTC - in response to Message ID 1680 .

Actually I've had so few problems with your application there was no reason to report in. Thanks for doing a great job.


You must be one lucky guy :-) Others have discovered many problems that we are currently working on.

Thanks
Andre
____________
D@H the greatest project in the world... a while from now!
Profile Conan
Volunteer tester
Avatar

Joined: Sep 13 06
Posts: 219
ID: 100
Credit: 4,256,493
RAC: 0
Message 1817 - Posted 18 Dec 2006 12:59:39 UTC

> Has there been any word Andre about why I can't merge my computer? It has been a few weeks (problem started on the 21/11/06) and they still don't merge. Of the 4 projects this happened on on the 21/11, I was able to merge Einstein and QMC that day, but have been unable to merge Docking and Ralph (curious that they are both Alpha projects).
Thanks and hope to hear from you.
____________

Profile Andre Kerstens
Forum moderator
Project tester
Volunteer tester
Avatar

Joined: Sep 11 06
Posts: 749
ID: 1
Credit: 15,199
RAC: 0
Message 1819 - Posted 18 Dec 2006 22:36:41 UTC - in response to Message ID 1817 .

Conan,

I don't know how to safely merge your hosts without damaging your database entries. By doing that, you might loose all your credit for those hosts and I don't want to be responsible for that to be honest. I'd rather leave things as is unless you insist on trying a fix; but in that case we cannot take any responsibility for the issues that might arise. Let me know....

Andre

> Has there been any word Andre about why I can't merge my computer? It has been a few weeks (problem started on the 21/11/06) and they still don't merge. Of the 4 projects this happened on on the 21/11, I was able to merge Einstein and QMC that day, but have been unable to merge Docking and Ralph (curious that they are both Alpha projects).
Thanks and hope to hear from you.


____________
D@H the greatest project in the world... a while from now!
Profile Conan
Volunteer tester
Avatar

Joined: Sep 13 06
Posts: 219
ID: 100
Credit: 4,256,493
RAC: 0
Message 1820 - Posted 18 Dec 2006 23:31:34 UTC - in response to Message ID 1819 .

Conan,

I don't know how to safely merge your hosts without damaging your database entries. By doing that, you might loose all your credit for those hosts and I don't want to be responsible for that to be honest. I'd rather leave things as is unless you insist on trying a fix; but in that case we cannot take any responsibility for the issues that might arise. Let me know....

Andre

> Has there been any word Andre about why I can't merge my computer? It has been a few weeks (problem started on the 21/11/06) and they still don't merge. Of the 4 projects this happened on on the 21/11, I was able to merge Einstein and QMC that day, but have been unable to merge Docking and Ralph (curious that they are both Alpha projects).
Thanks and hope to hear from you.




Thanks Andre,
No, you are right, I don't want to lose all my cobblestones. It seemed a simple thing when there is a function that can 'merge' hosts I assumed that it would be just as easy to do it manually. I don't understand how two other projects were able to identify my computer as the same host and merge them but another two projects say the hosts are different, or does the merge function just not work?
I guess I can live with the split, I will just have to add them together to get my host totals.
Thanks again for your concern and efforts.
I haven't been crunching for nearly a week to let my pending work load drop down. It was over 100 WUs at one stage, now it is around 40 so I will probably start crunching again soon.

If I don't talk you again before the 25th then you, your family, the Docking team all have a good Christmas.
I will be working right through that period, so no break for me.
See if you can sneak some time to finish that plane you are building.
____________

Message boards : Number crunching : Unable to Merge Host

Database Error
: The MySQL server is running with the --read-only option so it cannot execute this statement
array(3) {
  [0]=>
  array(7) {
    ["file"]=>
    string(47) "/boinc/projects/docking/html_v2/inc/db_conn.inc"
    ["line"]=>
    int(97)
    ["function"]=>
    string(8) "do_query"
    ["class"]=>
    string(6) "DbConn"
    ["object"]=>
    object(DbConn)#22 (2) {
      ["db_conn"]=>
      resource(84) of type (mysql link persistent)
      ["db_name"]=>
      string(7) "docking"
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(1) {
      [0]=>
      &string(51) "update DBNAME.thread set views=views+1 where id=110"
    }
  }
  [1]=>
  array(7) {
    ["file"]=>
    string(48) "/boinc/projects/docking/html_v2/inc/forum_db.inc"
    ["line"]=>
    int(60)
    ["function"]=>
    string(6) "update"
    ["class"]=>
    string(6) "DbConn"
    ["object"]=>
    object(DbConn)#22 (2) {
      ["db_conn"]=>
      resource(84) of type (mysql link persistent)
      ["db_name"]=>
      string(7) "docking"
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(3) {
      [0]=>
      object(BoincThread)#3 (16) {
        ["id"]=>
        string(3) "110"
        ["forum"]=>
        string(1) "2"
        ["owner"]=>
        string(3) "100"
        ["status"]=>
        string(1) "0"
        ["title"]=>
        string(20) "Unable to Merge Host"
        ["timestamp"]=>
        string(10) "1166484694"
        ["views"]=>
        string(4) "1153"
        ["replies"]=>
        string(2) "16"
        ["activity"]=>
        string(20) "8.2740219516148e-127"
        ["sufferers"]=>
        string(1) "0"
        ["score"]=>
        string(1) "0"
        ["votes"]=>
        string(1) "0"
        ["create_time"]=>
        string(10) "1164120247"
        ["hidden"]=>
        string(1) "0"
        ["sticky"]=>
        string(1) "0"
        ["locked"]=>
        string(1) "0"
      }
      [1]=>
      &string(6) "thread"
      [2]=>
      &string(13) "views=views+1"
    }
  }
  [2]=>
  array(7) {
    ["file"]=>
    string(63) "/boinc/projects/docking/html_v2/user/community/forum/thread.php"
    ["line"]=>
    int(184)
    ["function"]=>
    string(6) "update"
    ["class"]=>
    string(11) "BoincThread"
    ["object"]=>
    object(BoincThread)#3 (16) {
      ["id"]=>
      string(3) "110"
      ["forum"]=>
      string(1) "2"
      ["owner"]=>
      string(3) "100"
      ["status"]=>
      string(1) "0"
      ["title"]=>
      string(20) "Unable to Merge Host"
      ["timestamp"]=>
      string(10) "1166484694"
      ["views"]=>
      string(4) "1153"
      ["replies"]=>
      string(2) "16"
      ["activity"]=>
      string(20) "8.2740219516148e-127"
      ["sufferers"]=>
      string(1) "0"
      ["score"]=>
      string(1) "0"
      ["votes"]=>
      string(1) "0"
      ["create_time"]=>
      string(10) "1164120247"
      ["hidden"]=>
      string(1) "0"
      ["sticky"]=>
      string(1) "0"
      ["locked"]=>
      string(1) "0"
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(1) {
      [0]=>
      &string(13) "views=views+1"
    }
  }
}
query: update docking.thread set views=views+1 where id=110