Support Debian Trixie

[kyle-leonhard]

I have found these related issues/pull requests

None

Description

Hi sqlx!

Debian Trixie landed recently and the official Rust Docker image made it the default base. At least for my flow, the sqlx CLI breaks when built and ran with the Rust/trixie image against a postgresql DB. Interestingly, at least for my usage, sqlx used for postgresql as part of my Rust binary functions fine with the new Trixie base. Maybe I'm doing something wrong and there's nothing to do on sqlx's end.

Error:

./sqlx: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.39' not found (required by ./sqlx)

Dockerfile:

# Functional with: FROM rust:1.89.0@sha256:e090f7b4adf86191313dba91260351d7f5e15cac0fe34f26706a805c0cb9641f AS sqlx
FROM rust:1.89.0@sha256:6e6d04bd50cd4c433a805c58c13f186a508c5b5417b9b61cae40ec28e0593c51 AS sqlx
WORKDIR /app
RUN cargo install sqlx-cli@=0.8.6 --locked --no-default-features --features native-tls,postgres --root ./
# Also happens when using rustls
# Also happens without `--locked`, resolving: libc v0.2.175

Run command, ran from a github action using ubuntu-24.04:

docker run \
    --env DATABASE_URL \
    --network=host \
    --rm \
    $IMAGE \
    "./sqlx" database create

Cargo.toml sqlx dep:

sqlx = { version = "0.8.6", features = ["runtime-tokio", "tls-rustls", "postgres", "macros", "chrono", "rust_decimal", "uuid"] }

Prefered solution

The sqlx CLI should function when built using a Debian Trixie base image.

Is this a breaking change? Why or why not?

No, it's supporting a new Debian release

[abonander]

This is not a SQLx issue. SQLx does not specify a minimum glibc version. The base image for your actual container has a much older glibc (package libc-bin on Debian) than the Rust builder image.

I ran into this myself a few weeks ago when trying to run a container based on Debian Bookworm with a binary built on Arch Linux, as Arch generally has a much newer glibc.

The solution is either to update your container's base image, or use a different builder image. There's some discussion in this StackOverflow question.

[kyle-leonhard]

This is not a SQLx issue. SQLx does not specify a minimum glibc version. The base image for your actual container has a much older glibc (package libc-bin on Debian) than the Rust builder image.

I ran into this myself a few weeks ago when trying to run a container based on Debian Bookworm with a binary built on Arch Linux, as Arch generally has a much newer glibc.

The solution is either to update your container's base image, or use a different builder image. There's some discussion in this StackOverflow question.

Doh! Thanks for the details @abonander. I totally forgot to think about the base image. gcr.io/distroless/cc-debian12 is indeed older.