mysql: bigint support

[Marcus Furlong]

ceilometer-collector logs keep filling up with the following error on Newton:

2016-11-26 15:29:15.427 13997 ERROR ceilometer.collector
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy [-] Failed to record event: (_mysql_exceptions.DataError) (1264, "Out of range value for column 'value' at row 1") [SQL: u'INSERT INTO trait_int (event_id, `key`, value) VALUES (%s, %s, %s)'] [parameters: (256869L, 'bytes_sent', 2644705280)]
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy Traceback (most recent call last):
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy File "/usr/lib/python2.7/site-packages/ceilometer/event/storage/impl_sqlalchemy.py", line 216, in record_events
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy trait_map[dtype])
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 1046, in execute
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy bind, close_with_result=True).execute(clause, params or {})
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy return meth(self, multiparams, params)
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy return connection._execute_clauseelement(self, multiparams, params)
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy compiled_sql, distilled_params
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy context)
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy util.raise_from_cause(newraise, exc_info)
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy reraise(type(exception), exception, tb=exc_tb)
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy context)
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy cursor.execute(statement, parameters)
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 174, in execute
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy self.errorhandler(self, exc, value)
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy raise errorclass, errorvalue
2016-11-26 15:29:15.462 13999 ERROR ceilometer.event.storage.impl_sqlalchemy DBDataError: (_mysql_exceptions.DataError) (1264, "Out of range value for column 'value' at row 1") [SQL: u'INSERT INTO trait_int (event_id, `key`, value) VALUES (%s, %s, %s)'] [parameters: (256869L, 'bytes_sent', 2644705280)]

[Julien Danjou (jdanjou)]

Reassigned to Panko as we don't handle that in Ceilometer anymore

[gordon chung (chungg)]

this is bigger than int. we need to support bigint

[Julien Danjou (jdanjou)]

Are you still fixing that gordon?

[gordon chung (chungg)]

i don't know why it didn't pick up patch

https://review.openstack.org/#/c/484972/

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/484972
Committed: https://git.openstack.org/cgit/openstack/panko/commit/?id=fa8656ca7f6385f22bbf48b37fa34b86bd2e6414
Submitter: Jenkins
Branch: master

commit fa8656ca7f6385f22bbf48b37fa34b86bd2e6414
Author: gord chung <email address hidden>
Date: Tue Jul 18 22:24:52 2017 +0000

    sql: support bigint traits

    add alembic and support bigint traits

    Change-Id: I1fa3b5f9d72a4bc34b006648430c8399e9f3668e
    Closes-Bug: #1644954

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/pike
Review: https://review.openstack.org/501310

[OpenStack Infra (hudson-openstack)]

Change abandoned by Julien Danjou (<email address hidden>) on branch: stable/pike
Review: https://review.openstack.org/501310

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/panko 4.0.0 release.