1:22 p.m.
This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--BNsuvqlTn36xbwElBfkFvfgbObVW02SHF
Content-Type: multipart/mixed; boundary="GNlqx8MWeOXhKK4MmnxAuApqIV1VwqBOw"
From: Ricky Schneberger <ricky(a)schneberger.se>
Reply-To: ricky(a)schneberger.se
To: Yedidyah Bar David <didi(a)redhat.com>
Cc: Fernando Fuentes <ffuentes(a)darktcp.net>, users <users(a)ovirt.org>
Message-ID: <57724FD5.5040100(a)schneberger.se>
Subject: Re: [ovirt-users] restore of backup fail when Migrating to
ovirt-engine 4.0
References: <577140AA.1030104(a)schneberger.se>
<CAN8-ONptgJF+xyMyD03vn_T_JDw9TYjN5+xp_0P0+ck5XGG2SA(a)mail.gmail.com>
<1467043075.437745.649812721.558AB7EF(a)webmail.messagingengine.com>
<57715132.9030101(a)schneberger.se>
<1467047727.452431.649895969.3DAA7E9C(a)webmail.messagingengine.com>
<57722D13.7090907(a)schneberger.se>
<CAHRwYXu=6pGnFYBPY80qbhqLx67Hyuss+sDVvqiveuLDx-hEFw(a)mail.gmail.com>
In-Reply-To: <CAHRwYXu=6pGnFYBPY80qbhqLx67Hyuss+sDVvqiveuLDx-hEFw(a)mail.gmail.com>
--GNlqx8MWeOXhKK4MmnxAuApqIV1VwqBOw
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
On 2016-06-28 10:21, Yedidyah Bar David wrote:
#engine-backup --mode=3Drestore --no-restore-permissions --provision-db
--provision-dwh-db --provision-reports-db --file=3Dengine-backup.tar.gz
--log=3Dengine-backup-restore.log
Success with the restore!
Thanks for pointing me out. What I did was just following the
documentation, right or wrong.
But when I run "Engine-setup" I got stucked with
"[ INFO ] Stage: Setup validation
[WARNING] Less than 16384MB of memory is available
[ ERROR ] Failed to execute stage 'Setup validation': Trying to upgrade
from unsupported versions: 3.5
[ INFO ] Stage: Clean up
Log file is located at
/var/log/ovirt-engine/setup/ovirt-engine-setup-20160628120936-ix7pb8.log
[ INFO ] Generating answer file
'/var/lib/ovirt-engine/setup/answers/20160628121149-setup.conf'
[ INFO ] Stage: Pre-termination
[ INFO ] Stage: Termination
[ ERROR ] Execution of setup failed"
Seems to be something missing from an earlier db-upgrade?
--=20
Ricky Schneberger
------------------------------------
Use PGP to protect your own privacy!
Key fingerprint =3D 59E1 2B00 C28B 6E0D C8D1 D85B 39AA 7CD5 B88C 0B63
Key-ID: 0xB88C0B63
--GNlqx8MWeOXhKK4MmnxAuApqIV1VwqBOw--
--BNsuvqlTn36xbwElBfkFvfgbObVW02SHF
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"
On Tue, Jun 28, 2016 at 10:53 AM, Ricky Schneberger
<ricky(a)schneberger.se> wrote:
> 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:
>
> Allow engine-backup on el7 to restore backups taken on el6.
>
> Reason:
>
> 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:
>
> 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=3Drestor=
e.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=3Dba=
ckup.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'."
>
The backup/restore here is just like normal ones, so for details you can =
read
the output of 'engine-backup --help' or [1].
In your specific case, you seem to have dwh in your backup.
To restore it, you have to either prepare a database with the same creden=
tials
as the one used in the old machine, or, if it was
automatically-provision=
ed by
engine-setup, you can pass the option '--provision-dwh-db' to
make engine=
-backup
create it for you.
I think I should add an option '--provision-all-databases' or something l=
ike
that. Didn't feel very good about it so never done, and no-one
asked for =
it...
Best regards,
[1] http://www.ovirt.org/develop/release-management/features/engine/engin=
e-backup/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2
iEYEARECAAYFAldyT9YACgkQOap81biMC2MWzACeOmAGkLrp/GiX9v91YyDCK5ve
0t4An1/HBydydenxXbrfgomgSr9NT5H/
=r/tn
-----END PGP SIGNATURE-----
--BNsuvqlTn36xbwElBfkFvfgbObVW02SHF--
--
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(a)actnet.se