Azure Cosmos DB for PostgreSQL. Prepared statement error

Petter Moe 5 Reputation points
2024-06-27T14:26:29.3366667+00:00

I am running into issues regarding the pgbouncer connection pooling in Azure Cosmos DB for PostgreSQL: https://video2.skills-academy.com/en-us/azure/cosmos-db/postgresql/concepts-connection-pool.

The issue is that I get the error: "prepared statement "sqlx_s_1" already exists". I'm wondering if there is something we could do to solve that problem?

Seems like it might have been fixed with pgbouncer version 1.21.0, and I can't find any information about the pgbouncer version currently in use in the Azure Cosmos DB for PostgreSQL.

Is it true that the Azure Cosmos DB for PostgreSQL does not support prepared statements through pgbouncer? If so, are there any plans to support this?

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,659 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,477 Reputation points Microsoft Employee
    2024-06-27T21:28:21.6833333+00:00

    @Petter Moe Welcome to Microsoft Q&A thanks for posting your question.

    Azure Cosmos DB for PostgreSQL supports PgBouncer 1.20. Support for prepared statements was introduced in PgBouncer in version 1.21.

    We have PgBouncer 1.22 (or a later one) in our backlog but we don’t have specific date for this item at this time.

    Regards

    Geetha

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.