Events fail to be added to Panko DB with "Out of range" error
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.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
