HA takes a lot to boot recorder - some integrations doesn't start

Yesterday I restarted HA and it took a lot of time to boot, saying that recorder is being started. Finally it boots but several integrations which relies in the recorder doesn’t work.

It’s in a hd, not an SD card.

I attach screenshots:


And log:

share the contents of your configuration.yaml.

There you are:

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

# Text to speech
tts:
  - platform: google_translate



recorder:
  db_url: !secret mariadb_url
  purge_keep_days: 20
  commit_interval: 20
  exclude:
      domains:
        - device_tracker
        - remote
        - script
        - sun
        - zone
        - automation
        - updater
        - media_player
      entity_globs:
        - sensor.spiritu_*
        - sensor.legrand_*
        - binary_sensor.*_battery_low
        - binary_sensor.*_tamper
        - binary_sensor.*_update_available
        - binary_sensor.*op8*
        - binary_sensor.*op9pro
        - binary_sensor.disk*
        - binary_sensor.presencia_*
        - number.presencia_*
        - person.*
        - sensor.*_battery
        - sensor.*_linkquality
        - sensor.*_raw
        - sensor.*_update_state
        - sensor.*op8*
        - sensor.*op9pro
        - sensor.disk*
        - sensor.load_*
        - sensor.lxc*
        - sensor.memory_*
        - sensor.node*
        - sensor.panasonic_heat_pump_stats_*
        - sensor.presencia_*
        - sensor.qemu*
        - sensor.rt_ax86u_*
        - sensor.storage*
        - sensor.weather_*
        - sensor.fire_tablet_*

      entities:
        - sun.sun
        - sensor.panasonic_heat_pump_main_compressor_freq
        - sensor.fire_tablet_memoria_libre

      event_types:
        - call_service

influxdb:
  host: !secret influxIP
  port: 8086
  api_version: 1
  max_retries: 3
  password: !secret influxdb_password
  username: !secret influx user
  database: !secret influx db
  measurement_attr: unit_of_measurement
  default_measurement: units
  ssl: false
  verify_ssl: false
  tags:
    source: HA
  tags_attributes:
    - friendly_name
    - unit_of_measurement
  exclude:
    domains:
      - automation      
      - alarm_control_panel
      - button
      - script
      - camera
      - device_tracker
      - light
      - remote
      - scene
      - sun
      - zone
      - updater
      - media_player
    entity_globs:
      - sensor.f20t60a_*
      - sensor.spiritu_*
      - sensor.legrand_*
      - binary_sensor.*_battery_low
      - binary_sensor.*_tamper
      - binary_sensor.*_update_available
      - binary_sensor.*op8*
      - binary_sensor.*op9pro
      - binary_sensor.disk*
      - binary_sensor.presencia_*
      - number.presencia_*
      - person.*
      - sensor.*_battery
      - sensor.*_linkquality
      - sensor.*_raw
      - sensor.*_update_state
      - sensor.*op8*
      - sensor.*op9pro
      - sensor.disk*
      - sensor.load_*
      - sensor.lxc*
      - sensor.memory_*
      - sensor.node*
      - sensor.panasonic_heat_pump_stats_*
      - sensor.presencia_*
      - sensor.qemu*
      - sensor.rt_ax86u_*
      - sensor.storage*
      - sensor.weather_*
      - sensor.medidor_calidad_de_aire*
      - sensor.watchman_*
      - sensor.medidor_calidad_piscina_*
      - sensor.esphome_web_*
      - sensor.nivel_deposito_de_agua_*
      - number.nivel_deposito_de_agua_*
      
    entities:
      - sun.sun
      - sensor.timbre_garaje_last_motion
      - sensor.camara_ninos_last_motion
      - sensor.angulo_solar
      - sensor.amanecer
      - sensor.sun_state
      - sensor.day_night
      - number.tapocam_diego_motion_detection_digital_sensitivity
      - switch.patiodd_motion
      - switch.patiodi_motion
      - switch.patiotd_motion
      - switch.patioti_motion
      - binary_sensor.patioti_motion
      - binary_sensor.patiotd_motion
      - binary_sensor.patiodd_motion
      - binary_sensor.patiodi_motion
      - select.tapocam_diego_motion_detection
      - binary_sensor.teclado_motion
      - binary_sensor.teclado_garaje_motion
      - binary_sensor.camara_helena_motion_2
      - number.camara_helena_motion_duration
      - binary_sensor.timbre_garaje_motion
      - number.timbre_garaje_motion_duration
      - switch.timbre_garaje_motion_detection
      - switch.camara_ninos_motion_detection
      - switch.camara_ninos_motion_warning
      - select.camara_diego_motion_detectionp
      - binary_sensor.camara_diego_cell_motion_detection
      - number.camara_diego_motion_detection_digital_sensitivity
      - binary_sensor.tapocam_diego_cell_motion_detection
      - sensor.panasonic_heat_pump_main_compressor_freq
      - sensor.fire_tablet_memoria_libre
      - sun.sun
      - sensor.panasonic_heat_pump_main_compressor_freq
      - sensor.fire_tablet_memoria_libre
      - automation.f20t60a
      
# para poder dividir este archivo en varios
group: !include groups.yaml
automation: !include automations.yaml
automation old: !include_dir_merge_list automation/
script: !include scripts.yaml
scene: !include scenes.yaml
cover: !include covers.yaml
input_number: !include input_numbers.yaml
timer: !include timers.yaml
sensor: !include sensor.yaml
switch: !include switches.yaml
template: !include template.yaml
light: !include lights.yaml
binary_sensor: !include binary_sensor.yaml


homeassistant:
#  packages: !include_dir_merge_named packages/
  customize: !include customize.yaml
  allowlist_external_dirs:
    - /tmp



logger:
  default: warn
  logs:
    # log level for HA core
    homeassistant.core: warn

frontend:
  themes: !include_dir_merge_named themes
  extra_module_url:
    - /local/card-mod.js
    - /local/community/custom-brand-icons/custom-brand-icons.js

##bot telegram
telegram_bot:
  - platform: polling
    api_key: !secret telegram_token
    allowed_chat_ids: [!secret telegram_urgente, !secret telegram_no_urgente]



http:
  use_x_forwarded_for: true
  trusted_proxies:
#    - 172.16.0.0/12
#    - 127.0.0.1
    - 172.30.33.0/24
    - 192.168.0.4
#  ip_ban_enabled: true
#  login_attempts_threshold: 5
#  ssl_certificate: /ssl/fullchain.pem
#  ssl_key: /ssl/privkey.pem
  
python_script:

powercalc:
  

utility_meter:
  consumo_diario_aerotermia:
    source: sensor.medidor_energia_aerotermia_power
    cycle: daily
  enchufe_navidad_energy:
    source: sensor.enchufe_navidad_power_2
    cycle: hourly
  consumo_agua_horario:
    name: "Consumo Agua - Horario"
    source: sensor.esp_contador_de_agua_en_litros
    cycle: hourly
  consumo_agua_diario:
    name: "Consumo Agua - Diario"
    source: sensor.esp_contador_de_agua_en_litros
    cycle: daily
  consumo_agua_mensual:
    name: "Consumo Agua - Mensual"
    source: sensor.esp_contador_de_agua_en_litros
    cycle: monthly
  consumo_agua_anual:
    name: "Consumo Agua - Anual"
    source: sensor.esp_contador_de_agua_en_litros
    cycle: yearly

  #
  # For Energy Cards
  # For Solar Yield - Self use
  # For Solar Yield - Self-Sufficiency
  #
  power_meter_consumption_energy_daily:
    unique_id: power_meter_consumption_energy_daily
    name: "power_meter_consumption_energy_daily"
    # friendly_name: 'power_meter_consumption - Energy daily'
    source: sensor.power_meter_consumption
    cycle: daily
  power_meter_consumption_energy_weekly:
    unique_id: power_meter_consumption_energy_weekly
    name: "power_meter_consumption_energy_weekly"
    # friendly_name: 'power_meter_consumption - Energy weekly'
    source: sensor.power_meter_consumption
    cycle: weekly
  power_meter_consumption_energy_monthly:
    unique_id: power_meter_consumption_energy_monthly
    name: "power_meter_consumption_energy_monthly"
    # friendly_name: 'power_meter_consumption - Energy monthly'
    source: sensor.power_meter_consumption
    cycle: monthly
  power_meter_consumption_energy_yearly:
    unique_id: power_meter_consumption_energy_yearly
    name: "power_meter_consumption_energy_yearly"
    # friendly_name: 'power_meter_consumption - Energy yearly'
    source: sensor.power_meter_consumption
    cycle: yearly
  #
  # For Energy Cards
  # For Solar Yield - Self use
  # For Solar Yield - Self-Sufficiency
  #
  power_meter_exported_energy_daily:
    unique_id: power_meter_exported_energy_daily
    name: "power_meter_exported_energy_daily"
    # friendly_name: 'power_meter_exported - Energy daily'
    source: sensor.power_meter_exported
    cycle: daily
  power_meter_exported_energy_weekly:
    unique_id: power_meter_exported_energy_weekly
    name: "power_meter_exported_energy_weekly"
    # friendly_name: 'power_meter_exported - Energy weekly'
    source: sensor.power_meter_exported
    cycle: weekly
  power_meter_exported_energy_monthly:
    unique_id: power_meter_exported_energy_monthly
    name: "power_meter_exported_energy_monthly"
    # friendly_name: 'power_meter_exported - Energy monthly'
    source: sensor.power_meter_exported
    cycle: monthly
  power_meter_exported_energy_yearly:
    unique_id: power_meter_exported_energy_yearly
    name: "power_meter_exported_energy_yearly"
    # friendly_name: 'power_meter_exported - Energy yearly'
    source: sensor.power_meter_exported
    cycle: yearly
  #
  # For Solar Yield - Self use
  # For Solar Yield - Self-Sufficiency
  #
  inverter_yield_weekly:
    unique_id: inverter_yield_weekly
    name: "inverter_yield_weekly"
    # friendly_name: ' inverter_yield - Energy weekly'
    source: sensor.inverter_total_yield
    cycle: weekly
  inverter_yield_monthly:
    unique_id: inverter_yield_monthly
    name: "inverter_yield_monthly"
    # friendly_name: ' inverter_yield - Energy monthly'
    source: sensor.inverter_total_yield
    cycle: monthly
  inverter_yield_yearly:
    unique_id: inverter_yield_yearly
    name: "inverter_yield_yearly"
    # friendly_name: ' inverter_yield - Energy yearly'
    source: sensor.inverter_total_yield
    cycle: yearly
  #
  # For Solar Yield - Self use
  # For Solar Yield - Self-Sufficiency
  #
  house_consumption_energy_weekly:
    unique_id: house_consumption_energy_weekly
    name: "house_consumption_energy_weekly"
    # friendly_name: 'house_consumption - Energy weekly'
    source: sensor.house_consumption_energy_total
    cycle: weekly
  house_consumption_energy_monthly:
    unique_id: house_consumption_energy_monthly
    name: "house_consumption_energy_monthly"
    # friendly_name: 'house_consumption - Energy monthly'
    source: sensor.house_consumption_energy_total
    cycle: monthly
  house_consumption_energy_yearly:
    unique_id: house_consumption_energy_yearly
    name: "house_consumption_energy_yearly"
    # friendly_name: 'house_consumption - Energy yearly'
    source: sensor.house_consumption_energy_total
    cycle: yearly

  solar_yield_daily:
    unique_id: "solar_yield_daily"
    name: "solar_yield_daily"
    # friendly_name: 'solar_yield - Energy daily'
    source: sensor.solar_yield
    cycle: daily
  #
  # PV Panels Yield without Inverter Input Correction
  #
  # - Only for diagnostic and only used in the diagnostic cards
  #
  solar_yield_without_correction_daily:
    unique_id: "solar_yield_without_correction_daily"
    name: "solar_yield_without_correction_daily"
    # friendly_name: 'solar_yield without correction - Energy daily'
    source: sensor.solar_yield_without_correction
    cycle: daily
  #
  # Only for Calibration of sensor.solar_yield Correction
  #
  # - quarter-hourly
  #
  solar_yield_quarter_hourly:
    unique_id: "solar_yield_quarter_hourly"
    name: "solar_yield_quarter_hourly"
    # friendly_name: 'solar_yield - Energy quarter-hourly'
    source: sensor.solar_yield
    cycle: quarter-hourly
  inverter_yield_quarter_hourly:
    unique_id: inverter_yield_quarter_hourly
    name: "inverter_yield_quarter_hourly"
    # friendly_name: ' inverter_yield - Energy quarter-hourly'
    source: sensor.inverter_total_yield
    cycle: quarter-hourly
  #
  # - hourly
  #
  solar_yield_hourly:
    unique_id: "solar_yield_hourly"
    name: "solar_yield_hourly"
    # friendly_name: 'solar_yield - Energy hourly'
    source: sensor.solar_yield
    cycle: hourly
  inverter_yield_hourly:
    unique_id: inverter_yield_hourly
    name: "inverter_yield_hourly"
    # friendly_name: ' inverter_yield - Energy hourly'
    source: sensor.inverter_total_yield
    cycle: hourly


panel_custom:
  - name: zigbee2mqtt
    sidebar_title: Z2MQTT Garaje
    sidebar_icon: mdi:zigbee
    js_url: /api/hassio/app/entrypoint.js
    url_path: 45df7312_zigbee2mqtt/ingress
    embed_iframe: true
    require_admin: true
    config:
      ingress: core_configurator
  - name: automatizaciones
    sidebar_title: Automatizaciones
    sidebar_icon: mdi:cog-transfer
    js_url: /api/hassio/app/entrypoint.js
    url_path: config/automation/dashboard
    embed_iframe: true
    require_admin: true
    config:
      ingress: core_configurator
  - name: ourgroceries
    sidebar_title: Lista de la compra
    sidebar_icon: mdi:basket-check
    js_url: /api/hassio/app/entrypoint.js
    url_path: todo/carrefour
    embed_iframe: true
    require_admin: true
    config:
      ingress: core_configurator
  - name: dispositivos
    sidebar_title: Dispositivos
    sidebar_icon: mdi:devices
    js_url: /api/hassio/app/entrypoint.js
    url_path: 'config/integrations/dashboard'
    embed_iframe: true
    require_admin: true
    config:
      ingress: core_configurator




mqtt:
  sensor:
    - name: 'Airtag 1'
      unique_id: mqtt_airtag_one
      state_topic: 'btlescan/mypc/airtag_one'
      value_template: '{{ value_json.present }}'
    - name: 'Airtag 2'
      unique_id: mqtt_airtag_two
      state_topic: 'btlescan/mypc/airtag_two'
      value_template: '{{ value_json.present }}'
    - name: 'Airtag 3'
      unique_id: mqtt_airtag_three
      state_topic: 'btlescan/mypc/airtag_two'
      value_template: '{{ value_json.present }}'

Turns out it was something with mariadb lxc; rebooted it and everything started working fine.