8:44 a.m.
------=_Part_20349653_1465707940.1519829079176
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
If I run
# engine-backup --mode=restore --file=back_futur --log=log_futur --provision-db
--restore-permissions --provision-dwh-db --log=/root/rest-log
to create a log, I found these errors:
2018-02-28 14:36:31 6339: pg_cmd running: psql -w -U ovirt_engine_history -h localhost -p
5432 ovirt_engine_history -t -c show lc_messages
2018-02-28 14:36:31 6339: pg_cmd running: pg_dump -w -U ovirt_engine_history -h localhost
-p 5432 ovirt_engine_history -s
2018-02-28 14:36:31 6339: OUTPUT: - Engine database 'engine'
2018-02-28 14:36:31 6339: Restoring engine database backup at
/tmp/engine-backup.VVkcNuYAkV/db/engine_backup.db
2018-02-28 14:36:31 6339: restoreDB: backupfile
/tmp/engine-backup.VVkcNuYAkV/db/engine_backup.db user engine host localhost port 5432
database engine orig_user compressor format custom jobsnum 2
2018-02-28 14:36:31 6339: pg_cmd running: pg_restore -w -U engine -h localhost -p 5432 -d
engine -j 2 /tmp/engine-backup.VVkcNuYAkV/db/engine_backup.db
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 7314; 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 693; 1255 211334 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
2018-02-28 14:37:23 6339: FATAL: Errors while restoring database engine
De: suporte(a)logicworks.pt
Para: "Yedidyah Bar David" <didi(a)redhat.com>
Cc: "ovirt users" <users(a)ovirt.org>
Enviadas: Quarta-feira, 28 De Fevereiro de 2018 12:45:04
Assunto: Re: [ovirt-users] Backup & Restore
Still no luck:
# engine-backup --mode=restore --file=back_futur --log=log_futur --provision-db
--restore-permissions --provision-dwh-db
Preparing to restore:
- Unpacking file 'back_futur'
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
I did a engine-cleanup, try it again but still the same error.
De: "Yedidyah Bar David" <didi(a)redhat.com>
Para: suporte(a)logicworks.pt
Cc: "ovirt users" <users(a)ovirt.org>
Enviadas: Quarta-feira, 28 De Fevereiro de 2018 12:24:50
Assunto: Re: [ovirt-users] Backup & Restore
On Wed, Feb 28, 2018 at 2:10 PM, <suporte(a)logicworks.pt> wrote:
Hi,
I'm testing backup & restore on Ovirt 4.2.
I follow this doc
https://www.ovirt.org/documentation/admin-guide/chap-Backups_and_Migration/
Try to restore to a fresh installation but always get this error message:
restore-permissions
Preparing to restore:
- Unpacking file 'back_file'
Restoring:
- Files
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'.
On the live engine I run # engine-backup --scope=all --mode=backup
--file=file_name --log=log_file_name
And try to restore on a fresh installation:
# engine-backup --mode=restore --file=file_name --log=log_file_name
--provision-db --restore-permissions
Any Idea?
Please try adding to restore command '--providion-dwh-db'. Thanks.
--
Didi
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
------=_Part_20349653_1465707940.1519829079176
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
<html><body><div style=3D"font-family: trebuchet ms,sans-serif;
font-size: =
12pt; color: #000000"><div>If I run <br></div><div><br
data-mce-bogus=3D"1"=
</div><div># engine-backup --mode=3Drestore
--file=3Dback_futur --log=3Dlo=
g_futur --provision-db --restore-permissions
--provision-dwh-db --log=3D/ro=
ot/rest-log</div><div><br
data-mce-bogus=3D"1"></div><div>to create a log, =
I found these errors:<br
data-mce-bogus=3D"1"></div><div><br data-mce-bogus=
=3D"1"></div><div>2018-02-28 14:36:31 6339: pg_cmd running: psql
-w -U ovir=
t_engine_history -h localhost -p 5432 ovirt_engine_history -t -c show lc_me=
ssages<br>2018-02-28 14:36:31 6339: pg_cmd running: pg_dump -w -U ovirt_eng=
ine_history -h localhost -p 5432 ovirt_engine_history -s<br>2018-02-28 14:3=
6:31 6339: OUTPUT: - Engine database 'engine'<br>2018-02-28 14:36:31 6339:
=
Restoring engine database backup at /tmp/engine-backup.VVkcNuYAkV/db/engine=
_backup.db<br>2018-02-28 14:36:31 6339: restoreDB: backupfile /tmp/engine-b=
ackup.VVkcNuYAkV/db/engine_backup.db user engine host localhost port 5432 d=
atabase engine orig_user compressor format custom jobsnum 2<br>2018-02-28 1=
4:36:31 6339: pg_cmd running: pg_restore -w -U engine -h localhost -p 5432 =
-d engine -j 2 /tmp/engine-backup.VVkcNuYAkV/db/engine_backup.db<br>pg_rest=
ore: [archiver (db)] Error while PROCESSING TOC:<br>pg_restore: [archiver (=
db)] Error from TOC entry 7314; 0 0 COMMENT EXTENSION plpgsql <br>pg_restor=
e: [archiver (db)] could not execute query: ERROR: must be owner of extensi=
on plpgsql<br> Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL proce=
dural language';<br><br><br><br>pg_restore: [archiver (db)]
Error from TOC =
entry 693; 1255 211334 FUNCTION uuid_generate_v1() engine<br>pg_restore: [a=
rchiver (db)] could not execute query: ERROR: function "uuid_generate_v1" a=
lready exists with same argument types<br> Command was: CREATE FUNCTION uui=
d_generate_v1() RETURNS uuid<br> LANGUAGE plpgsql STABLE<br> AS
'<br>DECLAR=
E<br> v_val BIGINT;<br> v_4_1_par...<br>pg_restore: [archiver (db)]
could n=
ot execute query: ERROR: must be owner of function uuid_generate_v1<br> Com=
mand was: ALTER FUNCTION public.uuid_generate_v1() OWNER TO engine;<br><br>=
<br>pg_restore: WARNING: column "user_role_title" has type
"unknown"<br>DET=
AIL: Proceeding with relation creation anyway.<br>pg_restore: WARNING: no p=
rivileges could be revoked for "public"<br>pg_restore: WARNING: no
privileg=
es could be revoked for "public"<br>pg_restore: WARNING: no privileges
were=
granted for "public"<br>pg_restore: WARNING: no privileges were granted
fo=
r "public"<br>WARNING: errors ignored on restore: 3<br>2018-02-28
14:37:23 =
6339: FATAL: Errors while restoring database
engine<br></div><div><br></div=
<hr id=3D"zwchr"
data-marker=3D"__DIVIDER__"><div data-marker=3D"__HEADERS=
__"><b>De: </b>suporte(a)logicworks.pt<br><b>Para:
</b>"Yedidyah Bar David" &=
lt;didi(a)redhat.com&gt;<br><b>Cc: </b>"ovirt users"
&lt;users(a)ovirt.org&gt;<=
br><b>Enviadas: </b>Quarta-feira, 28 De Fevereiro de 2018
12:45:04<br><b>As=
sunto: </b>Re: [ovirt-users] Backup &
Restore<br></div><br><div data-ma=
rker=3D"__QUOTED_TEXT__"><div style=3D"font-family: trebuchet
ms,sans-serif=
; font-size: 12pt; color: #000000"><div>Still no
luck:<br></div><br><div># =
engine-backup --mode=3Drestore --file=3Dback_futur --log=3Dlog_futur --prov=
ision-db --restore-permissions --provision-dwh-db<br>Preparing to restore:<=
br>- Unpacking file 'back_futur'<br>Restoring:<br>-
Files<br>Provisioning P=
ostgreSQL users/databases:<br>- user 'engine', database
'engine'<br>- user =
'ovirt_engine_history', database
'ovirt_engine_history'<br>Restoring:<br>- =
Engine database 'engine'<br>FATAL: Errors while restoring database
engine<b=
r></div><br><div>I did a engine-cleanup, try it again but still the
same er=
ror.<br></div><br><hr
id=3D"zwchr"><div><b>De: </b>"Yedidyah Bar David"
<=
;didi(a)redhat.com&gt;<br><b>Para:
</b>suporte(a)logicworks.pt<br><b>Cc: </b>"o=
virt users" &lt;users(a)ovirt.org&gt;<br><b>Enviadas:
</b>Quarta-feira, 28 De=
Fevereiro de 2018 12:24:50<br><b>Assunto: </b>Re: [ovirt-users] Backup
&am=
p; Restore<br></div><br><div>On Wed, Feb 28, 2018 at 2:10 PM,
<sup=
orte(a)logicworks.pt&gt; wrote:<br>>
Hi,<br>><br>> I'm testing backu=
p & restore on Ovirt 4.2.<br>> I follow this doc<br>>
https://www=
.ovirt.org/documentation/admin-guide/chap-Backups_and_Migration/<br>> Tr=
y to restore to a fresh installation but always get this error message:<br>=
><br>> restore-permissions<br>> Preparing to
restore:<br>> - Un=
packing file 'back_file'<br>> Restoring:<br>> -
Files<br>> Provisi=
oning PostgreSQL users/databases:<br>> - user 'engine', database
'engine=
'<br>> Restoring:<br>> FATAL: Can't connect to database
'ovirt_engine=
_history'. Please see<br>> '/usr/bin/engine-backup
--help'.<br>><br>&=
gt; On the live engine I run # engine-backup --scope=3Dall --mode=3Dbackup<=
br>> --file=3Dfile_name
--log=3Dlog_file_name<br>><br>> And try to=
restore on a fresh installation:<br>> # engine-backup --mode=3Drestore =
--file=3Dfile_name --log=3Dlog_file_name<br>> --provision-db --restore-p=
ermissions<br>><br>> Any Idea?<br><br>Please try
adding to restore co=
mmand '--providion-dwh-db'. Thanks.<br>--
<br>Didi<br></div></div><br>_____=
__________________________________________<br>Users mailing list<br>Users@o=
virt.org<br>http://lists.ovirt.org/mailman/listinfo/users<br>...
body></html>
------=_Part_20349653_1465707940.1519829079176--