The Android app, now unable to load the Logbook.
In that case it is specific content that triggers the problem.
I can only talk for my own case and the history page is blank on any IOS device. I did not raise the original bug report so I am not alone.
Anyone having issue with MariaDB when upgrading, seems to fail at the DB migration phase with a connection issue after about 40-50 minutes, but the DB doesn’t go down, any help greatly appreciated, I have had to restore the DB and regress to 0.111.4 for now.:
2020-07-02 11:56:17 WARNING (Recorder) [homeassistant.components.recorder.migration] Database is about to upgrade. Schema version: 7
2020-07-02 11:56:17 WARNING (Recorder) [homeassistant.components.recorder.migration] Adding columns context_parent_id to table events. Note: this can take several minutes on large databases and slow computers. Please be patient!
2020-07-02 11:56:26 WARNING (MainThread) [homeassistant.setup] Setup of recorder is taking over 10 seconds.
2020-07-02 12:37:54 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (MySQLdb._exceptions.OperationalError) (2002, "Can't connect to MySQL server on '192.168.1.220' (115)")
(Background on this error at: http://sqlalche.me/e/e3q8)
2020-07-02 12:37:54 ERROR (Recorder) [sqlalchemy.pool.impl.QueuePool] Exception during reset or similar
Traceback (most recent call last):
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2345, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 364, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 500, in checkout
rec._checkin_failed(err)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 69, in __exit__
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
raise exception
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 497, in checkout
dbapi_connection = rec.get_connection()
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 610, in get_connection
self.__connect()
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 69, in __exit__
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
raise exception
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 490, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.7/site-packages/MySQLdb/__init__.py", line 84, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 179, in __init__
super(Connection, self).__init__(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (2002, "Can't connect to MySQL server on '192.168.1.220' (115)")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/recorder/util.py", line 27, in session_scope
yield session
File "/usr/src/homeassistant/homeassistant/components/recorder/migration.py", line 52, in migrate_schema
_apply_update(instance.engine, new_version, current_version)
File "/usr/src/homeassistant/homeassistant/components/recorder/migration.py", line 268, in _apply_update
_add_columns(engine, "events", ["context_parent_id CHARACTER(36)"])
File "/usr/src/homeassistant/homeassistant/components/recorder/migration.py", line 203, in _add_columns
table=table_name, column_def=column_def
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2243, in execute
connection = self._contextual_connect(close_with_result=True)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2311, in _contextual_connect
self._wrap_pool_connect(self.pool.connect, None),
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2349, in _wrap_pool_connect
e, dialect, self
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1591, in _handle_dbapi_exception_noconnection
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
raise exception
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2345, in _wrap_pool_connect
return fn()
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 364, in connect
return _ConnectionFairy._checkout(self)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 778, in _checkout
fairy = _ConnectionRecord.checkout(pool)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 500, in checkout
rec._checkin_failed(err)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 69, in __exit__
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
raise exception
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 497, in checkout
dbapi_connection = rec.get_connection()
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 610, in get_connection
self.__connect()
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 661, in __connect
pool.logger.debug("Error on connect(): %s", e)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 69, in __exit__
exc_value, with_traceback=exc_tb,
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
raise exception
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 656, in __connect
connection = pool._invoke_creator(self)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py", line 114, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 490, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/local/lib/python3.7/site-packages/MySQLdb/__init__.py", line 84, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.7/site-packages/MySQLdb/connections.py", line 179, in __init__
super(Connection, self).__init__(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (2002, "Can't connect to MySQL server on '192.168.1.220' (115)")
(Background on this error at: http://sqlalche.me/e/e3q8)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 752, in _rollback_impl
self.engine.dialect.do_rollback(self.connection)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2351, in do_rollback
dbapi_connection.rollback()
MySQLdb._exceptions.OperationalError: (2013, 'Lost connection to MySQL server during query')
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 697, in _finalize_fairy
fairy._reset(pool)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/pool/base.py", line 891, in _reset
self._reset_agent.rollback()
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1760, in rollback
self._do_rollback()
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1798, in _do_rollback
self.connection._rollback_impl()
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 754, in _rollback_impl
self._handle_dbapi_exception(e, None, None, None, None)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1518, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
raise exception
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 752, in _rollback_impl
self.engine.dialect.do_rollback(self.connection)
File "/usr/local/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/base.py", line 2351, in do_rollback
dbapi_connection.rollback()
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (2013, 'Lost connection to MySQL server during query')
(Background on this error at: http://sqlalche.me/e/e3q8)
2020-07-02 12:37:54 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (2002, "Can't connect to MySQL server on '192.168.1.220' (115)")
(Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
2020-07-02 12:37:57 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (2002, "Can't connect to MySQL server on '192.168.1.220' (115)")
(Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
2020-07-02 12:38:00 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1932, "Table 'homeassistant.events' doesn't exist in engine")
[SQL: DESCRIBE `events`]
(Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
2020-07-02 12:38:03 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1932, "Table 'homeassistant.events' doesn't exist in engine")
[SQL: DESCRIBE `events`]
(Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
2020-07-02 12:38:06 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1932, "Table 'homeassistant.events' doesn't exist in engine")
[SQL: DESCRIBE `events`]
(Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
2020-07-02 12:38:09 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1932, "Table 'homeassistant.events' doesn't exist in engine")
[SQL: DESCRIBE `events`]
(Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
2020-07-02 12:38:12 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1932, "Table 'homeassistant.events' doesn't exist in engine")
[SQL: DESCRIBE `events`]
(Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
2020-07-02 12:38:16 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1932, "Table 'homeassistant.events' doesn't exist in engine")
[SQL: DESCRIBE `events`]
(Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
2020-07-02 12:38:19 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1932, "Table 'homeassistant.events' doesn't exist in engine")
[SQL: DESCRIBE `events`]
(Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
2020-07-02 12:38:22 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1932, "Table 'homeassistant.events' doesn't exist in engine")
[SQL: DESCRIBE `events`]
(Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)
2020-07-02 12:38:22 ERROR (MainThread) [homeassistant.setup] Setup failed for recorder: Integration failed to initialize.
You sure you’re waiting long enough? In previous releases if you had a pi running HA and a large database, it would take upwards of 30 seconds to display a single day of history.
I lost my mediaplayer Denon AVR-X2100W with 0.112.
i have remove it from configuration.yaml, restart HA
then it’s found on new integration, but ever off. no state change.
log
> 020-07-02 13:02:54 ERROR (SyncWorker_13) [DenonAVR] No connection to /goform/AppCommand.xml end point on host 192.168.1. 142
> 2020-07-02 13:02:54 ERROR (SyncWorker_13) [DenonAVR] Getting renamed and deleted sources failed.
> 2020-07-02 13:02:54 ERROR (ThreadPoolExecutor-1_0) [DenonSSDP] During DenonAVR device identification, when trying to request http://192.168.1. 142:8080/description.xml the following error occurred: HTTPConnectionPool(host='192.168.1.%20142', port=8080): Max retries exceeded with url: /description.xml (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x6ad473f0>: Failed to establish a new connection: [Errno -2] Name does not resolve'))
> 2020-07-02 13:02:54 WARNING (ThreadPoolExecutor-1_1) [DenonAVR] Receiver name could not be determined. Using standard name: Denon AVR.
> 2020-07-02 13:02:54 ERROR (ThreadPoolExecutor-1_0) [DenonAVR] Unable to get device information of host 192.168.1. 142, can not use the serial number as identification
> 2020-07-02 13:02:54 ERROR (SyncWorker_13) [DenonAVR] Missing status information from XML of Main for: Power, InputFuncSelect, Mute, MasterVolume
> 2020-07-02 13:02:54 ERROR (SyncWorker_13) [DenonAVR] No connection to /goform/AppCommand.xml end point on host 192.168.1. 142
> 2020-07-02 13:02:54 ERROR (SyncWorker_13) [DenonAVR] Getting renamed and deleted sources failed.
> 2020-07-02 13:02:54 ERROR (ThreadPoolExecutor-4_0) [DenonSSDP] During DenonAVR device identification, when trying to request http://192.168.1. 142:8080/description.xml the following error occurred: HTTPConnectionPool(host='192.168.1.%20142', port=8080): Max retries exceeded with url: /description.xml (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x6aa98610>: Failed to establish a new connection: [Errno -2] Name does not resolve'))
> 2020-07-02 13:02:54 ERROR (ThreadPoolExecutor-4_0) [DenonAVR] Unable to get device information of host 192.168.1. 142, can not use the serial number as identification
> 2020-07-02 13:02:54 ERROR (SyncWorker_13) [DenonAVR] Missing status information from XML of Zone2 for: Power, InputFuncSelect, Mute, MasterVolume
> 2020-07-02 13:02:54 ERROR (SyncWorker_13) [DenonAVR] No connection to /goform/AppCommand.xml end point on host 192.168.1. 142
> 2020-07-02 13:02:54 ERROR (SyncWorker_13) [DenonAVR] Getting renamed and deleted sources failed.
> 2020-07-02 13:02:54 ERROR (ThreadPoolExecutor-7_0) [DenonSSDP] During DenonAVR device identification, when trying to request http://192.168.1. 142:8080/description.xml the following error occurred: HTTPConnectionPool(host='192.168.1.%20142', port=8080): Max retries exceeded with url: /description.xml (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x6aaa2d10>: Failed to establish a new connection: [Errno -2] Name does not resolve'))
> 2020-07-02 13:02:54 ERROR (ThreadPoolExecutor-7_0) [DenonAVR] Unable to get device information of host 192.168.1. 142, can not use the serial number as identification
> 2020-07-02 13:02:54 ERROR (SyncWorker_13) [DenonAVR] Missing status information from XML of Zone3 for: Power, InputFuncSelect, Mute, MasterVolume
@frenck look like integration add a space on IP adress 
open issue https://github.com/home-assistant/core/issues/37352 and find a fast fix
edit .storage/core.config_entries with correct IP
It is 
Just pushed out a change to the blog post to fix that. Should be visible any moment now.
1 Like
Hi Frenck,
just made the upgrade, had to delete and re-include Zigbee (Aquara) as they lost their sensors but the Aquara plug came back without any sensor (current, power, voltage)
Any idea where to look?
Phil
1 Like
Is there anyway to hide custom groups and scenes in the generated lovelace UI? Or is it time to move to customize the UI now that I have a bunch of things showing up that I previously hid (but still used in automations)?
Yes. The History comes up correctly in 4-5 seconds on a Windows client or Linux browser client. My HA runs on a NUC.
The data is there in the browser. If you poke your finger on the white area you get the same pop up windows with correct content as when you hover the mouse over the area in windows/Linux browser.
You can also see that the browser in IOS adds a scroll bar on the right and you can scroll down in the white area. The data is there.
It is just rendered white on white which makes me think CSS issue
Well, I doubt anything will be done because the issue you keep linking isn’t correct for everyone. I have iOS 12 and iOS 13 devices, including an iPad with working history. If this is the case for the devs, then how can they correct an issue they can’t see?
It’s it possible that the color theme for your ui needs to be adjusted?
1 Like
I run all default colour scheme. I have no custom anything related to styling my HA. I like the default design. And it should be the same in IOS and on Windows/Linux clients.
The Xiaomi Miio Air Purifier integration stopped working after upgrading to 0.112:
[homeassistant.components.xiaomi_miio.fan] Got exception while fetching the state: {'code': -5001, 'message': 'command error'}
Anyone else having this issue?
2 Likes
I have an important update in debugging the history on IOS but I think we have hijacked this enough. I just wanted to raise an awareness post. I will put some updates on the github item and I will be updating more later today (I am at work now)
I am also facing this issue.
Are dashboards / wall tablets a problem with this release? Have seen reports on Reddits the new disconnect if hidden/idle feature breaks them?
Can confirm that the hamburger icon is not displayed after clicking the Configuration menu item (and I refreshed the page with Ctrl+F5).
Should be displayed in the upper left hand corner, but it’s not. This is with the option “Always hide the sidebar” enabled.
EDIT
Opened a new issue in the frontend repo.
Didn’t see you had already opened an issue … and it has already been addressed.
1 Like
Maybe try to add manually ? Mine Denon AVR x4000 works
Anyone else having an issue with a wake on lan switch
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/components/websocket_api/commands.py", line 130, in handle_call_service
connection.context(msg),
File "/usr/src/homeassistant/homeassistant/core.py", line 1260, in async_call
task.result()
File "/usr/src/homeassistant/homeassistant/core.py", line 1295, in _execute_service
await handler.func(service_call)
File "/usr/src/homeassistant/homeassistant/helpers/entity_component.py", line 209, in handle_service
self._platforms.values(), func, call, required_features
File "/usr/src/homeassistant/homeassistant/helpers/service.py", line 454, in entity_service_call
future.result() # pop exception if have
File "/usr/src/homeassistant/homeassistant/helpers/entity.py", line 595, in async_request_call
await coro
File "/usr/src/homeassistant/homeassistant/helpers/service.py", line 485, in _handle_entity_call
await result
File "/usr/src/homeassistant/homeassistant/helpers/entity.py", line 621, in async_turn_on
await self.hass.async_add_executor_job(ft.partial(self.turn_on, **kwargs))
File "/usr/local/lib/python3.7/concurrent/futures/thread.py", line 57, in run
result = self.fn(*self.args, **self.kwargs)
File "/usr/src/homeassistant/homeassistant/components/wake_on_lan/switch.py", line 103, in turn_on
port=self._broadcast_port,
File "/usr/local/lib/python3.7/site-packages/wakeonlan.py", line 79, in send_magic_packet
sock.connect((ip, port))
TypeError: an integer is required (got type NoneType)
direct service call on wake_on_lan.send_magic_packet seems to work.
On the off chance you aren’t joking, PLEASE don’t do that. And even if you were joking, others may not realize it - so don’t encourage others to do that unless they have useful debug information to add that isn’t already in the thread.
The proper way to “me too” is to click the reaction icon (thumbs up) on the original post of a issue.
2 Likes