Bug 1103707 – application list database limit is too small (4000 chars)

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 1103707 - application list database limit is too small (4000 chars)

Summary:	application list database limit is too small (4000 chars)

Status:	CLOSED ERRATA

Aliases:	None

Product:	Red Hat Enterprise Virtualization Manager
Classification:	Red Hat
Component:	ovirt-engine (Show other bugs)
Sub Component:
Version:	3.3.0
Hardware:	Unspecified Unspecified

Priority	unspecified Severity unspecified
Target Milestone:	---
Target Release:	3.5.0
Assigned To:	Omer Frenkel
QA Contact:	Pavel Novotny
Docs Contact:

URL:
Whiteboard:	virt
Keywords:	CodeChange

Depends On:	1103710
Blocks:	rhev3.5beta 1156165
	Show dependency tree / graph

Reported:	2014-06-02 08:03 EDT by Michal Skrivanek
Modified:	2015-10-27 19:57 EDT (History)
CC List:	13 users (show)

See Also:
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 13:03:02 EST
Type:	Bug
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
oVirt gerrit	28279	master	MERGED	core: fix app_list parameter to 'text'	Never
Red Hat Product Errata	RHSA-2015:0158	normal	SHIPPED_LIVE	Important: Red Hat Enterprise Virtualization Manager 3.5.0	2015-02-11 17:38:50 EST

Groups: None (edit)

Description Michal Skrivanek 2014-06-02 08:03:37 EDT

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 03:59:12 EDT

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

Comment 2 Omer Frenkel 2014-06-11 06:37:16 EDT

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

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

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 13:03:02 EST

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

Note You need to log in before you can comment on or make changes to this bug.