Bug 1495270

Summary:	Panko: mysql bigint support
Product:	Red Hat OpenStack	Reporter:	Pradeep Kilambi <pkilambi>
Component:	openstack-panko	Assignee:	Julien Danjou <jdanjou>
Status:	CLOSED ERRATA	QA Contact:	Sasha Smolyak <ssmolyak>
Severity:	high	Docs Contact:
Priority:	high
Version:	11.0 (Ocata)	CC:	agarciam, ankur.h.garg, augol, dmacpher, jdanjou, mschuppe, pkilambi, rcernin, ssmolyak
Target Milestone:	z4	Keywords:	Triaged, ZStream
Target Release:	11.0 (Ocata)
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	openstack-panko-2.0.2-2.el7ost	Doc Type:	Bug Fix
Doc Text:	The Telemetry Event Storage used a SQL database column ('trait_int') with an 'Integer' type. This caused SQL errors due to the values in this column exceeding integer limits. This fix changes 'trait_int' to use 'BigInteger' values. The SQL errors no longer appear.	Story Points:	---
Clone Of:	1484078	Environment:
Last Closed:	2018-02-13 16:38:01 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:	1484078
Bug Blocks:

Comment 8 errata-xmlrpc 2018-02-13 16:38:01 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://access.redhat.com/errata/RHBA-2018:0311

Comment 9 Ankur Garg 2018-06-07 11:29:11 UTC

Hello,

Using Ocata Release (rhosp-release-11.0-2.el7ost.noarch) and tried following patch as resolution for this bug but it didnt make any change in trait_int table in DB:

openstack-panko-api-2.0.2-4.el7ost.noarch
python-panko-2.0.2-4.el7ost.noarch
openstack-panko-common-2.0.2-4.el7ost.noarch


Please check as after applying patch table remains same as:

desc trait_int;
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| event_id | int(11)      | NO   | PRI | NULL    |       |
| key      | varchar(255) | NO   | PRI | NULL    |       |
| value    | int(11)      | YES  |     | NULL    |       |
+----------+--------------+------+-----+---------+-------+
3 rows in set (0.01 sec)