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 

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