<div dir="ltr">Well, it worked, I could upgrade the hosted-engine changing the /etc/locale to en-US-UTF8. I deactivated puppet too, if someone are using puppet for provisioning. <div><br></div><div>Now I'm having problems to update the host, but it's just this annoying bug from vsdm(you need to restart it....)</div><div><br></div><div>Thanks a lot!</div><div><br></div><div>Best Regards,</div><div><br></div><div>Gabriel</div><div>PS: Looking forward for the resolution in Bugzilla.</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><span><font color="#888888"><span style="font-family:Calibri,sans-serif;font-size:11pt">Gabriel Stein</span><br><span style="font-family:Calibri,sans-serif;font-size:11pt">------------------------------</span><br><span style="font-family:Calibri,sans-serif;font-size:11pt">Gabriel Ferraz Stein</span><br><span style="font-family:Calibri,sans-serif;font-size:11pt">Tel.: <a value="+4915778816311">+49 (0) 170 2881531</a></span><br></font></span></div></div></div></div></div>
<br><div class="gmail_quote">2017-12-21 17:15 GMT+01:00 Simone Tiraboschi <span dir="ltr"><<a href="mailto:stirabos@redhat.com" target="_blank">stirabos@redhat.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">On Thu, Dec 21, 2017 at 4:30 PM, Simone Tiraboschi <span dir="ltr"><<a href="mailto:stirabos@redhat.com" target="_blank">stirabos@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="m_-3479158988183128573gmail-h5">On Thu, Dec 21, 2017 at 8:41 AM, Sandro Bonazzola <span dir="ltr"><<a href="mailto:sbonazzo@redhat.com" target="_blank">sbonazzo@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote"><span class="m_-3479158988183128573gmail-m_-1610598877350784934gmail-">2017-12-20 16:07 GMT+01:00 Gabriel Stein <span dir="ltr"><<a href="mailto:gabrielstein@gmail.com" target="_blank">gabrielstein@gmail.com</a>></span>:<br></span><span class="m_-3479158988183128573gmail-m_-1610598877350784934gmail-"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi!<div><br><div>well, I'm a update fever and I decided to update my ovirt to 4.2.0.</div></div></div></blockquote><div><br></div></span><div>Thanks for this valuable feedback! Simone has already replied and will check your setup logs.</div><span class="m_-3479158988183128573gmail-m_-1610598877350784934gmail-"><div><br></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div><br></div><div>How I'm doingi it? </div><div><br></div><div>I'm following the rules!</div><div><br></div><div>1 - Global Maintenance Mode</div><div>2 - Yum Install ovirt-release-4.2</div><div>3- yum update ovirt-setup*.</div><div><br></div><div>But, by the engine-setup I have a conflict with the system collation and postgresql. Unfortunatelly I changed via puppet to the german collation(de_DE-UTF8) of ovirt-engine hosted vm(because it's a standard for us) but this was after the engine-setup and the DB Configuration from Postgresql.</div></div></div></blockquote><div><br></div></span><div>Adding also Didi</div><span class="m_-3479158988183128573gmail-m_-1610598877350784934gmail-"><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div><br></div><div>I think that I can easily change the system collation to us-US-UFT8 but I'm afraid that I can "destroy" my hosted-engine VM with that change, is hosted-engine so sensible?<br><br>How I know that error? The logs are saying that(and the error in on postgresql upgrade part of setup)!</div><div><br></div><div><div><i>Performing Consistency Checks</i></div><div><i>-----------------------------</i></div><div><i>Checking cluster versions ok</i></div><div><i>Checking database user is the install user ok</i></div><div><i>Checking database connection settings ok</i></div><div><i>Checking for prepared transactions ok</i></div><div><i>Checking for reg* system OID user data types ok</i></div><div><i>Checking for contrib/isn with bigint-passing mismatch ok</i></div><div><i>Checking for invalid "line" user columns ok</i></div><div><i>Creating dump of global objects ok</i></div><div><i>Creating dump of database schemas</i></div><div><i> engine</i></div><div><i> ovirt_engine_history</i></div><div><i> postgres</i></div><div><i> template1</i></div><div><i> ok</i></div><div><i><br></i></div><div><i>lc_collate values for database "postgres" do not match: old "en_US.UTF-8", new "de_DE.UTF-8"</i></div><div><i>Failure, exiting</i></div></div><div><i><br></i></div><div>I would be thankful if someone could give me some hint about that!</div></div></div></blockquote></span></div></div></div></blockquote><div><br></div></div></div>OK, reproduced.<br>The issue happens if and only if you changed system wide locales after having installed ovirt-engine but before upgrading it to 4.2.<br>I'm going to open a bug to track it.<br></div></div></div></blockquote><div><br></div></div></div><div><a href="https://bugzilla.redhat.com/show_bug.cgi?id=1528371" target="_blank">https://bugzilla.redhat.com/<wbr>show_bug.cgi?id=1528371</a><br></div><div><div class="h5"><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><br>In engine-setup we are explicitly setting en_US.UTF-8 as the locale of the engine DB but we are not touching at all the locale of postgres own DB which match the system wide locale and your issue is indeed on the postgres DB, not on the engine one.<br>pg_upgrade cannot change it on the fly on upgrades.</div><div class="gmail_quote"><br></div><div class="gmail_quote">I tried to find a working fix with env variables but unfortunately nothing I tired worked.<br>The only workaround I was able to find is to temporary set the locale you had at first successful engine-setup execution time (en_US.UTF-8 in your case but it varies) under /etc/locale.conf and only then execute engine-setup to upgrade it to 4.2.<br>After that you could safely switch back /etc/locale.conf to whatever you need.<br>All the env variable I tried seams absolutely not relevant for this specific issue.<span class="m_-3479158988183128573gmail-"><div><br></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><span class="m_-3479158988183128573gmail-m_-1610598877350784934gmail-"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div><br></div><div>Best Regards,</div><div><br></div><div>Gabriel</div><div>PS: If I go to devconf in Brno I will pay a lot of beers to the developer of the engine-setup rollback! Saved my life!</div></div></div></blockquote><div><br></div></span><div>The specific developer won't be there, but you're welcome to reach oVirt people there and share some beer :-)</div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><span class="m_-3479158988183128573gmail-m_-1610598877350784934gmail-"><div dir="ltr"><div><span class="m_-3479158988183128573gmail-m_-1610598877350784934gmail-m_5757980399539745944HOEnZb"><font color="#888888"><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br clear="all"><div><div class="m_-3479158988183128573gmail-m_-1610598877350784934gmail-m_5757980399539745944m_-1919416582018557725gmail_signature"><div dir="ltr"><div><div dir="ltr"><span><font color="#888888"><span style="font-family:Calibri,sans-serif;font-size:11pt">Gabriel Stein</span><br><span style="font-family:Calibri,sans-serif;font-size:11pt">------------------------------</span><br><span style="font-family:Calibri,sans-serif;font-size:11pt">Gabriel Ferraz Stein</span><br><span style="font-family:Calibri,sans-serif;font-size:11pt">Tel.: <a value="+4915778816311">+49 (0) 170 2881531</a></span><br></font></span></div></div></div></div></div>
</div></font></span></div></div>
<br></span><span class="m_-3479158988183128573gmail-m_-1610598877350784934gmail-">______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a><br>
<br></span></blockquote></div><span class="m_-3479158988183128573gmail-m_-1610598877350784934gmail-HOEnZb"><font color="#888888"><br><br clear="all"><div><br></div>-- <br><div class="m_-3479158988183128573gmail-m_-1610598877350784934gmail-m_5757980399539745944gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><p style="color:rgb(0,0,0);font-family:overpass,sans-serif;font-weight:bold;margin:0px;padding:0px;font-size:14px;text-transform:uppercase"><span>SANDRO</span> <span>BONAZZOLA</span></p><p style="color:rgb(0,0,0);font-family:overpass,sans-serif;font-size:10px;margin:0px 0px 4px;text-transform:uppercase"><span>ASSOCIATE MANAGER, SOFTWARE ENGINEERING, EMEA ENG VIRTUALIZATION R&D</span></p><p style="font-family:overpass,sans-serif;margin:0px;font-size:10px;color:rgb(153,153,153)"><a href="https://www.redhat.com/" style="color:rgb(0,136,206);margin:0px" target="_blank">Red Hat <span>EMEA</span></a></p><table border="0" style="color:rgb(0,0,0);font-family:overpass,sans-serif;font-size:medium"><tbody><tr><td width="100px"><a href="https://red.ht/sig" target="_blank"><img src="https://www.redhat.com/profiles/rh/themes/redhatdotcom/img/logo-red-hat-black.png" width="90" height="auto"></a></td><td style="font-size:10px"><div><a href="https://redhat.com/trusted" style="color:rgb(204,0,0);font-weight:bold" target="_blank">TRIED. TESTED. TRUSTED.</a></div></td></tr></tbody></table><br></div></div></div></div></div></div></div></div></div></div></div></div></div>
</font></span></div></div>
<br>______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a><br>
<br></blockquote></span></div><br></div></div>
</blockquote></div></div></div><br></div></div>
</blockquote></div><br></div>