Search Postgresql Archives

Re: "out of memory" error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Fri, 30 Apr 2004, Rachel McConnell wrote:

> Hello,
> 
> I have a Java web application using Hibernate to connect to a PostgreSQL 
> backend.  I am seeing the below stack trace during processing of a set 
> of data consisting of around 1000 objects; for a 200 object set I don't 
> see the exception.
> 
> I believe the salient point is the Out Of Memory bit - marked below by 
> *****'s
> The fact that this exception occurs during a call to 
> org.postgresql.util.PSQLException.parseServerError() seems disturbing too.
> 

This is a server error message (which is why the stracktrace starts at
parseServerError, although perhaps it shouldn't).  This means the
postgresql server ran out of memory, but you haven't provided any
information as to why that is.  You should check the server error log for
more information.  The key thing to check would be the actual query being
run. Is it using a bad plan query plan?  What other activity is going on
at this time?  How much memory do you have?

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux