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

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.klaver@aklaver.com>
Envoyé : vendredi 16 mars 2018 16:26
À : francis cherat; pgsql-general@postgresql.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.klaver@aklaver.com

Hello,

there is no message in /var/log/messages

Regards
________________________________
De : francis cherat <renaultf11@hotmail.com>
Envoyé : vendredi 16 mars 2018 20:27
À : Adrian Klaver; pgsql-general@postgresql.org
Objet : RE: error 53200 out of memory

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.klaver@aklaver.com>
Envoyé : vendredi 16 mars 2018 16:26
À : francis cherat; pgsql-general@postgresql.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.klaver@aklaver.com

On 03/20/2018 12:08 AM, francis cherat wrote:

Hello,

there is no message in /var/log/messages

How about the Postgres logs?

Regards

--
Adrian Klaver
adrian.klaver@aklaver.com