Can you please update us on this thread once the patch is actually merged? Thanks, Oved On Tue, Dec 12, 2017 at 12:53 PM, Martin Perina <mperina@redhat.com> wrote:

On Tue, Dec 12, 2017 at 11:11 AM, Eli Mesika <emesika@redhat.com> wrote:

...

Hi

We had decided to drop our UUID generation function from DB in 4.2.1 and use the one provided by PG (using an extension) Please note that once this patch [1] is merged , you will have to do the following steps in your env in order that it will continue working.

1) make sure that the postgresql-contrib is installed on your machine (yum/dnf install postgresql-contrib -y)

​Just adding that package name is "postgresql-contrib" for Fedora and "rh-postgresql95-postgresql-contrib" for CentOS and it needs to be installed manually on engine developer's machines ​

...

2) run the following command from psql prompt while logging in with a DB admin (postgres) user a) DROP FUNCTION IF EXISTS uuid_generate_v1(); b) CREATE EXTENSION "uuid-ossp";' 3) validate from psql prompt by :

# select * from pg_available_extensions where name = 'uuid-ossp' and installed_version IS NOT NULL;

You should get the following result

-[ RECORD 1 ]-----+------------------------------------------------ name | uuid-ossp default_version | 1.0 installed_version | 1.0 comment | generate universally unique identifiers (UUIDs)

Please contact me for any questions or problems you encounter after this patch is merged to master.

[1] https://gerrit.ovirt.org/#/c/84832/

Thanks

Eli Mesika

-- Martin Perina Associate Manager, Software Engineering Red Hat Czech s.r.o.

It looks like it failed all post merge engine jobs: http://jenkins.ovirt.org/job/ovirt-engine_master_build-artifacts-el7-x86_64/... On Tue, Jan 16, 2018 at 3:52 PM, Eli Mesika <emesika@redhat.com> wrote:

Hi Guys

Please note that this patch was merged . You should follow all steps described in the original email

If you have any questions or problems, please contact me

Eli

On Tue, Dec 12, 2017 at 12:11 PM, Eli Mesika <emesika@redhat.com> wrote:

...

Hi

We had decided to drop our UUID generation function from DB in 4.2.1 and use the one provided by PG (using an extension) Please note that once this patch [1] is merged , you will have to do the following steps in your env in order that it will continue working.

1) make sure that the postgresql-contrib is installed on your machine (yum/dnf install postgresql-contrib -y) 2) run the following command from psql prompt while logging in with a DB admin (postgres) user a) DROP FUNCTION IF EXISTS uuid_generate_v1(); b) CREATE EXTENSION "uuid-ossp";' 3) validate from psql prompt by :

# select * from pg_available_extensions where name = 'uuid-ossp' and installed_version IS NOT NULL;

You should get the following result

-[ RECORD 1 ]-----+------------------------------------------------ name | uuid-ossp default_version | 1.0 installed_version | 1.0 comment | generate universally unique identifiers (UUIDs)

Please contact me for any questions or problems you encounter after this patch is merged to master.

[1] https://gerrit.ovirt.org/#/c/84832/

Thanks

Eli Mesika

-- Eyal edri MANAGER RHV DevOps EMEA VIRTUALIZATION R&D Red Hat EMEA <https://www.redhat.com/> <https://red.ht/sig> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted> phone: +972-9-7692018 irc: eedri (on #tlv #rhev-dev #rhev-integ)

"2) run the following command from psql prompt while logging in with a DB admin (postgres) user " Note on step 2: make sure you run $ psql engine and not just $ psql where engine = your engine db name, so that you connect to your engine db and not the server. The commands will run and look like they worked if you don't specify the database :) On Tue, Jan 16, 2018 at 8:52 AM, Eli Mesika <emesika@redhat.com> wrote:

Hi Guys

Please note that this patch was merged . You should follow all steps described in the original email

If you have any questions or problems, please contact me

Eli

On Tue, Dec 12, 2017 at 12:11 PM, Eli Mesika <emesika@redhat.com> wrote:

...

Hi

We had decided to drop our UUID generation function from DB in 4.2.1 and use the one provided by PG (using an extension) Please note that once this patch [1] is merged , you will have to do the following steps in your env in order that it will continue working.

1) make sure that the postgresql-contrib is installed on your machine (yum/dnf install postgresql-contrib -y) 2) run the following command from psql prompt while logging in with a DB admin (postgres) user a) DROP FUNCTION IF EXISTS uuid_generate_v1(); b) CREATE EXTENSION "uuid-ossp";' 3) validate from psql prompt by :

# select * from pg_available_extensions where name = 'uuid-ossp' and installed_version IS NOT NULL;

You should get the following result

-[ RECORD 1 ]-----+------------------------------------------------ name | uuid-ossp default_version | 1.0 installed_version | 1.0 comment | generate universally unique identifiers (UUIDs)

Please contact me for any questions or problems you encounter after this patch is merged to master.

[1] https://gerrit.ovirt.org/#/c/84832/

Thanks

Eli Mesika

-- GREG SHEREMETA SENIOR SOFTWARE ENGINEER - TEAM LEAD - RHV UX Red Hat NA <https://www.redhat.com/> gshereme@redhat.com IRC: gshereme <https://red.ht/sig>