021-05-21 14:10:39,972 - INFO - mycodo.daemon - Mycodo daemon v8.10.1 starting
2021-05-21 14:10:47,588 - INFO - mycodo.controllers.controller_output - Activated in 6031.0 ms
2021-05-21 14:10:55,814 - INFO - mycodo.daemon - All activated Conditional controllers started
2021-05-21 14:10:55,815 - INFO - mycodo.daemon - All activated Trigger controllers started
2021-05-21 14:10:55,815 - INFO - mycodo.daemon - All activated Input controllers started
2021-05-21 14:10:55,815 - INFO - mycodo.daemon - All activated Math controllers started
2021-05-21 14:10:55,816 - INFO - mycodo.daemon - All activated PID controllers started
2021-05-21 14:10:55,816 - INFO - mycodo.daemon - All activated LCD controllers started
2021-05-21 14:10:55,816 - INFO - mycodo.daemon - All activated Function controllers started
2021-05-21 14:11:00,841 - ERROR - mycodo.databases.utils - Error raised in session_scope.  Session will be rolled back: db_uri='sqlite:////home/pi/Mycodo/databases/mycodo.db', error='(sqlite3.OperationalError) database is locked
[SQL: SELECT misc.id AS misc_id, misc.dismiss_notification AS misc_dismiss_notification, misc.force_https AS misc_force_https, misc.hide_alert_info AS misc_hide_alert_info, misc.hide_alert_success AS misc_hide_alert_success, misc.hide_alert_warning AS misc_hide_alert_warning, misc.hide_tooltips AS misc_hide_tooltips, misc.grid_cell_height AS misc_grid_cell_height, misc.login_message AS misc_login_message, misc.max_amps AS misc_max_amps, misc.output_usage_cost AS misc_output_usage_cost, misc.output_usage_currency AS misc_output_usage_currency, misc.output_usage_dayofmonth AS misc_output_usage_dayofmonth, misc.output_usage_volts AS misc_output_usage_volts, misc.output_usage_report_gen AS misc_output_usage_report_gen, misc.output_usage_report_span AS misc_output_usage_report_span, misc.output_usage_report_day AS misc_output_usage_report_day, misc.output_usage_report_hour AS misc_output_usage_report_hour, misc.sample_rate_controller_conditional AS misc_sample_rate_controller_conditional, misc.sample_rate_controller_function AS misc_sample_rate_controller_function, misc.sample_rate_controller_input AS misc_sample_rate_controller_input, misc.sample_rate_controller_math AS misc_sample_rate_controller_math, misc.sample_rate_controller_output AS misc_sample_rate_controller_output, misc.sample_rate_controller_pid AS misc_sample_rate_controller_pid, misc.sample_rate_controller_widget AS misc_sample_rate_controller_widget, misc.stats_opt_out AS misc_stats_opt_out, misc.enable_upgrade_check AS misc_enable_upgrade_check, misc.mycodo_upgrade_available AS misc_mycodo_upgrade_available, misc.rpyc_timeout AS misc_rpyc_timeout, misc.daemon_debug_mode AS misc_daemon_debug_mode, misc.net_test_ip AS misc_net_test_ip, misc.net_test_port AS misc_net_test_port, misc.net_test_timeout AS misc_net_test_timeout 
FROM misc
 LIMIT ? OFFSET ?]
[parameters: (1, 0)]
(Background on this error at: http://sqlalche.me/e/14/e3q8)'
Traceback (most recent call last):
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context
    cursor, statement, parameters, context
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/var/mycodo-root/mycodo/databases/utils.py", line 26, in session_scope
    yield session
  File "/var/mycodo-root/mycodo/utils/database.py", line 72, in db_retrieve_table_daemon
    return_table = return_table.first()
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2736, in first
    return self.limit(1)._iter().first()
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2823, in _iter
    execution_options={"_sa_orm_load_options": self.load_options},
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1670, in execute
    result = conn._execute_20(statement, params or {}, execution_options)
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1520, in _execute_20
    return meth(self, args_10style, kwargs_10style, execution_options)
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 314, in _execute_on_connection
    self, multiparams, params, execution_options
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1399, in _execute_clauseelement
    cache_hit=cache_hit,
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1749, in _execute_context
    e, statement, parameters, cursor, context
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1930, in _handle_dbapi_exception
    sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
    raise exception
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context
    cursor, statement, parameters, context
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: SELECT misc.id AS misc_id, misc.dismiss_notification AS misc_dismiss_notification, misc.force_https AS misc_force_https, misc.hide_alert_info AS misc_hide_alert_info, misc.hide_alert_success AS misc_hide_alert_success, misc.hide_alert_warning AS misc_hide_alert_warning, misc.hide_tooltips AS misc_hide_tooltips, misc.grid_cell_height AS misc_grid_cell_height, misc.login_message AS misc_login_message, misc.max_amps AS misc_max_amps, misc.output_usage_cost AS misc_output_usage_cost, misc.output_usage_currency AS misc_output_usage_currency, misc.output_usage_dayofmonth AS misc_output_usage_dayofmonth, misc.output_usage_volts AS misc_output_usage_volts, misc.output_usage_report_gen AS misc_output_usage_report_gen, misc.output_usage_report_span AS misc_output_usage_report_span, misc.output_usage_report_day AS misc_output_usage_report_day, misc.output_usage_report_hour AS misc_output_usage_report_hour, misc.sample_rate_controller_conditional AS misc_sample_rate_controller_conditional, misc.sample_rate_controller_function AS misc_sample_rate_controller_function, misc.sample_rate_controller_input AS misc_sample_rate_controller_input, misc.sample_rate_controller_math AS misc_sample_rate_controller_math, misc.sample_rate_controller_output AS misc_sample_rate_controller_output, misc.sample_rate_controller_pid AS misc_sample_rate_controller_pid, misc.sample_rate_controller_widget AS misc_sample_rate_controller_widget, misc.stats_opt_out AS misc_stats_opt_out, misc.enable_upgrade_check AS misc_enable_upgrade_check, misc.mycodo_upgrade_available AS misc_mycodo_upgrade_available, misc.rpyc_timeout AS misc_rpyc_timeout, misc.daemon_debug_mode AS misc_daemon_debug_mode, misc.net_test_ip AS misc_net_test_ip, misc.net_test_port AS misc_net_test_port, misc.net_test_timeout AS misc_net_test_timeout 
FROM misc
 LIMIT ? OFFSET ?]
[parameters: (1, 0)]
(Background on this error at: http://sqlalche.me/e/14/e3q8)
2021-05-21 14:11:14,743 - ERROR - mycodo.database - The Mycodo database is locked. Trying to access again in 1 second...
2021-05-21 14:11:24,638 - ERROR - mycodo.databases.utils - Error raised in session_scope.  Session will be rolled back: db_uri='sqlite:////home/pi/Mycodo/databases/mycodo.db', error='(sqlite3.OperationalError) database is locked
[SQL: SELECT widget.id AS widget_id, widget.unique_id AS widget_unique_id, widget.graph_type AS widget_graph_type, widget.dashboard_id AS widget_dashboard_id, widget.name AS widget_name, widget.log_level_debug AS widget_log_level_debug, widget.font_em_name AS widget_font_em_name, widget.enable_drag_handle AS widget_enable_drag_handle, widget.position_x AS widget_position_x, widget.position_y AS widget_position_y, widget.width AS widget_width, widget.height AS widget_height, widget.custom_options AS widget_custom_options, widget.enable_header_buttons AS widget_enable_header_buttons, widget.period AS widget_period, widget.refresh_duration AS widget_refresh_duration, widget.x_axis_duration AS widget_x_axis_duration, widget.custom_yaxes AS widget_custom_yaxes, widget.decimal_places AS widget_decimal_places, widget.enable_status AS widget_enable_status, widget.enable_value AS widget_enable_value, widget.enable_name AS widget_enable_name, widget.enable_unit AS widget_enable_unit, widget.enable_measurement AS widget_enable_measurement, widget.enable_channel AS widget_enable_channel, widget.enable_timestamp AS widget_enable_timestamp, widget.pid_ids AS widget_pid_ids, widget.output_ids AS widget_output_ids, widget.math_ids AS widget_math_ids, widget.note_tag_ids AS widget_note_tag_ids, widget.input_ids_measurements AS widget_input_ids_measurements, widget.enable_navbar AS widget_enable_navbar, widget.enable_rangeselect AS widget_enable_rangeselect, widget.enable_export AS widget_enable_export, widget.enable_title AS widget_enable_title, widget.enable_auto_refresh AS widget_enable_auto_refresh, widget.enable_xaxis_reset AS widget_enable_xaxis_reset, widget.enable_manual_y_axis AS widget_enable_manual_y_axis, widget.enable_start_on_tick AS widget_enable_start_on_tick, widget.enable_end_on_tick AS widget_enable_end_on_tick, widget.enable_align_ticks AS widget_enable_align_ticks, widget.use_custom_colors AS widget_use_custom_colors, widget.custom_colors AS widget_custom_colors, widget.disable_data_grouping AS widget_disable_data_grouping, widget.max_measure_age AS widget_max_measure_age, widget.stops AS widget_stops, widget.range_colors AS widget_range_colors, widget.y_axis_min AS widget_y_axis_min, widget.y_axis_max AS widget_y_axis_max, widget.option_invert AS widget_option_invert, widget.font_em_value AS widget_font_em_value, widget.font_em_timestamp AS widget_font_em_timestamp, widget.enable_output_controls AS widget_enable_output_controls, widget.show_pid_info AS widget_show_pid_info, widget.show_set_setpoint AS widget_show_set_setpoint, widget.camera_id AS widget_camera_id, widget.camera_image_type AS widget_camera_image_type, widget.camera_max_age AS widget_camera_max_age 
FROM widget]
(Background on this error at: http://sqlalche.me/e/14/e3q8)'
Traceback (most recent call last):
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context
    cursor, statement, parameters, context
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute
    cursor.execute(statement, parameters)
sqlite3.OperationalError: database is locked

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/var/mycodo-root/mycodo/databases/utils.py", line 26, in session_scope
    yield session
  File "/var/mycodo-root/mycodo/utils/database.py", line 74, in db_retrieve_table_daemon
    return_table = return_table.all()
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2685, in all
    return self._iter().all()
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 2823, in _iter
    execution_options={"_sa_orm_load_options": self.load_options},
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1670, in execute
    result = conn._execute_20(statement, params or {}, execution_options)
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1520, in _execute_20
    return meth(self, args_10style, kwargs_10style, execution_options)
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 314, in _execute_on_connection
    self, multiparams, params, execution_options
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1399, in _execute_clauseelement
    cache_hit=cache_hit,
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1749, in _execute_context
    e, statement, parameters, cursor, context
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1930, in _handle_dbapi_exception
    sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
    raise exception
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1706, in _execute_context
    cursor, statement, parameters, context
  File "/var/mycodo-root/env/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 692, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: SELECT widget.id AS widget_id, widget.unique_id AS widget_unique_id, widget.graph_type AS widget_graph_type, widget.dashboard_id AS widget_dashboard_id, widget.name AS widget_name, widget.log_level_debug AS widget_log_level_debug, widget.font_em_name AS widget_font_em_name, widget.enable_drag_handle AS widget_enable_drag_handle, widget.position_x AS widget_position_x, widget.position_y AS widget_position_y, widget.width AS widget_width, widget.height AS widget_height, widget.custom_options AS widget_custom_options, widget.enable_header_buttons AS widget_enable_header_buttons, widget.period AS widget_period, widget.refresh_duration AS widget_refresh_duration, widget.x_axis_duration AS widget_x_axis_duration, widget.custom_yaxes AS widget_custom_yaxes, widget.decimal_places AS widget_decimal_places, widget.enable_status AS widget_enable_status, widget.enable_value AS widget_enable_value, widget.enable_name AS widget_enable_name, widget.enable_unit AS widget_enable_unit, widget.enable_measurement AS widget_enable_measurement, widget.enable_channel AS widget_enable_channel, widget.enable_timestamp AS widget_enable_timestamp, widget.pid_ids AS widget_pid_ids, widget.output_ids AS widget_output_ids, widget.math_ids AS widget_math_ids, widget.note_tag_ids AS widget_note_tag_ids, widget.input_ids_measurements AS widget_input_ids_measurements, widget.enable_navbar AS widget_enable_navbar, widget.enable_rangeselect AS widget_enable_rangeselect, widget.enable_export AS widget_enable_export, widget.enable_title AS widget_enable_title, widget.enable_auto_refresh AS widget_enable_auto_refresh, widget.enable_xaxis_reset AS widget_enable_xaxis_reset, widget.enable_manual_y_axis AS widget_enable_manual_y_axis, widget.enable_start_on_tick AS widget_enable_start_on_tick, widget.enable_end_on_tick AS widget_enable_end_on_tick, widget.enable_align_ticks AS widget_enable_align_ticks, widget.use_custom_colors AS widget_use_custom_colors, widget.custom_colors AS widget_custom_colors, widget.disable_data_grouping AS widget_disable_data_grouping, widget.max_measure_age AS widget_max_measure_age, widget.stops AS widget_stops, widget.range_colors AS widget_range_colors, widget.y_axis_min AS widget_y_axis_min, widget.y_axis_max AS widget_y_axis_max, widget.option_invert AS widget_option_invert, widget.font_em_value AS widget_font_em_value, widget.font_em_timestamp AS widget_font_em_timestamp, widget.enable_output_controls AS widget_enable_output_controls, widget.show_pid_info AS widget_show_pid_info, widget.show_set_setpoint AS widget_show_set_setpoint, widget.camera_id AS widget_camera_id, widget.camera_image_type AS widget_camera_image_type, widget.camera_max_age AS widget_camera_max_age 
FROM widget]
(Background on this error at: http://sqlalche.me/e/14/e3q8)
2021-05-21 14:11:24,642 - ERROR - mycodo.database - The Mycodo database is locked. Trying to access again in 1 second...
2021-05-21 14:11:26,556 - INFO - mycodo.controllers.controller_widget - Activated in 30739.4 ms
2021-05-21 14:11:27,558 - INFO - mycodo.daemon - Mycodo daemon started in 47.584 seconds
2021-05-21 14:11:27,769 - INFO - mycodo.daemon - 42.84 MB RAM in use
2021-05-21 14:39:53,351 - INFO - mycodo.daemon - Received command to terminate daemon
2021-05-21 14:39:53,626 - INFO - mycodo.daemon - All Function controllers stopped
2021-05-21 14:39:53,627 - INFO - mycodo.daemon - All LCD controllers stopped
2021-05-21 14:39:53,627 - INFO - mycodo.daemon - All PID controllers stopped
2021-05-21 14:39:53,627 - INFO - mycodo.daemon - All Math controllers stopped
2021-05-21 14:39:53,627 - INFO - mycodo.daemon - All Input controllers stopped
2021-05-21 14:39:53,628 - INFO - mycodo.daemon - All Trigger controllers stopped
2021-05-21 14:39:53,628 - INFO - mycodo.daemon - All Conditional controllers stopped
2021-05-21 14:39:53,677 - INFO - mycodo.controllers.controller_output - Deactivated in 49.0 ms
2021-05-21 14:39:53,761 - INFO - mycodo.controllers.controller_widget - Deactivated in 83.6 ms
2021-05-21 14:39:53,762 - INFO - mycodo.daemon - Mycodo daemon terminated in 0.410 seconds