SQLite3 missing or not found in Ubuntu 24, was present in Ubuntu 22

[pinheadmz]

Description

We have a github classroom assignment in progress. Since the 20241215 image release students are seeing failures. The code builds bitcoin core which requires SQLite3. This was present when we started the assignment but the upgrade runner is now failing.

Error:

CMake Error at /usr/local/share/cmake-3.31/Modules/FindPackageHandleStandardArgs.cmake:233 (message):
  Could NOT find SQLite3 (missing: SQLite3_INCLUDE_DIR SQLite3_LIBRARY)
  (Required is at least version "3.7.17")

Failing image info:

Current runner version: '2.321.0'
Operating System
  Ubuntu
  24.04.1
  LTS
Runner Image
  Image: ubuntu-24.04
  Version: 20241215.1.0
  Included Software: https://github.com/actions/runner-images/blob/ubuntu24/20241215.1/images/ubuntu/Ubuntu2404-Readme.md
  Image Release: https://github.com/actions/runner-images/releases/tag/ubuntu24%2F20241215.1

Last runner image that WORKED:

 Current runner version: '2.320.0'
Operating System
  Ubuntu
  22.04.5
  LTS
Runner Image
  Image: ubuntu-22.04
  Version: 20241103.1.0
  Included Software: https://github.com/actions/runner-images/blob/ubuntu22/20241103.1/images/ubuntu/Ubuntu2204-Readme.md
  Image Release: https://github.com/actions/runner-images/releases/tag/ubuntu22%2F20241103.1

Platforms affected

• Azure DevOps
• GitHub Actions - Standard Runners
• GitHub Actions - Larger Runners

Runner images affected

• Ubuntu 20.04
• Ubuntu 22.04
• Ubuntu 24.04
• macOS 12
• macOS 13
• macOS 13 Arm64
• macOS 14
• macOS 14 Arm64
• macOS 15
• macOS 15 Arm64
• Windows Server 2019
• Windows Server 2022
• Windows Server 2025

Image version and build link

Current runner version: '2.321.0'
Operating System
Ubuntu
24.04.1
LTS
Runner Image
Image: ubuntu-24.04
Version: 20241215.1.0
Included Software: https://github.com/actions/runner-images/blob/ubuntu24/20241215.1/images/ubuntu/Ubuntu2404-Readme.md
Image Release: https://github.com/actions/runner-images/releases/tag/ubuntu24%2F20241215.1

Is it regression?

Working runner version: '2.320.0'

Expected behavior

libsqlite3-dev does not need to be installed with apt

Actual behavior

libsqlite3-dev DOES need to be installed with apt

Repro steps

Attempt to build bitcoin core with this script:

sudo apt install -y build-essential pkg-config curl ca-certificates ccache python3 rsync git procps bison e2fsprogs cmake libevent-dev libboost-dev
cd bitcoin
cmake -B build -DBUILD_GUI=OFF -DWITH_BDB=OFF -DBUILD_BENCH=OFF -DBUILD_FOR_FUZZING=OFF -DBUILD_KERNEL_LIB=OFF -DBUILD_SHARED_LIBS=OFF -DBUILD_TESTS=OFF -DBUILD_TX=OFF -DBUILD_UTIL=OFF -DBUILD_WALLET_TOOL=OFF
cmake --build build -j$(nproc)

We have just added libsqlite3-dev to this script, but all students that have accepted the assignment since the runner image was released are seeing failures.

[kishorekumar-anchala]

@pinheadmz , thanks for raising the issue and will update as soon as possible.

[pinheadmz]

There are some actions running 2.321.0 that still use the Ubuntu 22.04 image. The version number there is still 12-15 though, so I'm very confused and its making it hard to predict which student submissions are failing because of this issue.

This runner below was OK

 Current runner version: '2.321.0'
Operating System
  Ubuntu
  22.04.5
  LTS
Runner Image
  Image: ubuntu-22.04
  Version: 20241215.1.0
  Included Software: https://github.com/actions/runner-images/blob/ubuntu22/20241215.1/images/ubuntu/Ubuntu2204-Readme.md
  Image Release: https://github.com/actions/runner-images/releases/tag/ubuntu22%2F20241215.1

[PriscahC]

Thank you for the update. I also had the SQLite3 error. The "add libsqlite3-dev to build.sh #17" commit made by @pinheadmz resolved the issue.