core: SQLite version 3.31.1 is not supported, although this is the official version of Ubuntu 20.04.3 LTS
The problem
I have Ubuntu 20.04.3 LTS, and in HA logs I saw “2021-11-03 22:34:07 WARNING (Recorder) [homeassistant.components.recorder.util] Version 3.31.1 of SQLite is not supported; minimum supported version is 3.32.1. Starting with Home Assistant 2022.2 this will prevent the recorder from starting. Please upgrade your database software before then”
I try to update to update SQLite, sudo apt-get install libsqlite3-dev and it is newest version “libsqlite3-dev is already the newest version (3.31.1-4ubuntu0.2)”
It would be great if HA could work with at least those versions that can be updated in LTS operating systems, since building new versions from sources is not quite the right approach
What version of Home Assistant Core has the issue?
core-2021.11.0
What was the last working version of Home Assistant Core?
2021.10.0
What type of installation are you running?
Home Assistant Core
Integration causing the issue
recorder
Link to integration documentation on our website
https://www.home-assistant.io/integrations/recorder
Example YAML snippet
No response
Anything in the logs that might be useful for us?
2021-11-03 22:34:07 WARNING (Recorder) [homeassistant.components.recorder.util] Version 3.31.1 of SQLite is not supported; minimum supported version is 3.32.1. Starting with Home Assistant 2022.2 this will prevent the recorder from starting. Please upgrade your database software before then
Additional information
| Version | core-2021.11.0 |
|---|---|
| Installation Type | Home Assistant Container |
| Development | false |
| Supervisor | false |
| Docker | true |
| Virtual Environment | true |
| Python Version | 3.9.0 |
| Operating System Family | Linux |
| Operating System Version | 5.4.83-v7+ |
| CPU Architecture | armv7l |
| Timezone | Europe/Moscow |
About this issue
- Original URL
- State: closed
- Created 3 years ago
- Comments: 18 (9 by maintainers)
We don’t rely on any features added in SQLite 3.32, we could lower the minimum version requirement to 3.31.
Maria DB (minimum Home Assistant version ≥ 10.3) is from 2017. https://en.wikipedia.org/wiki/MariaDB#Versioning
MySQL 8.0 is 2018 https://en.wikipedia.org/wiki/MySQL#Release_history
There have of course been newer point releases of both, but the minimum stated version from the release notes are the round numbered versions.
Home Assistant OS might be a better fit for your use case: https://github.com/home-assistant/architecture/blob/master/adr/0015-home-assistant-os.md#required-expertise
… or even container: https://github.com/home-assistant/architecture/blob/master/adr/0013-home-assistant-container.md
As it doesn’t require you to be responsible for Python dependencies that core and supervisor require: https://github.com/home-assistant/architecture/blob/master/adr/0016-home-assistant-core.md#required-expertise https://github.com/home-assistant/architecture/blob/master/adr/0014-home-assistant-supervised.md
I’m rursache’s boat as well. Any chance the version restriction can be relaxed even further?
@emontnemery the latest sqlite version available on raspbian is 3.27.2. there is no way i could update to anything newer and i couldn’t find instructions on how to build sqlite from source on rpi