INFO:import_garmin.py:Debug: False English units: True
INFO:/home/dale/GarminDB/FileProcessor.pyc:Reading directory: /root/HealthData/FitFiles/2018_Monitoring/
INFO:GarminDB.GarminDB:GarminDB: {'db_type': 'sqlite', 'db_path': '/root/HealthData/DBs'} debug: -1
INFO:GarminDB.MonitoringDB:MonitoringDB: {'db_type': 'sqlite', 'db_path': '/root/HealthData/DBs'} debug: -1
INFO:GarminDB.ActivitiesDB:ActivitiesDB: {'db_type': 'sqlite', 'db_path': '/root/HealthData/DBs'} debug: -1
INFO:/home/dale/GarminDB/FitFileProcessor.pyc:Debug: False English units: True
INFO:/home/dale/GarminDB/FitFileProcessor.pyc:Importing /root/HealthData/FitFiles/2018_Monitoring//24287393166.fit (2018-09-01 06:39:59) [FileType.monitoring_b] with message types: [<MessageType.file_id: 0>, <MessageType.device_info: 23>, <MessageType.software: 35>, <MessageType.monitoring_info: 103>, <MessageType.monitoring: 55>, <UnknownMessageType.unknown_211: 211>]
Traceback (most recent call last):
File "import_garmin.py", line 301, in
main(sys.argv[1:])
File "import_garmin.py", line 287, in main
gfd.process_files(db_params_dict)
File "import_garmin.py", line 79, in process_files
fp.write_file(Fit.File(file_name, self.english_units))
File "/home/dale/GarminDB/FitFileProcessor.py", line 62, in write_file
self.write_message_types(fit_file, fit_file.message_types())
File "/home/dale/GarminDB/FitFileProcessor.py", line 57, in write_message_types
self.write_message_type(fit_file, message_type)
File "/home/dale/GarminDB/FitFileProcessor.py", line 44, in write_message_type
function(fit_file, message_type, messages)
File "/home/dale/GarminDB/FitFileProcessor.py", line 37, in write_generic
function(fit_file, message)
File "/home/dale/GarminDB/FitFileProcessor.py", line 332, in write_monitoring_info_entry
GarminDB.MonitoringInfo.find_or_create(self.garmin_mon_db, entry)
File "/home/dale/GarminDB/HealthDB/DB.py", line 231, in find_or_create
DB.commit(session)
File "/home/dale/GarminDB/HealthDB/DB.py", line 58, in commit
session.commit()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 943, in commit
self.transaction.commit()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 467, in commit
self._prepare_impl()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 447, in _prepare_impl
self.session.flush()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2254, in flush
self._flush(objects)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2380, in _flush
transaction.rollback(_capture_exception=True)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 66, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2344, in _flush
flush_context.execute()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 391, in execute
rec.execute(self)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 556, in execute
uow
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 181, in save_obj
mapper, table, insert)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 830, in _emit_insert_statements
execute(statement, multiparams)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 265, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 509, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: monitoring_info.file_id [SQL: u'INSERT INTO monitoring_info (timestamp, file_id, activity_type, resting_metabolic_rate, cycles_to_distance, cycles_to_calories) VALUES (?, ?, ?, ?, ?, ?)'] [parameters: ('2018-09-01 06:40:00.000000', None, 'walking', 2447, 1.729, 0.0677344808351263)] (Background on this error at: http://sqlalche.me/e/gkpj)
make: *** [import_monitoring] Error 1