Re: [ovirt-users] Duplicate host_id after deployment via GUI, how is the hosted engine host_id selected?

Hi Thomas, is there a real need to have them aligned? Both SPM ID and Hosted engine ids are quite hidden and accompanied by hostname where visible. I understand the urge to have everything neatly organized, but playing with hosted engine IDs and SPM IDs will bring you nothing but trouble. Theoretically you could put all hosts to maintenance, hosted engine to global maintenance, stop the engine service and update the DB and hosted engine config files. Changing anything when active is a big NO-NO. And I can't promise stability even if you stop everything first. The short version: Please change hosted engine ID to match SPM ID (/etc/ovirt-hosted-engine/hosted-engine.conf) and ignore the hostname vs ID mismatch. All other options might cost you.. Best regards -- Martin Sivak SLA / oVirt On Mon, Apr 23, 2018 at 2:26 PM, Thomas Klute <klute(a)ingenit.com&gt; wrote: > Dear Simone, > > thanks for the help, I already have noticed, that there is a mismatch > between SPM IDs and the hosts. > From my knowledge this may be our fault. > > vds_name | vds_spm_id > oVirt4 | 3 > oVirt2 | 4 > oVirt6 | 6 > oVirt5 | 5 > oVirt1 | 1 > oVirt3 | 2 > > oVirt3 was re-installed using the node ng image - and was assigned id 2 that > was available at that time (taken into account this database query). > It was not available in fact because of the host ovirt2 having the host_id=2 > entry in the configuration on the host and the sanlock having locked the > appropriate space. > > I can't remember where this mismatch came from but I assume that some time > ago someone maybe manually changed the entry on oVirt2 host in order to > match with the hostname (oVirtX -> Host id X). > Thus I think it is not a bug at the moment. > > But that leads me to the next question: > > Is there a manual way to align numbers in the hostnames with the SPM IDs? > (oVirt4 should be spm id 4) > > Does this work? Update the database, change the entry in hosted-engine.conf > and then reboot the node? > > Thanks & best regards, > Thomas > > > > > On Mon, Apr 23, 2018 at 1:04 PM, Martin Sivak <msivak(a)redhat.com&gt; wrote: >> Hello, >> >> the ID should be coming from the SPM ID of the host as assigned by the >> engine and duplicates should not be happening indeed. >> >> Can you please tell us what version of engine you have and how was >> first hosted engine node deployed? We recently changed the default >> deployment method (4.2.2 in fact) and we would like to know whether >> this might be related to that change or not. >> >> Simone, do you know how to debug this? Are there logs we could use to >> check the behavior? The host-deploy logs maybe? > > Thomas, > can you please share the output of > sudo -u postgres scl enable rh-postgresql95 -- psql -d engine -c "select > vds_id, vds_name, vds_spm_id from vds" > executed on the engine VM > > and the content of /var/log/ovirt-engine/host-deploy (still from the engine > VM)? > >> >> Best regards >> >> -- >> Martin Sivak >> SLA / oVirt >> >> On Mon, Apr 23, 2018 at 12:54 PM, Thomas Klute <klute(a)ingenit.com&gt; wrote: >>> Dear oVirt Users, >>> >>> we installed a third ovirt node using the ovirt node ng image (4.2.2), >>> and >>> added that node using the web interface of the hosted engine: >>> >>> Compute->Hosts->New - including the Hosted engine option "Choose hosted >>> engine deployment action" set to "Deploy" >>> >>> After that we found out, that on the new node the host_id entry was >>> causing >>> problems. In >>> >>> /etc/ovirt-hosted-engine/hosted-engine.conf >>> >>> we found the entry >>> >>> ... >>> host_id=2 >>> ... >>> >>> But that host id already exists and was alive during deployment process. >>> So my questions are: >>> >>> How is the host id chosen (when adding a new host via GUI)? >>> Is there an option to preselect the host id in the GUI for a new node? >>> How can we prevent further duplicate host ids? >>> >>> Thanks and best regards, >>> Thomas >>> >>> >>> -- >>> ________________________________________________________________________ >>> >>> Dipl.-Inform. Thomas Klute klute(a)ingenit.com >>> Geschäftsführer / CEO >>> ---------------------------------------------------------------------- >>> ingenit GmbH & Co. KG Tel. +49 (0)231 58 698-120 >>> Emil-Figge-Strasse 76-80 Fax. +49 (0)231 58 698-121 >>> D-44227 Dortmund www.ingenit.com >>> >>> Registergericht: Amtsgericht Dortmund, HRA 13 914 >>> Gesellschafter : Thomas Klute, Marc-Christian Schröer >>> ________________________________________________________________________ >>> >>> >>> _______________________________________________ >>> Users mailing list >>> Users(a)ovirt.org >>> http://lists.ovirt.org/mailman/listinfo/users >>> > > > Sollten noch Fragen offen sein, stehen wir Ihnen natürlich jederzeit > gerne zur Verfügung. > > Mit Grüßen aus Dortmund, > Thomas Klute > > -- > ________________________________________________________________________ > > Dipl.-Inform. Thomas Klute klute(a)ingenit.com > Geschäftsführer / CEO > ---------------------------------------------------------------------- > ingenit GmbH & Co. KG Tel. +49 (0)231 58 698-120 > Emil-Figge-Strasse 76-80 Fax. +49 (0)231 58 698-121 > D-44227 Dortmund www.ingenit.com > > Registergericht: Amtsgericht Dortmund, HRA 13 914 > Gesellschafter : Thomas Klute, Marc-Christian Schröer > ________________________________________________________________________