search

home-assistant / core

:house_with_garden: Open source home automation that puts local control and privacy first.
https://www.home-assistant.io
Apache License 2.0
71.86k stars 30.1k forks source link

Ring Integration Error Fetching Data #44568

Closed djtimca closed 3 years ago

djtimca commented 3 years ago

The problem

The Ring integration has stopped reporting motion alerts from my doorbells. It is returning an error regularly.

Environment

System Health

version 2020.12.1
installation_type Home Assistant Supervised
dev false
hassio true
docker true
virtualenv false
python_version 3.8.6
os_name Linux
os_version 5.4.0-58-generic
arch x86_64
timezone America/Toronto
Home Assistant Community Store GitHub API | ok -- | -- Github API Calls Remaining | 607 Installed Version | 1.9.0 Stage | running Available Repositories | 763 Installed Repositories | 1
AccuWeather can_reach_server | ok -- | -- remaining_requests | 36
Home Assistant Cloud logged_in | true -- | -- subscription_expiration | January 3, 2021, 7:00 PM relayer_connected | true remote_enabled | true remote_connected | true alexa_enabled | false google_enabled | true can_reach_cert_server | ok can_reach_cloud_auth | ok can_reach_cloud | ok
Hass.io host_os | Ubuntu 20.04.1 LTS -- | -- update_channel | beta supervisor_version | 2020.12.7 docker_version | 19.03.12 disk_total | 456.6 GB disk_used | 39.3 GB healthy | true supported | failed to load: Unsupported supervisor_api | ok version_api | ok installed_addons | Samba share (9.2.0), Check Home Assistant configuration (3.4.0), chrony (1.1.2), File editor (5.2.0), Node-RED (7.2.11), Home Assistant Google Drive Backup (0.102.0), SSH & Web Terminal (7.8.0), Portainer (1.3.0), Guacamole (1), Visual Studio Code (2.9.1), MariaDB (2.2.1), phpMyAdmin (0.1.4), Nginx Proxy Manager (0.8.2), AdGuard Home (2.6.1), ADB - Android Debug Bridge (0.6.3), Assistant Relay (0.7.4), Mosquitto broker (5.1), OpenZWave (0.7.1)
Lovelace dashboards | 3 -- | -- mode | storage views | 12 resources | 15
Spotify api_endpoint_reachable | ok -- | --

Problem-relevant configuration.yaml

Traceback/Error logs

Logger: homeassistant.components.ring
Source: components/ring/__init__.py:210 
Integration: Ring (documentation, issues) 
First occurred: 8:17:19 AM (27 occurrences) 
Last logged: 9:38:29 PM

Error fetching Ring active dings data: ('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))
Error fetching Ring device data: ('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))
Error fetching Ring active dings data: ('Connection aborted.', ConnectionResetError(104, 'Connection reset by peer'))
Error fetching Ring device data: ('Connection aborted.', ConnectionResetError(104, 'Connection reset by peer'))
Error fetching Ring active dings data: 504 Server Error: Gateway Time-out for url: https://api.ring.com/clients_api/dings/active?api_version=9

Additional information

rohair81 commented 3 years ago

I actually got this fixed took some time but with removing the hoob, rebuilding the HomeAssistant, and then building the HB in concurrence with the HA build with HB first before integrating my SmartThings in the HA environment it totally fixed all my issues of integration of this app in HB and into HomeKit.

I am actually having issues with the integration as well it is triggering this: Logger: homeassistant.components.ring Source: components/ring/init.py:210 Integration: Ring (documentation, issues) First occurred: 9:26:15 PM (1 occurrences) Last logged: 9:26:15 PM

Error fetching Ring active dings data: ('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))

Then it triggers this: Logger: homeassistant.components.recorder Source: components/recorder/init.py:526 Integration: Recorder (documentation, issues) First occurred: 9:25:51 PM (4 occurrences) Last logged: 9:27:22 PM

Error executing query: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id, context_parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('call_service', '{"domain": "system_log", "service": "clear", "service_data": {}}', 'LOCAL', '2020-12-28 03:25:50.121995', '2020-12-28 03:25:50.121995', '053594f69a2e59a47547944956868af3', '607a7d33db4149a498c94ac277abeffd', None)] (Background on this error at: http://sqlalche.me/e/13/e3q8) Error executing query: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id, context_parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('state_changed', '{}', 'LOCAL', '2020-12-28 03:26:11.462021', '2020-12-28 03:26:11.462021', '8753315c1e9150c41417caf1ecf3141d', None, None)] (Background on this error at: http://sqlalche.me/e/13/e3q8) Error executing query: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id, context_parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('ios.entered_background', '{"sourceDeviceID": "ohairs_ipad", "sourceDeviceName": "O\u2019Hair\u2019s iPad", "sourceDevicePermanentID": "AD0F4032-444C-482C-A617-631ECF9D75F9"}', 'REMOTE', '2020-12-28 03:26:12.028669', '2020-12-28 03:26:12.028669', '44bd0afbb94ad58c3e5b971c6bf69f39', '607a7d33db4149a498c94ac277abeffd', None)] (Background on this error at: http://sqlalche.me/e/13/e3q8) Error executing query: (sqlite3.OperationalError) no such table: events [SQL: INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id, context_parent_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('ios.became_active', '{"sourceDeviceID": "ohairs_ipad", "sourceDeviceName": "O\u2019Hair\u2019s iPad", "sourceDevicePermanentID": "AD0F4032-444C-482C-A617-631ECF9D75F9"}', 'REMOTE', '2020-12-28 03:27:21.218348', '2020-12-28 03:27:21.218348', 'b2c090ce507873c42e492ebd65d97f9f', '607a7d33db4149a498c94ac277abeffd', None)] (Background on this error at: http://sqlalche.me/e/13/e3q8)

petarvucetin commented 3 years ago

I am getting different error lots of 401s

Logger: homeassistant.components.ring Source: components/ring/init.py:210 Integration: Ring (documentation, issues) First occurred: December 29, 2020, 4:22:15 PM (89 occurrences) Last logged: 1:43:15 PM

Error fetching Ring active dings data: 401 Client Error: Unauthorized for url: https://api.ring.com/clients_api/dings/active?api_version=9
Error fetching Ring device data: 401 Client Error: Unauthorized for url: https://api.ring.com/clients_api/ring_devices?api_version=9
Error fetching Ring device data: 504 Server Error: Gateway Time-out for url: https://api.ring.com/clients_api/ring_devices?api_version=9
Error fetching Ring active dings data: ('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))
Error fetching Ring active dings data: 504 Server Error: Gateway Time-out for url: https://api.ring.com/clients_api/dings/active?api_version=9
johntdyer commented 3 years ago

samer issue

hughes9214 commented 3 years ago

I am getting different error lots of 401s

Logger: homeassistant.components.ring Source: components/ring/init.py:210 Integration: Ring (documentation, issues) First occurred: December 29, 2020, 4:22:15 PM (89 occurrences) Last logged: 1:43:15 PM

Error fetching Ring active dings data: 401 Client Error: Unauthorized for url: https://api.ring.com/clients_api/dings/active?api_version=9
Error fetching Ring device data: 401 Client Error: Unauthorized for url: https://api.ring.com/clients_api/ring_devices?api_version=9
Error fetching Ring device data: 504 Server Error: Gateway Time-out for url: https://api.ring.com/clients_api/ring_devices?api_version=9
Error fetching Ring active dings data: ('Connection aborted.', RemoteDisconnected('Remote end closed connection without response'))
Error fetching Ring active dings data: 504 Server Error: Gateway Time-out for url: https://api.ring.com/clients_api/dings/active?api_version=9

I’m having the same issue

atjshop commented 3 years ago

same issue

djtimca commented 3 years ago

I actually noticed recently that my app now provides a picture preview of the motion alert when it sends to my phone - I think this behaviour changed at around the same time. Might be related?

djtimca commented 3 years ago

I removed the integration and added it again and it appears all of the functionality is back. Must have been something session related. Thanks!