API tools faq
paste
MecEng70

Log Details

MecEng70
May 1st, 2020
41
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.56 KB | None | 0 0
raw download clone embed print report
  1. Log Details (ERROR)
  2. Logger: homeassistant.components.recorder
  3. Source: components/recorder/__init__.py:470
  4. Integration: Recorder (documentation, issues)
  5. First occurred: 9:19:43 AM (1328 occurrences)
  6. Last logged: 2:22:12 PM
  7.  
  8. Error saving events: 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: (sqlite3.DatabaseError) database disk image is malformed [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "weather.smartweather", "old_state": {"entity_id": "weather.smartweather", "state": "sunny", "attributes": {"temperature": 77, "humidit ... (11310 characters truncated) ... :00", "last_updated": "2020-05-01T21:20:43.015041+00:00", "context": {"id": "15a47b91ef2f4a58a73ee2a2aa4eaa11", "parent_id": null, "user_id": null}}}', 'LOCAL', '2020-05-01 21:20:43.015205', '2020-05-01 21:20:43.036198', '15a47b91ef2f4a58a73ee2a2aa4eaa11', None)] (Background on this error at: http://sqlalche.me/e/4xp6) (Background on this error at: http://sqlalche.me/e/7s2a)
  9. Error saving events: 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: (sqlite3.DatabaseError) database disk image is malformed [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "sensor.smartweather_temperature", "old_state": {"entity_id": "sensor.smartweather_temperature", "state": "77.2", "attributes": {"attri ... (994 characters truncated) ... :00", "last_updated": "2020-05-01T21:20:45.032522+00:00", "context": {"id": "25f844b92dae42cba4522ea8198f249b", "parent_id": null, "user_id": null}}}', 'LOCAL', '2020-05-01 21:20:45.032636', '2020-05-01 21:20:45.055950', '25f844b92dae42cba4522ea8198f249b', None)] (Background on this error at: http://sqlalche.me/e/4xp6) (Background on this error at: http://sqlalche.me/e/7s2a)
  10. Error saving events: 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: (sqlite3.DatabaseError) database disk image is malformed [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "weather.smartweather", "old_state": {"entity_id": "weather.smartweather", "state": "sunny", "attributes": {"temperature": 78, "humidit ... (11310 characters truncated) ... :00", "last_updated": "2020-05-01T21:21:45.014522+00:00", "context": {"id": "f0cecfb5212b449e91057ba18571533a", "parent_id": null, "user_id": null}}}', 'LOCAL', '2020-05-01 21:21:45.014759', '2020-05-01 21:21:45.048172', 'f0cecfb5212b449e91057ba18571533a', None)] (Background on this error at: http://sqlalche.me/e/4xp6) (Background on this error at: http://sqlalche.me/e/7s2a)
  11. Error saving events: 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: (sqlite3.DatabaseError) database disk image is malformed [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "sensor.smartweather_temperature", "old_state": {"entity_id": "sensor.smartweather_temperature", "state": "77.7", "attributes": {"attri ... (994 characters truncated) ... :00", "last_updated": "2020-05-01T21:21:47.028922+00:00", "context": {"id": "15ce263d604146d3818c282b75c9041b", "parent_id": null, "user_id": null}}}', 'LOCAL', '2020-05-01 21:21:47.029044', '2020-05-01 21:21:47.055096', '15ce263d604146d3818c282b75c9041b', None)] (Background on this error at: http://sqlalche.me/e/4xp6) (Background on this error at: http://sqlalche.me/e/7s2a)
  12. Error saving events: 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: (sqlite3.DatabaseError) database disk image is malformed [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{"entity_id": "sun.sun", "old_state": {"entity_id": "sun.sun", "state": "above_horizon", "attributes": {"next_dawn": "2020-05-02T12:43:28+00:00", "ne ... (958 characters truncated) ... :00", "last_updated": "2020-05-01T21:22:10.005510+00:00", "context": {"id": "6b2d13cb38b343d9aff288d66cfc6b83", "parent_id": null, "user_id": null}}}', 'LOCAL', '2020-05-01 21:22:10.005613', '2020-05-01 21:22:12.229429', '6b2d13cb38b343d9aff288d66cfc6b83', None)] (Background on this error at: http://sqlalche.me/e/4xp6) (Background on this error at: http://sqlalche.me/e/7s2a)
  13. Traceback (most recent call last):
  14. File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 419, in _commit_event_session_or_retry
  15. self._commit_event_session()
  16. File "/usr/src/homeassistant/homeassistant/components/recorder/__init__.py", line 470, in _commit_event_session
  17. self.event_session.commit()
  18. File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1036, in commit
  19. self.transaction.commit()
  20. File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 501, in commit
  21. self._assert_active(prepared_ok=True)
  22. File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 295, in _assert_active
  23. code="7s2a",
  24. sqlalchemy.exc.InvalidRequestError: 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: (sqlite3.DatabaseError) database disk image is malformed
  25. [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)]
  26. [parameters: ('service_registered', '{"domain": "recorder", "service": "purge"}', 'LOCAL', '2020-05-01 16:18:56.345256', '2020-05-01 16:19:23.517933', '58dc4b3d4b044530917f4d5530a306d7', None)]
  27. (Background on this error at: http://sqlalche.me/e/4xp6) (Background on this error at: http://sqlalche.me/e/7s2a)
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!