This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --BNsuvqlTn36xbwElBfkFvfgbObVW02SHF Content-Type: multipart/mixed; boundary="GNlqx8MWeOXhKK4MmnxAuApqIV1VwqBOw" From: Ricky Schneberger <ricky@schneberger.se> Reply-To: ricky@schneberger.se To: Yedidyah Bar David <didi@redhat.com> Cc: Fernando Fuentes <ffuentes@darktcp.net>, users <users@ovirt.org> Message-ID: <57724FD5.5040100@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> <57722D13.7090907@schneberger.se> <CAHRwYXu=6pGnFYBPY80qbhqLx67Hyuss+sDVvqiveuLDx-hEFw@mail.gmail.com> In-Reply-To: <CAHRwYXu=6pGnFYBPY80qbhqLx67Hyuss+sDVvqiveuLDx-hEFw@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:
On Tue, Jun 28, 2016 at 10:53 AM, Ricky Schneberger <ricky@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/
#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" -----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@actnet.se