Bug 1070757

Summary: [database] support postgres user length within schema version
Product: Red Hat Enterprise Virtualization Manager Reporter: Yaniv Lavi <ylavi>
Component: ovirt-engine-dwhAssignee: Yaniv Lavi <ylavi>
Status: CLOSED ERRATA QA Contact: Barak Dagan <bdagan>
Severity: high Docs Contact:
Priority: unspecified    
Version: 3.4.0CC: aberezin, acathrow, adahms, alonbl, gklein, iheim, pstehlik, Rhev-m-bugs, yeylon, ylavi
Target Milestone: ---   
Target Release: 3.4.0   
Hardware: x86_64   
OS: Linux   
Whiteboard: infra
Fixed In Version: av3 - rhevm-dwh-setup-3.4.0-3.el6ev.noarch.rpm Doc Type: Bug Fix
Doc Text:
This update increases the size of data that can be stored in the installed_by column in the schema_version table of the engine database to 63 characters, providing support for the maximum length of user names that can be specified in PostgreSQL.
Story Points: ---
Clone Of: 1070742 Environment:
Last Closed: 2014-06-09 15:18:31 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:
Bug Depends On: 1070742    
Bug Blocks: 1078909, 1142926    

Description Yaniv Lavi 2014-02-27 14:06:43 UTC
+++ This bug was initially created as a clone of Bug #1070742 +++

Currently the schema version holds a field for user name, while the length of the field is shorter than what postgres supports.

Comment 2 Barak Dagan 2014-03-09 12:49:36 UTC
Verification failed on av2.1:

psql -d engine -c "select * from information_schema.columns where table_name = 'schema_version' and column_name = 'installed_by';" | less -S

 table_catalog | table_schema |   table_name   | column_name  | ordinal_position | column_default | is_nullable |     data_type     | character_maximum_length | character_octet_length | numeric_precision 
---------------+--------------+----------------+--------------+------------------+----------------+-------------+-------------------+--------------------------+------------------------+-------------------
 engine        | public       | schema_version | installed_by |                5 |                | NO          | character varying |                       30 |             1073741824 |                   
(1 row)


Fix will be entered in later version (3.4.1 ?)

https://bugzilla.redhat.com/show_bug.cgi?id=1070742 is still in modified.

Comment 3 Barak Dagan 2014-03-18 12:40:03 UTC
Verified on av3:

# rpm -q rhevm
rhevm-3.4.0-0.5.master.el6ev.noarch

# rpm -q rhevm-dwh
rhevm-dwh-3.4.0-3.el6ev.noarch

# rpm -q rhevm-reports
rhevm-reports-3.4.0-2.el6ev.noarch

 table_catalog | table_schema |   table_name   | column_name  | ordinal_position | column_default | is_nullable |     data_type     | character_maximum_length | character_octet_length | numeric_precision | nume
---------------+--------------+----------------+--------------+------------------+----------------+-------------+-------------------+--------------------------+------------------------+-------------------+-----
 engine        | public       | schema_version | installed_by |                5 |                | NO          | character varying |                       63 |             1073741824 |                   |     
(1 row)

Comment 4 errata-xmlrpc 2014-06-09 15:18:31 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHEA-2014-0601.html