{"action":"created","issue":{"url":"https://api.github.com/repos/domogik/domogik/issues/552","repository_url":"https://api.github.com/repos/domogik/domogik","labels_url":"https://api.github.com/repos/domogik/domogik/issues/552/labels{/name}","comments_url":"https://api.github.com/repos/domogik/domogik/issues/552/comments","events_url":"https://api.github.com/repos/domogik/domogik/issues/552/events","html_url":"https://github.com/domogik/domogik/issues/552","id":377163680,"node_id":"MDU6SXNzdWUzNzcxNjM2ODA=","number":552,"title":"xplgw crash","user":{"login":"tikismoke","id":2229691,"node_id":"MDQ6VXNlcjIyMjk2OTE=","avatar_url":"https://avatars0.githubusercontent.com/u/2229691?v=4","gravatar_id":"","url":"https://api.github.com/users/tikismoke","html_url":"https://github.com/tikismoke","followers_url":"https://api.github.com/users/tikismoke/followers","following_url":"https://api.github.com/users/tikismoke/following{/other_user}","gists_url":"https://api.github.com/users/tikismoke/gists{/gist_id}","starred_url":"https://api.github.com/users/tikismoke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tikismoke/subscriptions","organizations_url":"https://api.github.com/users/tikismoke/orgs","repos_url":"https://api.github.com/users/tikismoke/repos","events_url":"https://api.github.com/users/tikismoke/events{/privacy}","received_events_url":"https://api.github.com/users/tikismoke/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-11-04T15:28:59Z","updated_at":"2018-11-04T17:41:11Z","closed_at":null,"author_association":"MEMBER","body":"```\r\n2018-11-04 16:27:22,109 domogik-xplgw INFO Storing stat for device 'nest.thermostat' (423) and sensor 'Last Connection' (2771) with value 'None' after conversion.\r\n2018-11-04 16:27:22,137 domogik-xplgw ERROR Error when adding sensor history : Traceback (most recent call last):\r\n  File \"/home/domogik/src/domogik/bin/xplgw.py\", line 862, in run\r\n    current_date)\r\n  File \"/home/domogik/src/domogik/common/database.py\", line 1033, in add_sensor_history\r\n    self.__raise_dbhelper_exception(u\"Error when adding data to sensor history. Sensor id = {0}  | Value = {1}  | Date = {2}. Error is {3}\".format(sid, value, date, traceback.format_exc()))\r\n  File \"/home/domogik/src/domogik/common/database.py\", line 1945, in __raise_dbhelper_exception\r\n    raise DbHelperException(error_msg)\r\nDbHelperException: u'Error when adding data to sensor history. Sensor id = 2771  | Value = None  | Date = 1541345175. Error is Traceback (most recent call last):\\n  File \"/home/domogik/src/domogik/common/database.py\", line 952, in add_sensor_history\\n    self._do_commit()\\n  File \"/home/domogik/src/domogik/common/database.py\", line 256, in _do_commit\\n    self.__raise_dbhelper_exception(\"SQL exception (commit) : {0}\".format(sql_exception))\\n  File \"/home/domogik/src/domogik/common/database.py\", line 1945, in __raise_dbhelper_exception\\n    raise DbHelperException(error_msg)\\nDbHelperException: \\'SQL exception (commit) : (pymysql.err.IntegrityError) (1048, u\"Column \\\\\\'value_str\\\\\\' cannot be null\") [SQL: u\\\\\\'INSERT INTO core_sensor_history (sensor_id, date, value_num, value_str, original_value_num) VALUES (%(sensor_id)s, %(date)s, %(value_num)s, %(value_str)s, %(original_value_num)s)\\\\\\'] [parameters: {\\\\\\'date\\\\\\': datetime.datetime(2018, 11, 4, 16, 26, 15), \\\\\\'sensor_id\\\\\\': 2771, \\\\\\'original_value_num\\\\\\': None, \\\\\\'value_str\\\\\\': None, \\\\\\'value_num\\\\\\': None}]\\'\\n'\r\n\r\n2018-11-04 16:27:22,228 domogik-xplgw ERROR Traceback (most recent call last):\r\n  File \"/home/domogik/src/domogik/bin/xplgw.py\", line 870, in run\r\n    self._log.error(u\"Error when adding sensor history : {0}\".format(traceback.format_exc()))\r\n  File \"/usr/lib/python2.7/contextlib.py\", line 24, in __exit__\r\n    self.gen.next()\r\n  File \"/home/domogik/src/domogik/common/database.py\", line 180, in session_scope\r\n    self.__session.commit()\r\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py\", line 813, in commit\r\n    self.transaction.commit()\r\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py\", line 390, in commit\r\n    self._assert_active(prepared_ok=True)\r\n  File \"/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py\", line 214, in _assert_active\r\n    % self._rollback_exception\r\nInvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (pymysql.err.IntegrityError) (1048, u\"Column 'value_str' cannot be null\") [SQL: u'INSERT INTO core_sensor_history (sensor_id, date, value_num, value_str, original_value_num) VALUES (%(sensor_id)s, %(date)s, %(value_num)s, %(value_str)s, %(original_value_num)s)'] [parameters: {'date': datetime.datetime(2018, 11, 4, 16, 26, 15), 'sensor_id': 2771, 'original_value_num': None, 'value_str': None, 'value_num': None}]\r\n\r\n\r\n```\r\nSee when trying to debug the perpetual crash i had since yesterday\r\n"},"comment":{"url":"https://api.github.com/repos/domogik/domogik/issues/comments/435689934","html_url":"https://github.com/domogik/domogik/issues/552#issuecomment-435689934","issue_url":"https://api.github.com/repos/domogik/domogik/issues/552","id":435689934,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNTY4OTkzNA==","user":{"login":"tikismoke","id":2229691,"node_id":"MDQ6VXNlcjIyMjk2OTE=","avatar_url":"https://avatars0.githubusercontent.com/u/2229691?v=4","gravatar_id":"","url":"https://api.github.com/users/tikismoke","html_url":"https://github.com/tikismoke","followers_url":"https://api.github.com/users/tikismoke/followers","following_url":"https://api.github.com/users/tikismoke/following{/other_user}","gists_url":"https://api.github.com/users/tikismoke/gists{/gist_id}","starred_url":"https://api.github.com/users/tikismoke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tikismoke/subscriptions","organizations_url":"https://api.github.com/users/tikismoke/orgs","repos_url":"https://api.github.com/users/tikismoke/repos","events_url":"https://api.github.com/users/tikismoke/events{/privacy}","received_events_url":"https://api.github.com/users/tikismoke/received_events","type":"User","site_admin":false},"created_at":"2018-11-04T17:41:11Z","updated_at":"2018-11-04T17:41:11Z","author_association":"MEMBER","body":"My problems comes from the hardware.\n\nI have a raid degraded and it slow down MySQL.\n\nBut do not know wy these error."}}
{"actor":{"display_login":"tikismoke"}}