Search Postgresql Archives

Re: How to debug incomplete message on postgres 12.3 docker

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.klaver@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux