Обсуждение: error 53200 out of memory
Hello,
we have got an error 53200 after sql statement
in jboss logs we have got those errors
cluster configuration
server_version | 9.3.16
Server configuration
Thanks for your feedback
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
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
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,
>
> 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
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
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
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,
>
> 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