[home-assistant] ModuleNotFoundError: No module named 'psycopg2'

[Boemeltrein]

Chart Name

Home Assistant

Operating System

Talos-OS 1.9

Deployment Method

Helm

Chart Version

28.18.1

Kubernetes Events

-

Chart Logs

[entrypoint] WARNING: Set User-ID (UID) (0) does not match the guaranteed-default: 568
[entrypoint] WARNING: Set Group-ID (GID) (0) does not match the guaranteed-default: 568
Welcome to a TrueForge ContainerForge container!

If you are running into any issues, please file a support request on discord.

Container Info:
  * Running as: root (UID: 0, GID: 0)
  * Additional Groups: root tty uucp dialout cdrom apps (GIDs: 0 5 10 20 24 568)
  * Number of CPUs available: 12
  * Memory limits (if cgroup available):
        Total: 64277.3 MB

Important Directories:
  * /customscripts exists: no
  * /customoverlay exists: no

Useful Links:
  * Repository: https://github.com/trueforge-org/containerforge
  * Docs: https://trueforge.org
  * Discord: https://discord.gg/tVsPTHWTtr
  * Bugs or feature requests: open a GH issue
  * Questions: discuss in Discord
[entrypoint] No files found in /docker-entrypoint.d/, skipping
[Entrypoint] Checking Device permissions for video devices...
**** video permissions are good ****
[Entrypoint] Checking Device permissions for sound devices...
**** sound permissions are good ****
[entrypoint] Info: Executing /start.sh
Using CPython 3.13.7 interpreter at: /usr/local/bin/python
Creating virtual environment at: .venv
Activate with: source .venv/bin/activate
�[33m2025-11-27 23:27:11.908 WARNING (SyncWorker_0) [homeassistant.loader] We found a custom integration stromer 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�[0m
�[33m2025-11-27 23:27:11.908 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�[0m
�[31m2025-11-27 23:27:12.420 ERROR (Recorder) [homeassistant.components.recorder.core] Error during connection setup: (retrying in 3 seconds)
Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 916, in _setup_recorder
    self._setup_connection()
    ~~~~~~~~~~~~~~~~~~~~~~^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 1429, in _setup_connection
    self.engine = create_engine(self.db_url, **kwargs, future=True)
                  ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<string>", line 2, in create_engine
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/create.py", line 602, in create_engine
    dbapi = dbapi_meth(**dbapi_args)
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 696, in import_dbapi
    import psycopg2
ModuleNotFoundError: No module named 'psycopg2'�[0m
�[31m2025-11-27 23:27:15.422 ERROR (Recorder) [homeassistant.components.recorder.core] Error during connection setup: (retrying in 3 seconds)
Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 916, in _setup_recorder
    self._setup_connection()
    ~~~~~~~~~~~~~~~~~~~~~~^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 1429, in _setup_connection
    self.engine = create_engine(self.db_url, **kwargs, future=True)
                  ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<string>", line 2, in create_engine
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/create.py", line 602, in create_engine
    dbapi = dbapi_meth(**dbapi_args)
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 696, in import_dbapi
    import psycopg2
ModuleNotFoundError: No module named 'psycopg2'�[0m
�[31m2025-11-27 23:27:18.423 ERROR (Recorder) [homeassistant.components.recorder.core] Error during connection setup: (retrying in 3 seconds)
Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 916, in _setup_recorder
    self._setup_connection()
    ~~~~~~~~~~~~~~~~~~~~~~^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 1429, in _setup_connection
    self.engine = create_engine(self.db_url, **kwargs, future=True)
                  ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<string>", line 2, in create_engine
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/create.py", line 602, in create_engine
    dbapi = dbapi_meth(**dbapi_args)
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 696, in import_dbapi
    import psycopg2
ModuleNotFoundError: No module named 'psycopg2'�[0m
�[31m2025-11-27 23:27:21.424 ERROR (Recorder) [homeassistant.components.recorder.core] Error during connection setup: (retrying in 3 seconds)
Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 916, in _setup_recorder
    self._setup_connection()
    ~~~~~~~~~~~~~~~~~~~~~~^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 1429, in _setup_connection
    self.engine = create_engine(self.db_url, **kwargs, future=True)
                  ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<string>", line 2, in create_engine
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/create.py", line 602, in create_engine
    dbapi = dbapi_meth(**dbapi_args)
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 696, in import_dbapi
    import psycopg2
ModuleNotFoundError: No module named 'psycopg2'�[0m
�[33m2025-11-27 23:27:22.419 WARNING (MainThread) [homeassistant.setup] Setup of recorder is taking over 10 seconds.�[0m
�[31m2025-11-27 23:27:24.425 ERROR (Recorder) [homeassistant.components.recorder.core] Error during connection setup: (retrying in 3 seconds)
Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 916, in _setup_recorder
    self._setup_connection()
    ~~~~~~~~~~~~~~~~~~~~~~^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 1429, in _setup_connection
    self.engine = create_engine(self.db_url, **kwargs, future=True)
                  ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<string>", line 2, in create_engine
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/create.py", line 602, in create_engine
    dbapi = dbapi_meth(**dbapi_args)
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 696, in import_dbapi
    import psycopg2
ModuleNotFoundError: No module named 'psycopg2'�[0m
�[31m2025-11-27 23:27:27.426 ERROR (Recorder) [homeassistant.components.recorder.core] Error during connection setup: (retrying in 3 seconds)
Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 916, in _setup_recorder
    self._setup_connection()
    ~~~~~~~~~~~~~~~~~~~~~~^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 1429, in _setup_connection
    self.engine = create_engine(self.db_url, **kwargs, future=True)
                  ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<string>", line 2, in create_engine
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/create.py", line 602, in create_engine
    dbapi = dbapi_meth(**dbapi_args)
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 696, in import_dbapi
    import psycopg2
ModuleNotFoundError: No module named 'psycopg2'�[0m
�[31m2025-11-27 23:27:30.427 ERROR (Recorder) [homeassistant.components.recorder.core] Error during connection setup: (retrying in 3 seconds)
Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 916, in _setup_recorder
    self._setup_connection()
    ~~~~~~~~~~~~~~~~~~~~~~^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 1429, in _setup_connection
    self.engine = create_engine(self.db_url, **kwargs, future=True)
                  ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<string>", line 2, in create_engine
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/create.py", line 602, in create_engine
    dbapi = dbapi_meth(**dbapi_args)
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 696, in import_dbapi
    import psycopg2
ModuleNotFoundError: No module named 'psycopg2'�[0m
�[31m2025-11-27 23:27:33.428 ERROR (Recorder) [homeassistant.components.recorder.core] Error during connection setup: (retrying in 3 seconds)
Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 916, in _setup_recorder
    self._setup_connection()
    ~~~~~~~~~~~~~~~~~~~~~~^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 1429, in _setup_connection
    self.engine = create_engine(self.db_url, **kwargs, future=True)
                  ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<string>", line 2, in create_engine
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/create.py", line 602, in create_engine
    dbapi = dbapi_meth(**dbapi_args)
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 696, in import_dbapi
    import psycopg2
ModuleNotFoundError: No module named 'psycopg2'�[0m
�[31m2025-11-27 23:27:36.430 ERROR (Recorder) [homeassistant.components.recorder.core] Error during connection setup: (retrying in 3 seconds)
Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 916, in _setup_recorder
    self._setup_connection()
    ~~~~~~~~~~~~~~~~~~~~~~^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 1429, in _setup_connection
    self.engine = create_engine(self.db_url, **kwargs, future=True)
                  ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<string>", line 2, in create_engine
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/create.py", line 602, in create_engine
    dbapi = dbapi_meth(**dbapi_args)
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 696, in import_dbapi
    import psycopg2
ModuleNotFoundError: No module named 'psycopg2'�[0m
�[31m2025-11-27 23:27:39.431 ERROR (Recorder) [homeassistant.components.recorder.core] Error during connection setup: (retrying in 3 seconds)
Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 916, in _setup_recorder
    self._setup_connection()
    ~~~~~~~~~~~~~~~~~~~~~~^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/components/recorder/core.py", line 1429, in _setup_connection
    self.engine = create_engine(self.db_url, **kwargs, future=True)
                  ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<string>", line 2, in create_engine
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/util/deprecations.py", line 281, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/engine/create.py", line 602, in create_engine
    dbapi = dbapi_meth(**dbapi_args)
  File "/usr/local/lib/python3.13/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py", line 696, in import_dbapi
    import psycopg2
ModuleNotFoundError: No module named 'psycopg2'�[0m
�[31m2025-11-27 23:27:39.431 ERROR (Recorder) [homeassistant.components.recorder.core] Recorder setup failed, recorder shutting down�[0m
�[31m2025-11-27 23:27:39.432 ERROR (MainThread) [homeassistant.setup] Setup failed for 'recorder': Integration failed to initialize.�[0m
�[31m2025-11-27 23:27:40.350 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of 'history'. Setup failed for dependencies: ['recorder']�[0m
�[31m2025-11-27 23:27:40.350 ERROR (MainThread) [homeassistant.setup] Setup failed for 'history': Could not setup dependencies: recorder�[0m
�[31m2025-11-27 23:27:40.350 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of 'energy'. Setup failed for dependencies: ['history', 'recorder']�[0m
�[31m2025-11-27 23:27:40.350 ERROR (MainThread) [homeassistant.setup] Setup failed for 'energy': Could not setup dependencies: history, recorder�[0m
�[31m2025-11-27 23:27:40.350 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of 'logbook'. Setup failed for dependencies: ['recorder']�[0m
�[31m2025-11-27 23:27:40.350 ERROR (MainThread) [homeassistant.setup] Setup failed for 'logbook': Could not setup dependencies: recorder�[0m
�[31m2025-11-27 23:27:40.351 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of 'usage_prediction'. Setup failed for dependencies: ['recorder']�[0m
�[31m2025-11-27 23:27:40.351 ERROR (MainThread) [homeassistant.setup] Setup failed for 'usage_prediction': Could not setup dependencies: recorder�[0m
�[31m2025-11-27 23:27:42.041 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of 'default_config'. Setup failed for dependencies: ['energy', 'history', 'logbook', 'usage_prediction']�[0m
�[31m2025-11-27 23:27:42.041 ERROR (MainThread) [homeassistant.setup] Setup failed for 'default_config': Could not setup dependencies: energy, history, logbook, usage_prediction�[0m
�[33m2025-11-27 23:27:46.336 WARNING (MainThread) [homeassistant.components.template.trigger] Error initializing 'template' trigger for 'Stromer cancel updates when locked': ValueError: Template error: as_timestamp got invalid input '<template TemplateState(<state sensor.st3_laatste_data_push=2025-11-27T22:27:44+00:00; device_class=timestamp, friendly_name=ST3 Laatste data push @ 2025-11-27T23:27:45.104079+01:00>)>' when rendering template '{{ now().timestamp() - as_timestamp(states.sensor.st3_laatste_data_push) > 600 }}' but no default was specified�[0m
�[31m2025-11-27 23:27:46.336 ERROR (MainThread) [homeassistant.helpers.event] Error while processing template: Template<template=({{ now().timestamp() - as_timestamp(states.sensor.st3_laatste_data_push) > 600 }}) renders=3>
Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/helpers/template/__init__.py", line 1916, in forgiving_as_timestamp
    return dt_util.as_timestamp(value)
           ~~~~~~~~~~~~~~~~~~~~^^^^^^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/util/dt.py", line 155, in as_timestamp
    raise ValueError("not a valid date/time.")
ValueError: not a valid date/time.

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/helpers/template/__init__.py", line 469, in async_render
    render_result = render_with_context(self.template, compiled, **kwargs)
  File "/usr/local/lib/python3.13/site-packages/homeassistant/helpers/template/context.py", line 45, in render_with_context
    return template.render(**kwargs)
           ~~~~~~~~~~~~~~~^^^^^^^^^^
  File "/usr/local/lib/python3.13/site-packages/jinja2/environment.py", line 1295, in render
    self.environment.handle_exception()
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^
  File "/usr/local/lib/python3.13/site-packages/jinja2/environment.py", line 942, in handle_exception
    raise rewrite_traceback_stack(source=source)
  File "<template>", line 1, in top-level template code
  File "/usr/local/lib/python3.13/site-packages/jinja2/sandbox.py", line 401, in call
    return __context.call(__obj, *args, **kwargs)
           ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/helpers/template/__init__.py", line 1919, in forgiving_as_timestamp
    raise_no_default("as_timestamp", value)
    ~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/helpers/template/helpers.py", line 13, in raise_no_default
    raise ValueError(
    ...<2 lines>...
    )
ValueError: Template error: as_timestamp got invalid input '<template TemplateState(<state sensor.st3_laatste_data_push=2025-11-27T22:27:44+00:00; device_class=timestamp, friendly_name=ST3 Laatste data push @ 2025-11-27T23:27:45.104079+01:00>)>' when rendering template '{{ now().timestamp() - as_timestamp(states.sensor.st3_laatste_data_push) > 600 }}' but no default was specified

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/helpers/template/__init__.py", line 587, in async_render_to_info
    render_info._result = self.async_render(  # noqa: SLF001
                          ~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^
        variables, strict=strict, log_fn=log_fn, **kwargs
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/helpers/template/__init__.py", line 471, in async_render
    raise TemplateError(err) from err
homeassistant.exceptions.TemplateError: ValueError: Template error: as_timestamp got invalid input '<template TemplateState(<state sensor.st3_laatste_data_push=2025-11-27T22:27:44+00:00; device_class=timestamp, friendly_name=ST3 Laatste data push @ 2025-11-27T23:27:45.104079+01:00>)>' when rendering template '{{ now().timestamp() - as_timestamp(states.sensor.st3_laatste_data_push) > 600 }}' but no default was specified�[0m
�[33m2025-11-27 23:27:46.347 WARNING (MainThread) [homeassistant.components.template.trigger] Error initializing 'template' trigger for 'Stromer start updates when unlocked': ValueError: Template error: as_timestamp got invalid input '<template TemplateState(<state sensor.st3_laatste_data_push=2025-11-27T22:27:44+00:00; device_class=timestamp, friendly_name=ST3 Laatste data push @ 2025-11-27T23:27:45.104079+01:00>)>' when rendering template '{{ now().timestamp() - as_timestamp(states.sensor.st3_laatste_data_push) > 600 }}' but no default was specified�[0m
�[31m2025-11-27 23:27:46.347 ERROR (MainThread) [homeassistant.helpers.event] Error while processing template: Template<template=({{ now().timestamp() - as_timestamp(states.sensor.st3_laatste_data_push) > 600 }}) renders=3>
Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/helpers/template/__init__.py", line 1916, in forgiving_as_timestamp
    return dt_util.as_timestamp(value)
           ~~~~~~~~~~~~~~~~~~~~^^^^^^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/util/dt.py", line 155, in as_timestamp
    raise ValueError("not a valid date/time.")
ValueError: not a valid date/time.

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/helpers/template/__init__.py", line 469, in async_render
    render_result = render_with_context(self.template, compiled, **kwargs)
  File "/usr/local/lib/python3.13/site-packages/homeassistant/helpers/template/context.py", line 45, in render_with_context
    return template.render(**kwargs)
           ~~~~~~~~~~~~~~~^^^^^^^^^^
  File "/usr/local/lib/python3.13/site-packages/jinja2/environment.py", line 1295, in render
    self.environment.handle_exception()
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^
  File "/usr/local/lib/python3.13/site-packages/jinja2/environment.py", line 942, in handle_exception
    raise rewrite_traceback_stack(source=source)
  File "<template>", line 1, in top-level template code
  File "/usr/local/lib/python3.13/site-packages/jinja2/sandbox.py", line 401, in call
    return __context.call(__obj, *args, **kwargs)
           ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/helpers/template/__init__.py", line 1919, in forgiving_as_timestamp
    raise_no_default("as_timestamp", value)
    ~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/helpers/template/helpers.py", line 13, in raise_no_default
    raise ValueError(
    ...<2 lines>...
    )
ValueError: Template error: as_timestamp got invalid input '<template TemplateState(<state sensor.st3_laatste_data_push=2025-11-27T22:27:44+00:00; device_class=timestamp, friendly_name=ST3 Laatste data push @ 2025-11-27T23:27:45.104079+01:00>)>' when rendering template '{{ now().timestamp() - as_timestamp(states.sensor.st3_laatste_data_push) > 600 }}' but no default was specified

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/local/lib/python3.13/site-packages/homeassistant/helpers/template/__init__.py", line 587, in async_render_to_info
    render_info._result = self.async_render(  # noqa: SLF001
                          ~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^
        variables, strict=strict, log_fn=log_fn, **kwargs
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    )
    ^
  File "/usr/local/lib/python3.13/site-packages/homeassistant/helpers/template/__init__.py", line 471, in async_render
    raise TemplateError(err) from err
homeassistant.exceptions.TemplateError: ValueError: Template error: as_timestamp got invalid input '<template TemplateState(<state sensor.st3_laatste_data_push=2025-11-27T22:27:44+00:00; device_class=timestamp, friendly_name=ST3 Laatste data push @ 2025-11-27T23:27:45.104079+01:00>)>' when rendering template '{{ now().timestamp() - as_timestamp(states.sensor.st3_laatste_data_push) > 600 }}' but no default was specified�[0m
�[33m2025-11-27 23:28:00.103 WARNING (MainThread) [homeassistant.components.template.trigger] Error evaluating 'template' trigger for 'Stromer cancel updates when locked': ValueError: Template error: as_timestamp got invalid input '<template TemplateState(<state sensor.st3_laatste_data_push=2025-11-27T22:27:44+00:00; device_class=timestamp, friendly_name=ST3 Laatste data push @ 2025-11-27T23:27:45.104079+01:00>)>' when rendering template '{{ now().timestamp() - as_timestamp(states.sensor.st3_laatste_data_push) > 600 }}' but no default was specified�[0m
�[33m2025-11-27 23:28:00.301 WARNING (MainThread) [homeassistant.components.template.trigger] Error evaluating 'template' trigger for 'Stromer start updates when unlocked': ValueError: Template error: as_timestamp got invalid input '<template TemplateState(<state sensor.st3_laatste_data_push=2025-11-27T22:27:44+00:00; device_class=timestamp, friendly_name=ST3 Laatste data push @ 2025-11-27T23:27:45.104079+01:00>)>' when rendering template '{{ now().timestamp() - as_timestamp(states.sensor.st3_laatste_data_push) > 600 }}' but no default was specified�[0m
``

Chart Configuration

  values:
    TZ: Europe/Amsterdam

    global:
      stopAll: false

    credentials:
      minio:
        type: s3
        url: "http://${S3_URL}"
        bucket: "taloscluster"
        accessKey: "${S3_ACCESKEY}"
        secretKey: "${S3_SECRETKEY}"
        encrKey: "${S3_ENCRKEY}"

    ingress:
      main:
        enabled: true
        ingressClassName: internal
        hosts:
          - host: homeassistant.${BASE_DOMAIN}
        integrations:
          certManager:
            enabled: true
            certificateIssuer: cloudflare
          homepage:
            enabled: true
            group: "Network"
            widget:
              custom:
                key: "${HP_API_HASS}"

    homeassistant:
      trusted_proxies:
        - 172.16.0.0/16
        - 172.17.0.0/16

    persistence:
      config:
        volsync:
          - name: config
            type: restic
            credentials: minio
            dest: #VolSync Destination (Restore)
              enabled: true
            src: #VolSync Source (Backup)
              enabled: true
      p1meter:
        enabled: true
        type: device
        hostPath: /dev/serial/by-id/usb-FTDI_P1_Converter_Cable_A6X1Y2R3-if00-port0

    cnpg:
      main:
        cluster:
          singleNode: true
        mode: recovery # Set to 'recovery' when recovery from S3, also change the revisions
        backups:
          enabled: true
          credentials: minio
          retentionPolicy: "14d"
          revision: "2"
        recovery:
          credentials: minio
          revision: "1"

Describe the bug

flood of logs with the missing module.
Inside homeassistant no graphs and historic data

To Reproduce

deploy home-assistant
No graphs
No Energy dashboard

Expected Behavior

working recorder/home assistant

Screenshots

No response

Additional Context

No response

I've read and agree with the following

• I've checked all open and closed issues and my issue is not there.
• I've prefixed my issue title with [Chart-Name]

[kebot]

until this is fixed, I'm switching back to the old home-assistant image:

  values:
    image: 
      repository: docker.io/homeassistant/home-assistant
      tag: "2025.11.3" # or 2025.12.1

[jtmusson]

This issue persists on the 2025.12.0 version of the container

[d90]

Confirmed on 2025.12.3

Quick fix: Drop this in values.yaml (mind your spacing)

You should see:

1. Installing psycopg2-binary for PostgreSQL support...
2. Successfully installed psycopg2-binary...
3. The main Home Assistant application starting without the "ModuleNotFoundError".

#--------------------------Temp psycopg2 fix---------------------------------------
    persistence:
      init-script:
        enabled: true
        type: configmap
        objectName: init-script
        mountPath: "/docker-entrypoint.d/99-install-psycopg2.sh"
        subPath: install-psycopg2.sh
        defaultMode: "0777"
        readOnly: true     

    configmap:
      init-script:
        enabled: true
        data: 
          install-psycopg2.sh: |-
            #!/bin/bash
            echo "Installing psycopg2-binary for PostgreSQL support..."
            pip install psycopg2-binary 
#----------------------------------------------------------------------------------