SQLite3 not loaded correctly on ubuntu-24.04 runner

[andrerav]

Description

Using SQLite3 and spatialite on ubuntu-22.04 works, but fails on ubuntu-24.04.

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

Runner image: ubuntu-24.04 version 20250105.1.0

Is it regression?

ubuntu-22.04 version 20250105.1.0

Expected behavior

I expect sqlite3 to be successfully loaded.

Actual behavior

Error Message:
OneTimeSetUp: System.TypeInitializationException : The type initializer for 'Microsoft.Data.Sqlite.SqliteConnection' threw an exception.
----> System.Reflection.TargetInvocationException : Exception has been thrown by the target of an invocation.
----> System.DllNotFoundException : Unable to load shared library 'sqlite3' or one of its dependencies. In order to help diagnose loading problems, consider using a tool like strace. If you're using glibc, consider setting the LD_DEBUG environment variable:
/home/runner/work/SomeProduct/SomeProduct/src/SomeVendor.SomeProduct.Data.Services.Tests/bin/Debug/net8.0/runtimes/linux-x64/native/sqlite3.so: cannot open shared object file: No such file or directory
/usr/share/dotnet/shared/Microsoft.NETCore.App/8.0.12/sqlite3.so: cannot open shared object file: No such file or directory
/home/runner/work/SomeProduct/SomeProduct/src/SomeVendor.SomeProduct.Data.Services.Tests/bin/Debug/net8.0/sqlite3.so: cannot open shared object file: No such file or directory
/home/runner/work/SomeProduct/SomeProduct/src/SomeVendor.SomeProduct.Data.Services.Tests/bin/Debug/net8.0/runtimes/linux-x64/native/libsqlite3.so: cannot open shared object file: No such file or directory
/usr/share/dotnet/shared/Microsoft.NETCore.App/8.0.12/libsqlite3.so: cannot open shared object file: No such file or directory
/home/runner/work/SomeProduct/SomeProduct/src/SomeVendor.SomeProduct.Data.Services.Tests/bin/Debug/net8.0/libsqlite3.so: cannot open shared object file: No such file or directory
/home/runner/work/SomeProduct/SomeProduct/src/SomeVendor.SomeProduct.Data.Services.Tests/bin/Debug/net8.0/runtimes/linux-x64/native/sqlite3: cannot open shared object file: No such file or directory
/usr/share/dotnet/shared/Microsoft.NETCore.App/8.0.12/sqlite3: cannot open shared object file: No such file or directory
/home/runner/work/SomeProduct/SomeProduct/src/SomeVendor.SomeProduct.Data.Services.Tests/bin/Debug/net8.0/sqlite3: cannot open shared object file: No such file or directory
/home/runner/work/SomeProduct/SomeProduct/src/SomeVendor.SomeProduct.Data.Services.Tests/bin/Debug/net8.0/runtimes/linux-x64/native/libsqlite3: cannot open shared object file: No such file or directory
/usr/share/dotnet/shared/Microsoft.NETCore.App/8.0.12/libsqlite3: cannot open shared object file: No such file or directory
/home/runner/work/SomeProduct/SomeProduct/src/SomeVendor.SomeProduct.Data.Services.Tests/bin/Debug/net8.0/libsqlite3: cannot open shared object file: No such file or directory

Repro steps

Create a .NET test project with EF Core.
Install the following packages:

• SQLitePCLRaw.bundle_sqlite3
• Microsoft.EntityFrameworkCore.Sqlite
• Microsoft.EntityFrameworkCore.Sqlite.Core
• Microsoft.EntityFrameworkCore.Sqlite.NetTopologySuite

Configure the context for SQLite.

Create one or more tests that make roundtrips to the database.

The tests will fail with the above error on ubuntu-24.04, but will work fine on ubuntu-22.04.

[kishorekumar-anchala]

Hi @andrerav - Thank you for bringing this issue to our attention. We will look into this issue closely and will update you after investigating.

[kishorekumar-anchala]

Hi @andrerav - Could you please confirm, is this issue still persist ?

[andrerav]

Hi @kishorekumar-anchala -- unfortunately not. I am having some sort of problem with spatialite now that is causing this error:

The active test run was aborted. Reason: Test host process crashed

I have no idea how to debug that (and I don't have time/interest), so I've decided to rearchitect and remove spatialite completely. It's been causing a lot more hassle than it's worth.

I will get back to you when I've gotten rid of spatialite so I can test your changes.