<div dir="ltr"><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">Hi Sven,<br><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">I've found this one: <a href="https://gist.github.com/turboladen/6790847">https://gist.github.com/turboladen/6790847</a><br><br></div><div class="gmail_default" style="font-family:tahoma,sans-serif;font-size:small">I think it should help :)<br></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"><div><span style="font-family:tahoma,sans-serif"><b>Regards,<br></b></span></div><span style="font-family:tahoma,sans-serif"><b>Shani Leviim<br></b></span></div></div></div></div></div>
<br><div class="gmail_quote">On Fri, Apr 13, 2018 at 12:00 PM, Sven Achtelik <span dir="ltr"><<a href="mailto:Sven.Achtelik@eps.aero" target="_blank">Sven.Achtelik@eps.aero</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi All, <br>
<br>
I got my stuff up and running again. I works like described in the manual and I used some extra hardware to jumpstart this. I'm now back on my hosted Engine 4.1.9 with 3 Hosts running it. The Engine is running on the appliance that is pulled by the deployment tool and after having everything stable again I thought of upgrading to 4.2. Thing is that this is just not working with the appliance because of some issue when upgrading Postgres inside. Looking at the logs I found this: <br>
----------------------------<br>
Creating dump of database schemas<br>
engine<br>
ovirt_engine_history<br>
postgres<br>
template1<br>
ok<br>
<br>
encodings for database "postgres" do not match: old "SQL_ASCII", new "UTF8"<br>
Failure, exiting<br>
------------------------------<br>
<br>
After some research I found something here <a href="https://bugzilla.redhat.com/show_bug.cgi?id=1525976" rel="noreferrer" target="_blank">https://bugzilla.redhat.com/<wbr>show_bug.cgi?id=1525976</a>, but I'm not sure what to do with that Information. I used the appliance and didn't do anything manual in the complete process and I'm wondering why I'm getting this issue now ? Could someone advice on how to proceed ? <br>
<br>
Thank you, <br>
Sven <br>
<br>
> -----Ursprüngliche Nachricht-----<br>
> Von: <a href="mailto:users-bounces@ovirt.org">users-bounces@ovirt.org</a> [mailto:<a href="mailto:users-bounces@ovirt.org">users-bounces@ovirt.<wbr>org</a>] Im Auftrag<br>
> von Sven Achtelik<br>
> Gesendet: Mittwoch, 28. März 2018 18:28<br>
> An: Yedidyah Bar David<br>
<div class="HOEnZb"><div class="h5">> Cc: <a href="mailto:users@ovirt.org">users@ovirt.org</a><br>
> Betreff: Re: [ovirt-users] Recovering oVirt-Engine with a backup before<br>
> upgrading to 4.2<br>
> <br>
> <br>
> <br>
> > -----Ursprüngliche Nachricht-----<br>
> > Von: Yedidyah Bar David [mailto:<a href="mailto:didi@redhat.com">didi@redhat.com</a>]<br>
> > Gesendet: Mittwoch, 28. März 2018 10:06<br>
> > An: Sven Achtelik<br>
> > Cc: <a href="mailto:users@ovirt.org">users@ovirt.org</a><br>
> > Betreff: Re: [ovirt-users] Recovering oVirt-Engine with a backup<br>
> > before upgrading to 4.2<br>
> ><br>
> > On Tue, Mar 27, 2018 at 9:14 PM, Sven Achtelik<br>
> > <<a href="mailto:Sven.Achtelik@eps.aero">Sven.Achtelik@eps.aero</a>><br>
> > wrote:<br>
> > > Hi All,<br>
> > ><br>
> > ><br>
> > ><br>
> > > I’m still facing issues with my HE engine. Here are the steps that I<br>
> > > took to end up in this situation:<br>
> > ><br>
> > ><br>
> > ><br>
> > > - Update Engine from 4.1.7 to 4.1.9<br>
> > ><br>
> > > o That worked as expected<br>
> > ><br>
> > > - Automatic Backup of Engine DB in the night<br>
> > ><br>
> > > - Upgraded Engine from 4.1.9 to 4.2.1<br>
> > ><br>
> > > o That worked fine<br>
> > ><br>
> > > - Noticed Issues with the HA support for HE<br>
> > ><br>
> > > o Cause was not having the latest ovirt-ha agent/broker version on hosts<br>
> > ><br>
> > > - After updating the first host with the latest packages for the<br>
> > > Agent/Broker engine was started twice<br>
> > ><br>
> > > o As a result the Engine VM Disk was corrupted and there is no Backup of<br>
> > > the Disk<br>
> > ><br>
> > > o There is also no Backup of the Engine DB with version 4.2<br>
> > ><br>
> > > - VM disk was repaired with fsck.ext4, but DB is corrupt<br>
> > ><br>
> > > o Can’t restore the Engine DB because the Backup DB from Engine V 4.1<br>
> > ><br>
> > > - Rolled back all changes on Engine VM to 4.1.9 and imported Backup<br>
> > ><br>
> > > o Checked for HA VMs to set as disabled and started the Engine<br>
> > ><br>
> > > - Login is fine but the Engine is having trouble picking up and<br>
> > > information from the Hosts<br>
> > ><br>
> > > o No information on running VMs or hosts status<br>
> > ><br>
> > > - Final Situation<br>
> > ><br>
> > > o 2 Hosts have VMs still running and I can’t stop those<br>
> > ><br>
> > > o I still have the image of my corrupted Engine VM (v4.2)<br>
> > ><br>
> > ><br>
> > ><br>
> > > Since there were no major changes after upgrading from 4.1 to 4.2,<br>
> > > would it be possible to manually restore the 4.1 DB to the 4.2<br>
> > > Engine VM to this up and running again or are there modifications<br>
> > > made to the DB on upgrading that are relevant for this ?<br>
> ><br>
> > engine-backup requires restoring to the same version used to take the<br>
> > backup, with a single exception - on 4.0, it can restore 3.6.<br>
> ><br>
> > It's very easy to patch it to allow also 4.1->4.2, search inside it<br>
> > for "VALID_BACKUP_RESTORE_PAIRS". However, I do not think anyone ever<br>
> > tested this, so no idea might break. In 3.6->4.0 days, we did have to<br>
> > fix a few other things, notably apache httpd and iptables->firewalld:<br>
> ><br>
> > <a href="https://bugzilla.redhat.com/show_bug.cgi?id=1318580" rel="noreferrer" target="_blank">https://bugzilla.redhat.com/<wbr>show_bug.cgi?id=1318580</a><br>
> ><br>
> > > All my work on rolling back to 4.1.9 with the DB restore failed as<br>
> > > the Engine is not capable of picking up information from the hosts.<br>
> ><br>
> > No idea why, but not sure it's related to your restore flow.<br>
> ><br>
> > > Lessons learned is to always make a copy/snapshot of the engine VM<br>
> > > disk before upgrading anything.<br>
> ><br>
> > If it's a hosted-engine, this isn't supported - see my reply on the<br>
> > list ~ 1 hour ago...<br>
> ><br>
> > > What are my options on getting<br>
> > > back to a working environment ? Any help or hint is greatly appreciated.<br>
> ><br>
> > Restore again with either methods - what you tried, or patching<br>
> > engine- backup and restore directly into 4.2 - and if the engine fails<br>
> > to talk to the hosts, try to debug/fix this.<br>
> ><br>
> > If you suspect corruption more severe that just the db, you can<br>
> > install a fresh engine machine from scratch and restore to it. If it's<br>
> > a hosted-engine, you'll need to deploy hosted-engine from scratch,<br>
> > check docs about hosted-engine backup/restore.<br>
> <br>
> I read through those documents and it seems that I would need an extra<br>
> Host/Hardware which I don't have. <a href="https://ovirt.org/documentation/self-" rel="noreferrer" target="_blank">https://ovirt.org/<wbr>documentation/self-</a><br>
> hosted/chap-Backing_up_and_<wbr>Restoring_an_EL-Based_Self-<br>
> Hosted_Environment/<br>
> <br>
> So how would I be able to get a new setup working when I would like to use the<br>
> Engine-VM-Image ? At this point it sounds like I would have to manually<br>
> reinstall the machine that is left over and running. I'm lost at this point.<br>
> ><br>
> > Best regards,<br>
> > --<br>
> > Didi<br>
> ______________________________<wbr>_________________<br>
> Users mailing list<br>
> <a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
> <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
</div></div></blockquote></div><br></div>