Bug 1262831

Summary: engine db infrastructure doesn't work properly with other schemas
Product: [oVirt] ovirt-engine Reporter: Martin Perina <mperina>
Component: Database.CoreAssignee: Martin Perina <mperina>
Status: CLOSED CURRENTRELEASE QA Contact: Lukas Svaty <lsvaty>
Severity: high Docs Contact:
Priority: unspecified    
Version: 3.6.0CC: bmcclain, bugs, emesika, gklein, lsvaty, oourfali, tnisan
Target Milestone: ovirt-3.6.0-gaFlags: rule-engine: ovirt-3.6.0+
ylavi: planning_ack+
oourfali: devel_ack+
gklein: testing_ack+
Target Release: 3.6.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: infra
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-11-27 07:54:20 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Martin Perina 2015-09-14 12:51:49 UTC
Description of problem:

In oVirt 3.6 engine and aaa-jdbc extension providing 'internal' domain are both installed in the same database using same database user. Engine is installed by default into 'public' schema, aaa-jdbc extension providing 'internal' domain is installed into 'aaa_jdbc' schema. Unfortunately engine db infrastructure functions included in common_sp.sql doesn't work properly if 'aaa_jdbc' schema is present.

Version-Release number of selected component (if applicable):

Any 3.6 version or master

How reproducible:

100%

Steps to Reproduce:

This is reproducing steps for fn_db_add_column function:
1. Create an upgrade script which will try to add column 'password_valid_to' to engine 'users' table
2. Execute engine-setup
3. Column 'password_valid_to' is not added into engine 'users' table, because column of the same name already exists in aaa-jdbc 'users' table

Actual results:

Engine database infrastructure functions doesn't work correctly if multiple schemas are present in engine database

Expected results:

Engine database infrastructure function should use only 'public' schema

Additional info:

Comment 1 Lukas Svaty 2015-11-26 16:18:08 UTC
verified in rhevm-3.6.1-0.2.el6.noarch

Comment 2 Sandro Bonazzola 2015-11-27 07:54:20 UTC
Since oVirt 3.6.0 has been released, moving from verified to closed current release.