efcore.pg icon indicating copy to clipboard operation
efcore.pg copied to clipboard

Received backend message ParseComplete while expecting BindCompleteMessage using pgcat pooler

Open vivaticket-gpatane opened this issue 1 year ago • 0 comments

Hi, I am trying to determine which PostgreSQL pooler to use in combination with EntityFramework and Dapper. PgBouncer on Kubernetes exhibits strange behavior; during load tests, we observe increased latency in opening connections. However, we have obtained very good results with the new pgcat pooler, which seems better suited for containerization.

The only problem we are encountering concerns writes within transactions. We receive the following error:

Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.
 ---> Npgsql.NpgsqlException (0x80004005): Received backend message ParseComplete while expecting BindCompleteMessage. Please file a bug.
   at Npgsql.Util.Statics.ThrowIfMsgWrongType[T](IBackendMessage msg, NpgsqlConnector connector)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)

The error itself is asking me to create the issue :) However, I wanted to understand if there is a way to identify the cause of the error so that I can report it to the pgcat team. It seems to me that there is an error in the type of message returned at the completion of a specific operation.

vivaticket-gpatane avatar Jul 29 '24 10:07 vivaticket-gpatane