1 Mar
2018
1 Mar
'18
12:07 p.m.
------=_Part_20566966_39555052.1519906078677 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Yes, it happens in a clean machine. I try it twice and restore always fails. From: "Yedidyah Bar David" <didi@redhat.com> To: suporte@logicworks.pt, "Eli Mesika" <emesika@redhat.com> Cc: "ovirt users" <users@ovirt.org> Sent: Thursday, March 1, 2018 7:28:13 AM Subject: Re: [ovirt-users] Backup & Restore On Wed, Feb 28, 2018 at 4:44 PM, <suporte@logicworks.pt> wrote: > 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 This is the error that fails you. I have a pending patch to make this more visible in the log [1], need to find time to verify it... Does this happen on a clean machine? Perhaps 'engine-cleanup' after such a failed restore is not enough. Please try reinstalling the OS and trying again. If it's not an important machine (test/dev/etc), this will probably be enough, as a faster replacement for a full OS reinstall: engine-cleanup systemctl stop postgresql systemctl stop rh-postgresql95-postgresql rm -rf /var/lib/pgsql/data /var/opt/rh/rh-postgresql95/lib/pgsql/data Then try restore again. [1] https://gerrit.ovirt.org/86395 > 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; Adding also Eli. Eli - perhaps we need to patch engine-backup to ignore also this error? I think the minimal flow to reproduce is: engine-setup engine-backup --mode=backup --file=f1 --log=l1 engine-cleanup engine-backup --mode=restore --file=f1 --provision-db --provision-dwh-db --log=l2 Didn't try this myself. > > > 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@logicworks.pt > Para: "Yedidyah Bar David" <didi@redhat.com> > Cc: "ovirt users" <users@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@redhat.com> > Para: suporte@logicworks.pt > Cc: "ovirt users" <users@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@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@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users -- Didi ------=_Part_20566966_39555052.1519906078677 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>Yes, it happens in a clean machine. I try it twi= ce and restore always fails.</div><div><br></div><hr id=3D"zwchr" data-mark= er=3D"__DIVIDER__"><div data-marker=3D"__HEADERS__"><b>From: </b>"Yedidyah = Bar David" <didi@redhat.com><br><b>To: </b>suporte@logicworks.pt, "El= i Mesika" <emesika@redhat.com><br><b>Cc: </b>"ovirt users" <users@= ovirt.org><br><b>Sent: </b>Thursday, March 1, 2018 7:28:13 AM<br><b>Subj= ect: </b>Re: [ovirt-users] Backup & Restore<br></div><div><br></div><di= v data-marker=3D"__QUOTED_TEXT__">On Wed, Feb 28, 2018 at 4:44 PM, &l= t;suporte@logicworks.pt> wrote:<br>> If I run<br>><br>> # engin= e-backup --mode=3Drestore --file=3Dback_futur --log=3Dlog_futur<br>> --p= rovision-db --restore-permissions --provision-dwh-db --log=3D/root/rest-log= <br>><br>> to create a log, I found these errors:<br>><br>> 201= 8-02-28 14:36:31 6339: pg_cmd running: psql -w -U ovirt_engine_history -h<b= r>> localhost -p 5432 ovirt_engine_history -t -c show lc_messages<br>>= ; 2018-02-28 14:36:31 6339: pg_cmd running: pg_dump -w -U ovirt_engine_hist= ory<br>> -h localhost -p 5432 ovirt_engine_history -s<br>> 2018-02-28= 14:36:31 6339: OUTPUT: - Engine database 'engine'<br>> 2018-02-28 14:36= :31 6339: Restoring engine database backup at<br>> /tmp/engine-backup.VV= kcNuYAkV/db/engine_backup.db<br>> 2018-02-28 14:36:31 6339: restoreDB: b= ackupfile<br>> /tmp/engine-backup.VVkcNuYAkV/db/engine_backup.db user en= gine host localhost<br>> port 5432 database engine orig_user compressor = format custom jobsnum 2<br>> 2018-02-28 14:36:31 6339: pg_cmd running: p= g_restore -w -U engine -h<br>> localhost -p 5432 -d engine -j 2<br>> = /tmp/engine-backup.VVkcNuYAkV/db/engine_backup.db<br>> pg_restore: [arch= iver (db)] Error while PROCESSING TOC:<br>> pg_restore: [archiver (db)] = Error from TOC entry 7314; 0 0 COMMENT EXTENSION<br>> plpgsql<br>> pg= _restore: [archiver (db)] could not execute query: ERROR: must be owner of<= br>> extension plpgsql<br>> Command was: COMMENT ON EXTENSION plpgsql= IS 'PL/pgSQL procedural language';<br>><br>><br>><br>> pg_rest= ore: [archiver (db)] Error from TOC entry 693; 1255 211334 FUNCTION<br>>= uuid_generate_v1() engine<br>> pg_restore: [archiver (db)] could not ex= ecute query: ERROR: function<br>> "uuid_generate_v1" already exists with= same argument types<br><br>This is the error that fails you. I have a pend= ing patch to make this more<br>visible in the log [1], need to find time to= verify it...<br><br>Does this happen on a clean machine? Perhaps 'engine-c= leanup' after such<br>a failed restore is not enough. Please try reinstalli= ng the OS and trying<br>again.<br><br>If it's not an important machine (tes= t/dev/etc), this will probably be<br>enough, as a faster replacement for a = full OS reinstall:<br><br>engine-cleanup<br>systemctl stop postgresql<br>sy= stemctl stop rh-postgresql95-postgresql<br>rm -rf /var/lib/pgsql/data /var/= opt/rh/rh-postgresql95/lib/pgsql/data<br><br>Then try restore again.<br><br= >[1] https://gerrit.ovirt.org/86395<br><br>> Command was: CREATE FUNCTIO= N uuid_generate_v1() RETURNS uuid<br>> LANGUAGE plpgsql STABLE<br>> A= S '<br>> DECLARE<br>> v_val BIGINT;<br>> v_4_1_par...<br>> pg_r= estore: [archiver (db)] could not execute query: ERROR: must be owner of<br= >> function uuid_generate_v1<br>> Command was: ALTER FUNCTION public.= uuid_generate_v1() OWNER TO engine;<br><br>Adding also Eli. Eli - perhaps w= e need to patch engine-backup to ignore<br>also this error? I think the min= imal flow to reproduce is:<br><br>engine-setup<br>engine-backup --mode=3Dba= ckup --file=3Df1 --log=3Dl1<br>engine-cleanup<br>engine-backup --mode=3Dres= tore --file=3Df1 --provision-db<br>--provision-dwh-db --log=3Dl2<br><br>Did= n't try this myself.<br><br>><br>><br>> pg_restore: WARNING: colum= n "user_role_title" has type "unknown"<br>> DETAIL: Proceeding with rela= tion creation anyway.<br>> pg_restore: WARNING: no privileges could be r= evoked for "public"<br>> pg_restore: WARNING: no privileges could be rev= oked for "public"<br>> pg_restore: WARNING: no privileges were granted f= or "public"<br>> pg_restore: WARNING: no privileges were granted for "pu= blic"<br>> WARNING: errors ignored on restore: 3<br>> 2018-02-28 14:3= 7:23 6339: FATAL: Errors while restoring database engine<br>><br>> __= ______________________________<br>> De: suporte@logicworks.pt<br>> Pa= ra: "Yedidyah Bar David" <didi@redhat.com><br>> Cc: "ovirt users" = <users@ovirt.org><br>> Enviadas: Quarta-feira, 28 De Fevereiro de = 2018 12:45:04<br>><br>> Assunto: Re: [ovirt-users] Backup & Resto= re<br>><br>> Still no luck:<br>><br>> # engine-backup --mode=3D= restore --file=3Dback_futur --log=3Dlog_futur<br>> --provision-db --rest= ore-permissions --provision-dwh-db<br>> Preparing to restore:<br>> - = Unpacking file 'back_futur'<br>> Restoring:<br>> - Files<br>> Prov= isioning PostgreSQL users/databases:<br>> - user 'engine', database 'eng= ine'<br>> - user 'ovirt_engine_history', database 'ovirt_engine_history'= <br>> Restoring:<br>> - Engine database 'engine'<br>> FATAL: Error= s while restoring database engine<br>><br>> I did a engine-cleanup, t= ry it again but still the same error.<br>><br>> _____________________= ___________<br>> De: "Yedidyah Bar David" <didi@redhat.com><br>>= ; Para: suporte@logicworks.pt<br>> Cc: "ovirt users" <users@ovirt.org= ><br>> Enviadas: Quarta-feira, 28 De Fevereiro de 2018 12:24:50<br>&g= t; Assunto: Re: [ovirt-users] Backup & Restore<br>><br>> On Wed, = Feb 28, 2018 at 2:10 PM, <suporte@logicworks.pt> wrote:<br>>= > Hi,<br>>><br>>> I'm testing backup & restore on Ovirt = 4.2.<br>>> I follow this doc<br>>><br>>> https://www.ovir= t.org/documentation/admin-guide/chap-Backups_and_Migration/<br>>> Try= to restore to a fresh installation but always get this error message:<br>&= gt;><br>>> restore-permissions<br>>> Preparing to restore:<b= r>>> - Unpacking file 'back_file'<br>>> Restoring:<br>>> = - Files<br>>> Provisioning 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>>> On the live engine I= run # engine-backup --scope=3Dall --mode=3Dbackup<br>>> --file=3Dfil= e_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-per= missions<br>>><br>>> Any Idea?<br>><br>> Please try addin= g to restore command '--providion-dwh-db'. Thanks.<br>> --<br>> Didi<= br>><br>> _______________________________________________<br>> Use= rs mailing list<br>> Users@ovirt.org<br>> http://lists.ovirt.org/mail= man/listinfo/users<br><br><br><br>-- <br>Didi<br></div></div></body></html> ------=_Part_20566966_39555052.1519906078677--