[Lazarus] PostgreSql: unexpected EOF on client connection with an open transaction

[Michael Van Canneyt]

On Tue, 1 Sep 2015, Leonardo M. Ramé wrote:

> Hi, this is kind of a dejavu, I'm pretty sure I have asked this question 
> before, but I can't find the old message, so, here I go.
>
> In my postgresql.log file I get this two messages every time I query/update 
> the database:
>
> could not receive data from client: Connection reset by peer
> unexpected EOF on client connection with an open transaction
>
> I'm using TPQConnection/TSqlTransaction/TSqlQuery in a CGI with this method:
>
> procedure TDataModule1.ExecSql(ASql: string);
> var
>  lSql: TSQLQuery;
> begin
>  lSql := TSQLQuery.Create(nil);
>  try
>    lSql.DataBase := PQConnection1;
>    lSql.Transaction := SQLTransaction1;
>    lSql.SQL.Text:= ASql;
>    lSql.ExecSQL;
>    SQLTransaction1.Commit;
>  finally
>    lSql.Free;
>  end;
> end;
>
> The query is executed without issues, data is stored into the db, but I keep 
> getting those messages.

Do you have a second transaction object (e.g. default transaction) ?
If so, that's probably it.

Michael.