Re: How to debug incomplete message on postgres 12.3 docker

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