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.
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
