7:20 p.m.
Hello,
I had a ovirt-engine-4.3.0 that I am migrating to a new machine. I have done a backup of
that machine but the restore fails on the new machine.
Fresh install of centos and the 4.3.3 ovirt-engine.
[root@oengine ~]# engine-backup --mode=restore
--file=ovirt-engine-backup-20190426214711.backup --log=02.17.log --provision-db
--provision-dwh-db --restore-permissions
Start of engine-backup with mode 'restore'
scope: all
archive file: ovirt-engine-backup-20190426214711.backup
log file: 02.17.log
Preparing to restore:
- Unpacking file 'ovirt-engine-backup-20190426214711.backup'
Restoring:
- Files
Provisioning PostgreSQL users/databases:
- user 'engine', database 'engine'
- user 'ovirt_engine_history', database 'ovirt_engine_history'
Restoring:
- Engine database 'engine'
FATAL: Errors while restoring database engine
[root@oengine ~]# cat 02.17.log
2019-04-27 02:17:55 32343: Start of engine-backup mode restore scope all file
ovirt-engine-backup-20190426214711.backup
2019-04-27 02:17:55 32343: OUTPUT: Start of engine-backup with mode 'restore'
2019-04-27 02:17:55 32343: OUTPUT: scope: all
2019-04-27 02:17:55 32343: OUTPUT: archive file:
ovirt-engine-backup-20190426214711.backup
2019-04-27 02:17:55 32343: OUTPUT: log file: 02.17.log
2019-04-27 02:17:55 32343: Setting scl env for rh-postgresql10
2019-04-27 02:17:55 32343: OUTPUT: Preparing to restore:
2019-04-27 02:17:55 32343: OUTPUT: - Unpacking file
'ovirt-engine-backup-20190426214711.backup'
2019-04-27 02:17:55 32343: Opening tarball ovirt-engine-backup-20190426214711.backup to
/tmp/engine-backup.NVv4Bxjb2k
2019-04-27 02:17:55 32343: Verifying hash
2019-04-27 02:17:55 32343: Verifying version
2019-04-27 02:17:55 32343: Reading config
2019-04-27 02:17:55 32343: OUTPUT: Restoring:
2019-04-27 02:17:55 32343: OUTPUT: - Files
2019-04-27 02:17:55 32343: Restoring files
2019-04-27 02:17:56 32343: Reloading configuration
2019-04-27 02:17:56 32343: OUTPUT: Provisioning PostgreSQL users/databases:
2019-04-27 02:17:56 32343: provisionDB: user engine host localhost port 5432 database
engine secured False secured_host_validation False
2019-04-27 02:17:56 32343: 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.NVv4Bxjb2k/pg-provision-answer-file']
Log file:
/var/log/ovirt-engine/setup/ovirt-engine-provisiondb-20190427021756-hxbrea.log
Version: otopi-1.8.1 (otopi-1.8.1-1.el7)
[ 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 (early)
[ 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-20190427021756-hxbrea.log
[ INFO ] Stage: Pre-termination
[ INFO ] Stage: Termination
[ INFO ] Execution of provisiondb completed successfully
2019-04-27 02:17:58 32343: provisionDB: user ovirt_engine_history host localhost port 5432
database ovirt_engine_history secured False secured_host_validation False
2019-04-27 02:17:58 32343: OUTPUT: - user 'ovirt_engine_history', database
'ovirt_engine_history'
[ 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.NVv4Bxjb2k/pg-provision-answer-file']
Log file:
/var/log/ovirt-engine/setup/ovirt-engine-provisiondb-20190427021758-s2av1b.log
Version: otopi-1.8.1 (otopi-1.8.1-1.el7)
[ 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 (early)
[ INFO ] Stage: Package installation
[ INFO ] Stage: Misc configuration
[ INFO ] Creating PostgreSQL 'ovirt_engine_history' 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-20190427021758-s2av1b.log
[ INFO ] Stage: Pre-termination
[ INFO ] Stage: Termination
[ INFO ] Execution of provisiondb completed successfully
2019-04-27 02:18:00 32343: OUTPUT: Restoring:
2019-04-27 02:18:00 32343: Generating pgpass
2019-04-27 02:18:00 32343: Verifying connection
2019-04-27 02:18:00 32343: pg_cmd running: psql -w -U engine -h localhost -p 5432 engine
-c select 1
?column?
----------
1
(1 row)
2019-04-27 02:18:00 32343: pg_cmd running: psql -w -U engine -h localhost -p 5432 engine
-t -c show lc_messages
2019-04-27 02:18:00 32343: pg_cmd running: pg_dump -w -U engine -h localhost -p 5432
engine -s
2019-04-27 02:18:01 32343: pg_cmd running: psql -w -U ovirt_engine_history -h localhost -p
5432 ovirt_engine_history -c select 1
?column?
----------
1
(1 row)
2019-04-27 02:18:01 32343: pg_cmd running: psql -w -U ovirt_engine_history -h localhost -p
5432 ovirt_engine_history -t -c show lc_messages
2019-04-27 02:18:01 32343: pg_cmd running: pg_dump -w -U ovirt_engine_history -h localhost
-p 5432 ovirt_engine_history -s
2019-04-27 02:18:01 32343: OUTPUT: - Engine database 'engine'
2019-04-27 02:18:01 32343: Restoring engine database backup at
/tmp/engine-backup.NVv4Bxjb2k/db/engine_backup.db
2019-04-27 02:18:01 32343: restoreDB: backupfile
/tmp/engine-backup.NVv4Bxjb2k/db/engine_backup.db user engine host localhost port 5432
database engine orig_user compressor format custom jobsnum 2
2019-04-27 02:18:01 32343: pg_cmd running: pg_restore -w -U engine -h localhost -p 5432 -d
engine -j 2 /tmp/engine-backup.NVv4Bxjb2k/db/engine_backup.db
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 7624; 0 0 COMMENT EXTENSION plpgsql
pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of extension
plpgsql
Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
pg_restore: [archiver (db)] Error from TOC entry 7625; 0 0 COMMENT EXTENSION
"uuid-ossp"
pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of extension
uuid-ossp
Command was: COMMENT ON EXTENSION "uuid-ossp" IS 'generate universally
unique identifiers (UUIDs)';
pg_restore: [archiver (db)] Error from TOC entry 6400; 2606 18298 CONSTRAINT
external_variable pk_external_variable engine
pg_restore: [archiver (db)] could not execute query: ERROR: could not create unique index
"pk_external_variable"
DETAIL: Key (var_name)=(fence-kdump-listener-heartbeat) is duplicated.
Command was: ALTER TABLE ONLY public.external_variable
ADD CONSTRAINT pk_external_variable PRIMARY KEY (var_name);
WARNING: errors ignored on restore: 4
2019-04-27 02:18:43 32343: Non-ignored-errors in pg_restore log:
pg_restore: [archiver (db)] could not execute query: ERROR: could not create unique index
"pk_external_variable"
2019-04-27 02:18:43 32343: FATAL: Errors while restoring database engine
If this is a problem while restoring a 4.3.0 backup to a 4.3.3 engine is it possible to
install the 4.3.0 version?
Following the installation part of the release notes of 4.3.0 will result in 4.3.3 being
installed.
Best Regards
Magnus