{"action":"closed","issue":{"url":"https://api.github.com/repos/home-assistant/home-assistant/issues/13957","repository_url":"https://api.github.com/repos/home-assistant/home-assistant","labels_url":"https://api.github.com/repos/home-assistant/home-assistant/issues/13957/labels{/name}","comments_url":"https://api.github.com/repos/home-assistant/home-assistant/issues/13957/comments","events_url":"https://api.github.com/repos/home-assistant/home-assistant/issues/13957/events","html_url":"https://github.com/home-assistant/home-assistant/issues/13957","id":315123194,"number":13957,"title":"Log errors are recorded in the database","user":{"login":"VDRainer","id":26381449,"avatar_url":"https://avatars1.githubusercontent.com/u/26381449?v=4","gravatar_id":"","url":"https://api.github.com/users/VDRainer","html_url":"https://github.com/VDRainer","followers_url":"https://api.github.com/users/VDRainer/followers","following_url":"https://api.github.com/users/VDRainer/following{/other_user}","gists_url":"https://api.github.com/users/VDRainer/gists{/gist_id}","starred_url":"https://api.github.com/users/VDRainer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/VDRainer/subscriptions","organizations_url":"https://api.github.com/users/VDRainer/orgs","repos_url":"https://api.github.com/users/VDRainer/repos","events_url":"https://api.github.com/users/VDRainer/events{/privacy}","received_events_url":"https://api.github.com/users/VDRainer/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-04-17T15:50:50Z","updated_at":"2018-04-28T21:09:39Z","closed_at":"2018-04-28T21:09:39Z","author_association":"NONE","body":"**Home Assistant release with the issue:**\r\n0.67.0\r\n\r\n**Last working Home Assistant release (if known):**\r\nunknown, saw this issue the first time\r\n\r\n**Operating environment (Hass.io/Docker/Windows/etc.):**\r\nUbuntu 16.04, Python 3.6.3 venv\r\n\r\n**Component/platform:**\r\nLogger, Recorder\r\n\r\n**Description of problem:**\r\nWondered why my system monitor (disk_use_percent) increased more than normal in the last 24 hours.\r\nSaw an error in the logfile that was written multiple times per second to the log.\r\n\r\nAfter restart the log was cleaned, and the error was gone, but then i saw that the database sice increased too.\r\n\r\nIf i look at the events table i see the above error was also written to the database 189667 times.\r\n\r\nevent_type: system_log_event\r\nevent_data: {\"timestamp\": 1523964163.7068207, \"level\": \"ERROR\", \"message\": \"Error doing job: Exception in callback SendfileStreamWriter._sendfile_cb(<Future cancelled>, 27, 26, 46138, 143943, <_UnixSelecto...e debug=False>, True)\", \"exception\": \"Traceback (most recent call last):\\n  File \\\"/usr/lib/python3.6/asyncio/events.py\\\", line 127, in _run\\n    self._callback(*self._args)\\n  File \\\"/srv/ha/lib/python3.6/site-packages/aiohttp/web_fileresponse.py\\\", line 37, in _sendfile_cb\\n    loop.remove_writer(out_fd)\\n  File \\\"/usr/lib/python3.6/asyncio/selector_events.py\\\", line 351, in remove_writer\\n    self._ensure_fd_no_transport(fd)\\n  File \\\"/usr/lib/python3.6/asyncio/selector_events.py\\\", line 258, in _ensure_fd_no_transport\\n    fd, transport))\\nRuntimeError: File descriptor 27 is used by transport <_SelectorSocketTransport fd=27 read=polling write=<polling, bufsize=0>>\\n\", \"source\": \"/srv/ha/lib/python3.6/site-packages/homeassistant/core.py\"}\r\n\r\nExpected that Errors are only written to the logs and not to the database.\r\n\r\nEDIT: Maybe this is related to https://github.com/home-assistant/home-assistant/issues/10663 ?\r\n\r\n\r\n\r\n"}}
{"actor":{"display_login":"balloob"}}