Re: [ovirt-users] restore of backup fail when Migrating to ovirt-engine 4.0

28 Jun 2016

      This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--X1bMWFpsf2B6WeUlPQWQ79ga0HH4Ir30b
Content-Type: multipart/mixed; boundary="RbuEg8Cm5biR9Sc8pBSF3NhlWLgtUJ7da"
From: Ricky Schneberger <ricky@schneberger.se>
Reply-To: ricky@schneberger.se
To: Fernando Fuentes <ffuentes@darktcp.net>, users@ovirt.org
Message-ID: <57722D13.7090907@schneberger.se>
Subject: Re: [ovirt-users] restore of backup fail when Migrating to
 ovirt-engine 4.0
References: <577140AA.1030104@schneberger.se>
 <CAN8-ONptgJF+xyMyD03vn_T_JDw9TYjN5+xp_0P0+ck5XGG2SA@mail.gmail.com>
 <1467043075.437745.649812721.558AB7EF@webmail.messagingengine.com>
 <57715132.9030101@schneberger.se>
 <1467047727.452431.649895969.3DAA7E9C@webmail.messagingengine.com>
In-Reply-To: <1467047727.452431.649895969.3DAA7E9C@webmail.messagingengine.com>

--RbuEg8Cm5biR9Sc8pBSF3NhlWLgtUJ7da
Content-Type: multipart/mixed;
 boundary="------------060009030503040407080808"

This is a multi-part message in MIME format.
--------------060009030503040407080808
Content-Type: multipart/alternative;
 boundary="------------060709040505040106000408"

--------------060709040505040106000408
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

On 2016-06-27 19:15, Fernando Fuentes wrote:
...
Ricky,
I am under the impression that the DB migration was implemented in
release 3.6.6.
I might be wrong.
https://www.ovirt.org/release/3.6.6/
What's New in 3.6.6?
Enhancement
oVirt Engine
BZ 1241149 [RFE] Provide way to preform in-cluster upgrade of hosts from
el6->el7.
BZ 1332463 [RFE] restore: ensure that 3.6 on el6 backup can be restored
on 3.6 on el7
Feature:=20
Allow engine-backup on el7 to restore backups taken on el6.
Reason:=20
engine 4.0 does not support el6. Users that want to upgrade from 3.6 on
el6 to 4.0 on el7 have to do this by backing up the engine on 3.6/el6
and restore on 4.0/el7.
This feature, backported from 4.0, allows to do such a migration also in
3.6.
Result:=20
Using this flow, it's possible to migrate a el6 setup to el7:
On the existing engine machine run:
1. engine-backup --mode=3Dbackup --file=3Dengine-3.6.bck --log=3Dbackup.l=
og
On a new el7 machine:
2. Install engine, including dwh if it was set up on el6.
3. Copy engine-3.6.bck to the el7 machine
4. engine-backup --mode=3Drestore --file=3Dengine-3.6.bck --log=3Drestore=
.log
--provision-db --no-restore-permissions
5. engine-setup
Check engine-backup documentation for other options, including using
remote databases, extra grants/permissions, etc.
One step forward, two backward....

- upgrade the old EL6 to ovirt 3.6.6
- engine-backup --mode=3Dbackup --file=3Dengine-backup.tar.gz --log=3Dbacku=
p.log
- install http://resources.ovirt.org/pub/yum-repo/ovirt-release40.rpm,
to have ovirt-engine 4.0.0.6.
- yum install ovirt-engine
- |engine-backup --mode=3Drestore --no-restore-permissions --provision-db
--file=3Dengine-backup.tar.gz --log=3Dengine-backup-restore.log

Then I got this error...

"Preparing to restore:
- Unpacking file 'engine-backup.tar.gz'
Restoring:
- Files
---------------------------------------------------------------------------=
---
Please note:

Operating system is different from the one used during backup.
Current operating system: centos7
Operating system at backup: centos6

Apache httpd configuration will not be restored.
You will be asked about it on the next engine-setup run.
---------------------------------------------------------------------------=
---
Provisioning PostgreSQL users/databases:
- user 'engine', database 'engine'
Restoring:
FATAL: Can't connect to database 'ovirt_engine_history'. Please see
'/usr/bin/engine-backup --help'."

I have attached the engine-backup-restore.log.

//Ricky

|

--------------060709040505040106000408
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta content=3D"text/html; charset=3Dutf-8" http-equiv=3D"Content-Type=
">
  </head>
  <body text=3D"#000000" bgcolor=3D"#FFFFFF">
    <div class=3D"moz-cite-prefix">On 2016-06-27 19:15, Fernando Fuentes
      wrote:<br>
    </div>
    <blockquote
cite=3D"mid:1467047727.452431.649895969.3DAA7E9C@webmail.messagingengine.co=
m"
      type=3D"cite">
      <pre wrap=3D"">Ricky,

I am under the impression that the DB migration was implemented in
release 3.6.6.

I might be wrong.

<a class=3D"moz-txt-link-freetext" href=3D"https://www.ovirt.org/release/3.=
6.6/">https://www.ovirt.org/release/3.6.6/</a>

What's New in 3.6.6?
Enhancement
oVirt Engine

BZ 1241149 [RFE] Provide way to preform in-cluster upgrade of hosts from
el6->el7.
BZ 1332463 [RFE] restore: ensure that 3.6 on el6 backup can be restored
on 3.6 on el7
Feature:=20

Allow engine-backup on el7 to restore backups taken on el6.

Reason:=20

engine 4.0 does not support el6. Users that want to upgrade from 3.6 on
el6 to 4.0 on el7 have to do this by backing up the engine on 3.6/el6
and restore on 4.0/el7.

This feature, backported from 4.0, allows to do such a migration also in
3.6.

Result:=20

Using this flow, it's possible to migrate a el6 setup to el7:

On the existing engine machine run:
1. engine-backup --mode=3Dbackup --file=3Dengine-3.6.bck --log=3Dbackup.log

On a new el7 machine:
2. Install engine, including dwh if it was set up on el6.
3. Copy engine-3.6.bck to the el7 machine
4. engine-backup --mode=3Drestore --file=3Dengine-3.6.bck --log=3Drestore.l=
og
--provision-db --no-restore-permissions
5. engine-setup

Check engine-backup documentation for other options, including using
remote databases, extra grants/permissions, etc.

</pre>
    </blockquote>
    <br>
    One step forward, two backward....<br>
    <br>
    <tt>- upgrade the old EL6 to ovirt 3.6.6</tt><tt><br>
    </tt><tt>- engine-backup --mode=3Dbackup --file=3Dengine-backup.tar.gz
      --log=3Dbackup.log</tt><tt><br>
    </tt><tt>- install </tt><tt><a class=3D"moz-txt-link-freetext"
        href=3D"http://resources.ovirt.org/pub/yum-repo/ovirt-release40.rpm=
">http://resources.ovirt.org/pub/yum-repo/ovirt-release40.rpm</a></tt><tt>,
      to have ovirt-engine 4.0.0.6.</tt><tt><br>
    </tt><tt>- yum install ovirt-engine</tt><tt><br>
    </tt><tt>- </tt><code>engine-backup --mode=3Drestore
      --no-restore-permissions --provision-db
      --file=3Dengine-backup.tar.gz --log=3Dengine-backup-restore.log<br>
      <br>
      Then I got this error...<br>
      <br>
      "Preparing to restore:<br>
      - Unpacking file 'engine-backup.tar.gz'<br>
      Restoring:<br>
      - Files<br>
---------------------------------------------------------------------------=
---<br>
      Please note:<br>
      <br>
      Operating system is different from the one used during backup.<br>
      Current operating system: centos7<br>
      Operating system at backup: centos6<br>
      <br>
      Apache httpd configuration will not be restored.<br>
      You will be asked about it on the next engine-setup run.<br>
---------------------------------------------------------------------------=
---<br>
      Provisioning PostgreSQL users/databases:<br>
      - user 'engine', database 'engine'<br>
      Restoring:<br>
      FATAL: Can't connect to database 'ovirt_engine_history'. Please
      see '/usr/bin/engine-backup --help'."<br>
      <br>
      I have attached the engine-backup-restore.log.<br>
      <br>
      //Ricky<br>
      <br>
      <br>
    </code>
  </body>
</html>

--------------060709040505040106000408--

--------------060009030503040407080808
Content-Type: text/plain; charset=UTF-8;
 name="Untitled Document 1"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="Untitled Document 1"

MjAxNi0wNi0yOCAwOTo0MjowMSAyMDI2MDogU3RhcnQgb2YgZW5naW5lLWJh
Y2t1cCBtb2RlIHJlc3RvcmUgc2NvcGUgYWxsIGZpbGUgZW5naW5lLWJhY2t1
cC50YXIuZ3oKMjAxNi0wNi0yOCAwOTo0MjowMSAyMDI2MDogT1VUUFVUOiBQ
cmVwYXJpbmcgdG8gcmVzdG9yZToKMjAxNi0wNi0yOCAwOTo0MjowMSAyMDI2
MDogT1VUUFVUOiAtIFVucGFja2luZyBmaWxlICdlbmdpbmUtYmFja3VwLnRh
ci5neicKMjAxNi0wNi0yOCAwOTo0MjowMSAyMDI2MDogT3BlbmluZyB0YXJi
YWxsIGVuZ2luZS1iYWNrdXAudGFyLmd6IHRvIC90bXAvZW5naW5lLWJhY2t1
cC5ZdU5ZUWFDOUozCjIwMTYtMDYtMjggMDk6NDI6MDIgMjAyNjA6IFZlcmlm
eWluZyBtZDUKMjAxNi0wNi0yOCAwOTo0MjowMiAyMDI2MDogVmVyaWZ5aW5n
IHZlcnNpb24KMjAxNi0wNi0yOCAwOTo0MjowMiAyMDI2MDogUmVhZGluZyBj
b25maWcKMjAxNi0wNi0yOCAwOTo0MjowMiAyMDI2MDogT1VUUFVUOiBSZXN0
b3Jpbmc6CjIwMTYtMDYtMjggMDk6NDI6MDIgMjAyNjA6IE9VVFBVVDogLSBG
aWxlcwoyMDE2LTA2LTI4IDA5OjQyOjAyIDIwMjYwOiBSZXN0b3JpbmcgZmls
ZXMKMjAxNi0wNi0yOCAwOTo0MjowMiAyMDI2MDogUmVsb2FkaW5nIGNvbmZp
Z3VyYXRpb24KMjAxNi0wNi0yOCAwOTo0MjowMiAyMDI2MDogT1VUUFVUOiBQ
cm92aXNpb25pbmcgUG9zdGdyZVNRTCB1c2Vycy9kYXRhYmFzZXM6CjIwMTYt
MDYtMjggMDk6NDI6MDIgMjAyNjA6IHByb3Zpc2lvbkRCOiB1c2VyIGVuZ2lu
ZSBob3N0IGxvY2FsaG9zdCBwb3J0IDU0MzIgZGF0YWJhc2UgZW5naW5lIHNl
Y3VyZWQgRmFsc2Ugc2VjdXJlZF9ob3N0X3ZhbGlkYXRpb24gRmFsc2UKMjAx
Ni0wNi0yOCAwOTo0MjowMiAyMDI2MDogT1VUUFVUOiAtIHVzZXIgJ2VuZ2lu
ZScsIGRhdGFiYXNlICdlbmdpbmUnClsgSU5GTyAgXSBTdGFnZTogSW5pdGlh
bGl6aW5nClsgSU5GTyAgXSBTdGFnZTogRW52aXJvbm1lbnQgc2V0dXAKICAg
ICAgICAgIENvbmZpZ3VyYXRpb24gZmlsZXM6IFsnL2V0Yy9vdmlydC1lbmdp
bmUtc2V0dXAuY29uZi5kLzEwLXBhY2thZ2luZy1qYm9zcy5jb25mJywgJy9l
dGMvb3ZpcnQtZW5naW5lLXNldHVwLmNvbmYuZC8xMC1wYWNrYWdpbmcuY29u
ZicsICcvZXRjL292aXJ0LWVuZ2luZS1zZXR1cC5jb25mLmQvMjAtc2V0dXAt
b3ZpcnQtcG9zdC5jb25mJywgJy90bXAvZW5naW5lLWJhY2t1cC5ZdU5ZUWFD
OUozL3BnLXByb3Zpc2lvbi1hbnN3ZXItZmlsZSddCiAgICAgICAgICBMb2cg
ZmlsZTogL3Zhci9sb2cvb3ZpcnQtZW5naW5lL3NldHVwL292aXJ0LWVuZ2lu
ZS1wcm92aXNpb25kYi0yMDE2MDYyODA5NDIwMi1ud2NwMjEubG9nCiAgICAg
ICAgICBWZXJzaW9uOiBvdG9waS0xLjUuMCAob3RvcGktMS41LjAtMS5lbDcu
Y2VudG9zKQpbIElORk8gIF0gU3RhZ2U6IEVudmlyb25tZW50IHBhY2thZ2Vz
IHNldHVwClsgSU5GTyAgXSBTdGFnZTogUHJvZ3JhbXMgZGV0ZWN0aW9uClsg
SU5GTyAgXSBTdGFnZTogRW52aXJvbm1lbnQgY3VzdG9taXphdGlvbgpbIElO
Rk8gIF0gU3RhZ2U6IFNldHVwIHZhbGlkYXRpb24KWyBJTkZPICBdIFN0YWdl
OiBUcmFuc2FjdGlvbiBzZXR1cApbIElORk8gIF0gU3RhZ2U6IE1pc2MgY29u
ZmlndXJhdGlvbgpbIElORk8gIF0gU3RhZ2U6IFBhY2thZ2UgaW5zdGFsbGF0
aW9uClsgSU5GTyAgXSBTdGFnZTogTWlzYyBjb25maWd1cmF0aW9uClsgSU5G
TyAgXSBDcmVhdGluZyBQb3N0Z3JlU1FMICdlbmdpbmUnIGRhdGFiYXNlClsg
SU5GTyAgXSBDb25maWd1cmluZyBQb3N0Z3JlU1FMClsgSU5GTyAgXSBTdGFn
ZTogVHJhbnNhY3Rpb24gY29tbWl0ClsgSU5GTyAgXSBTdGFnZTogQ2xvc2lu
ZyB1cApbIElORk8gIF0gU3RhZ2U6IENsZWFuIHVwCiAgICAgICAgICBMb2cg
ZmlsZSBpcyBsb2NhdGVkIGF0IC92YXIvbG9nL292aXJ0LWVuZ2luZS9zZXR1
cC9vdmlydC1lbmdpbmUtcHJvdmlzaW9uZGItMjAxNjA2MjgwOTQyMDItbndj
cDIxLmxvZwpbIElORk8gIF0gU3RhZ2U6IFByZS10ZXJtaW5hdGlvbgpbIElO
Rk8gIF0gU3RhZ2U6IFRlcm1pbmF0aW9uClsgSU5GTyAgXSBFeGVjdXRpb24g
b2YgcHJvdmlzaW9uZGIgY29tcGxldGVkIHN1Y2Nlc3NmdWxseQoyMDE2LTA2
LTI4IDA5OjQyOjA4IDIwMjYwOiBPVVRQVVQ6IFJlc3RvcmluZzoKMjAxNi0w
Ni0yOCAwOTo0MjowOCAyMDI2MDogR2VuZXJhdGluZyBwZ3Bhc3MKMjAxNi0w
Ni0yOCAwOTo0MjowOCAyMDI2MDogVmVyaWZ5aW5nIGNvbm5lY3Rpb24KMjAx
Ni0wNi0yOCAwOTo0MjowOCAyMDI2MDogcGdfY21kIHJ1bm5pbmc6IHBzcWwg
LXcgLVUgZW5naW5lIC1oIGxvY2FsaG9zdCAtcCA1NDMyICBlbmdpbmUgLWMg
c2VsZWN0IDEKID9jb2x1bW4/IAotLS0tLS0tLS0tCiAgICAgICAgMQooMSBy
b3cpCgoyMDE2LTA2LTI4IDA5OjQyOjA4IDIwMjYwOiBwZ19jbWQgcnVubmlu
ZzogcHNxbCAtdyAtVSBlbmdpbmUgLWggbG9jYWxob3N0IC1wIDU0MzIgIGVu
Z2luZSAtdCAtYyBzaG93IGxjX21lc3NhZ2VzCjIwMTYtMDYtMjggMDk6NDI6
MDggMjAyNjA6IHBnX2NtZCBydW5uaW5nOiBwZ19kdW1wIC13IC1VIGVuZ2lu
ZSAtaCBsb2NhbGhvc3QgLXAgNTQzMiAgZW5naW5lIC1zCjIwMTYtMDYtMjgg
MDk6NDI6MDggMjAyNjA6IHBnX2NtZCBydW5uaW5nOiBwc3FsIC13IC1VIG92
aXJ0X2VuZ2luZV9oaXN0b3J5IC1oIGxvY2FsaG9zdCAtcCA1NDMyICBvdmly
dF9lbmdpbmVfaGlzdG9yeSAtYyBzZWxlY3QgMQpwc3FsOiBGQVRBTDogIElk
ZW50IGF1dGhlbnRpY2F0aW9uIGZhaWxlZCBmb3IgdXNlciAib3ZpcnRfZW5n
aW5lX2hpc3RvcnkiCjIwMTYtMDYtMjggMDk6NDI6MDggMjAyNjA6IEZBVEFM
OiBDYW4ndCBjb25uZWN0IHRvIGRhdGFiYXNlICdvdmlydF9lbmdpbmVfaGlz
dG9yeScuIFBsZWFzZSBzZWUgJy91c3IvYmluL2VuZ2luZS1iYWNrdXAgLS1o
ZWxwJy4KCg==

--------------060009030503040407080808--

--RbuEg8Cm5biR9Sc8pBSF3NhlWLgtUJ7da--

--X1bMWFpsf2B6WeUlPQWQ79ga0HH4Ir30b
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iEYEARECAAYFAldyLRMACgkQOap81biMC2Ne1wCfT/D+/lKKN4GCapw4fCWB/wiH
ABAAoIsnW4xd3EU8TKBZOIxd4HlLMz2t
=jr51
-----END PGP SIGNATURE-----

--X1bMWFpsf2B6WeUlPQWQ79ga0HH4Ir30b--

--
IMPORTANT!
This message has been scanned for viruses and phishing links.
However, it is your responsibility to evaluate the links and attachments you choose to click.
If you are uncertain, we always try to help.
Greetings helpdesk@actnet.se