<div dir="ltr"><div><div>Hello ,</div><div> I do a full-backup of ovirt-engine,instaled ovirt-engine in new host , drop database postgres and create a new with this steps:</div><div><br></div><div> 1-drop database postgres;</div><div> 2- create database template1 with owner=postgres encoding='UTF-8' </div><div> lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;</div><div> </div><div>and after this steps I restores backup of ovirt-engine and run engine-setup, upgrade works now.</div><div><br></div><div>With this steps I can obtain somethings erros in the future?</div><div><br></div><div>Thanks,</div><div><br></div><div>Marcelo Leandro</div></div><br><div class="gmail_quote"><div dir="ltr">Em seg, 23 de abr de 2018 17:04, Marcelo Leandro <<a href="mailto:marceloltmm@gmail.com" target="_blank">marceloltmm@gmail.com</a>> escreveu:<br></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>Thank you for reply, </div><div><br></div><div><br></div><div>"BZ 1515635 [RFE] Drop uuid_generate_v1() internal implementation and use the implementation from standard PostgreSQL uuid-ossp extension</div><div>We have added a requirement for uuid-ossp PostgreSQL extension to be present in engine database. For databases managed by engine-setup this is performed automatically, but non-managed databases (usually remote databases) this needs to be done manually by administrators. "</div><div><br></div><div><br></div><div>my database is managed by engine-setup, so i think that is perfomed automatically. I know that problem in my database , but I instaled it`s whith engine-setup com default options.</div><div><br></div><div>I try an new instalation in new host and restore backup and when I try update I had take the same error.</div><div><br></div><div><br></div><div>Very thanks!!</div><div><div><span style="color:rgb(51,51,51);font-family:"Source Sans Pro","Open Sans","Helvetica Neue",Helvetica,Arial,sans-serif;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div><span style="color:rgb(51,51,51);font-family:"Source Sans Pro","Open Sans","Helvetica Neue",Helvetica,Arial,sans-serif;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div><span style="color:rgb(51,51,51);font-family:"Source Sans Pro","Open Sans","Helvetica Neue",Helvetica,Arial,sans-serif;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div><br></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">2018-04-23 16:47 GMT-03:00 Alexander Wels <span dir="ltr"><<a href="mailto:awels@redhat.com" rel="noreferrer" target="_blank">awels@redhat.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><span>On Monday, April 23, 2018 3:23:21 PM EDT Marcelo Leandro wrote:<br>
> Can someone help me?<br>
> <br>
> Thanks,<br>
> <br>
> Marcelo Leandro<br>
> <br>
<br>
</span>You need postgresql 9.5, following the information here should give you <br>
everything you need:<br>
<br>
<a href="https://www.ovirt.org/release/4.2.1/" rel="noreferrer noreferrer" target="_blank">https://www.ovirt.org/release/<wbr>4.2.1/</a><br>
<br>
Also look at the information below 'What's New in 4.2.1' it has some <br>
information on upgrading the uuid generation which requires some manual steps.<br>
<div class="gmail-m_7567998292622958876m_3776405359289056821HOEnZb"><div class="gmail-m_7567998292622958876m_3776405359289056821h5"><br>
> 2018-04-23 8:27 GMT-03:00 Robert O'Kane <<a href="mailto:okane@khm.de" rel="noreferrer" target="_blank">okane@khm.de</a>>:<br>
> > Hello,<br>
> > <br>
> > Sorry, I did not have to chance anything else. It simply worked after my<br>
> > SELinux solution.<br>
> > <br>
> > Good Luck.<br>
> > <br>
> > Robert O'Kane<br>
> > <br>
> > On 04/23/2018 01:21 PM, Marcelo Leandro wrote:<br>
> >> Hello, Robert<br>
> >> <br>
> >> Thank you for reply, I tried this steps but not worked for me , I think<br>
> >> that I need change parameters in my postgresql but I don't know how do<br>
> >> this.<br>
> >> <br>
> >> <br>
> >> 2018-04-22 7:45 GMT-03:00 Robert O'Kane <<a href="mailto:okane@khm.de" rel="noreferrer" target="_blank">okane@khm.de</a> <mailto:<br>
> >> <br>
> >> <a href="mailto:okane@khm.de" rel="noreferrer" target="_blank">okane@khm.de</a>>>:<br>
> >> Hello,<br>
> >> <br>
> >> I had a similar problem with the engine update from 4.1.9 to 4.2.2.<br>
> >> For me it was SELinux in Enforcing mode on the host. You should<br>
> >> <br>
> >> check that<br>
> >> <br>
> >> SELinux is in "Enforcing" mode and that the audit daemon is<br>
> >> <br>
> >> complaining<br>
> >> <br>
> >> about postgres95. "audit2why -a"<br>
> >> <br>
> >> <br>
> >> I set the host to "Permissive", did the upgrade and it worked for me.<br>
> >> But you may have to leave it in "Permissive" mode until you can<br>
> >> <br>
> >> update the<br>
> >> <br>
> >> SELinux rules.<br>
> >> <br>
> >> <br>
> >> *IF* the problem is SELinux I would suggest:<br>
> >> <br>
> >> 1: Clean up the auditd logs (make sure all old problems are<br>
> >> <br>
> >> corrected).<br>
> >> <br>
> >> Reset the auditd logs so the following output is "cleaner".<br>
> >> The "audit2why -a" command should show nothing. Please RYFM....<br>
> >> <br>
> >> 2: Set SELinux to "Permissive" mode.<br>
> >> <br>
> >> 3: Apply the Ovirt-engine updates. Make sure everything works.<br>
> >> <br>
> >> 4: run "audit2why -a" and see what the warnings are<br>
> >> <br>
> >> or go directly to 5<br>
> >> <br>
> >> 5: generate the new rules with:<br>
> >> audit2allow -a -M postgres95-selinux-ovirt<br>
> >> <br>
> >> 6: add the rules to the system:<br>
> >> semodule -i postgres95-selinux-ovirt.pp<br>
> >> <br>
> >> 7: It should now be possible to set SELinux back to "Enforcing"<br>
> >> <br>
> >> <br>
> >> Good Luck,<br>
> >> <br>
> >> Robert O'Kane<br>
> >> <br>
> >> Am 21.04.2018 um 10:26 schrieb Marcelo Leandro:<br>
> >> Hello,<br>
> >> I have problem when i try upgrade the ovirt to 4.2, my version<br>
> >> <br>
> >> is 4.1.9, I<br>
> >> <br>
> >> have problem when engine-setup try update the postgresql.<br>
> >> Postgres version 9.2<br>
> >> <br>
> >> I had this message:<br>
> >> <br>
> >> Log install:<br>
> >> <br>
> >> ERROR: pg_upgrade tool failed<br>
> >> ERROR: Upgrade failed.<br>
> >> <br>
> >> * See /var/lib/pgsql/upgrade_rh-<wbr>postgresql95-postgresql.log<br>
> >> <br>
> >> for details.<br>
> >> <br>
> >> 2018-04-21 04:53:10,766-0300 DEBUG otopi.transaction<br>
> >> transaction._prepare:66 exception during prepare phase<br>
> >> <br>
> >> Traceback (most recent call last):<br>
> >> File "/usr/lib/python2.7/site-<wbr>packages/otopi/transaction.py"<wbr>,<br>
> >> <br>
> >> line<br>
> >> <br>
> >> 62, in<br>
> >> _prepare<br>
> >> <br>
> >> element.prepare()<br>
> >> <br>
> >> File<br>
> >> <br>
> >> "/usr/share/ovirt-engine/<wbr>setup/ovirt_engine_setup/<wbr>engine_<br>
> >> <br>
> >> common/postgres.py",<br>
> >> <br>
> >> line 777, in prepare<br>
> >> <br>
> >> raiseOnError=True,<br>
> >> <br>
> >> File "/usr/lib/python2.7/site-<wbr>packages/otopi/plugin.py",<br>
> >> <br>
> >> line 931, in<br>
> >> <br>
> >> execute<br>
> >> <br>
> >> command=args[0],<br>
> >> <br>
> >> RuntimeError: Command<br>
> >> '/opt/rh/rh-postgresql95/<wbr>root/usr/bin/postgresql-setup' failed<br>
> >> <br>
> >> to execute<br>
> >> <br>
> >> 2018-04-21 04:53:10,768-0300 DEBUG otopi.context<br>
> >> <br>
> >> context._executeMethod:143<br>
> >> <br>
> >> method exception<br>
> >> <br>
> >> Traceback (most recent call last):<br>
> >> File "/usr/lib/python2.7/site-<wbr>packages/otopi/context.py",<br>
> >> <br>
> >> line 133, in<br>
> >> <br>
> >> _executeMethod<br>
> >> <br>
> >> method['method']()<br>
> >> <br>
> >> File<br>
> >> <br>
> >> "/usr/share/ovirt-engine/<wbr>setup/bin/../plugins/ovirt-<wbr>engine-<br>
> >> <br>
> >> setup/ovirt-engine/db/<wbr>dbmsupgrade.py",<br>
> >> <br>
> >> line 89, in _updateDBMS<br>
> >> <br>
> >> oengcommcons.ProvisioningEnv.<wbr>OLD_POSTGRES_SERVICE<br>
> >> <br>
> >> File "/usr/lib/python2.7/site-<wbr>packages/otopi/transaction.py"<wbr>,<br>
> >> <br>
> >> line 106,<br>
> >> <br>
> >> in append<br>
> >> <br>
> >> self._prepare(element=<wbr>element)<br>
> >> <br>
> >> File "/usr/lib/python2.7/site-<wbr>packages/otopi/transaction.py"<wbr>,<br>
> >> <br>
> >> line<br>
> >> <br>
> >> 62, in<br>
> >> _prepare<br>
> >> <br>
> >> element.prepare()<br>
> >> <br>
> >> File<br>
> >> <br>
> >> "/usr/share/ovirt-engine/<wbr>setup/ovirt_engine_setup/<wbr>engine_<br>
> >> <br>
> >> common/postgres.py",<br>
> >> <br>
> >> line 777, in prepare<br>
> >> <br>
> >> raiseOnError=True,<br>
> >> <br>
> >> File "/usr/lib/python2.7/site-<wbr>packages/otopi/plugin.py",<br>
> >> <br>
> >> line 931, in<br>
> >> <br>
> >> execute<br>
> >> <br>
> >> command=args[0],<br>
> >> <br>
> >> RuntimeError: Command<br>
> >> '/opt/rh/rh-postgresql95/<wbr>root/usr/bin/postgresql-setup' failed<br>
> >> <br>
> >> to execute<br>
> >> <br>
> >> 2018-04-21 04:53:10,770-0300 ERROR otopi.context<br>
> >> <br>
> >> context._executeMethod:152<br>
> >> <br>
> >> Failed to execute stage 'Misc configuration': Command<br>
> >> '/opt/rh/rh-postgresql95/<wbr>root/usr/bin/postgresql-setup' failed<br>
> >> <br>
> >> to execute<br>
> >> <br>
> >> Log postgres:<br>
> >> Performing Consistency Checks<br>
> >> -----------------------------<br>
> >> Checking cluster versions ok<br>
> >> Checking database user is the install user ok<br>
> >> Checking database connection settings ok<br>
> >> Checking for prepared transactions ok<br>
> >> Checking for reg* system OID user data types ok<br>
> >> Checking for contrib/isn with bigint-passing mismatch ok<br>
> >> Checking for invalid "line" user columns ok<br>
> >> Creating dump of global objects ok<br>
> >> Creating dump of database schemas<br>
> >> <br>
> >> engine<br>
> >> ovirt_engine_history<br>
> >> postgres<br>
> >> template1<br>
> >> <br>
> >> ok<br>
> >> <br>
> >> encodings for database "postgres" do not match: old "SQL_ASCII",<br>
> >> <br>
> >> new "UTF8"<br>
> >> <br>
> >> Failure, exiting<br>
> >> <br>
> >> <br>
> >> I know that problem not is in oVirt , but anyone help me ?<br>
> >> <br>
> >> <br>
> >> Thank you!<br>
> >> <br>
> >> <br>
> >> <br>
> >> _____________________________<wbr>__________________<br>
> >> Users mailing list<br>
> >> <a href="mailto:Users@ovirt.org" rel="noreferrer" target="_blank">Users@ovirt.org</a> <mailto:<a href="mailto:Users@ovirt.org" rel="noreferrer" target="_blank">Users@ovirt.org</a>><br>
> >> <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
> >> <<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a>><br>
> >> <br>
> >> -- Systems Administrator<br>
> >> Kunsthochschule für Medien Köln<br>
> >> Peter-Welter-Platz 2<br>
> >> 50676 Köln<br>
> >> _____________________________<wbr>__________________<br>
> >> Users mailing list<br>
> >> <a href="mailto:Users@ovirt.org" rel="noreferrer" target="_blank">Users@ovirt.org</a> <mailto:<a href="mailto:Users@ovirt.org" rel="noreferrer" target="_blank">Users@ovirt.org</a>><br>
> >> <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
> >> <<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a>><br>
> > <br>
> > --<br>
> > Robert O'Kane<br>
> > Systems Administrator<br>
> > Kunsthochschule für Medien Köln<br>
> > Peter-Welter-Platz 2<br>
> > 50676 Köln<br>
> > <br>
> > fon: +49(221)20189-223<br>
> > fax: +49(221)20189-49223<br>
<br>
<br>
<br>
<br>
</div></div></blockquote></div><br></div>
</blockquote></div></div>