Re: How to debug incomplete message on postgres 12.3 docker

Thanks all for the fast replay, the thing is i cannot get the transection
query to know what really happened, ill try backing up db and rm containers
and re build them as i dont have any other idea also server logs looks fine
also cpu..
thanks!
בתאריך יום א׳, 16 בינו׳ 2022 ב-19:05 מאת Adrian Klaver <
adrian(dot)klaver(at)aklaver(dot)com>:

> On 1/16/22 07:13, R Batchen wrote:
> >
> > Hello,
> >
> > I hope i reached the right mailing list, i have psql 12.3 container that
> > is the db of apache guacamole container is connected to,
> > the apache guacamole stopped working and i started to get this message
> > on the postgres:
> >
> > |LOG: incomplete message from client |
> >
> > How can I debug it?
> >
> > i want to see when and who did the translation and what is the
> incomplete query ? because i did approached guacamole mailing list and they
> said my DB is closing connection in the middle of the transaction
> >
> > and its psql issue and i am not able to debug it because i only have
> this incomlit msg.
>
> The message is pretty clear, the error is coming from the client which
> is not Postgres.
>
> >
> > *Is there a way to catch this transaction?*
> >
> > full logs :
>
> >
> > |postgres_gqm_1 | 2022-01-13T19:32:24.187916615Z 2022-01-13 19:32:24.187
> > UTC [4394] LOG: incomplete message from client guacamole_1 |
> > 2022-01-13T19:32:24.214231454Z 19:32:24.214 [http-nio-8080-exec-6] ERROR
> > o.a.g.rest.RESTExceptionMapper - Unexpected internal error: guacamole_1
>
> The above would seem to be the place to look.
>
> > | 2022-01-13T19:32:24.214398980Z ### Error rolling back transaction.
> > Cause: org.postgresql.util.PSQLException: This connection has been
> > closed. guacamole_1 | 2022-01-13T19:32:24.214445260Z ### Cause:
> > org.postgresql.util.PSQLException: This connection has been closed. |
> >
> >
> > docker file :
> >
> > postgres_gqm:
> >
> > |image: postgres:12.3 environment: PGDATA:
> > /var/lib/postgresql/data/guacamole POSTGRES_DB: db POSTGRES_PASSWORD:
> > XXX POSTGRES_USER: user restart: always volumes: -
> > ./init:/docker-entrypoint-initdb.d:ro -
> > ./data:/var/lib/postgresql/data:rw logging: driver: "json-file" options:
> > max-size: "750m" |
> >
> >
> >
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>