Re: error 53200 out of memory - Mailing list pgsql-general

From Adrian Klaver
Subject Re: error 53200 out of memory
Date
Msg-id 03f4c632-5062-1475-2747-4555baae565b@aklaver.com
Whole thread Raw
In response to error 53200 out of memory  (francis cherat <renaultf11@hotmail.com>)
Responses RE: error 53200 out of memory  (francis cherat <renaultf11@hotmail.com>)
List pgsql-general
On 03/16/2018 04:00 AM, francis cherat wrote:
> Hello,
> 
> we have got  an error 53200 after sql statement
> 
> [5-1] ERROR:  53200: out of memory
> [6-1] DETAIL:  Failed on request of size 1572864.
> [7-1] LOCATION:  AllocSetRealloc, aset.c:973
> 
> in jboss logs we have got those errors
> 
> org.jboss.logging.jboss-logging - 3.1.2.GA | ERROR: out of memory
>    Détail : Failed on request of size 1572864.
> executing failed
> org.hibernate.exception.GenericJDBCException: could not extract ResultSet
> 
> cluster configuration
> server_version                      | 9.3.16
> effective_cache_size                | 12800MB
> shared_buffers                      | 384MB
> work_mem                            | 384MB
> 
> Server configuration
> RHEL 6.5
> RAM : 16Go
> 2 CPUs
> 
> Thanks for your feedback

Is there anything in the Postgres and/or system logs from the same time 
that might shed on this?



-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Prompt for parameter value in psql
Next
From: "David G. Johnston"
Date:
Subject: Re: STRING_AGG and GROUP BY