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

Tue Jun 28 09:02:39 EDT 2016

Adding Jiri.

Yaniv Dary
Technical Product Manager
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109

Tel : +972 (9) 7692306
        8272306
Email: ydary at redhat.com
IRC : ydary

On Tue, Jun 28, 2016 at 4:00 PM, Yaniv Dary <ydary at redhat.com> wrote:

> Do you have any 3.5 clusters? You can only upgrade to 4.0, if all the
> cluster are 3.6 compatibility.
>
> Yaniv Dary
> Technical Product Manager
> Red Hat Israel Ltd.
> 34 Jerusalem Road
> Building A, 4th floor
> Ra'anana, Israel 4350109
>
> Tel : +972 (9) 7692306
>         8272306
> Email: ydary at redhat.com
> IRC : ydary
>
>
> On Tue, Jun 28, 2016 at 1:22 PM, Ricky Schneberger <ricky at schneberger.se>
> wrote:
>
>> On 2016-06-28 10:21, Yedidyah Bar David wrote:
>> > On Tue, Jun 28, 2016 at 10:53 AM, Ricky Schneberger
>> > <ricky at 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=backup --file=engine-3.6.bck --log=backup.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=restore --file=engine-3.6.bck --log=restore.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=backup --file=engine-backup.tar.gz
>> --log=backup.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=restore --no-restore-permissions --provision-db
>> >> --file=engine-backup.tar.gz --log=engine-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
>> credentials
>> > as the one used in the old machine, or, if it was
>> automatically-provisioned 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
>> like
>> > 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/engine-backup/
>> >
>> >
>>
>> #engine-backup --mode=restore --no-restore-permissions --provision-db
>> --provision-dwh-db --provision-reports-db --file=engine-backup.tar.gz
>> --log=engine-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?
>>
>> --
>> Ricky Schneberger
>>
>> ------------------------------------
>>
>>
>> Use PGP to protect your own privacy!
>>
>> Key fingerprint = 59E1 2B00 C28B 6E0D C8D1  D85B 39AA 7CD5 B88C 0B63
>> Key-ID: 0xB88C0B63
>>
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20160628/c8054992/attachment.html>