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
mailinglist 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.klaver@aklaver.com