Tokio Postgres hangs

[FaveroFerreira]

Bug Description

Tokio Postgres hangs when running CREATE DATABASE query. awaiting it never returns.

In this example I am using simple_query, but it also happens with execute and query methods.

All other queries works fine.

Minimal Reproduction

• Cargo.toml

  tokio-postgres = { version = "0.7.8", features = ["with-uuid-1", "with-chrono-0_4", "with-serde_json-1"] }

async fn seed_database(db_config: &PostgresConfig) {
    let without_db = format!(
        "postgres://{}:{}@{}:{}/postgres",
        db_config.username.expose_secret(),
        db_config.password.expose_secret(),
        db_config.host,
        5432
    );

    let (client, _conn) = tokio_postgres::connect(&without_db, tokio_postgres::NoTls)
        .await
        .expect("Failed to connect to Postgres");

    client
        .simple_query(&format!("CREATE DATABASE \"{}\"", db_config.database))
        .await
        .expect("Failed to create database");

  // ....
}

Info

• Tokio Postgres version: 0.7.8
• Features enabled: ["with-uuid-1", "with-chrono-0_4", "with-serde_json-1"]
• Database server and version: Postgres 15.01
• Operating system: Pop!_OS 22.04 LTS
• rustc --version: rustc 1.71.0 (8ede3aae2 2023-07-12)

[sfackler]

Don't ignore conn.

[FaveroFerreira]

Tried it, sadly it behaves the same.

[sfackler]

What is "it"? What are you doing with conn?

[FaveroFerreira]

Sorry for the late response, I realised I was not spawning the conn to a separate thread. My bad.