Comment 8 for bug 1975401

Kinetic now has Python 3.10.6 ( http://changelogs.ubuntu.com/changelogs/pool/main/p/python3.10/python3.10_3.10.6-1/changelog ), where interestingly the changelog says that 3.10.5 (the first Python release with the aforementioned bug fixed) was supposedly released on June 8th (the timestamp on the 3.10.5 changelog file in changelogs.ubuntu.com supports that).

Regardless, you can now build and install Python 3.10.6 on your jammy (22.04 LTS) installation by following these instructions:

1. Create a new file `/etc/apt/sources.list.d/kinetic-sources.list' to contain just the following line:
deb-src http://archive.ubuntu.com/ubuntu kinetic main restricted
2. Install the following packages: build-essential fakeroot dpkg-dev
3. The rest of the commands assume you opened a terminal, created a new directory somewhere and cd into it.
4. sudo apt update
5. apt-get source python3.10
6. sudo apt-get build-dep python3.10
7. dpkg-source -x python3.10_3.10.6-1.dsc
8. cd python3.10-3.10.6/
9. dpkg-buildpackage --no-sign -rfakeroot -b
10. ...wait until the build completes - it could take an hour or more...
11. cd ..
12. dpkg -i python3.10_3.10.6-1_amd64.deb python3.10-minimal_3.10.6-1_amd64.deb libpython3.10_3.10.6-1_amd64.deb libpython3.10-stdlib_3.10.6-1_amd64.deb libpython3.10-minimal_3.10.6-1_amd64.deb

After which Kodi should start properly and should have no problem running plugins that use sqlite.