home-assistant / core

:house_with_garden: Open source home automation that puts local control and privacy first.
https://www.home-assistant.io
Apache License 2.0
69.7k stars 28.86k forks source link

HA InfluxDB integration fails with Read-only file system error following upgrade to Docker 26.0.x #115209

Closed edudele closed 2 months ago

edudele commented 2 months ago

The problem

ERROR (influxdb) [homeassistant.components.influxdb] Cannot connect to InfluxDB due to '[Errno 30] Read-only file system'. Please check that the provided connection details (host, port, etc.) are correct and that your InfluxDB server is running and accessible.

Similar issues https://github.com/home-assistant/core/issues/108810

What version of Home Assistant Core has the issue?

core-2024.4.1

What was the last working version of Home Assistant Core?

No response

What type of installation are you running?

Home Assistant Container

Integration causing the issue

InfluxDB

Link to integration documentation on our website

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

Diagnostics information

No response

Example YAML snippet

# influxdb section from configuration.yaml

influxdb:
  api_version: 2
  host: 192.168.1.2
  port: 8086
  ssl: false
  token: REDACTED
  organization: REDACTED
  bucket: home_assistant
  override_measurement: sensor
  default_measurement: state

Anything in the logs that might be useful for us?

grep -i influxdb /usr/share/hassio/homeassistant/home-assistant.log.*

/usr/share/hassio/homeassistant/home-assistant.log.1:2024-04-08 13:46:44.641 ERROR (influxdb) [homeassistant.components.influxdb] Cannot connect to InfluxDB due to '[Errno 30] Read-only file system'. Please check that the provided connection details (host, port, etc.) are correct and that your InfluxDB server is running and accessible.

Additional information

We are still experiencing this issue in Home Assistant Container, without a supervisor, this problem is not fixed.

Cannot connect to InfluxDB due to '[Errno 30] Read-only file system'. Please check that the provided connection details (host, port, etc.) are correct and that your InfluxDB server is running and accessible.

System Information

version core-2024.4.1
installation_type Home Assistant Container
dev false
hassio false
docker true
user root
virtualenv false
python_version 3.12.2
os_name Linux
os_version 6.1.0-18-amd64
arch x86_64
timezone Europe/Madrid
config_dir /config
Docker **Client: Docker Engine - Community** Version | 26.0.0 -- | -- API version | 1.45 Go version | go1.21.8 Git commit | 2ae903e Built | Wed Mar 20 15:18:01 2024 OS/Arch | linux/amd64 Context | default **Server: Docker Engine - Community Engine:** Version | 26.0.0 -- | -- API version | 1.45 (minimum version 1.24) Go version | go1.21.8 Git commit | 8b79278 Built | Wed Mar 20 15:18:01 2024 OS/Arch | linux/amd64 Experimental | false containerd: Version | 1.6.28 GitCommit | ae07eda36dd25f8a1b98dfbf587313b99c0190bb runc: Version | 1.1.12 GitCommit | v1.1.12-0-g51d5e94 docker-init: Version | 0.19.0 GitCommit | de40ad0
Home Assistant Community Store GitHub API | ok -- | -- GitHub Content | ok GitHub Web | ok GitHub API Calls Remaining | 5000 Installed Version | 1.34.0 Stage | running Available Repositories | 1467 Downloaded Repositories | 3 HACS Data | ok
Home Assistant Cloud logged_in | false -- | -- can_reach_cert_server | ok can_reach_cloud_auth | ok can_reach_cloud | ok
Dashboards dashboards | 2 -- | -- resources | 1 views | 1 mode | storage
Recorder oldest_recorder_run | 2 de abril de 2024, 17:02 -- | -- current_recorder_run | 8 de abril de 2024, 14:12 estimated_db_size | 16.06 MiB database_engine | mysql database_version | 11.3.2
home-assistant[bot] commented 2 months ago

Hey there @mdegat01, mind taking a look at this issue as it has been labeled with an integration (influxdb) you are listed as a code owner for? Thanks!

Code owner commands Code owners of `influxdb` 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 influxdb` 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)


influxdb documentation influxdb source (message by IssueLinks)

RogerSelwyn commented 2 months ago

Also did an upgrade to Supervisor 2023.04.0 and Core 2024.4.2 (in that order). Still have the same error after upgrading Docker.

sairon commented 2 months ago

This is essentially a duplicate of #108810 and not a Core regression. It's (previously working) misconfiguration on the host system, root cause are changes in Docker version 25.0.0+ as explained in https://github.com/home-assistant/supervisor/issues/4996.

Rollo32 commented 2 months ago

I have still the same Errno 30 on the OS Version with Home Assistant OS 12.2 with Core 2024.4.2.

The error occurs after the update from 2024.4.1 to 2024.4.2. My InfluxDB V2 is up and running. Did not changed other things, so i suggest the error is still in 2024.4.2

RogerSelwyn commented 2 months ago

Did you do an ha core rebuild?

Rollo32 commented 2 months ago

Issue Resolved: The issue with Errno 30 was resolved after performing an ha core rebuild. My Home Assistant instance is now updated to OS Version 12.2 with Core 2024.4.2, and the connection to InfluxDB V2 is up and running smoothly. Thank you for the suggestion, @Roger. This confirms that a core rebuild might be a necessary step for others experiencing similar issues after an update.

jeremie-borel commented 2 months ago

Hello, same problem here but my home assistant is on a raspberry. I tried to reboot but no effect. Is their anything I can do to have the same effect as "ha core rebuild" ?

Thanks.

Log line: Cannot connect to InfluxDB due to '[Errno 30] Read-only file system'

Core 2024.4.3 Supervisor 2024.04.0 Operating System 12.2

Zwo12 commented 2 months ago

@jeremie-borel: After creating a backup (just to be sure) simply go to the terminal of your HA instance on the raspberry (a SSH add-on like 'Advanced SSH & Web Terminal' is needed for that) and enter "ha core rebuild" - that solves the issue