error 53200 out of memory

From: francis cherat <renaultf11(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: error 53200 out of memory
Date: 2018-03-16 11:00:42
Message-ID: DB6PR0801MB2039B364C9F52D75D6C74B29DCD70@DB6PR0801MB2039.eurprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2018-03-16 11:45:56 Re: Circle and box intersect
Previous Message Martin Moore 2018-03-16 10:00:38 Circle and box intersect