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

2015-09-02 Thread Leonardo M . Ramé
Do you have a second transaction object (e.g. default transaction) ? If so, that's probably it. Michael. No, just a TSQLTransaction attached to the TPQConnection object. I commented all my code but the PQConnection1.Connected := True, and I noted I get the "could not receive data from

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

2015-09-02 Thread Michael Van Canneyt
On Wed, 2 Sep 2015, Leonardo M. Ramé wrote: Do you have a second transaction object (e.g. default transaction) ? If so, that's probably it. Michael. No, just a TSQLTransaction attached to the TPQConnection object. I commented all my code but the PQConnection1.Connected := True, and I

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

2015-09-02 Thread Leonardo M . Ramé
El 02/09/15 a las 16:11, Leonardo M. Ramé escribió: El 02/09/15 a las 16:00, Michael Van Canneyt escribió: Well, that is why I asked how it is closed. Maybe it was closed a different way in your CGI, without properly closing it. The strange thing is that it reports an active transaction. Do

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

2015-09-02 Thread Leonardo M . Ramé
El 02/09/15 a las 15:09, Michael Van Canneyt escribió: On Wed, 2 Sep 2015, Leonardo M. Ramé wrote: Do you have a second transaction object (e.g. default transaction) ? If so, that's probably it. Michael. Yes, I added an onDestroy event to the datamodule containing the PQConnection

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

2015-09-02 Thread Michael Van Canneyt
On Wed, 2 Sep 2015, Leonardo M. Ramé wrote: El 02/09/15 a las 15:09, Michael Van Canneyt escribió: On Wed, 2 Sep 2015, Leonardo M. Ramé wrote: Do you have a second transaction object (e.g. default transaction) ? If so, that's probably it. Michael. Yes, I added an onDestroy event

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

2015-09-02 Thread Leonardo M . Ramé
El 02/09/15 a las 16:00, Michael Van Canneyt escribió: Well, that is why I asked how it is closed. Maybe it was closed a different way in your CGI, without properly closing it. The strange thing is that it reports an active transaction. Do you open a dataset ? If so, try setting

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

2015-09-02 Thread Marc Santhoff
On Di, 2015-09-01 at 14:26 -0300, 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: > >

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

2015-09-02 Thread 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

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

2015-09-02 Thread Mark Morgan Lloyd
Marc Santhoff wrote: On Di, 2015-09-01 at 14:26 -0300, 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

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

2015-09-02 Thread Leonardo M . Ramé
El 02/09/15 a las 10:28, Marc Santhoff escribió: Only guessing: maybe the transaction object is set to "autocommit" and the .Commit statement produces the error? It's configured to caRollBack. -- ___ Lazarus mailing list

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

2015-09-01 Thread Leonardo M . Ramé
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