Multiple Failing Integrations/Platforms - Last 24 hours

[riccidan]

The problem

In the last 24 hours my Home Assistant has failed to be able to load the following:

• recorder
• history
• logbook
• energy
• default_config

I have attempted to reboot the router, I have also conducted a full restore of a complete backup from about 3 days ago, however the systems continue to fail.

The only 'considerable' change I have made was the implementation of the secrets.yaml, however this was completed 7 days ago and the system was running perfectly until the last day. HA Logfile18092021.txt

What is version of Home Assistant Core has the issue?

core-2021.8.8

What was the last working version of Home Assistant Core?

core-2021.8.8

What type of installation are you running?

Home Assistant OS

Integration causing the issue

Seeing multiple integrations fail such as Tuyalocal, Waze, Sensibo and the mariadb url failing to parse.

Link to integration documentation on our website

No response

Example YAML snippet

Providing my configuration.yaml below:

# Configure a default setup of Home Assistant (frontend, api, etc)
default_config:

# Text to speech
tts:
  - platform: google_translate
group: !include groups.yaml
automation: !include automations.yaml
script: !include scripts.yaml
scene: !include scenes.yaml
sensor: !include sensor.yaml
recorder:
  db_url: secret! db_url
http:
    base_url: https://danielettoha.duckdns.org:8123
    ssl_certificate: /ssl/fullchain.pem
    ssl_key: /ssl/privkey.pem
frontend:
  themes: !include_dir_merge_named themes
tradfri:
  host: 10.0.0.43
auto_backup:
  auto_purge: true
climate:
  - platform: sensibo
    api_key: secret! sensibo_api_key
device_tracker:
  - platform: netgear
    host: 10.0.0.1
    username: admin
    password: secret! netgear_password
    new_device_defaults:
      track_new_devices: true
# Create variable for vacation mode
# in configuration.yaml.
input_boolean:
  vacation_mode:
    initial: off
localtuya:
#  - host: 10.0.0.35
#    device_id: (Removed for this paste)
#    local_key: secret! localtuya_35_key
#    name: tuya_g4
#    friendly_name: Washing Machine Meter Local
#    protocol_version: 3.3
#    switches:
#      sw01:
#        name: tuya_g4
#        friendly_name: Washing Machine Meter Local
#        id: 1
#        current: 4
#        current_consumption: 5
#        voltage: 6
  - host: 10.0.0.34
    device_id: (Removed for this paste)
    local_key: secret! localtuya_34_key
    friendly_name: DoubleGPOPool
    protocol_version: "3.3"
    entities:
      - platform: switch
        friendly_name: GardenShed
        id: 1
      - platform: switch
        friendly_name: Festoon
        id: 2
spotify:
  client_id: (Removed for this paste)
  client_secret: secret! spotify_secret
downloader:
  download_dir: downloads
# logger:
#  default: info
#  logs:
#    iaqualink: debug
#    homeassistant.components.iaqualink: debug

Anything in the logs that might be useful for us?

The following are all the 'red' entries in the log file:

2021-09-18 04:17:25 ERROR (SyncWorker_5) [homeassistant.loader] The custom integration 'aqualink' does not have a valid version key (None) in the manifest file and was blocked from loading. See https://developers.home-assistant.io/blog/2021/01/29/custom-integration-changes#versions for more details
2021-09-18 04:17:26 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup to secret! db_url: Could not parse rfc1738 URL from string 'secret! db_url' (retrying in 3 seconds)
2021-09-18 04:17:56 ERROR (MainThread) [homeassistant.setup] Setup failed for recorder: Integration failed to initialize.
2021-09-18 04:18:02 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of history. Setup failed for dependencies: recorder
2021-09-18 04:18:02 ERROR (MainThread) [homeassistant.setup] Setup failed for history: Could not set up all dependencies.
2021-09-18 04:18:03 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of logbook. Setup failed for dependencies: recorder
2021-09-18 04:18:03 ERROR (MainThread) [homeassistant.setup] Setup failed for logbook: Could not set up all dependencies.
2021-09-18 04:18:03 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of energy. Setup failed for dependencies: history
2021-09-18 04:18:03 ERROR (MainThread) [homeassistant.setup] Setup failed for energy: Could not set up all dependencies.
2021-09-18 04:18:05 ERROR (Thread-3) [tuya iot] error while get mqtt config
2021-09-18 04:18:05 ERROR (Thread-3) [root] Uncaught thread exception
2021-09-18 04:18:05 ERROR (MainThread) [homeassistant.config_entries] Error unloading entry BBQ GPO for switch
2021-09-18 04:18:08 ERROR (MainThread) [homeassistant.components.sensibo.climate] Failed to get devices from Sensibo servers
2021-09-18 04:18:09 WARNING (MainThread) [homeassistant.config_entries] Config entry 'RBR750 (Gateway)' for upnp integration not ready yet: None; Retrying in background
2021-09-18 04:18:09 ERROR (SyncWorker_1) [pynetgear] Invalid response
2021-09-18 04:18:09 ERROR (SyncWorker_1) [pynetgear] Invalid response
2021-09-18 04:18:09 ERROR (SyncWorker_1) [pynetgear] Get attached devices failed
2021-09-18 04:18:09 ERROR (SyncWorker_1) [homeassistant.components.netgear.device_tracker] Failed to Login
2021-09-18 04:18:09 WARNING (MainThread) [homeassistant.components.climate] Platform sensibo not ready yet: <html><head><title>403 NotAuthorized - Sensibo</title></head><body><h>403 NotAuthorized</h><p>Invalid API key</p><body></html>; Retrying in background in 30 seconds
2021-09-18 04:18:09 ERROR (MainThread) [homeassistant.components.device_tracker] Error setting up platform legacy netgear
2021-09-18 04:18:09 ERROR (MainThread) [custom_components.localtuya.common] [035...ee6] Connect to 10.0.0.9 failed
2021-09-18 04:18:10 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of default_config. Setup failed for dependencies: energy, history, logbook
2021-09-18 04:18:10 ERROR (MainThread) [homeassistant.setup] Setup failed for default_config: Could not set up all dependencies.
2021-09-18 04:18:11 ERROR (MainThread) [homeassistant.components.lifx.light] Failed to initialize 169.254.94.85
2021-09-18 04:18:12 ERROR (MainThread) [custom_components.localtuya.common] [124...65a] Connect to 10.0.0.34 failed

Additional information

No response

[riccidan]

I have restored my old configuration.yaml (took a backup before rolling the secrets.yaml) and those integrations are now connecting, however if I could please get some feedback as to why these integrations might be failing it would be appreciated.

The system HAD been working fine until recently.

[Adminiuga]

Highlight:

(Recorder) [homeassistant.components.recorder] Error during connection setup to secret! db_url: Could not parse rfc1738 URL from string 'secret! db_url' (retrying in 3 seconds)

[Adminiuga]

check your secrets.

[riccidan]

check your secrets.

Yes I've checked them, they appear to be configured identically as the original config.yaml

[Adminiuga]

And yet it complains about db url.

[ludeeus]

Probably using % in username or password instead of the encoded value for it