I really need help here... please!!
my engine was crashed, I have backups, but the restore failed.
engine-backup --mode=restore --file=backup --log=restore.log
--provision-all-databases --restore-permissions
this is the log:
2019-01-02 03:39:22 13186: Start of engine-backup mode restore scope all
file backup
2019-01-02 03:39:22 13186: Setting scl env for rh-postgresql95
2019-01-02 03:39:22 13186: OUTPUT: Preparing to restore:
2019-01-02 03:39:22 13186: OUTPUT: - Unpacking file 'backup'
2019-01-02 03:39:22 13186: Opening tarball backup to
/tmp/engine-backup.bGOLRNXeD4
2019-01-02 03:39:22 13186: Verifying md5
2019-01-02 03:39:22 13186: Verifying version
2019-01-02 03:39:22 13186: Reading config
2019-01-02 03:39:22 13186: OUTPUT: Restoring:
2019-01-02 03:39:22 13186: OUTPUT: - Files
2019-01-02 03:39:22 13186: Restoring files
2019-01-02 03:39:22 13186: Reloading configuration
2019-01-02 03:39:22 13186: OUTPUT: Provisioning PostgreSQL users/databases:
2019-01-02 03:39:22 13186: provisionDB: user engine host localhost port
5432 database engine secured False secured_host_validation False
2019-01-02 03:39:22 13186: 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.bGOLRNXeD4/pg-provision-answer-file']
Log file:
/var/log/ovirt-engine/setup/ovirt-engine-provisiondb-20190102033923-c7vy1o.log
Version: otopi-1.7.8 (otopi-1.7.8-1.el7)
[ INFO ] Stage: Environment packages setup
[ INFO ] Stage: Programs detection
[ INFO ] Stage: Environment customization
[ INFO ] Stage: Setup validation
[WARNING] Cannot validate host name settings, reason: resolved host does
not match any of the local addresses
[ 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-20190102033923-c7vy1o.log
[ INFO ] Stage: Pre-termination
[ INFO ] Stage: Termination
[ INFO ] Execution of provisiondb completed successfully
2019-01-02 03:39:28 13186: provisionDB: user ovirt_engine_history host
localhost port 5432 database ovirt_engine_history secured False
secured_host_validation False
2019-01-02 03:39:28 13186: 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.bGOLRNXeD4/pg-provision-answer-file']
Log file:
/var/log/ovirt-engine/setup/ovirt-engine-provisiondb-20190102033928-nit1oc.log
Version: otopi-1.7.8 (otopi-1.7.8-1.el7)
[ INFO ] Stage: Environment packages setup
[ INFO ] Stage: Programs detection
[ INFO ] Stage: Environment customization
[ INFO ] Stage: Setup validation
[WARNING] Cannot validate host name settings, reason: resolved host does
not match any of the local addresses
[ INFO ] Stage: Transaction setup
[ INFO ] Stage: Misc configuration
[ 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-20190102033928-nit1oc.log
[ INFO ] Stage: Pre-termination
[ INFO ] Stage: Termination
[ INFO ] Execution of provisiondb completed successfully
2019-01-02 03:39:34 13186: OUTPUT: Restoring:
2019-01-02 03:39:34 13186: Generating pgpass
2019-01-02 03:39:34 13186: Verifying connection
2019-01-02 03:39:34 13186: pg_cmd running: psql -w -U engine -h localhost
-p 5432 engine -c select 1
?column?
----------
1
(1 row)
2019-01-02 03:39:34 13186: pg_cmd running: psql -w -U engine -h localhost
-p 5432 engine -t -c show lc_messages
2019-01-02 03:39:34 13186: pg_cmd running: pg_dump -w -U engine -h
localhost -p 5432 engine -s
2019-01-02 03:39:34 13186: pg_cmd running: psql -w -U ovirt_engine_history
-h localhost -p 5432 ovirt_engine_history -c select 1
?column?
----------
1
(1 row)
2019-01-02 03:39:34 13186: pg_cmd running: psql -w -U ovirt_engine_history
-h localhost -p 5432 ovirt_engine_history -t -c show lc_messages
2019-01-02 03:39:34 13186: pg_cmd running: pg_dump -w -U
ovirt_engine_history -h localhost -p 5432 ovirt_engine_history -s
2019-01-02 03:39:34 13186: OUTPUT: - Engine database 'engine'
2019-01-02 03:39:34 13186: Restoring engine database backup at
/tmp/engine-backup.bGOLRNXeD4/db/engine_backup.db
2019-01-02 03:39:34 13186: restoreDB: backupfile
/tmp/engine-backup.bGOLRNXeD4/db/engine_backup.db user engine host
localhost port 5432 database engine orig_user compressor format custom
jobsnum 2
2019-01-02 03:39:34 13186: pg_cmd running: pg_restore -w -U engine -h
localhost -p 5432 -d engine -j 2
/tmp/engine-backup.bGOLRNXeD4/db/engine_backup.db
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 7410; 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 710; 1255 174984 FUNCTION
uuid_generate_v1() engine
pg_restore: [archiver (db)] could not execute query: ERROR: function
"uuid_generate_v1" already exists with same argument types
Command was: CREATE FUNCTION uuid_generate_v1() RETURNS uuid
LANGUAGE plpgsql STABLE
AS '
DECLARE
v_val BIGINT;
v_4_1_par...
pg_restore: [archiver (db)] could not execute query: ERROR: must be owner
of function uuid_generate_v1
Command was: ALTER FUNCTION public.uuid_generate_v1() OWNER TO engine;
pg_restore: WARNING: column "user_role_title" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
pg_restore: WARNING: no privileges could be revoked for "public"
pg_restore: WARNING: no privileges could be revoked for "public"
pg_restore: WARNING: no privileges were granted for "public"
pg_restore: WARNING: no privileges were granted for "public"
WARNING: errors ignored on restore: 3
2019-01-02 03:39:38 13186: FATAL: Errors while restoring database engine
On Wed, Jan 2, 2019 at 1:37 AM maoz zadok <mao...@gmail.com> wrote:
> please someone, any ideas?
>
>
> engine-backup --mode=restore --file=backup --log=log_file_name
> --provision-db --restore-permissions
> Preparing to restore:
> - Unpacking file 'backup'
> Restoring:
> - Files
> Provisioning PostgreSQL users/databases:
> - user 'engine', database 'engine'
> FATAL: Existing database 'engine' or user 'engine' found and temporary
> ones created - Please clean up everything and try again
>
>
_______________________________________________
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct:
https://www.ovirt.org/community/about/community-guidelines/
List Archives:
https://lists.ovirt.org/archives/list/users@ovirt.org/message/PTVG4BWRPSOLPQ2PA5NPHZSCGROPPIWI/
