Bug 1103707

Summary:	application list database limit is too small (4000 chars)
Product:	Red Hat Enterprise Virtualization Manager	Reporter:	Michal Skrivanek <michal.skrivanek>
Component:	ovirt-engine	Assignee:	Omer Frenkel <ofrenkel>
Status:	CLOSED ERRATA	QA Contact:	Pavel Novotny <pnovotny>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	3.3.0	CC:	iheim, lpeer, mavital, michal.skrivanek, mkalinin, pablo.iranzo, pstehlik, rbalakri, Rhev-m-bugs, sherold, tdosek, yeylon
Target Milestone:	---	Keywords:	CodeChange
Target Release:	3.5.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:	virt
Fixed In Version:	ovirt-engine-3.5.0_beta	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2015-02-11 18:03:02 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:	1103710
Bug Blocks:	1142923, 1156165

Description Michal Skrivanek 2014-06-02 12:03:37 UTC

Description of problem:

stored procedure has a limit on 4000 characters for the app_list from guest agent. 
That's wrong!

Comment 1 Michal Skrivanek 2014-06-10 07:59:12 UTC

we figured out it's not really relevant, so it's just a "nice to have" patch

Comment 2 Omer Frenkel 2014-06-11 10:37:16 UTC

marking as code change, as this has no affect on the application, just db definitions

Comment 3 Pavel Novotny 2014-08-12 12:32:23 UTC

Verified upstream in ovirt-engine-3.5.0-0.0.master.20140804172041.git23b558e.el6.noarch (rc1).

The `app_list` column in `vm_dynamic` table is now of type `text` and not `varchar(4000)`.


engine=> \d vm_dynamic 
                              Table "public.vm_dynamic"
         Column         |           Type           |            Modifiers            
------------------------+--------------------------+---------------------------------
 vm_guid                | uuid                     | not null
...
...
 app_list               | text                     |

Comment 5 errata-xmlrpc 2015-02-11 18:03:02 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.

https://rhn.redhat.com/errata/RHSA-2015-0158.html