Duplicate host_id after deployment via GUI, how is the hosted engine host_id selected?

This is a multi-part message in MIME format. --------------27CA2B1123847DBF1F81EC89 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable 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=3D2 ... 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 --=20 ________________________________________________________________________ Dipl.-Inform. Thomas Klute klute@ingenit.com Gesch=C3=A4ftsf=C3=BChrer / 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=C3=B6er ________________________________________________________________________ --------------27CA2B1123847DBF1F81EC89 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html> <head> <meta http-equiv=3D"content-type" content=3D"text/html; charset=3Dutf= -8"> </head> <body text=3D"#000000" bgcolor=3D"#FFFFFF"> <p>Dear oVirt Users,</p> <p>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:<br> <br> Compute->Hosts->New - including the Hosted engine option "Choose hosted engine deployment action" set to "Deploy"<br> </p> <p>After that we found out, that on the new node the host_id entry was causing problems. In <br> </p> <p>/etc/ovirt-hosted-engine/hosted-engine.conf<br> </p> <p>we found the entry<br> </p> <p>...<br> host_id=3D2<br> ...<br> <br> But that host id already exists and was alive during deployment process.<br> So my questions are:</p> <ul> <li>How is the host id chosen (when adding a new host via GUI)?</li=
<li>Is there an option to preselect the host id in the GUI for a new node?</li> <li>How can we prevent further duplicate host ids?<br> </li> </ul> <p>Thanks and best regards,<br> Thomas<br> </p> <br> <pre class=3D"moz-signature" cols=3D"72"> --=20 ________________________________________________________________________ Dipl.-Inform. Thomas Klute <a class=3D"moz-txt= -link-abbreviated" href=3D"mailto:klute@ingenit.com">klute@ingenit.com</a=
Gesch=C3=A4ftsf=C3=BChrer / CEO ---------------------------------------------------------------------- ingenit GmbH & Co. KG Tel. +49 (0)231 58 698-1= 20 Emil-Figge-Strasse 76-80 Fax. +49 (0)231 58 698-121 D-44227 Dortmund <a class=3D"moz-t= xt-link-abbreviated" href=3D"http://www.ingenit.com">www.ingenit.com</a> Registergericht: Amtsgericht Dortmund, HRA 13 914 Gesellschafter : Thomas Klute, Marc-Christian Schr=C3=B6er ________________________________________________________________________ </pre> </body> </html> --------------27CA2B1123847DBF1F81EC89--

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? Best regards -- Martin Sivak SLA / oVirt On Mon, Apr 23, 2018 at 12:54 PM, Thomas Klute <klute@ingenit.com> 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@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

On Mon, Apr 23, 2018 at 1:04 PM, Martin Sivak <msivak@redhat.com> 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@ingenit.com> 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@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

This is a multi-part message in MIME format. --------------E286642B64280AE88EDC5994 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable 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.
=C2=A0vds_name | vds_spm_id =C2=A0oVirt4=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 3 =C2=A0oVirt2=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 4 =C2=A0oVirt6=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 6 =C2=A0oVirt5=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 5 =C2=A0oVirt1=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 1 =C2=A0oVirt3=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 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=3D2 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@redhat.com <mailto:msivak@redhat.com>> 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=C2=A0 =C2=A0 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=C2=A0/var/log/ovirt-engine/host-deploy (still from t=
he
engine VM)? =C2=A0
Best regards
-- Martin Sivak SLA / oVirt
On Mon, Apr 23, 2018 at 12:54 PM, Thomas Klute <klute@ingenit.com <mailto:klute@ingenit.com>> 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=3D2 > ... > > 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 > > > -- > ___________________________________________________________________=
> >=C2=A0 Dipl.-Inform. Thomas Klute=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0
=C2=A0klute@ingenit.com <mailto:klute@ingenit.com> >=C2=A0 Gesch=C3=A4ftsf=C3=BChrer / CEO >=C2=A0 -------------------------------------------------------------------=
---
>=C2=A0 ingenit GmbH & Co. KG=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Tel. +49 (0)231 58
698-120 >=C2=A0 Emil-Figge-Strasse 76-80=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Fax. +49 (0)231 58
698-121 >=C2=A0 D-44227 Dortmund=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0
=C2=A0www.ingenit.com <http://www.ingenit.com> > >=C2=A0 Registergericht: Amtsgericht Dortmund, HRA 13 914 >=C2=A0 Gesellschafter : Thomas Klute, Marc-Christian Schr=C3=B6er > ___________________________________________________________________=
_____
> > > _______________________________________________ > Users mailing list > Users@ovirt.org <mailto:Users@ovirt.org> > http://lists.ovirt.org/mailman/listinfo/users <http://lists.ovirt.org/mailman/listinfo/users> >
Sollten noch Fragen offen sein, stehen wir Ihnen nat=C3=BCrlich jederzeit gerne zur Verf=C3=BCgung. Mit Gr=C3=BC=C3=9Fen aus Dortmund, Thomas Klute --=20 ________________________________________________________________________ Dipl.-Inform. Thomas Klute klute@ingenit.com Gesch=C3=A4ftsf=C3=BChrer / 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=C3=B6er ________________________________________________________________________ --------------E286642B64280AE88EDC5994 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <html> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dutf= -8"> </head> <body text=3D"#000000" bgcolor=3D"#FFFFFF"> <div class=3D"moz-cite-prefix">Dear Simone,<br> <br> thanks for the help, I already have noticed, that there is a mismatch between SPM IDs and the hosts.<br> From my knowledge this may be our fault.<br> <br> =C2=A0vds_name | vds_spm_id<br> =C2=A0oVirt4=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 3<br> =C2=A0oVirt2=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 4<br> =C2=A0oVirt6=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 6<br> =C2=A0oVirt5=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 5<br> =C2=A0oVirt1=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 1<br> =C2=A0oVirt3=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 2<br> <br> 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).<br> It was not available in fact because of the host ovirt2 having the host_id=3D2 entry in the configuration on the host and the sanlock having locked the appropriate space.<br> <br> 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).<= br> Thus I think it is not a bug at the moment.<br> <br> But that leads me to the next question:<br> <br> Is there a manual way to align numbers in the hostnames with the SPM IDs? (oVirt4 should be spm id 4)<br> <br> Does this work? Update the database, change the entry in hosted-engine.conf and then reboot the node?<br> <br> Thanks & best regards,<br> Thomas<br> <br> <br> </div> <blockquote type=3D"cite" cite=3D"mid:CAN8-ONoCNj8gth+sxHdgXnYOEizwtcUXLocaBddo+Z+jJdHUKA@mail.gmai= l.com"> <div dir=3D"ltr"><br> <div class=3D"gmail_extra"><br> <div class=3D"gmail_quote">On Mon, Apr 23, 2018 at 1:04 PM, Martin Sivak <span dir=3D"ltr"><<a href=3D"mailto:msivak@redhat.com" target=3D"_blank" moz-do-not-send=3D"true">msivak@redhat.com</a>></span> wrote:<br> <blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello,<br> <br> the ID should be coming from the SPM ID of the host as assigned by the<br> engine and duplicates should not be happening indeed.<br> <br> Can you please tell us what version of engine you have and how was<br> first hosted engine node deployed? We recently changed the default<br> deployment method (4.2.2 in fact) and we would like to know whether<br> this might be related to that change or not.<br> <br> Simone, do you know how to debug this? Are there logs we could use to<br> check the behavior? The host-deploy logs maybe?<br> </blockquote> <div><br> </div> <div>Thomas,</div> <div>can you please share the output of=C2=A0</div> <div>=C2=A0 sudo -u postgres scl enable rh-postgresql95 -- ps= ql -d engine -c "select vds_id, vds_name, vds_spm_id from vds"<br> </div> <div>executed on the engine VM</div> <div><br> </div> <div>and the content of=C2=A0/var/log/ovirt-engine/host-deplo= y (still from the engine VM)?</div> <div>=C2=A0</div> <blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> <br> Best regards<br> <br> --<br> Martin Sivak<br> SLA / oVirt<br> <div> <div class=3D"gmail-h5"><br> On Mon, Apr 23, 2018 at 12:54 PM, Thomas Klute <<a href=3D"mailto:klute@ingenit.com" moz-do-not-send=3D"true">klute@ingenit.com</a>> wrote:<br> > Dear oVirt Users,<br> ><br> > we installed a third ovirt node using the ovirt node ng image (4.2.2), and<br> > added that node using the web interface of the hosted engine:<br> ><br> > Compute->Hosts->New - including the Hosted engine option "Choose hosted<br> > engine deployment action" set to "Deploy"<br> ><br> > After that we found out, that on the new node the host_id entry was causing<br> > problems. In<br> ><br> > /etc/ovirt-hosted-engine/<wbr>hosted-engine.conf<b= r> ><br> > we found the entry<br> ><br> > ...<br> > host_id=3D2<br> > ...<br> ><br> > But that host id already exists and was alive during deployment process.<br> > So my questions are:<br> ><br> > How is the host id chosen (when adding a new host via GUI)?<br> > Is there an option to preselect the host id in the GUI for a new node?<br> > How can we prevent further duplicate host ids?<br> ><br> > Thanks and best regards,<br> > Thomas<br> ><br> ><br> > --<br> > ______________________________<wbr>_______________= _______________<wbr>____________<br> ><br> >=C2=A0 Dipl.-Inform. Thomas Klute=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0<a href=3D"mailto:klute@ingenit.com= " moz-do-not-send=3D"true">klute@ingenit.com</a><br> >=C2=A0 Gesch=C3=A4ftsf=C3=BChrer / CEO<br> >=C2=A0 ------------------------------<wbr>---------= ---------------------<wbr>----------<br> >=C2=A0 ingenit GmbH & Co. KG=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Tel. +49 (0)231 58 698-120<br> >=C2=A0 Emil-Figge-Strasse 76-80=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Fax. +49 (0)231 58 698-121<br> >=C2=A0 D-44227 Dortmund=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0<a href=3D"http://www.ingeni= t.com" rel=3D"noreferrer" target=3D"_blank" moz-do-not-send=3D"true">www.ingenit.com</a><br> ><br> >=C2=A0 Registergericht: Amtsgericht Dortmund, HRA 1= 3 914<br> >=C2=A0 Gesellschafter : Thomas Klute, Marc-Christia= n Schr=C3=B6er<br> > ______________________________<wbr>_______________= _______________<wbr>____________<br> ><br> ><br> </div> </div> > ______________________________<wbr>_________________<b= r> > Users mailing list<br> > <a href=3D"mailto:Users@ovirt.org" moz-do-not-send=3D"true">Users@ovirt.org</a><br> > <a href=3D"http://lists.ovirt.org/mailman/listinfo/users" rel=3D"noreferrer" target=3D"_blank" moz-do-not-send=3D"t= rue">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br> ><br> </blockquote> </div> <br> </div> </div> </blockquote> <p><br> </p> <pre class=3D"moz-signature" cols=3D"72">Sollten noch Fragen offen se= in, stehen wir Ihnen nat=C3=BCrlich jederzeit gerne zur Verf=C3=BCgung. Mit Gr=C3=BC=C3=9Fen aus Dortmund, Thomas Klute --=20 ________________________________________________________________________ Dipl.-Inform. Thomas Klute <a class=3D"moz-txt= -link-abbreviated" href=3D"mailto:klute@ingenit.com">klute@ingenit.com</a=
Gesch=C3=A4ftsf=C3=BChrer / CEO ---------------------------------------------------------------------- ingenit GmbH & Co. KG Tel. +49 (0)231 58 698-1= 20 Emil-Figge-Strasse 76-80 Fax. +49 (0)231 58 698-121 D-44227 Dortmund <a class=3D"moz-t= xt-link-abbreviated" href=3D"http://www.ingenit.com">www.ingenit.com</a> Registergericht: Amtsgericht Dortmund, HRA 13 914 Gesellschafter : Thomas Klute, Marc-Christian Schr=C3=B6er ________________________________________________________________________ </pre> </body> </html> --------------E286642B64280AE88EDC5994--

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@ingenit.com> 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@redhat.com> 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@ingenit.com> 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@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@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@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 ________________________________________________________________________

Hi Martin, I fully understand. The only reason is that it's not only me administering this oVirt setup, it's a setup for a client that has 2 local administrators. We are trying to eliminate any configuration that might cause confusion. When doing a hosted-engine --vm-status a list like this is shown: --== Host 1 status ==-- ... Hostname : ovirt1.munk.de Host ID : 1 ... --== Host 2 status ==-- ... Hostname : ovirt3.munk.de Host ID : 2 ... and so on. This "Host 2" -> ovirt3 will sooner or later cause confusion and will lead to administrative actions applied to the wrong hosts. I'll give it a try and try to align the hosts and ids. I'll backup the old values in order to be able to roll back the changes if it does not work. Thanks for your help!! Best regards, Thomas
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@ingenit.com> 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@redhat.com> 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@ingenit.com> 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@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@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@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 ________________________________________________________________________
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@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 ________________________________________________________________________

Hi Thomas, I posted https://gerrit.ovirt.org/#/c/90549/ in an attempt to see how to improve the clarity. The result is in the attachment. The ID is still different, but the section header shows the hostname as well. Do you think it would be enough for you? We can't expect people to touch the DB every time they add a host out of order and the SPM ID is not selectable by user, because it needs to fit some storage constraints (we use it for protecting storage metadata) and must match the hosted engine ID now. Best regards Martin Sivak On Mon, Apr 23, 2018 at 2:47 PM, Thomas Klute <klute@ingenit.com> wrote:
Hi Martin,
I fully understand. The only reason is that it's not only me administering this oVirt setup, it's a setup for a client that has 2 local administrators. We are trying to eliminate any configuration that might cause confusion. When doing a
hosted-engine --vm-status
a list like this is shown:
--== Host 1 status ==-- ... Hostname : ovirt1.munk.de Host ID : 1 ...
--== Host 2 status ==-- ... Hostname : ovirt3.munk.de Host ID : 2 ...
and so on. This "Host 2" -> ovirt3 will sooner or later cause confusion and will lead to administrative actions applied to the wrong hosts.
I'll give it a try and try to align the hosts and ids. I'll backup the old values in order to be able to roll back the changes if it does not work.
Thanks for your help!! Best regards, Thomas
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@ingenit.com> 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@redhat.com> 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@ingenit.com> 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@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@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@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 ________________________________________________________________________
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@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 ________________________________________________________________________

Dear Martin, yes, that's a good improvement! Just to let you know: The alignment of database and host ids did work and thus we now have everything aligned and will have an improved output because of your changes, thanks! Best regards, Thomas
Hi Thomas,
I posted https://gerrit.ovirt.org/#/c/90549/ in an attempt to see how to improve the clarity. The result is in the attachment.
The ID is still different, but the section header shows the hostname as well. Do you think it would be enough for you? We can't expect people to touch the DB every time they add a host out of order and the SPM ID is not selectable by user, because it needs to fit some storage constraints (we use it for protecting storage metadata) and must match the hosted engine ID now.
Best regards
Martin Sivak
On Mon, Apr 23, 2018 at 2:47 PM, Thomas Klute <klute@ingenit.com> wrote:
Hi Martin,
I fully understand. The only reason is that it's not only me administering this oVirt setup, it's a setup for a client that has 2 local administrators. We are trying to eliminate any configuration that might cause confusion. When doing a
hosted-engine --vm-status
a list like this is shown:
--== Host 1 status ==-- ... Hostname : ovirt1.munk.de Host ID : 1 ...
--== Host 2 status ==-- ... Hostname : ovirt3.munk.de Host ID : 2 ...
and so on. This "Host 2" -> ovirt3 will sooner or later cause confusion and will lead to administrative actions applied to the wrong hosts.
I'll give it a try and try to align the hosts and ids. I'll backup the old values in order to be able to roll back the changes if it does not work.
Thanks for your help!! Best regards, Thomas
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@ingenit.com> 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@redhat.com> 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@ingenit.com> 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@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@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@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 ________________________________________________________________________ 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@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 ________________________________________________________________________
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@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 ________________________________________________________________________
participants (3)
-
Martin Sivak
-
Simone Tiraboschi
-
Thomas Klute