use std::fmt::Write;
use anyhow::Context;
use futures_util::{SinkExt, StreamExt};
use crate::proto::backend::BackendMessage;
use crate::proto::frontend::FrontendMessage;
use crate::proto::types::TransactionStatus;
use super::server::ServerConn;
const BASE_RESET: &str = "\
ROLLBACK;\
CLOSE ALL;\
UNLISTEN *;\
SELECT pg_advisory_unlock_all();\
DISCARD SEQUENCES;\
DISCARD TEMP;\
";
#[tracing::instrument(name = "pool.reset", skip_all, err(Display), fields(
otel.status_code,
otel.status_description,
))]
pub(crate) async fn reset_connection(conn: &mut ServerConn) -> anyhow::Result<()> {
async {
let mut query = String::new();
for var in conn.dirty_vars.drain() {
let _ = write!(query, "RESET {var};");
}
query.push_str(BASE_RESET);
conn.framed.send(FrontendMessage::Query(query)).await?;
loop {
match conn
.framed
.next()
.await
.transpose()
.context("reading reset response")?
{
Some(BackendMessage::ReadyForQuery(TransactionStatus::Idle)) => return Ok(()),
Some(BackendMessage::ReadyForQuery(status)) => {
anyhow::bail!("reset left connection in non-idle state: {status:?}");
}
Some(BackendMessage::ErrorResponse(err)) => {
anyhow::bail!("reset failed: {}", err.message().unwrap_or("unknown"));
}
None => anyhow::bail!("upstream closed during reset"),
Some(_) => {}
}
}
}
.await
.inspect(|()| {
tracing::Span::current().record("otel.status_code", "OK");
})
.inspect_err(|e| {
let span = tracing::Span::current();
span.record("otel.status_code", "ERROR");
span.record("otel.status_description", e.to_string().as_str());
})
}