Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
1 of 16 tasks
pinheadmz opened this issue Jan 3, 2025 · 3 comments · May be fixed by #11341
Open
1 of 16 tasks

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

pinheadmz opened this issue Jan 3, 2025 · 3 comments · May be fixed by #11341
Assignees
@kishorekumar-anchala
Labels
awaiting-deployment Code complete; awaiting deployment and/or deployment in progress bug report OS: Ubuntu OS: Ubuntu24

Comments

@pinheadmz
Copy link

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 kishorekumar-anchala self-assigned this Jan 3, 2025
@kishorekumar-anchala
Copy link
Contributor

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

@pinheadmz
Copy link
Author

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
Copy link

PriscahC commented Jan 4, 2025

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.

@vidyasagarnimmagaddi vidyasagarnimmagaddi mentioned this issue Jan 6, 2025
Closed
@kishorekumar-anchala kishorekumar-anchala mentioned this issue Jan 6, 2025
Merged
4 tasks
@kishorekumar-anchala kishorekumar-anchala added the awaiting-deployment Code complete; awaiting deployment and/or deployment in progress label Jan 7, 2025
Setland34 added a commit to Setland34/runner-images that referenced this issue Jan 9, 2025
@Setland34
Fix SQLite3 missing in Ubuntu 24.04 runner image
f5ea096 
Fixes actions#11279

Add SQLite3 to Ubuntu 24.04 runner image.

* Add `libsqlite3-dev` to the `common_packages` section in `toolset-2404.json`.
* Add `sqlite3` to the `cmd_packages` section in `toolset-2404.json`.
* Add `sqlite3` version to the `Databases` section in `Ubuntu2404-Readme.md`.

---

For more details, open the [Copilot Workspace session](https://copilot-workspace.githubnext.com/actions/runner-images/issues/11279?shareId=XXXX-XXXX-XXXX-XXXX).
@Setland34 Setland34 linked a pull request Jan 9, 2025 that will close this issue
Open
Setland34 added a commit to Setland34/runner-images that referenced this issue Jan 10, 2025
@Setland34
Fix SQLite3 missing in Ubuntu 24.04 runner image
2635e5c 
Fixes actions#11279

Add SQLite3 to Ubuntu 24.04 runner image.

* Add `libsqlite3-dev` to the `common_packages` section in `toolset-2404.json`.
* Add `sqlite3` to the `cmd_packages` section in `toolset-2404.json`.
* Add `sqlite3` version to the `Databases` section in `Ubuntu2404-Readme.md`.

---

For more details, open the [Copilot Workspace session](https://copilot-workspace.githubnext.com/actions/runner-images/issues/11279?shareId=XXXX-XXXX-XXXX-XXXX).
@Setland34 Setland34 mentioned this issue Jan 10, 2025
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@kishorekumar-anchala kishorekumar-anchala

Labels
awaiting-deployment Code complete; awaiting deployment and/or deployment in progress bug report OS: Ubuntu OS: Ubuntu24
Projects
None yet
Milestone
No milestone
4 participants
@pinheadmz @PriscahC @vidyasagarnimmagaddi @kishorekumar-anchala