Bug 1070757

Summary:	[database] support postgres user length within schema version
Product:	Red Hat Enterprise Virtualization Manager	Reporter:	Yaniv Lavi <ylavi>
Component:	ovirt-engine-dwh	Assignee:	Yaniv Lavi <ylavi>
Status:	CLOSED ERRATA	QA Contact:	Barak Dagan <bdagan>
Severity:	high	Docs Contact:
Priority:	unspecified
Version:	3.4.0	CC:	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:
Embargoed:
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