Events fail to be added to Panko DB with "Out of range" error

Solution Verified - Updated -

Issue

When events with values > then int gets added to the trait_int table, the insert fails with:

2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy [-] Failed to record event: (pymysql.err.DataError) (1264, u"Out of range value for column 'value' at row 1") [SQL: u'INSERT INTO trait_int (event_id, `key`, value) VALUES (%(event_id)s, %(key)s, %(value)s)'] [parameters: {'event_id': 68727326, 'value': 3280076800, 'key': u'bytes_sent'}]
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy Traceback (most recent call last):
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib/python2.7/site-packages/panko/storage/impl_sqlalchemy.py", line 197, in record_events
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     trait_map[dtype])
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 1046, in execute
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     bind, close_with_result=True).execute(clause, params or {})
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     return meth(self, multiparams, params)
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     return connection._execute_clauseelement(self, multiparams, params)
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     compiled_sql, distilled_params
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     context)
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     util.raise_from_cause(newraise, exc_info)
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     reraise(type(exception), exception, tb=exc_tb)
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     context)
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     cursor.execute(statement, parameters)
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 166, in execute
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     result = self._query(query)
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 322, in _query
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     conn.query(q)
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 841, in query
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1029, in _read_query_result
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     result.read()
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1312, in read
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     first_packet = self.connection._read_packet()
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 991, in _read_packet
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     packet.check_error()
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 393, in check_error
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     err.raise_mysql_exception(self._data)
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy     raise errorclass(errno, errval)
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy DBDataError: (pymysql.err.DataError) (1264, u"Out of range value for column 'value' at row 1") [SQL: u'INSERT INTO trait_int (event_id, `key`, value) VALUES (%(event_id)s, %(key)s, %(value)s)'] [parameters: {'event_id': 68727326, 'value': 3280076800, 'key': u'bytes_sent'}]
2017-09-01 12:16:13.891 58769 ERROR panko.storage.impl_sqlalchemy
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector [-] Dispatcher failed to handle the notification, re-queuing it.
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector Traceback (most recent call last):
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector   File "/usr/lib/python2.7/site-packages/ceilometer/collector.py", line 177, in sample
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector     self.dispatcher_manager.map_method(self.method, goods)
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector   File "/usr/lib/python2.7/site-packages/stevedore/extension.py", line 282, in map_method
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector     method_name, *args, **kwds)
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector   File "/usr/lib/python2.7/site-packages/stevedore/extension.py", line 255, in map
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector     self._invoke_one_plugin(response.append, func, e, args, kwds)
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector   File "/usr/lib/python2.7/site-packages/stevedore/extension.py", line 286, in _invoke_one_plugin
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector     response_callback(func(e, *args, **kwds))
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector   File "/usr/lib/python2.7/site-packages/stevedore/extension.py", line 260, in _call_extension_method
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector     return getattr(extension.obj, method_name)(*args, **kwds)
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector   File "/usr/lib/python2.7/site-packages/panko/dispatcher/database.py", line 68, in record_events
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector     self.conn.record_events(event_list)
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector   File "/usr/lib/python2.7/site-packages/panko/storage/impl_sqlalchemy.py", line 206, in record_events
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector     raise error
2017-09-01 12:16:13.894 58769 ERROR ceilometer.collector DBDataError: (pymysql.err.DataError) (1264, u"Out of range value for column 'value' at row 1") [SQL: u'INSERT INTO trait_int (event_id, `key`, value) VALUES (%(event_id)s, %(key)s, %(value)s)'] [parameters: {'event_id': 68727326, 'value': 3280076800, 'key': u'bytes_sent'}]

Environment

  • Red Hat OpenStack Platform 11.0 (RHOSP)
  • Red Hat OpenStack Platform 10.0 (RHOSP)

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In