Version 3.22.0 of SQLite is not supported

Configuration
1

i’ve see the following warning message in my logs …
Version 3.22.0 of SQLite is not supported; minimum supported version is 3.31.0. Starting with Home Assistant 2022.2 this will prevent the recorder from starting. Please upgrade your database software before then
i’m running Ubuntu 18.02 with Python3.9 in a venv…
i can not figure out how to get version 3.36 recognized HA…
i’ve compiled version 3.36 and place it in /usr/bin, /usr/local/bin … but on restart HA still give the same warning … any help to get HA to use this version of sqlite3 is appreciated. thanks,

1 Like
2

Did you find a solution for this? Got the same Problem after updating homeassistant to newest version.

3

Same problem for me, running on Raspberry Pi…

4

Same here. I don’t recall having to install SQLite as part of the HA Core install procedure. I think this is related to running Ubuntu 18.04. Upgrading OS to 20.04 should resolve or adding to 18.04 apt repository.

5

Did you ever find a solution? I believe the 2022.2 drops tomorrow and I still haven’t found a fix.

6

Hi All.

Found a solution as follow:
Log in to your ubuntu Server via Shell, once there do the following:
##Get the supported version of SQL Lite:

wget https://sqlite.org/2021/sqlite-autoconf-3360000.tar.gz

##Extract it:

tar -xvf sqlite-autoconf-3360000.tar.gz

##Install & Configure it:

./configure
make
sudo make install

Once its installed, it will be installed in the default location of /usr/local/lib/…
This is a problem… In order for HASS to use it, it needs to be in the platform folder under:
/usr/lib/…whateverplatformyourusing…

So for an Ubuntu Deployment of x86 / x64 platform the folder will be
/usr/lib/x86_64-linux-gnu/

Simplest way of fixing it is to just copy the files over, so:

sudo cp /usr/local/lib/*sql* /usr/lib/x86_64-linux-gnu/

And then make sure they are exectuable:

sudo chmod a+x /usr/lib/x86_64-linux-gnu/*sql*

Rememer to replace the folder above with your platform for example:
Standard PC with Ubuntu will most probably be: x86_64-linux-gnu
a Raspberry Pi might be: arm-linux-gnueabihf etc.

After this restart the HomeAssistant Service

sudo systemctl restart [email protected]

Hope this helps

4 Likes
7

root@raspberrypi:~# sudo apt-get install sqlite3
root@raspberrypi:~# sqlite3 myfirstdatabase.db
SQLite version 3.34.1 2021-01-20 14:10:07