hi, I follow this doc https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restorin... 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
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.thetas@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/
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-leave@ovirt.org
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.thetas@obs-nancay.fr <mailto:emmanuel.thetas@obs-nancay.fr>> wrote:
hi,
I follow this doc
https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restorin... <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-leave@ovirt.org <mailto:users-leave@ovirt.org>
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.thetas@obs-nancay.fr> wrote:
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
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.thetas@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/
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-leave@ovirt.org
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/OS7PIU2YUEIA3T3... 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.thetas@obs-nancay.fr <mailto:emmanuel.thetas@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
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.thetas@obs-nancay.fr <mailto:emmanuel.thetas@obs-nancay.fr>> wrote:
hi,
I follow this doc
https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restorin... <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-leave@ovirt.org <mailto:users-leave@ovirt.org>
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 <emmanuel.thetas@obs-nancay.fr <mailto:emmanuel.thetas@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
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.thetas@obs-nancay.fr <mailto:emmanuel.thetas@obs-nancay.fr>> wrote:
hi,
I follow this doc
https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restorin... <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-leave@ovirt.org <mailto:users-leave@ovirt.org>
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_Engin... 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/#... cleanup, restore with this backup https://www.ovirt.org/documentation/admin-guide/chap-Backups_and_Migration/#... 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 <emmanuel.thetas@obs-nancay.fr <mailto:emmanuel.thetas@obs-nancay.fr>> wrote:
hi,
I follow this doc
https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restorin... <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-leave@ovirt.org <mailto:users-leave@ovirt.org>
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 <emmanuel.thetas@obs-nancay.fr <mailto:emmanuel.thetas@obs-nancay.fr>> wrote:
hi,
I follow this doc
https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restorin... <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-leave@ovirt.org <mailto:users-leave@ovirt.org>
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 <emmanuel.thetas@obs-nancay.fr <mailto:emmanuel.thetas@obs-nancay.fr>> wrote:
hi,
I follow this doc
https://www.ovirt.org/documentation/self-hosted/chap-Backing_up_and_Restorin... <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-leave@ovirt.org <mailto:users-leave@ovirt.org>
_______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-leave@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/OR55P3N3YIW6LL...
participants (2)
-
Simone Tiraboschi -
thetas emmanuel