ubuntu 22.04 - python3-pysqlite2 has no installation candidate

[Tobi]

on Ubuntu 22.04 the package "python3-pysqlite2" its not in the repository (anymore?). All other packages which are defined in "https://opendev.org/openstack/puppet-oslo/src/tag/23.0.0/manifests/params.pp" are available.

Error: /Stage[main]/Keystone::Db/Oslo::Db[keystone_config]/Package[python3-pysqlite2]/ensure: change from 'purged' to 'present' failed: Execution of '/usr/bin/apt-get -q -y -o DPkg::Options::=--force-confold install python3-pysqlite2' returned 100: Reading package lists...
Building dependency tree...
Reading state information...
Package python3-pysqlite2 is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source

E: Package 'python3-pysqlite2' has no installation candidate

[Tobi (tobl0815)]

also broken on ubuntu 20.04

[Takashi Kajinami (kajinamit)]

Looking at the code in sqlalchemy, it seems the built-in sqlite3[1] should be used in Python 3.

[1] https://docs.python.org/3.11/library/sqlite3.html

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/puppet-oslo/+/903585
Committed: https://opendev.org/openstack/puppet-oslo/commit/482fae00cd4992ded18fea169e4a86993d550725
Submitter: "Zuul (22348)"
Branch: master

commit 482fae00cd4992ded18fea169e4a86993d550725
Author: Takashi Kajinami <email address hidden>
Date: Wed Dec 13 20:08:44 2023 +0900

    Debian/Ubuntu: Do not install python3-pysqlite2

    The python3-pysqlite2 package is no longer available, and the built-in
    sqlite3 library is used instead.

    Closes-Bug: #2046335
    Change-Id: I9642ca3b6e37d3a85ae274d38a8376e9afa03042

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/2023.2
Review: https://review.opendev.org/c/openstack/puppet-oslo/+/903821

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/puppet-oslo/+/903821
Committed: https://opendev.org/openstack/puppet-oslo/commit/0787356604486cf84f7fe4a78fecfa5c3f127639
Submitter: "Zuul (22348)"
Branch: stable/2023.2

commit 0787356604486cf84f7fe4a78fecfa5c3f127639
Author: Takashi Kajinami <email address hidden>
Date: Wed Dec 13 20:08:44 2023 +0900

    Debian/Ubuntu: Do not install python3-pysqlite2

    The python3-pysqlite2 package is no longer available, and the built-in
    sqlite3 library is used instead.

    Closes-Bug: #2046335
    Change-Id: I9642ca3b6e37d3a85ae274d38a8376e9afa03042
    (cherry picked from commit 482fae00cd4992ded18fea169e4a86993d550725)

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/2023.1
Review: https://review.opendev.org/c/openstack/puppet-oslo/+/903920

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/puppet-oslo/+/903920
Committed: https://opendev.org/openstack/puppet-oslo/commit/30415904823d929dfc835adf879fc70ee0d706ed
Submitter: "Zuul (22348)"
Branch: stable/2023.1

commit 30415904823d929dfc835adf879fc70ee0d706ed
Author: Takashi Kajinami <email address hidden>
Date: Wed Dec 13 20:08:44 2023 +0900

    Debian/Ubuntu: Do not install python3-pysqlite2

    The python3-pysqlite2 package is no longer available, and the built-in
    sqlite3 library is used instead.

    Conflicts:
            manifests/db.pp
            spec/defines/oslo_db_spec.rb

    Closes-Bug: #2046335
    Change-Id: I9642ca3b6e37d3a85ae274d38a8376e9afa03042
    (cherry picked from commit 482fae00cd4992ded18fea169e4a86993d550725)
    (cherry picked from commit 0787356604486cf84f7fe4a78fecfa5c3f127639)

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/puppet-oslo 24.0.0 release.