RE: error 53200 out of memory

From: francis cherat <renaultf11(at)hotmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: RE: error 53200 out of memory
Date: 2018-03-16 19:27:02
Message-ID: DB6PR0801MB2039A0AA044BDA5E0F5D5BEBDCD70@DB6PR0801MB2039.eurprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I don't think so, but i am not in my office. I can't connect to this server.
I would answer you on monday

Regards
________________________________
De : Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Envoyé : vendredi 16 mars 2018 16:26
À : francis cherat; pgsql-general(at)postgresql(dot)org
Objet : Re: error 53200 out of memory

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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-03-16 19:28:17 Re: ora2pg and invalid command \N
Previous Message Charlin Barak 2018-03-16 18:36:31 Re: ora2pg and invalid command \N