Re: PostgreSQL server "idle in transaction"

2022-11-16 Thread Adrian Klaver
On 11/16/22 12:51 AM, Matthias Apitz wrote: El día Dienstag, November 15, 2022 a las 10:28:11 -0500, Tom Lane escribió: Adrian Klaver writes: On 11/15/22 04:28, Matthias Apitz wrote: I have below the full ESQL/C log and do not understand, why the PostgreSQL server is thinking "idle in transa

Re: PostgreSQL server "idle in transaction"

2022-11-16 Thread Matthias Apitz
El día Dienstag, November 15, 2022 a las 10:28:11 -0500, Tom Lane escribió: > Adrian Klaver writes: > > On 11/15/22 04:28, Matthias Apitz wrote: > >> I have below the full ESQL/C log and do not understand, why the > >> PostgreSQL server is thinking "idle in transaction". For me with the > >> "COM

Re: PostgreSQL server "idle in transaction"

2022-11-16 Thread Matthias Apitz
El día Dienstag, November 15, 2022 a las 10:28:11 -0500, Tom Lane escribió: > Adrian Klaver writes: > > On 11/15/22 04:28, Matthias Apitz wrote: > >> I have below the full ESQL/C log and do not understand, why the > >> PostgreSQL server is thinking "idle in transaction". For me with the > >> "COM

Re: PostgreSQL server "idle in transaction"

2022-11-15 Thread Tom Lane
Adrian Klaver writes: > On 11/15/22 04:28, Matthias Apitz wrote: >> I have below the full ESQL/C log and do not understand, why the >> PostgreSQL server is thinking "idle in transaction". For me with the >> "COMMIT" on the line below marked with ^ the transaction was closed. > From your log:

Re: PostgreSQL server "idle in transaction"

2022-11-15 Thread Adrian Klaver
On 11/15/22 04:28, Matthias Apitz wrote: Hello, We face with our application servers (ESQL/C written) and a 14.1 server on Linux, the situation that the PostgreSQL backend for servers are saying "idle in transaction". One can see this in the table pg_stat_activity and also on the shell: $ ps -