Using sqlx prepare output: "Error: failed to open the temporary file"

[Remalloc]

Hello everyone, when I use sqlx prepare, it results in an error: 'Error: failed to open the temporary file'. However, cargo check completes successfully.

Environment details:

Ubuntu 20.04.3 LTS
sqlx v0.7.3
rustc 1.73.0 (cc66ad468 2023-10-03)
Here's a snippet of the output:

error: failed to open the temporary file: Os { code: 95, kind: Uncategorized, message: "Operation not supported" }
  --> core/strategy_manager/src/http_handler/model.rs:14:9
   |
14 | /         sqlx::query_as!(
15 | |             User,
16 | |             "SELECT user_id, passwd, comments, role FROM strategy.user WHERE user_id = $1;",
17 | |             user_id
18 | |         )
   | |_________^
   |
   = note: this error originates in the macro `$crate::sqlx_macros::expand_query` which comes from the expansion of the macro `sqlx::query_as` (in Nightly builds, run with -Z macro-backtrace for more info)

[abonander]

What filesystem is your project directory on?

[Remalloc]

I develop my project in Docker. It worked previously, but issues arose after I updated sqlx to v0.7.3. I also tried rolling back to an earlier version, but that didn't resolve the issue. Directory on /data (overlay)

Filesystem Type 1K-blocks Used Available Use% Mounted on
overlay overlay 1967874000 750948168 1116889584 41% /
tmpfs tmpfs 65536 0 65536 0% /dev
shm tmpfs 65536 0 65536 0% /dev/shm
/dev/nvme1n1p1 ext4 1967874000 750948168 1116889584 41% /etc/hosts
tmpfs tmpfs 32820024 0 32820024 0% /proc/asound
tmpfs tmpfs 32820024 0 32820024 0% /proc/acpi
tmpfs tmpfs 32820024 0 32820024 0% /proc/scsi
tmpfs tmpfs 32820024 0 32820024 0% /sys/firmware

[abonander]

It looks like overlayfs doesn't support O_TMPFILE which is used by the atomic-write-file crate added in #2803

That was part of the 0.7.3 release so you should be able to downgrade to 0.7.2, but you probably need to specify the exact version:

# Only use 0.7.2
sqlx = { version = "=0.7.2" }

This is definitely something we'll want to fix as building in Docker is an important use case.

[Remalloc]

That's really helpful. Thank you.

[abonander]

The atomic-write-file crate has released a fix. Try cargo update after switching back to SQLx 0.7.3 to pick it up and let me know if it works now.

[Remalloc]

It works now.