017-11-24 17:30:50.054 21833 CRITICAL cloudkitty [-] DBDataError: (pymysql.err.DataError) (1264, u"Out of range value for column 'qty' at row 1") [SQL: u'INSERT INTO rated_data_frames (tenant_id, begin, end, unit, qty, res_type, rate, `desc`) VALUES (%(tenant_id)s, %(begin)s, %(end)s, %(unit)s, %(qty)s, %(res_type)s, %(rate)s, %(desc)s)'] [parameters: {'res_type': 'network.bw.in', 'begin': datetime.datetime(2017, 11, 13, 14, 30), 'end': datetime.datetime(2017, 11, 13, 15, 30), 'tenant_id': u'ccfc7f4c3ead44e68e566d8acf3eecc5', 'qty': Decimal('104494.439491'), 'rate': Decimal('0'), 'unit': 'MB', 'desc': '{"revision_start": "2017-10-25T06:41:52.289697+00:00", "revision_end": null, "resource_id": "0c722bb2-4b5e-5fbe-99ff-4e9f52d6a188", "created_by_project_id": "39e0e6e1dce44b359d7c7502d5c69d86", "network.incoming.bytes": 104494.439491, "original_resource_id": "instance-0000023d-4b55abbd-355c-45c9-9be6-1c9a8bc5bb2b-tapf8181d0e-29", "ended_at": null, "started_at": "2017-10-25T06:41:52.289676+00:00", "id": "0c722bb2-4b5e-5fbe-99ff-4e9f52d6a188", "created_by_user_id": "fdd8fcc7f3974a6ea3a01fc144fdf624", "user_id": "7ebc4811f18a4db481adb1601200a435", "name": "tapf8181d0e-29", "creator": "fdd8fcc7f3974a6ea3a01fc144fdf624:39e0e6e1dce44b359d7c7502d5c69d86", "instance_id": "4b55abbd-355c-45c9-9be6-1c9a8bc5bb2b", "project_id": "ccfc7f4c3ead44e68e566d8acf3eecc5", "type": "instance_network_interface"}'}]
2017-11-24 17:30:50.054 21833 ERROR cloudkitty Traceback (most recent call last):
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/bin/cloudkitty-processor", line 10, in <module>
2017-11-24 17:30:50.054 21833 ERROR cloudkitty sys.exit(main())
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/cloudkitty/cli/processor.py", line 26, in main
2017-11-24 17:30:50.054 21833 ERROR cloudkitty processor.process()
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/cloudkitty/orchestrator.py", line 284, in process
2017-11-24 17:30:50.054 21833 ERROR cloudkitty worker.run()
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/cloudkitty/orchestrator.py", line 210, in run
2017-11-24 17:30:50.054 21833 ERROR cloudkitty self._storage.commit(self._tenant_id)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/cloudkitty/storage/__init__.py", line 247, in commit
2017-11-24 17:30:50.054 21833 ERROR cloudkitty self._commit(tenant_id)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/cloudkitty/storage/sqlalchemy/__init__.py", line 61, in _commit
2017-11-24 17:30:50.054 21833 ERROR cloudkitty self._session[tenant_id].commit()
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 813, in commit
2017-11-24 17:30:50.054 21833 ERROR cloudkitty self.transaction.commit()
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 392, in commit
2017-11-24 17:30:50.054 21833 ERROR cloudkitty self._prepare_impl()
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl
2017-11-24 17:30:50.054 21833 ERROR cloudkitty self.session.flush()
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2027, in flush
2017-11-24 17:30:50.054 21833 ERROR cloudkitty self._flush(objects)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2145, in _flush
2017-11-24 17:30:50.054 21833 ERROR cloudkitty transaction.rollback(_capture_exception=True)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
2017-11-24 17:30:50.054 21833 ERROR cloudkitty compat.reraise(exc_type, exc_value, exc_tb)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2109, in _flush
2017-11-24 17:30:50.054 21833 ERROR cloudkitty flush_context.execute()
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute
2017-11-24 17:30:50.054 21833 ERROR cloudkitty rec.execute(self)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute
2017-11-24 17:30:50.054 21833 ERROR cloudkitty uow
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj
2017-11-24 17:30:50.054 21833 ERROR cloudkitty mapper, table, insert)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 800, in _emit_insert_statements
2017-11-24 17:30:50.054 21833 ERROR cloudkitty execute(statement, params)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2017-11-24 17:30:50.054 21833 ERROR cloudkitty return meth(self, multiparams, params)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
2017-11-24 17:30:50.054 21833 ERROR cloudkitty return connection._execute_clauseelement(self, multiparams, params)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
2017-11-24 17:30:50.054 21833 ERROR cloudkitty compiled_sql, distilled_params
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2017-11-24 17:30:50.054 21833 ERROR cloudkitty context)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
2017-11-24 17:30:50.054 21833 ERROR cloudkitty util.raise_from_cause(newraise, exc_info)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause
2017-11-24 17:30:50.054 21833 ERROR cloudkitty reraise(type(exception), exception, tb=exc_tb)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2017-11-24 17:30:50.054 21833 ERROR cloudkitty context)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2017-11-24 17:30:50.054 21833 ERROR cloudkitty cursor.execute(statement, parameters)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 166, in execute
2017-11-24 17:30:50.054 21833 ERROR cloudkitty result = self._query(query)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 322, in _query
2017-11-24 17:30:50.054 21833 ERROR cloudkitty conn.query(q)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2017-11-24 17:30:50.054 21833 ERROR cloudkitty self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2017-11-24 17:30:50.054 21833 ERROR cloudkitty result.read()
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2017-11-24 17:30:50.054 21833 ERROR cloudkitty first_packet = self.connection._read_packet()
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2017-11-24 17:30:50.054 21833 ERROR cloudkitty packet.check_error()
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2017-11-24 17:30:50.054 21833 ERROR cloudkitty err.raise_mysql_exception(self._data)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 107, in raise_mysql_exception
2017-11-24 17:30:50.054 21833 ERROR cloudkitty raise errorclass(errno, errval)
2017-11-24 17:30:50.054 21833 ERROR cloudkitty DBDataError: (pymysql.err.DataError) (1264, u"Out of range value for column 'qty' at row 1") [SQL: u'INSERT INTO rated_data_frames (tenant_id, begin, end, unit, qty, res_type, rate, `desc`) VALUES (%(tenant_id)s, %(begin)s, %(end)s, %(unit)s, %(qty)s, %(res_type)s, %(rate)s, %(desc)s)'] [parameters: {'res_type': 'network.bw.in', 'begin': datetime.datetime(2017, 11, 13, 14, 30), 'end': datetime.datetime(2017, 11, 13, 15, 30), 'tenant_id': u'ccfc7f4c3ead44e68e566d8acf3eecc5', 'qty': Decimal('104494.439491'), 'rate': Decimal('0'), 'unit': 'MB', 'desc': '{"revision_start": "2017-10-25T06:41:52.289697+00:00", "revision_end": null, "resource_id": "0c722bb2-4b5e-5fbe-99ff-4e9f52d6a188", "created_by_project_id": "39e0e6e1dce44b359d7c7502d5c69d86", "network.incoming.bytes": 104494.439491, "original_resource_id": "instance-0000023d-4b55abbd-355c-45c9-9be6-1c9a8bc5bb2b-tapf8181d0e-29", "ended_at": null, "started_at": "2017-10-25T06:41:52.289676+00:00", "id": "0c722bb2-4b5e-5fbe-99ff-4e9f52d6a188", "created_by_user_id": "fdd8fcc7f3974a6ea3a01fc144fdf624", "user_id": "7ebc4811f18a4db481adb1601200a435", "name": "tapf8181d0e-29", "creator": "fdd8fcc7f3974a6ea3a01fc144fdf624:39e0e6e1dce44b359d7c7502d5c69d86", "instance_id": "4b55abbd-355c-45c9-9be6-1c9a8bc5bb2b", "project_id": "ccfc7f4c3ead44e68e566d8acf3eecc5", "type": "instance_network_interface"}'}]
2017-11-24 17:30:50.054 21833 ERROR cloudkitty
2017-11-24 17:30:50.198 21833 WARNING tooz.drivers.file [-] Unreleased lock /var/lib/cloudkitty/locks/cloudkitty-ccfc7f4c3ead44e68e566d8acf3eecc5 garbage collected