[ovirt-users] restore of backup fail when Migrating to ovirt-engine 4.0
Ricky Schneberger
ricky at schneberger.se
Tue Jun 28 07:53:55 UTC 2016
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'."
I have attached the engine-backup-restore.log.
//Ricky
|
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20160628/007b780b/attachment-0001.html>
-------------- next part --------------
2016-06-28 09:42:01 20260: Start of engine-backup mode restore scope all file engine-backup.tar.gz
2016-06-28 09:42:01 20260: OUTPUT: Preparing to restore:
2016-06-28 09:42:01 20260: OUTPUT: - Unpacking file 'engine-backup.tar.gz'
2016-06-28 09:42:01 20260: Opening tarball engine-backup.tar.gz to /tmp/engine-backup.YuNYQaC9J3
2016-06-28 09:42:02 20260: Verifying md5
2016-06-28 09:42:02 20260: Verifying version
2016-06-28 09:42:02 20260: Reading config
2016-06-28 09:42:02 20260: OUTPUT: Restoring:
2016-06-28 09:42:02 20260: OUTPUT: - Files
2016-06-28 09:42:02 20260: Restoring files
2016-06-28 09:42:02 20260: Reloading configuration
2016-06-28 09:42:02 20260: OUTPUT: Provisioning PostgreSQL users/databases:
2016-06-28 09:42:02 20260: provisionDB: user engine host localhost port 5432 database engine secured False secured_host_validation False
2016-06-28 09:42:02 20260: OUTPUT: - user 'engine', database 'engine'
[ INFO ] Stage: Initializing
[ INFO ] Stage: Environment setup
Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging-jboss.conf', '/etc/ovirt-engine-setup.conf.d/10-packaging.conf', '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf', '/tmp/engine-backup.YuNYQaC9J3/pg-provision-answer-file']
Log file: /var/log/ovirt-engine/setup/ovirt-engine-provisiondb-20160628094202-nwcp21.log
Version: otopi-1.5.0 (otopi-1.5.0-1.el7.centos)
[ INFO ] Stage: Environment packages setup
[ INFO ] Stage: Programs detection
[ INFO ] Stage: Environment customization
[ INFO ] Stage: Setup validation
[ INFO ] Stage: Transaction setup
[ INFO ] Stage: Misc configuration
[ INFO ] Stage: Package installation
[ INFO ] Stage: Misc configuration
[ INFO ] Creating PostgreSQL 'engine' database
[ INFO ] Configuring PostgreSQL
[ INFO ] Stage: Transaction commit
[ INFO ] Stage: Closing up
[ INFO ] Stage: Clean up
Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-provisiondb-20160628094202-nwcp21.log
[ INFO ] Stage: Pre-termination
[ INFO ] Stage: Termination
[ INFO ] Execution of provisiondb completed successfully
2016-06-28 09:42:08 20260: OUTPUT: Restoring:
2016-06-28 09:42:08 20260: Generating pgpass
2016-06-28 09:42:08 20260: Verifying connection
2016-06-28 09:42:08 20260: pg_cmd running: psql -w -U engine -h localhost -p 5432 engine -c select 1
?column?
----------
1
(1 row)
2016-06-28 09:42:08 20260: pg_cmd running: psql -w -U engine -h localhost -p 5432 engine -t -c show lc_messages
2016-06-28 09:42:08 20260: pg_cmd running: pg_dump -w -U engine -h localhost -p 5432 engine -s
2016-06-28 09:42:08 20260: pg_cmd running: psql -w -U ovirt_engine_history -h localhost -p 5432 ovirt_engine_history -c select 1
psql: FATAL: Ident authentication failed for user "ovirt_engine_history"
2016-06-28 09:42:08 20260: FATAL: Can't connect to database 'ovirt_engine_history'. Please see '/usr/bin/engine-backup --help'.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 181 bytes
Desc: OpenPGP digital signature
URL: <http://lists.ovirt.org/pipermail/users/attachments/20160628/007b780b/attachment-0001.sig>
More information about the Users
mailing list