Unclear error when running cargo sqlx prepare

[MarkForLoop]

Hi, I'm trying to understand the following error message I get when running either:

cargo sqlx prepare
# or
cargo sqlx prepare --check

I receive this error:

Error: Issue parsing `cargo metadata` output - consider manually running it to check for issues

However, this message is not very clear to me, and I'm unsure how to resolve it.

Some context:

• My DATABASE_URL is set correctly in my .env file and is visible when I run:

  cat .env | grep DATABASE_URL

• I'm using sqlx-cli version 0.8.6.

My Cargo.toml contains the following configuration:

sqlx = { version = "0.8", features = [
  "postgres",
  "runtime-tokio-rustls",
  "chrono",
  "rust_decimal",
  "migrate"
] }

When running: sqlx migrate I done it like this

sqlx migrate run --database-url postgresql://postgres:[email protected]:5432/xyz --source spec/db/migrations

Has anyone else encountered this or have suggestions on how to debug it further?

Thanks in advance!

[abonander]

What version of Rust/Cargo are you using?

[MarkForLoop]

I have deleted me .lock and ran cargo clean and I am still getting the same issue

[MarkForLoop]

I ran
cargo metadata --format-version=1 --no-deps > metadata.json

but the json file is valid I am kinda stumped on why it is occurring

[joeydewaal]

Oh I see you are using version 1.86, the edition shouldn't be the problem.

[MarkForLoop]

I found out the problem.
The .env was not loading for some reason

after running

export $(grep DATABASE_URL .env | xargs)

the prepare works