error 53200 out of memory
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
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 Envoyé : vendredi 16 mars 2018 16:26 À : francis cherat; pgsql-gene...@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.kla...@aklaver.com
RE: error 53200 out of memory
Hello, there is no message in /var/log/messages Regards De : francis cherat Envoyé : vendredi 16 mars 2018 20:27 À : Adrian Klaver; pgsql-gene...@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 Envoyé : vendredi 16 mars 2018 16:26 À : francis cherat; pgsql-gene...@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.kla...@aklaver.com
