[ovirt-users] Re: restore Self-Hosted Engine
Resolved , I don't update completely ovirt-engine I missed to do|||"engine-setup" after "yum update" on original VM engine.| |Restore is ok now | |Sorry,| | | |Regards,| -- Emmanuel Le 08/06/2018 à 11:34, thetas emmanuel a écrit : > > for info: > > if i use pg_restore with file extract from backup > > scl enable rh-postgresql95 'pg_restore -d engine > /root/db/engine_backup.db' > > no error!! > > same think with ovirt_engine_history > > > -- > Emmanuel > Le 24/05/2018 à 14:18, Simone Tiraboschi a écrit : >> Hi, >> adding also Didi here. >> We'll try to reproduce, in the mean time, can you please share >> engine-backup logs at backup and restore times? >> thanks >> >> On Wed, May 23, 2018 at 2:20 PM, thetas emmanuel >> > <mailto:emmanuel.the...@obs-nancay.fr>> wrote: >> >> hi, >> >> I follow this doc >> >> >> https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restoring_an_EL-Based_Self-Hosted_Environment/ >> >> <https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restoring_an_EL-Based_Self-Hosted_Environment/> >> >> But like others, i can't restore database >> >> I Have : >> >> pg_restore: [archiver (db)] Error while PROCESSING TOC: >> pg_restore: [archiver (db)] Error from TOC entry 7397; 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'; >> >> .. >> >> ... >> >> >> Any solution ? >> >> >> emmanuel >> ___ >> Users mailing list -- users@ovirt.org <mailto:users@ovirt.org> >> To unsubscribe send an email to users-le...@ovirt.org >> <mailto:users-le...@ovirt.org> >> >> > > > > ___ > 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/OR55P3N3YIW6LL3TTJF3TPQ2EDVBPCDV/ ___ 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/4VN5YMBGVPPPLEOEGXQ7CBPKJD5B7N3O/
[ovirt-users] Re: restore Self-Hosted Engine
for info: if i use pg_restore with file extract from backup scl enable rh-postgresql95 'pg_restore -d engine /root/db/engine_backup.db' no error!! same think with ovirt_engine_history -- Emmanuel Le 24/05/2018 à 14:18, Simone Tiraboschi a écrit : > Hi, > adding also Didi here. > We'll try to reproduce, in the mean time, can you please share > engine-backup logs at backup and restore times? > thanks > > On Wed, May 23, 2018 at 2:20 PM, thetas emmanuel > mailto:emmanuel.the...@obs-nancay.fr>> > wrote: > > hi, > > I follow this doc > > > https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restoring_an_EL-Based_Self-Hosted_Environment/ > > <https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restoring_an_EL-Based_Self-Hosted_Environment/> > > But like others, i can't restore database > > I Have : > > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Error from TOC entry 7397; 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'; > > .. > > ... > > > Any solution ? > > > emmanuel > ___ > Users mailing list -- users@ovirt.org <mailto:users@ovirt.org> > To unsubscribe send an email to users-le...@ovirt.org > <mailto:users-le...@ovirt.org> > > ___ 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/OR55P3N3YIW6LL3TTJF3TPQ2EDVBPCDV/
[ovirt-users] Re: restore Self-Hosted Engine
hi, I do test to understand my problem I do a fresh install of an EL-Based Self-Hosted Engine see https://ovirt.org/documentation/self-hosted/chap-Deploying_Self-Hosted_Engine/ REM : "hosted-engine --deploy" don't ash for storage so do hosted-engine --deploy --noansible I do a full backup of the engine https://www.ovirt.org/documentation/admin-guide/chap-Backups_and_Migration/#creating-a-backup-with-the-engine-backup-command cleanup, restore with this backup https://www.ovirt.org/documentation/admin-guide/chap-Backups_and_Migration/#restoring-a-backup-to-overwrite-an-existing-installation restore is ok : I do same think with my backup (v4.2.3) but same error on engine database : pg_restore: [archiver (db)] Error from TOC entry 1244; 1255 2004229 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; notice database created with 4.1 and upgrade to 4.2 How can I check the database ? clean up ? Do I create a bug report ? Regards, -- Emmanuel Le 24/05/2018 à 14:18, Simone Tiraboschi a écrit : > Hi, > adding also Didi here. > We'll try to reproduce, in the mean time, can you please share > engine-backup logs at backup and restore times? > thanks > > On Wed, May 23, 2018 at 2:20 PM, thetas emmanuel > mailto:emmanuel.the...@obs-nancay.fr>> > wrote: > > hi, > > I follow this doc > > > https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restoring_an_EL-Based_Self-Hosted_Environment/ > > <https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restoring_an_EL-Based_Self-Hosted_Environment/> > > But like others, i can't restore database > > I Have : > > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Error from TOC entry 7397; 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'; > > .. > > ... > > > Any solution ? > > > emmanuel > ___ > Users mailing list -- users@ovirt.org <mailto:users@ovirt.org> > To unsubscribe send an email to users-le...@ovirt.org > <mailto:users-le...@ovirt.org> > > ___ 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/KWUN6LFXX6CHAIGN4UKA456HATQL3MMZ/
[ovirt-users] Re: restore Self-Hosted Engine
Hi, still same error see my backup and restore log I restore on a new host /new storage I test FC and nfs but same error I want to migrate hosted VM to a new cluster/storage an other solution ? Regards, -- Emmanuel Thétas Equipe informatique support_informatique AT obs-nancay.fr Station de Radio-astronomie de Nançay (USN/Observatoire de Paris/CNRS) 18330 Nançay mail: emmanuel.thetas AT obs-nancay.fr tel: 02 48 51 87 20 fax: 02 48 51 83 18 web: http://www.obs-nancay.fr Le 24/05/2018 à 15:27, Simone Tiraboschi a écrit : > Hi, > according to the logs it seems that something was already in the > engine DB. > Could you please try running engine-cleanup before trying the restore? > > On Thu, May 24, 2018 at 3:24 PM, thetas emmanuel > mailto:emmanuel.the...@obs-nancay.fr>> > wrote: > > hi, > > > see my restore.log in attachment > > > regards, > > -- > Emmanuel Thétas > Equipe informatique > support_informatique AT obs-nancay.fr <http://obs-nancay.fr> > > Station de Radio-astronomie de Nançay > (USN/Observatoire de Paris/CNRS) > 18330 Nançay > > mail: emmanuel.thetas AT obs-nancay.fr <http://obs-nancay.fr> > tel: 02 48 51 87 20 > fax: 02 48 51 83 18 > > web: http://www.obs-nancay.fr > > Le 24/05/2018 à 14:18, Simone Tiraboschi a écrit : >> Hi, >> adding also Didi here. >> We'll try to reproduce, in the mean time, can you please share >> engine-backup logs at backup and restore times? >> thanks >> >> On Wed, May 23, 2018 at 2:20 PM, thetas emmanuel >> > <mailto:emmanuel.the...@obs-nancay.fr>> wrote: >> >> hi, >> >> I follow this doc >> >> >> https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restoring_an_EL-Based_Self-Hosted_Environment/ >> >> <https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restoring_an_EL-Based_Self-Hosted_Environment/> >> >> But like others, i can't restore database >> >> I Have : >> >> pg_restore: [archiver (db)] Error while PROCESSING TOC: >> pg_restore: [archiver (db)] Error from TOC entry 7397; 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'; >> >> .. >> >> ... >> >> >> Any solution ? >> >> >> emmanuel >> ___ >> Users mailing list -- users@ovirt.org <mailto:users@ovirt.org> >> To unsubscribe send an email to users-le...@ovirt.org >> <mailto:users-le...@ovirt.org> >> >> > > 2018-06-01 09:17:44 12236: Start of engine-backup mode restore scope all file backup-engine-20180601.tar.gz 2018-06-01 09:17:44 12236: Setting scl env for rh-postgresql95 2018-06-01 09:17:44 12236: OUTPUT: Preparing to restore: 2018-06-01 09:17:44 12236: OUTPUT: - Unpacking file 'backup-engine-20180601.tar.gz' 2018-06-01 09:17:44 12236: Opening tarball backup-engine-20180601.tar.gz to /tmp/engine-backup.hsqLgAr6qB 2018-06-01 09:17:44 12236: Verifying md5 2018-06-01 09:17:44 12236: Verifying version 2018-06-01 09:17:44 12236: Reading config 2018-06-01 09:17:44 12236: OUTPUT: Restoring: 2018-06-01 09:17:44 12236: OUTPUT: - Files 2018-06-01 09:17:44 12236: Restoring files 2018-06-01 09:17:45 12236: Reloading configuration 2018-06-01 09:17:45 12236: OUTPUT: Provisioning PostgreSQL users/databases: 2018-06-01 09:17:45 12236: provisionDB: user engine host localhost port 5432 database engine secured False secured_host_validation False 2018-06-01 09:17:45 12236: 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.hsqLgAr6qB/pg-provision-answer-file'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-provisiondb-20180601091746-iy1ai9.log Version: otopi-1.7.7 (otopi-1.7.7-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: P
[ovirt-users] Re: restore Self-Hosted Engine
I do the restore procedure 3 times and do for 1 engine-cleanup systemctl stop rh-postgresql95-postgresql rm -rf /var/opt/rh/rh-postgresql95/lib/pgsql/data and restore like i see here https://lists.ovirt.org/archives/list/users@ovirt.org/thread/OS7PIU2YUEIA3T3RCCQQETS5W64H7YJL/ but same error -- Emmanuel Thétas Equipe informatique support_informatique AT obs-nancay.fr Station de Radio-astronomie de Nançay (USN/Observatoire de Paris/CNRS) 18330 Nançay mail: emmanuel.thetas AT obs-nancay.fr tel: 02 48 51 87 20 fax: 02 48 51 83 18 web: http://www.obs-nancay.fr Le 24/05/2018 à 15:27, Simone Tiraboschi a écrit : > Hi, > according to the logs it seems that something was already in the > engine DB. > Could you please try running engine-cleanup before trying the restore? > > On Thu, May 24, 2018 at 3:24 PM, thetas emmanuel > <emmanuel.the...@obs-nancay.fr <mailto:emmanuel.the...@obs-nancay.fr>> > wrote: > > hi, > > > see my restore.log in attachment > > > regards, > > -- > Emmanuel Thétas > Equipe informatique > support_informatique AT obs-nancay.fr <http://obs-nancay.fr> > > Station de Radio-astronomie de Nançay > (USN/Observatoire de Paris/CNRS) > 18330 Nançay > > mail: emmanuel.thetas AT obs-nancay.fr <http://obs-nancay.fr> > tel: 02 48 51 87 20 > fax: 02 48 51 83 18 > > web: http://www.obs-nancay.fr > > Le 24/05/2018 à 14:18, Simone Tiraboschi a écrit : >> Hi, >> adding also Didi here. >> We'll try to reproduce, in the mean time, can you please share >> engine-backup logs at backup and restore times? >> thanks >> >> On Wed, May 23, 2018 at 2:20 PM, thetas emmanuel >> <emmanuel.the...@obs-nancay.fr >> <mailto:emmanuel.the...@obs-nancay.fr>> wrote: >> >> hi, >> >> I follow this doc >> >> >> https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restoring_an_EL-Based_Self-Hosted_Environment/ >> >> <https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restoring_an_EL-Based_Self-Hosted_Environment/> >> >> But like others, i can't restore database >> >> I Have : >> >> pg_restore: [archiver (db)] Error while PROCESSING TOC: >> pg_restore: [archiver (db)] Error from TOC entry 7397; 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'; >> >> .. >> >> ... >> >> >> Any solution ? >> >> >> emmanuel >> ___ >> Users mailing list -- users@ovirt.org <mailto:users@ovirt.org> >> To unsubscribe send an email to users-le...@ovirt.org >> <mailto:users-le...@ovirt.org> >> >> > > ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org
[ovirt-users] Re: restore Self-Hosted Engine
hi, see my restore.log in attachment regards, -- Emmanuel Thétas Equipe informatique support_informatique AT obs-nancay.fr Station de Radio-astronomie de Nançay (USN/Observatoire de Paris/CNRS) 18330 Nançay mail: emmanuel.thetas AT obs-nancay.fr tel: 02 48 51 87 20 fax: 02 48 51 83 18 web: http://www.obs-nancay.fr Le 24/05/2018 à 14:18, Simone Tiraboschi a écrit : > Hi, > adding also Didi here. > We'll try to reproduce, in the mean time, can you please share > engine-backup logs at backup and restore times? > thanks > > On Wed, May 23, 2018 at 2:20 PM, thetas emmanuel > <emmanuel.the...@obs-nancay.fr <mailto:emmanuel.the...@obs-nancay.fr>> > wrote: > > hi, > > I follow this doc > > > https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restoring_an_EL-Based_Self-Hosted_Environment/ > > <https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restoring_an_EL-Based_Self-Hosted_Environment/> > > But like others, i can't restore database > > I Have : > > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Error from TOC entry 7397; 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'; > > .. > > ... > > > Any solution ? > > > emmanuel > ___ > Users mailing list -- users@ovirt.org <mailto:users@ovirt.org> > To unsubscribe send an email to users-le...@ovirt.org > <mailto:users-le...@ovirt.org> > > 2018-05-23 11:29:24 14557: Start of engine-backup mode restore scope all file backup-engine-20180523.tar.gz 2018-05-23 11:29:24 14557: Setting scl env for rh-postgresql95 2018-05-23 11:29:24 14557: OUTPUT: Preparing to restore: 2018-05-23 11:29:24 14557: OUTPUT: - Unpacking file 'backup-engine-20180523.tar.gz' 2018-05-23 11:29:24 14557: Opening tarball backup-engine-20180523.tar.gz to /tmp/engine-backup.cYnEKLlBNr 2018-05-23 11:29:25 14557: Verifying md5 2018-05-23 11:29:25 14557: Verifying version 2018-05-23 11:29:25 14557: Reading config 2018-05-23 11:29:25 14557: OUTPUT: Restoring: 2018-05-23 11:29:25 14557: OUTPUT: - Files 2018-05-23 11:29:25 14557: Restoring files 2018-05-23 11:29:25 14557: Reloading configuration 2018-05-23 11:29:25 14557: OUTPUT: Provisioning PostgreSQL users/databases: 2018-05-23 11:29:25 14557: provisionDB: user engine host localhost port 5432 database engine secured False secured_host_validation False 2018-05-23 11:29:25 14557: 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.cYnEKLlBNr/pg-provision-answer-file'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-provisiondb-20180523112926-ryujgr.log Version: otopi-1.7.7 (otopi-1.7.7-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 ] Initializing PostgreSQL [ 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-20180523112926-ryujgr.log [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ INFO ] Execution of provisiondb completed successfully 2018-05-23 11:29:37 14557: provisionDB: user ovirt_engine_history host localhost port 5432 database ovirt_engine_history secured False secured_host_validation False 2018-05-23 11:29:37 14557: 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.cYnEKLlBNr/pg-provision-answer-file'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-provisiondb-20180523112937-ttl7gv.log Version: otopi-1.7.7 (otopi-1.7.7-1.el7.centos) [ INFO ] Stage: Environment packages setup [ INFO ] Stage: Programs detection [ INFO ] Stage: Environment customization [ INFO ] Stage: Setup validation [ INFO
[ovirt-users] restore Self-Hosted Engine
hi, I follow this doc https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restoring_an_EL-Based_Self-Hosted_Environment/ But like others, i can't restore database I Have : pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 7397; 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'; .. ... Any solution ? emmanuel ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org
