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

Tue Jun 28 03:53:55 EDT 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>