Some entities show 'no statistics found', but do have history after updating to 2024.9.2

nv96 commented 1 week ago

The problem

Since 17 September, after I upgraded HA core from 2024.9.0 to 2024.9.2, some entities (but not all) have started displaying 'no statistics found'. However, when I click 'show more' the history of that entity opens and the data from the past 2 days is there. Because there are 'no statistics found' for all of the entities used in the energy-dashboard, this now shows nothing. All of the affected entities do show history of the past 2 days when I click 'show more'.

I've tried rolling back to 2024.9.0 (via SSH ha core update --version 2024.9.0) but no success. I also tried a partially backup from 14 September (via partially restore, restoring 'Home Assistant'), but no success either.

I think the problem is originating from the recorder integration (see logs below), since this is reporting Error while processing event StatisticsTask .... I have not made any changes to the database or recorder integration.

Can the above behavior possibly be caused by the upgrade?

What version of Home Assistant Core has the issue?

2024.9.2

What was the last working version of Home Assistant Core?

2024.9.0

What type of installation are you running?

Home Assistant OS

Integration causing the issue

Recorder

Link to integration documentation on our website

https://www.home-assistant.io/integrations/recorder/

Diagnostics information

Core error logs, log 1 :

Logger: homeassistant.components.recorder.core
Bron: components/recorder/core.py:880
integratie: Recorder (documentatie, problemen)
Eerst voorgekomen: 13:31:39 (12 gebeurtenissen)
Laatst gelogd: 14:25:10
Error while processing event StatisticsTask(start=datetime.datetime(2024, 9, 19, 12, 0, tzinfo=datetime.timezone.utc), fire_events=True)
Error while processing event StatisticsTask(start=datetime.datetime(2024, 9, 19, 12, 5, tzinfo=datetime.timezone.utc), fire_events=True)
Error while processing event StatisticsTask(start=datetime.datetime(2024, 9, 19, 12, 10, tzinfo=datetime.timezone.utc), fire_events=True)
Error while processing event StatisticsTask(start=datetime.datetime(2024, 9, 19, 12, 15, tzinfo=datetime.timezone.utc), fire_events=True)
Error while processing event StatisticsTask(start=datetime.datetime(2024, 9, 19, 12, 20, tzinfo=datetime.timezone.utc), fire_events=True)
Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 880, in _guarded_process_one_task_or_event_or_recover
    self._process_one_task_or_event_or_recover(task)
  File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 900, in _process_one_task_or_event_or_recover
    task.run(self)
  File "/usr/src/homeassistant/homeassistant/components/recorder/tasks.py", line 178, in run
    if statistics.compile_missing_statistics(instance):
       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/util.py", line 664, in wrapper
    return job(instance, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 476, in compile_missing_statistics
    modified_statistic_ids = _compile_statistics(
                             ^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 558, in _compile_statistics
    compiled: PlatformCompiledStatistics = platform_compile_statistics(
                                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/sensor/recorder.py", line 469, in compile_statistics
    last_stats = statistics.get_latest_short_term_statistics_with_session(
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 1998, in get_latest_short_term_statistics_with_session
    return _sorted_statistics_to_dict(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 2197, in _sorted_statistics_to_dict
    _stats = _build_stats(*build_args, row_mapping)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 2097, in _build_stats
    "end": start_ts + table_duration_seconds,
           ~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~
TypeError: unsupported operand type(s) for +: 'NoneType' and 'float'

and log 2:

Logger: homeassistant.helpers.recorder
Bron: helpers/recorder.py:101
Eerst voorgekomen: 13:31:39 (12 gebeurtenissen)
Laatst gelogd: 14:25:10
Error executing query
Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/helpers/recorder.py", line 101, in session_scope
    yield session
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 476, in compile_missing_statistics
    modified_statistic_ids = _compile_statistics(
                             ^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 558, in _compile_statistics
    compiled: PlatformCompiledStatistics = platform_compile_statistics(
                                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/sensor/recorder.py", line 469, in compile_statistics
    last_stats = statistics.get_latest_short_term_statistics_with_session(
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 1998, in get_latest_short_term_statistics_with_session
    return _sorted_statistics_to_dict(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 2197, in _sorted_statistics_to_dict
    _stats = _build_stats(*build_args, row_mapping)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 2097, in _build_stats
    "end": start_ts + table_duration_seconds,
           ~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~
TypeError: unsupported operand type(s) for +: 'NoneType' and 'float'

Example YAML snippet

No response

Anything in the logs that might be useful for us?

No response

Additional information

System info:

System Information

version	core-2024.9.2
installation_type	Home Assistant OS
dev	false
hassio	true
docker	true
user	root
virtualenv	false
python_version	3.12.4
os_name	Linux
os_version	6.6.46-haos
arch	aarch64
timezone	Europe/Amsterdam
config_dir	/config

Home Assistant Community Store

Home Assistant Cloud

Home Assistant Supervisor

Dashboards

Recorder

Spotify

api_endpoint_reachable | ok -- | --

home-assistant[bot] commented 1 week ago

Hey there @home-assistant/core, mind taking a look at this issue as it has been labeled with an integration (recorder) you are listed as a code owner for? Thanks!

Code owner commands

Code owners of `recorder` can trigger bot actions by commenting: - `@home-assistant close` Closes the issue. - `@home-assistant rename Awesome new title` Renames the issue. - `@home-assistant reopen` Reopen the issue. - `@home-assistant unassign recorder` Removes the current integration label and assignees on the issue, add the integration domain after the command. - `@home-assistant add-label needs-more-information` Add a label (needs-more-information, problem in dependency, problem in custom component) to the issue. - `@home-assistant remove-label needs-more-information` Remove a label (needs-more-information, problem in dependency, problem in custom component) on the issue.

_{^{(message by CodeOwnersMention)}}

recorder documentation recorder source _{^{(message by IssueLinks)}}

singhvaibhav98 commented 1 week ago

Facing similar issue with 2024.9.2 since yesterday, Suddenly can't see history/statistics of my enteties.

nv96 commented 1 week ago

So I've been trying to find where the issue is coming from, but had no luck resolving it so far. Summary of what I've tried the past days:

Tried making a new backup and restoring that, but during uploading of the backup to my 2nd system (same hardware, odroid n2+/HA blue with 500 GB SSD) the system keeps crashing and reboots. In the logs I saw a message that said something like unexpected end of data. This leads me to think backups from after the occurrence are corrupt/useless. Tried both down- and up-loading through Firefox and Chrome.
Successfully restored (downloaded and uploaded through Chrome) full backup of the 14th when I did not have the issue and HA was still on 2024.9.0 This works and does not log the Error executing query and Error while processing event StatisticsTask(start=datetime.datetime(2024, 9, 21, 8, 10, tzinfo=datetime.timezone.utc), fire_events=True) at startup. However, after a few hours the same error came back and entity statistics crashed the same way. History still works fine. This leads me to think that this problem does not per se originate from updating to 2024.9.2, but is caused by something else.
Restored full backup of the 10th, this also didn't show the errors at first but started doing it after some time too.
Removed some helpers, since the logs mentions "homeassistant.helpers.recorder" / "helpers/recorder.py:101". (But I don't see any recorder helpers through the UI.)
Removed a few custom_components and some node-red stuff that calculates with float and cleaned up other warnings from the core-log.

Now all I have in the core logs are:

some warning about setup and connectivity of mqtt entities and esphome-sensors, I don't think these matter/are related. These all state they will stop working in a 2025.X release.
some warnings about custom integrations that use an entity service with a non entity service schema.

See the full log from boot:

2024-09-21 10:57:18.096 WARNING (SyncWorker_0) [homeassistant.loader] We found a custom integration brandstofprijzen which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant
2024-09-21 10:57:18.098 WARNING (SyncWorker_0) [homeassistant.loader] We found a custom integration zonneplan_one which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant
2024-09-21 10:57:18.100 WARNING (SyncWorker_0) [homeassistant.loader] We found a custom integration nordpool which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant
2024-09-21 10:57:18.102 WARNING (SyncWorker_0) [homeassistant.loader] We found a custom integration spotcast which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant
2024-09-21 10:57:18.104 WARNING (SyncWorker_0) [homeassistant.loader] We found a custom integration hacs which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant
2024-09-21 10:57:18.106 WARNING (SyncWorker_0) [homeassistant.loader] We found a custom integration afvalinfo which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant
2024-09-21 10:57:18.107 WARNING (SyncWorker_0) [homeassistant.loader] We found a custom integration alarmo which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant
2024-09-21 10:57:18.109 WARNING (SyncWorker_0) [homeassistant.loader] We found a custom integration nodered which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant
2024-09-21 10:57:18.112 WARNING (SyncWorker_0) [homeassistant.loader] We found a custom integration attributes which has not been tested by Home Assistant. This component might cause stability problems, be sure to disable it if you experience issues with Home Assistant
2024-09-21 10:57:20.390 WARNING (MainThread) [homeassistant.helpers.frame] Detected that custom integration 'attributes' creates a template object without passing hass, which will stop working in HA Core 2025.10 at custom_components/attributes/sensor.py, line 92: state_template = template_helper.Template(state_template), please create a bug report at https://github.com/pilotak/homeassistant-attributes/issues
2024-09-21 10:57:21.138 WARNING (MainThread) [homeassistant.util.loop] Detected blocking call to open with args ('/usr/local/lib/python3.12/site-packages/pytz/zoneinfo/Africa/Abidjan', 'rb') inside the event loop by custom integration 'nordpool' at custom_components/nordpool/__init__.py, line 158: tz=timezone("Europe/Stockholm"), (offender: /usr/local/lib/python3.12/site-packages/pytz/__init__.py, line 108: return open(filename, 'rb')), please create a bug report at https://github.com/custom-components/nordpool/issues
For developers, please see https://developers.home-assistant.io/docs/asyncio_blocking_operations/#open
Traceback (most recent call last):
  File "<frozen runpy>", line 198, in _run_module_as_main
  File "<frozen runpy>", line 88, in _run_code
  File "/usr/src/homeassistant/homeassistant/__main__.py", line 223, in <module>
    sys.exit(main())
  File "/usr/src/homeassistant/homeassistant/__main__.py", line 209, in main
    exit_code = runner.run(runtime_conf)
  File "/usr/src/homeassistant/homeassistant/runner.py", line 189, in run
    return loop.run_until_complete(setup_and_run_hass(runtime_config))
  File "/usr/local/lib/python3.12/asyncio/base_events.py", line 674, in run_until_complete
    self.run_forever()
  File "/usr/local/lib/python3.12/asyncio/base_events.py", line 641, in run_forever
    self._run_once()
  File "/usr/local/lib/python3.12/asyncio/base_events.py", line 1990, in _run_once
    handle._run()
  File "/usr/local/lib/python3.12/asyncio/events.py", line 88, in _run
    self._context.run(self._callback, *self._args)
  File "/usr/src/homeassistant/homeassistant/helpers/entity_component.py", line 288, in async_setup_platform
    platform = await async_prepare_setup_platform(
  File "/usr/src/homeassistant/homeassistant/setup.py", line 552, in async_prepare_setup_platform
    ) and not await async_setup_component(hass, integration.domain, hass_config):
  File "/usr/src/homeassistant/homeassistant/setup.py", line 165, in async_setup_component
    result = await _async_setup_component(hass, domain, config)
  File "/usr/src/homeassistant/homeassistant/setup.py", line 416, in _async_setup_component
    result = await task
  File "/config/custom_components/nordpool/__init__.py", line 176, in async_setup
    return await _dry_setup(hass, config)
  File "/config/custom_components/nordpool/__init__.py", line 158, in _dry_setup
    tz=timezone("Europe/Stockholm"),

2024-09-21 10:57:25.286 WARNING (MainThread) [homeassistant.util.loop] Detected blocking call to open with args ('/usr/share/zoneinfo/Europe/Stockholm', 'rb') inside the event loop by custom integration 'nordpool' at custom_components/nordpool/aio_price.py, line 110: zone = tz.gettz(zone) (offender: /usr/local/lib/python3.12/site-packages/dateutil/tz/tz.py, line 464: fileobj = open(fileobj, 'rb')), please create a bug report at https://github.com/custom-components/nordpool/issues
For developers, please see https://developers.home-assistant.io/docs/asyncio_blocking_operations/#open
Traceback (most recent call last):
  File "<frozen runpy>", line 198, in _run_module_as_main
  File "<frozen runpy>", line 88, in _run_code
  File "/usr/src/homeassistant/homeassistant/__main__.py", line 223, in <module>
    sys.exit(main())
  File "/usr/src/homeassistant/homeassistant/__main__.py", line 209, in main
    exit_code = runner.run(runtime_conf)
  File "/usr/src/homeassistant/homeassistant/runner.py", line 189, in run
    return loop.run_until_complete(setup_and_run_hass(runtime_config))
  File "/usr/local/lib/python3.12/asyncio/base_events.py", line 674, in run_until_complete
    self.run_forever()
  File "/usr/local/lib/python3.12/asyncio/base_events.py", line 641, in run_forever
    self._run_once()
  File "/usr/local/lib/python3.12/asyncio/base_events.py", line 1990, in _run_once
    handle._run()
  File "/usr/local/lib/python3.12/asyncio/events.py", line 88, in _run
    self._context.run(self._callback, *self._args)
  File "/usr/src/homeassistant/homeassistant/helpers/entity_platform.py", line 644, in async_add_entities
    await add_func(coros, entities, timeout)
  File "/usr/src/homeassistant/homeassistant/helpers/entity_platform.py", line 595, in _async_add_entities
    await coro
  File "/usr/src/homeassistant/homeassistant/helpers/entity_platform.py", line 909, in _async_add_entity
    await entity.add_to_platform_finish()
  File "/usr/src/homeassistant/homeassistant/helpers/entity.py", line 1365, in add_to_platform_finish
    await self.async_added_to_hass()
  File "/config/custom_components/nordpool/sensor.py", line 518, in async_added_to_hass
    await self.handle_new_hr()
  File "/config/custom_components/nordpool/sensor.py", line 480, in handle_new_hr
    today = await self._api.today(self._area, self._currency)
  File "/config/custom_components/nordpool/__init__.py", line 110, in today
    return await self._someday(area, currency, "today")
  File "/config/custom_components/nordpool/__init__.py", line 99, in _someday
    await self.update_today(None)
  File "/config/custom_components/nordpool/__init__.py", line 80, in update_today
    await self._update("today")
  File "/config/custom_components/nordpool/__init__.py", line 73, in _update
    data = await spot.hourly(end_date=dt)
  File "/config/custom_components/nordpool/aio_price.py", line 228, in hourly
    return await self.fetch(self.HOURLY, end_date, areas)
  File "/usr/local/lib/python3.12/site-packages/backoff/_async.py", line 151, in retry
    ret = await target(*args, **kwargs)
  File "/config/custom_components/nordpool/aio_price.py", line 222, in fetch
    return join_result_for_correct_time(raw, end_date)
  File "/config/custom_components/nordpool/aio_price.py", line 110, in join_result_for_correct_time
    zone = tz.gettz(zone)

2024-09-21 10:57:25.562 WARNING (MainThread) [hass_nabucasa.cloud_api] Fetched https://alexa-api.nabucasa.com/access_token (400) 
2024-09-21 10:57:31.266 WARNING (MainThread) [aioesphomeapi.reconnect_logic] Can't connect to ESPHome API for 192.168.20.41: Error connecting to [AddrInfo(family=<AddressFamily.AF_INET: 2>, type=<SocketKind.SOCK_STREAM: 1>, proto=6, sockaddr=IPv4Sockaddr(address='192.168.20.41', port=6053))]: [Errno 111] Connect call failed ('192.168.20.41', 6053) (SocketAPIError)
2024-09-21 10:57:31.499 WARNING (MainThread) [aioesphomeapi.reconnect_logic] Can't connect to ESPHome API for 192.168.20.40: Error connecting to [AddrInfo(family=<AddressFamily.AF_INET: 2>, type=<SocketKind.SOCK_STREAM: 1>, proto=6, sockaddr=IPv4Sockaddr(address='192.168.20.40', port=6053))]: [Errno 111] Connect call failed ('192.168.20.40', 6053) (SocketAPIError)
2024-09-21 10:57:31.721 WARNING (MainThread) [homeassistant.helpers.frame] Detected that custom integration 'alarmo' registers an entity service with a non entity service schema which will stop working in HA Core 2025.9 at custom_components/alarmo/alarm_control_panel.py, line 97: platform.async_register_entity_service(, please create a bug report at https://github.com/nielsfaber/alarmo/issues
2024-09-21 10:57:31.730 WARNING (MainThread) [homeassistant.helpers.frame] Detected that custom integration 'alarmo' registers an entity service with a non entity service schema which will stop working in HA Core 2025.9 at custom_components/alarmo/alarm_control_panel.py, line 102: platform.async_register_entity_service(, please create a bug report at https://github.com/nielsfaber/alarmo/issues
2024-09-21 10:57:33.230 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x48B0/rgbw/4', 'state_topic': 'milight/states/0x48B0/rgbw/4', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 18608, 'rgbw', 4]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'unique_id': '444F28-Ke', 'name': 'Ke', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.235 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x20B2/cct/3', 'state_topic': 'milight/states/0x20B2/cct/3', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 8370, 'cct', 3]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-Pu', 'name': 'Pu', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.245 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x20B2/cct/4', 'state_topic': 'milight/states/0x20B2/cct/4', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 8370, 'cct', 4]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-TK', 'name': 'TK', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.270 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x10/cct/1', 'state_topic': 'milight/states/0x10/cct/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 16, 'cct', 1]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-Has', 'name': 'Has', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.280 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x10/cct/2', 'state_topic': 'milight/states/0x10/cct/2', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 16, 'cct', 2]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-Tr', 'name': 'Tr', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.287 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x11/rgb_cct/1', 'state_topic': 'milight/states/0x11/rgb_cct/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 17, 'rgb_cct', 1]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-Hv', 'name': 'Hv', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.292 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x11/cct/1', 'state_topic': 'milight/states/0x11/cct/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 17, 'cct', 1]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-Sb', 'name': 'Sb', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.297 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x5AA8/rgb_cct/1', 'state_topic': 'milight/states/0x5AA8/rgb_cct/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 23208, 'rgb_cct', 1]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-WC', 'name': 'WC', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.302 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x1912/fut089/1', 'state_topic': 'milight/states/0x1912/fut089/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 6418, 'fut089', 1]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-tl1', 'name': 'tl1', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.306 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x1912/fut089/2', 'state_topic': 'milight/states/0x1912/fut089/2', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 6418, 'fut089', 2]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-tl2', 'name': 'tl2', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.314 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x1912/fut089/3', 'state_topic': 'milight/states/0x1912/fut089/3', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 6418, 'fut089', 3]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-tl3', 'name': 'tl3', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.318 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x1912/fut089/4', 'state_topic': 'milight/states/0x1912/fut089/4', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 6418, 'fut089', 4]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-tl4', 'name': 'tl4', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.327 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x12/cct/1', 'state_topic': 'milight/states/0x12/cct/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 18, 'cct', 1]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-opr', 'name': 'opr', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.333 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x1912/fut089/5', 'state_topic': 'milight/states/0x1912/fut089/5', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 6418, 'fut089', 5]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-ts1', 'name': 'ts1', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.338 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x1912/fut089/6', 'state_topic': 'milight/states/0x1912/fut089/6', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 6418, 'fut089', 6]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-ts2', 'name': 'ts2', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.343 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x1912/fut089/7', 'state_topic': 'milight/states/0x1912/fut089/7', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 6418, 'fut089', 7]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-ts3', 'name': 'ts3', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.350 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x12/rgbw/1', 'state_topic': 'milight/states/0x12/rgbw/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 18, 'rgbw', 1]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'unique_id': '444F28-ta', 'name': 'ta', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.355 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x5AA8/rgb_cct/2', 'state_topic': 'milight/states/0x5AA8/rgb_cct/2', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 23208, 'rgb_cct', 2]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-Ba', 'name': 'Ba', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.359 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x48B0/rgbw/3', 'state_topic': 'milight/states/0x48B0/rgbw/3', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 18608, 'rgbw', 3]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'unique_id': '444F28-Bal', 'name': 'Bal', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.365 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x11/cct/2', 'state_topic': 'milight/states/0x11/cct/2', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 17, 'cct', 2]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-Be', 'name': 'Be', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.371 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x5AA8/rgb_cct/4', 'state_topic': 'milight/states/0x5AA8/rgb_cct/4', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 23208, 'rgb_cct', 4]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-Co', 'name': 'Co', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.375 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x9/cct/1', 'state_topic': 'milight/states/0x9/cct/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 9, 'cct', 1]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-G1', 'name': 'G1', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.400 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x9/cct/2', 'state_topic': 'milight/states/0x9/cct/2', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 9, 'cct', 2]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-G2', 'name': 'G2', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.404 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x9/cct/3', 'state_topic': 'milight/states/0x9/cct/3', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 9, 'cct', 3]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-G3', 'name': 'G3', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.409 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x5AA8/rgb_cct/3', 'state_topic': 'milight/states/0x5AA8/rgb_cct/3', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 23208, 'rgb_cct', 3]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-Ha', 'name': 'Ha', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.413 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x20B2/cct/2', 'state_topic': 'milight/states/0x20B2/cct/2', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 8370, 'cct', 2]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-SL', 'name': 'SL', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.418 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x20B2/cct/1', 'state_topic': 'milight/states/0x20B2/cct/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 8370, 'cct', 1]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '444F28-SR', 'name': 'SR', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.424 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x1D53/rgbw/4', 'state_topic': 'milight/states/0x1D53/rgbw/4', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 7507, 'rgbw', 4]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'unique_id': '444F28-Sla', 'name': 'Sla', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.429 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x48B0/rgbw/1', 'state_topic': 'milight/states/0x48B0/rgbw/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 18608, 'rgbw', 1]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'unique_id': '444F28-VL', 'name': 'VL', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.435 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x48B0/rgbw/2', 'state_topic': 'milight/states/0x48B0/rgbw/2', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [4476712, 18608, 'rgbw', 2]}, 'availability_topic': 'milight/client_statu', 'payload_available': 'connected', 'payload_not_available': 'disconnected', 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'unique_id': '444F28-VR', 'name': 'VR', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.440 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x7FC/rgb_cct/1', 'state_topic': 'milight/states/0x7FC/rgb_cct/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 2044, 'rgb_cct', 1]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-AC', 'name': 'AC', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.444 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x281D/cct/1', 'state_topic': 'milight/states/0x281D/cct/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 10269, 'cct', 1]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-BK', 'name': 'BK', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.449 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x281D/cct/4', 'state_topic': 'milight/states/0x281D/cct/4', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 10269, 'cct', 4]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-HH', 'name': 'HH', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.453 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x281D/cct/3', 'state_topic': 'milight/states/0x281D/cct/3', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 10269, 'cct', 3]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-HS', 'name': 'HS', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.456 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x7FC/rgb_cct/2', 'state_topic': 'milight/states/0x7FC/rgb_cct/2', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 2044, 'rgb_cct', 2]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-R1', 'name': 'R1', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.461 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x7FC/rgb_cct/3', 'state_topic': 'milight/states/0x7FC/rgb_cct/3', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 2044, 'rgb_cct', 3]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-R2', 'name': 'R2', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.464 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x281D/cct/2', 'state_topic': 'milight/states/0x281D/cct/2', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 10269, 'cct', 2]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-TH', 'name': 'TH', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.467 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x2DBA/rgbw/1', 'state_topic': 'milight/states/0x2DBA/rgbw/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 11706, 'rgbw', 1]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'unique_id': '8F254-ths1', 'name': 'ths1', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.472 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x2DBA/rgbw/2', 'state_topic': 'milight/states/0x2DBA/rgbw/2', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 11706, 'rgbw', 2]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'unique_id': '8F254-ths2', 'name': 'ths2', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.475 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x2DBA/rgbw/3', 'state_topic': 'milight/states/0x2DBA/rgbw/3', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 11706, 'rgbw', 3]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'unique_id': '8F254-ths3', 'name': 'ths3', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.479 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x2DBA/rgbw/4', 'state_topic': 'milight/states/0x2DBA/rgbw/4', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 11706, 'rgbw', 4]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'unique_id': '8F254-ths4', 'name': 'ths4', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.483 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x56FF/cct/1', 'state_topic': 'milight/states/0x56FF/cct/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 22271, 'cct', 1]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-Bu1', 'name': 'Bu1', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.487 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x56FF/cct/2', 'state_topic': 'milight/states/0x56FF/cct/2', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 22271, 'cct', 2]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-Bu2', 'name': 'Bu2', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.493 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x56FF/cct/3', 'state_topic': 'milight/states/0x56FF/cct/3', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 22271, 'cct', 3]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-Sha', 'name': 'Sha', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.500 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x56FF/cct/4', 'state_topic': 'milight/states/0x56FF/cct/4', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 22271, 'cct', 4]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-Vo', 'name': 'Vo', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.505 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x3604/cct/1', 'state_topic': 'milight/states/0x3604/cct/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 13828, 'cct', 1]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-THK', 'name': 'THK', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.513 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x3604/cct/2', 'state_topic': 'milight/states/0x3604/cct/2', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 13828, 'cct', 2]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-THS', 'name': 'THS', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.519 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x3604/cct/3', 'state_topic': 'milight/states/0x3604/cct/3', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 13828, 'cct', 3]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-THB', 'name': 'THB', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.525 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x3604/cct/4', 'state_topic': 'milight/states/0x3604/cct/4', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 13828, 'cct', 4]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-TH2', 'name': 'TH2', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.530 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x6/cct/2', 'state_topic': 'milight/states/0x6/cct/2', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 6, 'cct', 2]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-FR', 'name': 'FR', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.535 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x6/cct/1', 'state_topic': 'milight/states/0x6/cct/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 6, 'cct', 1]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-TE', 'name': 'TE', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.540 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x2597/cct/1', 'state_topic': 'milight/states/0x2597/cct/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 9623, 'cct', 1]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-C1', 'name': 'C1', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.544 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x2597/cct/2', 'state_topic': 'milight/states/0x2597/cct/2', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 9623, 'cct', 2]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-C2', 'name': 'C2', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.548 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x2597/cct/3', 'state_topic': 'milight/states/0x2597/cct/3', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 9623, 'cct', 3]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-C3', 'name': 'C3', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.553 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x2597/cct/4', 'state_topic': 'milight/states/0x2597/cct/4', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 9623, 'cct', 4]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-C4', 'name': 'C4', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.556 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x3604/cct/0', 'state_topic': 'milight/states/0x3604/cct/0', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 13828, 'cct', 0]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-Ttt', 'name': 'Ttt', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.560 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x7FC/rgb_cct/4', 'state_topic': 'milight/states/0x7FC/rgb_cct/4', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [586324, 2044, 'rgb_cct', 4]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'rgb': True, 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '8F254-Vu', 'name': 'Vu', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.564 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0xB72/cct/1', 'state_topic': 'milight/states/0xB72/cct/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [5546368, 2930, 'cct', 1]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '54A180-BBQ', 'name': 'BBQ', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.568 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0xB72/cct/2', 'state_topic': 'milight/states/0xB72/cct/2', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [5546368, 2930, 'cct', 2]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '54A180-Hok', 'name': 'Hok', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.572 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'command_topic': 'milight/0x13/cct/1', 'state_topic': 'milight/states/0x13/cct/1', 'device': {'manufacturer': 'esp8266_milight_hub', 'sw_version': '1.10.8', 'identifiers': [5546368, 19, 'cct', 1]}, 'brightness': True, 'effect': True, 'effect_list': ['night_mode'], 'color_temp': True, 'max_mireds': 370, 'min_mireds': 153, 'unique_id': '54A180-thb1', 'name': 'thb1', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.578 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'brightness': True, 'effect': True, 'rgb': True, 'device_class': 'light', 'unique_id': '8849FF-ta', 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'name': 'ta', 'device': {'identifiers': '8931839', 'manufacturer': 'espressif', 'model': 'nodemcuv2', 'name': 'milight-hub', 'sw_version': 'esp8266_milight_hub v1.11.2', 'configuration_url': 'http://192.168.20.74'}, 'availability_topic': 'milight/client_status', 'payload_available': 'connected', 'command_topic': 'milight/0x12/rgbw/1', 'payload_not_available': 'disconnected', 'state_topic': 'milight/states/0x12/rgbw/1', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.581 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'brightness': True, 'effect': True, 'color_temp': True, 'device_class': 'light', 'max_mireds': 370, 'unique_id': '8849FF-A5', 'effect_list': ['night_mode'], 'name': 'A5', 'min_mireds': 153, 'device': {'identifiers': '8931839', 'manufacturer': 'espressif', 'model': 'nodemcuv2', 'name': 'milight-hub', 'sw_version': 'esp8266_milight_hub v1.11.2', 'configuration_url': 'http://192.168.20.74'}, 'availability_topic': 'milight/client_status', 'payload_available': 'connected', 'command_topic': 'milight/0x281D/cct/0', 'payload_not_available': 'disconnected', 'state_topic': 'milight/states/0x281D/cct/0', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.616 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'brightness': True, 'effect': True, 'rgb': True, 'color_temp': True, 'device_class': 'light', 'max_mireds': 370, 'unique_id': '8849FF-A6', 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'name': 'A6', 'min_mireds': 153, 'device': {'identifiers': '8931839', 'manufacturer': 'espressif', 'model': 'nodemcuv2', 'name': 'milight-hub', 'sw_version': 'esp8266_milight_hub v1.11.2', 'configuration_url': 'http://192.168.20.74'}, 'availability_topic': 'milight/client_status', 'payload_available': 'connected', 'command_topic': 'milight/0x7FC/rgb_cct/0', 'payload_not_available': 'disconnected', 'state_topic': 'milight/states/0x7FC/rgb_cct/0', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.621 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp, rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'brightness': True, 'effect': True, 'rgb': True, 'color_temp': True, 'device_class': 'light', 'max_mireds': 370, 'unique_id': '8849FF-A7', 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'name': 'A7', 'min_mireds': 153, 'device': {'identifiers': '8931839', 'manufacturer': 'espressif', 'model': 'nodemcuv2', 'name': 'milight-hub', 'sw_version': 'esp8266_milight_hub v1.11.2', 'configuration_url': 'http://192.168.20.74'}, 'availability_topic': 'milight/client_status', 'payload_available': 'connected', 'command_topic': 'milight/0x1912/fut089/0', 'payload_not_available': 'disconnected', 'state_topic': 'milight/states/0x1912/fut089/0', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.627 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [rgb] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'brightness': True, 'effect': True, 'rgb': True, 'device_class': 'light', 'unique_id': '8849FF-A8', 'effect_list': ['night_mode', 'white_mode', '0', '1', '2', '3', '4', '5', '6', '7', '8'], 'name': 'A8', 'device': {'identifiers': '8931839', 'manufacturer': 'espressif', 'model': 'nodemcuv2', 'name': 'milight-hub', 'sw_version': 'esp8266_milight_hub v1.11.2', 'configuration_url': 'http://192.168.20.74'}, 'availability_topic': 'milight/client_status', 'payload_available': 'connected', 'command_topic': 'milight/0x2DBA/rgbw/0', 'payload_not_available': 'disconnected', 'state_topic': 'milight/states/0x2DBA/rgbw/0', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.632 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'brightness': True, 'effect': True, 'color_temp': True, 'device_class': 'light', 'max_mireds': 370, 'unique_id': '8849FF-A9', 'effect_list': ['night_mode'], 'name': 'A9', 'min_mireds': 153, 'device': {'identifiers': '8931839', 'manufacturer': 'espressif', 'model': 'nodemcuv2', 'name': 'milight-hub', 'sw_version': 'esp8266_milight_hub v1.11.2', 'configuration_url': 'http://192.168.20.74'}, 'availability_topic': 'milight/client_status', 'payload_available': 'connected', 'command_topic': 'milight/0xB72/cct/0', 'payload_not_available': 'disconnected', 'state_topic': 'milight/states/0xB72/cct/0', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:33.637 WARNING (MainThread) [homeassistant.components.mqtt.light.schema_json] Deprecated flags [color_temp] used in MQTT JSON light config for handling color mode, please use `supported_color_modes` instead. Got: {'schema': 'json', 'brightness': True, 'effect': True, 'color_temp': True, 'device_class': 'light', 'max_mireds': 370, 'unique_id': '8849FF-A10', 'effect_list': ['night_mode'], 'name': 'A10', 'min_mireds': 153, 'device': {'identifiers': '8931839', 'manufacturer': 'espressif', 'model': 'nodemcuv2', 'name': 'milight-hub', 'sw_version': 'esp8266_milight_hub v1.11.2', 'configuration_url': 'http://192.168.20.74'}, 'availability_topic': 'milight/client_status', 'payload_available': 'connected', 'command_topic': 'milight/0x3604/cct/1', 'payload_not_available': 'disconnected', 'state_topic': 'milight/states/0x3604/cct/1', 'platform': 'mqtt'}. This will stop working in Home Assistant Core 2025.3
2024-09-21 10:57:34.118 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.ms_3_overkapping_ms_3_overkapping_illuminance (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'lux' which is not a valid unit for the device class ('illuminance') it is using; expected one of ['lx']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-09-21 10:57:34.143 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.ms_5_houtstek_ms_5_houtstek_illuminance (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'lux' which is not a valid unit for the device class ('illuminance') it is using; expected one of ['lx']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-09-21 10:57:34.183 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.ms_6_hok_ms_6_hok_illuminance (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'lux' which is not a valid unit for the device class ('illuminance') it is using; expected one of ['lx']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-09-21 10:57:34.195 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.ms_2_keuken_ms_2_keuken_illuminance (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'lux' which is not a valid unit for the device class ('illuminance') it is using; expected one of ['lx']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-09-21 10:57:34.861 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.ms_8_slaapkamer_ms_8_slaapkamer_illuminance (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'lux' which is not a valid unit for the device class ('illuminance') it is using; expected one of ['lx']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-09-21 10:57:34.962 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.ms_9_tuinhuisje_ms_9_tuinhuisje_illuminance (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'lux' which is not a valid unit for the device class ('illuminance') it is using; expected one of ['lx']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-09-21 10:57:34.973 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.ms_10_tuinhuis_buiten_ms_10_tuinhuis_buiten_illuminance (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'lux' which is not a valid unit for the device class ('illuminance') it is using; expected one of ['lx']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-09-21 10:57:35.004 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.ms_1_badkamer_ms_1_badkamer_illuminance (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'lux' which is not a valid unit for the device class ('illuminance') it is using; expected one of ['lx']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-09-21 10:57:35.117 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.ms_4_tuinkamer_ms_4_tuinkamer_illuminance (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'lux' which is not a valid unit for the device class ('illuminance') it is using; expected one of ['lx']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-09-21 10:57:36.531 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.ms_7_tuinhok_ms_7_tuinhok_illuminance (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'lux' which is not a valid unit for the device class ('illuminance') it is using; expected one of ['lx']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-09-21 10:57:42.379 WARNING (MainThread) [homeassistant.helpers.frame] Detected that custom integration 'attributes' calls `async_track_state_change` instead of `async_track_state_change_event` which is deprecated and will be removed in Home Assistant 2025.5 at custom_components/attributes/sensor.py, line 221: async_track_state_change(, please create a bug report at https://github.com/pilotak/homeassistant-attributes/issues
2024-09-21 10:57:42.384 WARNING (MainThread) [homeassistant.helpers.frame] Detected that custom integration 'attributes' calls `async_add_job`, which is deprecated and will be removed in Home Assistant 2025.4; Please review https://developers.home-assistant.io/blog/2024/03/13/deprecate_add_run_job for replacement options at custom_components/attributes/sensor.py, line 224: self.hass.async_add_job(self.async_update_ha_state(True)), please create a bug report at https://github.com/pilotak/homeassistant-attributes/issues
2024-09-21 10:57:51.023 WARNING (MainThread) [homeassistant.helpers.frame] Detected that custom integration 'nodered' registers an entity service with a non entity service schema which will stop working in HA Core 2025.9 at custom_components/nodered/switch.py, line 62: platform.async_register_entity_service(, please create a bug report at https://github.com/zachowj/hass-node-red/issues
2024-09-21 10:57:52.506 ERROR (Recorder) [homeassistant.helpers.recorder] Error executing query
Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/helpers/recorder.py", line 101, in session_scope
    yield session
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 476, in compile_missing_statistics
    modified_statistic_ids = _compile_statistics(
                             ^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 558, in _compile_statistics
    compiled: PlatformCompiledStatistics = platform_compile_statistics(
                                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/sensor/recorder.py", line 469, in compile_statistics
    last_stats = statistics.get_latest_short_term_statistics_with_session(
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 1998, in get_latest_short_term_statistics_with_session
    return _sorted_statistics_to_dict(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 2197, in _sorted_statistics_to_dict
    _stats = _build_stats(*build_args, row_mapping)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 2097, in _build_stats
    "end": start_ts + table_duration_seconds,
           ~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~
TypeError: unsupported operand type(s) for +: 'NoneType' and 'float'
2024-09-21 10:57:52.512 ERROR (Recorder) [homeassistant.components.recorder.core] Error while processing event CompileMissingStatisticsTask()
Traceback (most recent call last):
  File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 880, in _guarded_process_one_task_or_event_or_recover
    self._process_one_task_or_event_or_recover(task)
  File "/usr/src/homeassistant/homeassistant/components/recorder/core.py", line 900, in _process_one_task_or_event_or_recover
    task.run(self)
  File "/usr/src/homeassistant/homeassistant/components/recorder/tasks.py", line 178, in run
    if statistics.compile_missing_statistics(instance):
       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/util.py", line 664, in wrapper
    return job(instance, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 476, in compile_missing_statistics
    modified_statistic_ids = _compile_statistics(
                             ^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 558, in _compile_statistics
    compiled: PlatformCompiledStatistics = platform_compile_statistics(
                                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/sensor/recorder.py", line 469, in compile_statistics
    last_stats = statistics.get_latest_short_term_statistics_with_session(
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 1998, in get_latest_short_term_statistics_with_session
    return _sorted_statistics_to_dict(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 2197, in _sorted_statistics_to_dict
    _stats = _build_stats(*build_args, row_mapping)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/src/homeassistant/homeassistant/components/recorder/statistics.py", line 2097, in _build_stats
    "end": start_ts + table_duration_seconds,
           ~~~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~
TypeError: unsupported operand type(s) for +: 'NoneType' and 'float'

I'm sorry for the assumption I made in the first post, this does not seem to be related to 2024.9.2 per se.

I'm not sure where to look anymore or what else to try. Does anybody have any suggestions what else to try or similar behaviour?

nv96 commented 1 week ago

Extracted the home-assistant_v2.db database and the sql integrity_check returns:

Enter ".help" for usage hints.
sqlite> PRAGMA integrity_check;
*** in database main ***
Tree 15 page 46937: btreeInitPage() returns error code 11
Tree 15 page 46710: btreeInitPage() returns error code 11
Tree 15 page 54899: btreeInitPage() returns error code 11
Tree 15 page 46712: btreeInitPage() returns error code 11
Tree 15 page 46711: btreeInitPage() returns error code 11
Tree 15 page 52712: btreeInitPage() returns error code 11
Tree 15 page 54959: btreeInitPage() returns error code 11
Tree 15 page 54885: btreeInitPage() returns error code 11
Tree 15 page 46714: btreeInitPage() returns error code 11
Tree 15 page 46719: btreeInitPage() returns error code 11
Tree 15 page 78521 cell 364: Rowid 242058657 out of order
Tree 15 page 54886: btreeInitPage() returns error code 11
Tree 15 page 52714 cell 2: Rowid 242058616 out of order
Tree 15 page 78521 cell 361: Rowid 242058528 out of order
Tree 15 page 78521 cell 360: Rowid 242058485 out of order
Tree 15 page 46726: btreeInitPage() returns error code 11
Tree 15 page 46725 cell 56: Rowid 242058500 out of order
Tree 15 page 78521 cell 343: Rowid 242057677 out of order
Tree 15 page 46857 cell 54: Rowid 242057680 out of order
Tree 15 page 46743 cell 48: Rowid 242057729 out of order
Tree 40 page 57511: btreeInitPage() returns error code 11
Tree 40 page 57517: btreeInitPage() returns error code 11
Tree 40 page 57521: btreeInitPage() returns error code 11
Tree 39 page 57507: btreeInitPage() returns error code 11
Tree 39 page 57510: btreeInitPage() returns error code 11
Tree 39 page 57513: btreeInitPage() returns error code 11
Tree 39 page 57515: btreeInitPage() returns error code 11
Tree 39 page 57518: btreeInitPage() returns error code 11
Tree 39 page 57520: btreeInitPage() returns error code 11
Tree 39 page 57522: btreeInitPage() returns error code 11
Tree 38 page 57509: btreeInitPage() returns error code 11
Tree 38 page 57512: btreeInitPage() returns error code 11
Tree 38 page 57516: btreeInitPage() returns error code 11
Tree 38 page 57519: btreeInitPage() returns error code 11
Tree 36 page 54951: btreeInitPage() returns error code 11
Tree 36 page 54956: btreeInitPage() returns error code 11
Tree 36 page 54942: btreeInitPage() returns error code 11
Page 46718: never used
Page 54960: never used
Page 57508: never used
row 23 missing from index ix_states_metadata_id_last_updated_ts
row 2601 missing from index ix_states_metadata_id_last_updated_ts
row 3028 missing from index ix_states_attributes_id
row 3045 missing from index ix_states_attributes_id
row 3061 missing from index ix_states_attributes_id
row 3071 missing from index ix_states_attributes_id
row 3082 missing from index ix_states_attributes_id
row 3091 missing from index ix_states_attributes_id
row 3112 missing from index ix_states_attributes_id
row 3121 missing from index ix_states_attributes_id
row 3136 missing from index ix_states_attributes_id
row 3147 missing from index ix_states_attributes_id
row 3158 missing from index ix_states_attributes_id
row 3168 missing from index ix_states_attributes_id
row 3174 missing from index ix_states_attributes_id
row 3184 missing from index ix_states_attributes_id
row 3193 missing from index ix_states_attributes_id
row 4018 missing from index ix_states_metadata_id_last_updated_ts
row 4039 missing from index ix_states_metadata_id_last_updated_ts
row 4061 missing from index ix_states_metadata_id_last_updated_ts
row 4069 missing from index ix_states_metadata_id_last_updated_ts
row 4084 missing from index ix_states_metadata_id_last_updated_ts
row 4112 missing from index ix_states_metadata_id_last_updated_ts
row 4134 missing from index ix_states_metadata_id_last_updated_ts
row 4152 missing from index ix_states_metadata_id_last_updated_ts
row 4175 missing from index ix_states_metadata_id_last_updated_ts
row 4201 missing from index ix_states_metadata_id_last_updated_ts
row 4267 missing from index ix_states_metadata_id_last_updated_ts
row 4295 missing from index ix_states_metadata_id_last_updated_ts
row 4319 missing from index ix_states_metadata_id_last_updated_ts
row 4339 missing from index ix_states_metadata_id_last_updated_ts
row 4359 missing from index ix_states_metadata_id_last_updated_ts
row 4382 missing from index ix_states_metadata_id_last_updated_ts
row 4401 missing from index ix_states_metadata_id_last_updated_ts
row 4427 missing from index ix_states_metadata_id_last_updated_ts
row 5545 missing from index ix_states_metadata_id_last_updated_ts
row 8402 missing from index ix_states_metadata_id_last_updated_ts
row 9890 missing from index ix_states_metadata_id_last_updated_ts
row 10646 missing from index ix_states_metadata_id_last_updated_ts
row 10661 missing from index ix_states_metadata_id_last_updated_ts
row 11011 missing from index ix_states_metadata_id_last_updated_ts
row 11043 missing from index ix_states_metadata_id_last_updated_ts
row 11067 missing from index ix_states_metadata_id_last_updated_ts
row 11086 missing from index ix_states_metadata_id_last_updated_ts
row 11120 missing from index ix_states_metadata_id_last_updated_ts
row 11136 missing from index ix_states_metadata_id_last_updated_ts
row 11152 missing from index ix_states_metadata_id_last_updated_ts
row 11188 missing from index ix_states_metadata_id_last_updated_ts
row 11224 missing from index ix_states_metadata_id_last_updated_ts
row 11240 missing from index ix_states_metadata_id_last_updated_ts
row 11367 missing from index ix_states_metadata_id_last_updated_ts
row 11388 missing from index ix_states_metadata_id_last_updated_ts
row 12009 missing from index ix_states_metadata_id_last_updated_ts
row 12073 missing from index ix_states_attributes_id
row 12090 missing from index ix_states_attributes_id
row 12110 missing from index ix_states_attributes_id
row 12128 missing from index ix_states_attributes_id
row 12145 missing from index ix_states_attributes_id
row 12164 missing from index ix_states_attributes_id
row 12182 missing from index ix_states_attributes_id

So it seems to be corruption of data? No idea where to go from here or how to fix this though. I was hoping for some hints/clues as to which entities cause this, but don't see any in the logs.

home-assistant / core