Bug 1070742

Summary:	[database] support postgres user length within schema version
Product:	[Retired] oVirt	Reporter:	Alon Bar-Lev <alonbl>
Component:	ovirt-engine-core	Assignee:	Eli Mesika <emesika>
Status:	CLOSED CURRENTRELEASE	QA Contact:	bugs <bugs>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	3.4	CC:	acathrow, bdagan, gklein, iheim, knesenko, yeylon, ylavi
Target Milestone:	---
Target Release:	3.4.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:	infra
Fixed In Version:	ovirt-engine-3.4.0_rc	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:
Clones:	1070757 (view as bug list)		Environment:
Last Closed:	2014-03-31 12:27:38 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1024889, 1070757

Description Alon Bar-Lev 2014-02-27 13:36:45 UTC

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

Comment 1 Sandro Bonazzola 2014-03-04 09:22:36 UTC

This is an automated message.
Re-targeting all non-blocker bugs still open on 3.4.0 to 3.4.1.

Comment 2 Alon Bar-Lev 2014-03-04 09:55:51 UTC

Can someone mark it as blocker?

Comment 3 Sandro Bonazzola 2014-03-31 12:27:38 UTC

this is an automated message: moving to Closed CURRENT RELEASE since oVirt 3.4.0 has been released

Comment 4 Barak Dagan 2014-03-31 13:18:04 UTC

Verified on av5:


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


could not change directory to "/root"
 column_name  |     data_type     | character_maximum_length 
--------------+-------------------+--------------------------
 installed_by | character varying |                       63
(1 row)