Bug 1495270 - Panko: mysql bigint support
Summary: Panko: mysql bigint support
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-panko
Version: 11.0 (Ocata)
Hardware: Unspecified
OS: Unspecified
Target Milestone: z4
: 11.0 (Ocata)
Assignee: Julien Danjou
QA Contact: Sasha Smolyak
Depends On: 1484078
TreeView+ depends on / blocked
Reported: 2017-09-25 16:13 UTC by Pradeep Kilambi
Modified: 2021-04-15 04:34 UTC (History)
9 users (show)

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.
Clone Of: 1484078
Last Closed: 2018-02-13 16:38:01 UTC
Target Upstream Version:

Attachments (Terms of Use)

System ID Private Priority Status Summary Last Updated
Launchpad 1644954 0 None None None 2017-09-25 16:13:30 UTC
OpenStack gerrit 484972 0 None MERGED sql: support bigint traits 2020-04-13 11:18:04 UTC
Red Hat Knowledge Base (Solution) 3175651 0 None None None 2017-09-25 16:13:30 UTC
Red Hat Product Errata RHBA-2018:0311 0 normal SHIPPED_LIVE Red Hat OpenStack Platform 11 Bug Fix and Enhancement Advisory 2018-02-14 00:05:57 UTC

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.


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

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:


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)

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