By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,369 Members | 1,131 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,369 IT Pros & Developers. It's quick & easy.

"out of memory" error

P: n/a
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.

* the JVM or servlet container might be out of memory, however the db is
on a different machine than the server so this doesn't seem likely

* Postgres might be out of memory. How would I check for this?
Subsequent requests go through just fine, as do any requests I make
directly using psql.

* something Else is happening

Any advice on how to attack this issue would be much appreciated!

Rachel McConnell
WARN [ SystemErrorInterceptor ] - java.util.NoSuchElementException
java.util.NoSuchElementException
at java.util.AbstractList$Itr.next(AbstractList.java: 426)
at java.util.Collections$6.nextElement(Collections.ja va:2479)
at
com.enginegreen.denali.interceptor.SystemErrorInte rceptor.intercept(SystemErrorInterceptor.java:89)
at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)
at
com.opensymphony.xwork.interceptor.TimerIntercepto r.intercept(TimerInterceptor.java:62)
at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)
at
com.opensymphony.xwork.DefaultActionProxy.execute( DefaultActionProxy.java:116)
at
com.opensymphony.webwork.dispatcher.ServletDispatc her.serviceAction(ServletDispatcher.java:182)
at
com.opensymphony.webwork.dispatcher.ServletDispatc her.service(ServletDispatcher.java:162)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:103)
at
com.caucho.server.http.FilterChainServlet.doFilter (FilterChainServlet.java:96)
at
com.enginegreen.denali.chrome.filter.ChromeFilter. doFilter(ChromeFilter.java:57)
at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)
at
com.enginegreen.denali.interceptor.HibernateFilter .doFilter(HibernateFilter.java:42)
at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)
at
com.enginegreen.denali.action.DenaliFilter.doFilte r(DenaliFilter.java:28)
at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)
at com.caucho.server.http.Invocation.service(Invocati on.java:315)
at
com.caucho.server.http.CacheInvocation.service(Cac heInvocation.java:135)
at
com.caucho.server.http.RunnerRequest.handleRequest (RunnerRequest.java:346)
at
com.caucho.server.http.RunnerRequest.handleConnect ion(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection. java:139)
at java.lang.Thread.run(Thread.java:534)
WARN [ SystemErrorInterceptor ] -
com.enginegreen.denali.persistence.PersistenceExce ption:
net.sf.hibernate.JDBCException: could not initialize collection:
[com.enginegreen.ledger.model.InvoiceSummary.orderS ummarySet#78828]
at
com.enginegreen.ledger.invoice.impl.BillingClerkIm pl.renderInvoicesAsPDF(BillingClerkImpl.java:429)
at
com.enginegreen.denali.domain.billing.BillingManag erImpl.finalizeNextBillingPeriod(BillingManagerImp l.java:248)
at
com.enginegreen.denali.domain.billing.SecureBillin gManager.finalizeNextBillingPeriod(SecureBillingMa nager.java:96)
at
com.enginegreen.denali.action.billing.GenerateInvo icesAction.doExecute(GenerateInvoicesAction.java:1 21)
at
com.enginegreen.denali.action.WorkflowActionSuppor t.execute(WorkflowActionSupport.java:65)
at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:172)
at
com.enginegreen.denali.interceptor.ActionSourceInt erceptor.intercept(ActionSourceInterceptor.java:50 )
at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)
at
com.enginegreen.denali.interceptor.NullInterceptor .intercept(NullInterceptor.java:25)
at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)
at
com.opensymphony.xwork.interceptor.AroundIntercept or.intercept(AroundInterceptor.java:37)
at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)
at
com.opensymphony.xwork.interceptor.AroundIntercept or.intercept(AroundInterceptor.java:37)
at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)
at
com.opensymphony.xwork.interceptor.AroundIntercept or.intercept(AroundInterceptor.java:37)
at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)
at
com.opensymphony.xwork.interceptor.AroundIntercept or.intercept(AroundInterceptor.java:37)
at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)
at
com.opensymphony.xwork.interceptor.AroundIntercept or.intercept(AroundInterceptor.java:37)
at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)
at
com.enginegreen.denali.interceptor.security.AdminS ecurityInterceptor.intercept(AdminSecurityIntercep tor.java:31)
at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)
at
com.enginegreen.denali.interceptor.SystemErrorInte rceptor.intercept(SystemErrorInterceptor.java:47)
at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)
at
com.opensymphony.xwork.interceptor.TimerIntercepto r.intercept(TimerInterceptor.java:62)
at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)
at
com.opensymphony.xwork.DefaultActionProxy.execute( DefaultActionProxy.java:116)
at
com.opensymphony.webwork.dispatcher.ServletDispatc her.serviceAction(ServletDispatcher.java:182)
at
com.opensymphony.webwork.dispatcher.ServletDispatc her.service(ServletDispatcher.java:162)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:103)
at
com.caucho.server.http.FilterChainServlet.doFilter (FilterChainServlet.java:96)
at
com.enginegreen.denali.chrome.filter.ChromeFilter. doFilter(ChromeFilter.java:57)
at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)
at
com.enginegreen.denali.interceptor.HibernateFilter .doFilter(HibernateFilter.java:42)
at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)
at
com.enginegreen.denali.action.DenaliFilter.doFilte r(DenaliFilter.java:28)
at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)
at com.caucho.server.http.Invocation.service(Invocati on.java:315)
at
com.caucho.server.http.CacheInvocation.service(Cac heInvocation.java:135)
at
com.caucho.server.http.RunnerRequest.handleRequest (RunnerRequest.java:346)
at
com.caucho.server.http.RunnerRequest.handleConnect ion(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection. java:139)
at java.lang.Thread.run(Thread.java:534)
Caused by: net.sf.hibernate.JDBCException: could not initialize
collection:
[com.enginegreen.ledger.model.InvoiceSummary.orderS ummarySet#78828]
at
net.sf.hibernate.collection.AbstractCollectionPers ister.initialize(AbstractCollectionPersister.java: 287)
at
net.sf.hibernate.impl.SessionImpl.initializeCollec tion(SessionImpl.java:3226)
at
net.sf.hibernate.collection.PersistentCollection.f orceInitialization(PersistentCollection.java:340)
at
net.sf.hibernate.impl.SessionImpl.initializeNonLaz yCollections(SessionImpl.java:3089)
at
net.sf.hibernate.loader.Loader.doQueryAndInitializ eNonLazyCollections(Loader.java:138)
at net.sf.hibernate.loader.Loader.doList(Loader.java: 950)
at net.sf.hibernate.loader.Loader.list(Loader.java:94 1)
at
net.sf.hibernate.hql.QueryTranslator.list(QueryTra nslator.java:834)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl .java:1512)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.jav a:39)
at
com.enginegreen.ledger.invoice.impl.BillingClerkIm pl.renderInvoicesAsPDF(BillingClerkImpl.java:414)
... 42 more

******

Caused by: org.postgresql.util.PSQLException: ERROR: out of memory

at
org.postgresql.util.PSQLException.parseServerError (PSQLException.java:139)
at
org.postgresql.core.QueryExecutor.executeV3(QueryE xecutor.java:154)
at
org.postgresql.core.QueryExecutor.execute(QueryExe cutor.java:101)
at org.postgresql.core.QueryExecutor.execute(QueryExe cutor.java:43)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execut e(AbstractJdbc1Statement.java:515)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execut e(AbstractJdbc2Statement.java:50)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execut eQuery(AbstractJdbc1Statement.java:231)
at
net.sf.hibernate.impl.BatcherImpl.getResultSet(Bat cherImpl.java:87)
at net.sf.hibernate.loader.Loader.getResultSet(Loader .java:795)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java :189)
at
net.sf.hibernate.loader.Loader.doQueryAndInitializ eNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.loadCollection(Load er.java:910)
at net.sf.hibernate.loader.Loader.loadCollection(Load er.java:885)
at
net.sf.hibernate.loader.OneToManyLoader.initialize (OneToManyLoader.java:80)
at
net.sf.hibernate.collection.AbstractCollectionPers ister.initialize(AbstractCollectionPersister.java: 284)
... 52 more


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Rachel,

Most likely your data set coming back is too large to process all at
once. You need to set the fetch size on the statement to control the
number of records coming back per request for them.

ps.setFetchSize( 100 ); where ps is a prepared statement. The result
set will use a cursor to only bring back 100 records at a time and will
automatically fetch the next hundred until the entire result set has
been brought back.

Make sure that your JDBC statements don't have a semi colon at the end
of them otherwise the setFetchSize will be ignored and the entire result
set will be returned at once.

--sean
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.

* the JVM or servlet container might be out of memory, however the db
is on a different machine than the server so this doesn't seem likely

* Postgres might be out of memory. How would I check for this?
Subsequent requests go through just fine, as do any requests I make
directly using psql.

* something Else is happening

Any advice on how to attack this issue would be much appreciated!

Rachel McConnell
WARN [ SystemErrorInterceptor ] - java.util.NoSuchElementException
java.util.NoSuchElementException
at java.util.AbstractList$Itr.next(AbstractList.java: 426)
at java.util.Collections$6.nextElement(Collections.ja va:2479)
at
com.enginegreen.denali.interceptor.SystemErrorInte rceptor.intercept(SystemErrorInterceptor.java:89)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.interceptor.TimerIntercepto r.intercept(TimerInterceptor.java:62)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.DefaultActionProxy.execute( DefaultActionProxy.java:116)

at
com.opensymphony.webwork.dispatcher.ServletDispatc her.serviceAction(ServletDispatcher.java:182)

at
com.opensymphony.webwork.dispatcher.ServletDispatc her.service(ServletDispatcher.java:162)

at javax.servlet.http.HttpServlet.service(HttpServlet .java:103)
at
com.caucho.server.http.FilterChainServlet.doFilter (FilterChainServlet.java:96)

at
com.enginegreen.denali.chrome.filter.ChromeFilter. doFilter(ChromeFilter.java:57)

at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)

at
com.enginegreen.denali.interceptor.HibernateFilter .doFilter(HibernateFilter.java:42)

at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)

at
com.enginegreen.denali.action.DenaliFilter.doFilte r(DenaliFilter.java:28)
at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)

at com.caucho.server.http.Invocation.service(Invocati on.java:315)
at
com.caucho.server.http.CacheInvocation.service(Cac heInvocation.java:135)
at
com.caucho.server.http.RunnerRequest.handleRequest (RunnerRequest.java:346)

at
com.caucho.server.http.RunnerRequest.handleConnect ion(RunnerRequest.java:274)

at com.caucho.server.TcpConnection.run(TcpConnection. java:139)
at java.lang.Thread.run(Thread.java:534)
WARN [ SystemErrorInterceptor ] -
com.enginegreen.denali.persistence.PersistenceExce ption:
net.sf.hibernate.JDBCException: could not initialize collection:
[com.enginegreen.ledger.model.InvoiceSummary.orderS ummarySet#78828]
at
com.enginegreen.ledger.invoice.impl.BillingClerkIm pl.renderInvoicesAsPDF(BillingClerkImpl.java:429)

at
com.enginegreen.denali.domain.billing.BillingManag erImpl.finalizeNextBillingPeriod(BillingManagerImp l.java:248)

at
com.enginegreen.denali.domain.billing.SecureBillin gManager.finalizeNextBillingPeriod(SecureBillingMa nager.java:96)

at
com.enginegreen.denali.action.billing.GenerateInvo icesAction.doExecute(GenerateInvoicesAction.java:1 21)

at
com.enginegreen.denali.action.WorkflowActionSuppor t.execute(WorkflowActionSupport.java:65)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:172)

at
com.enginegreen.denali.interceptor.ActionSourceInt erceptor.intercept(ActionSourceInterceptor.java:50 )

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.enginegreen.denali.interceptor.NullInterceptor .intercept(NullInterceptor.java:25)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.interceptor.AroundIntercept or.intercept(AroundInterceptor.java:37)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.interceptor.AroundIntercept or.intercept(AroundInterceptor.java:37)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.interceptor.AroundIntercept or.intercept(AroundInterceptor.java:37)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.interceptor.AroundIntercept or.intercept(AroundInterceptor.java:37)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.interceptor.AroundIntercept or.intercept(AroundInterceptor.java:37)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.enginegreen.denali.interceptor.security.AdminS ecurityInterceptor.intercept(AdminSecurityIntercep tor.java:31)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.enginegreen.denali.interceptor.SystemErrorInte rceptor.intercept(SystemErrorInterceptor.java:47)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.interceptor.TimerIntercepto r.intercept(TimerInterceptor.java:62)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.DefaultActionProxy.execute( DefaultActionProxy.java:116)

at
com.opensymphony.webwork.dispatcher.ServletDispatc her.serviceAction(ServletDispatcher.java:182)

at
com.opensymphony.webwork.dispatcher.ServletDispatc her.service(ServletDispatcher.java:162)

at javax.servlet.http.HttpServlet.service(HttpServlet .java:103)
at
com.caucho.server.http.FilterChainServlet.doFilter (FilterChainServlet.java:96)

at
com.enginegreen.denali.chrome.filter.ChromeFilter. doFilter(ChromeFilter.java:57)

at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)

at
com.enginegreen.denali.interceptor.HibernateFilter .doFilter(HibernateFilter.java:42)

at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)

at
com.enginegreen.denali.action.DenaliFilter.doFilte r(DenaliFilter.java:28)
at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)

at com.caucho.server.http.Invocation.service(Invocati on.java:315)
at
com.caucho.server.http.CacheInvocation.service(Cac heInvocation.java:135)
at
com.caucho.server.http.RunnerRequest.handleRequest (RunnerRequest.java:346)

at
com.caucho.server.http.RunnerRequest.handleConnect ion(RunnerRequest.java:274)

at com.caucho.server.TcpConnection.run(TcpConnection. java:139)
at java.lang.Thread.run(Thread.java:534)
Caused by: net.sf.hibernate.JDBCException: could not initialize
collection:
[com.enginegreen.ledger.model.InvoiceSummary.orderS ummarySet#78828]
at
net.sf.hibernate.collection.AbstractCollectionPers ister.initialize(AbstractCollectionPersister.java: 287)

at
net.sf.hibernate.impl.SessionImpl.initializeCollec tion(SessionImpl.java:3226)

at
net.sf.hibernate.collection.PersistentCollection.f orceInitialization(PersistentCollection.java:340)

at
net.sf.hibernate.impl.SessionImpl.initializeNonLaz yCollections(SessionImpl.java:3089)

at
net.sf.hibernate.loader.Loader.doQueryAndInitializ eNonLazyCollections(Loader.java:138)

at net.sf.hibernate.loader.Loader.doList(Loader.java: 950)
at net.sf.hibernate.loader.Loader.list(Loader.java:94 1)
at
net.sf.hibernate.hql.QueryTranslator.list(QueryTra nslator.java:834)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl .java:1512)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.jav a:39)
at
com.enginegreen.ledger.invoice.impl.BillingClerkIm pl.renderInvoicesAsPDF(BillingClerkImpl.java:414)

... 42 more

******

Caused by: org.postgresql.util.PSQLException: ERROR: out of memory

at
org.postgresql.util.PSQLException.parseServerError (PSQLException.java:139)

at
org.postgresql.core.QueryExecutor.executeV3(QueryE xecutor.java:154)
at
org.postgresql.core.QueryExecutor.execute(QueryExe cutor.java:101)
at
org.postgresql.core.QueryExecutor.execute(QueryExe cutor.java:43)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execut e(AbstractJdbc1Statement.java:515)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.execut e(AbstractJdbc2Statement.java:50)

at
org.postgresql.jdbc1.AbstractJdbc1Statement.execut eQuery(AbstractJdbc1Statement.java:231)

at
net.sf.hibernate.impl.BatcherImpl.getResultSet(Bat cherImpl.java:87)
at net.sf.hibernate.loader.Loader.getResultSet(Loader .java:795)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java :189)
at
net.sf.hibernate.loader.Loader.doQueryAndInitializ eNonLazyCollections(Loader.java:133)

at net.sf.hibernate.loader.Loader.loadCollection(Load er.java:910)
at net.sf.hibernate.loader.Loader.loadCollection(Load er.java:885)
at
net.sf.hibernate.loader.OneToManyLoader.initialize (OneToManyLoader.java:80)

at
net.sf.hibernate.collection.AbstractCollectionPers ister.initialize(AbstractCollectionPersister.java: 284)

... 52 more


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #2

P: n/a
Rachel,

Most likely your data set coming back is too large to process all at
once. You need to set the fetch size on the statement to control the
number of records coming back per request for them.

ps.setFetchSize( 100 ); where ps is a prepared statement. The result
set will use a cursor to only bring back 100 records at a time and will
automatically fetch the next hundred until the entire result set has
been brought back.

Make sure that your JDBC statements don't have a semi colon at the end
of them otherwise the setFetchSize will be ignored and the entire result
set will be returned at once.

--sean
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.

* the JVM or servlet container might be out of memory, however the db
is on a different machine than the server so this doesn't seem likely

* Postgres might be out of memory. How would I check for this?
Subsequent requests go through just fine, as do any requests I make
directly using psql.

* something Else is happening

Any advice on how to attack this issue would be much appreciated!

Rachel McConnell
WARN [ SystemErrorInterceptor ] - java.util.NoSuchElementException
java.util.NoSuchElementException
at java.util.AbstractList$Itr.next(AbstractList.java: 426)
at java.util.Collections$6.nextElement(Collections.ja va:2479)
at
com.enginegreen.denali.interceptor.SystemErrorInte rceptor.intercept(SystemErrorInterceptor.java:89)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.interceptor.TimerIntercepto r.intercept(TimerInterceptor.java:62)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.DefaultActionProxy.execute( DefaultActionProxy.java:116)

at
com.opensymphony.webwork.dispatcher.ServletDispatc her.serviceAction(ServletDispatcher.java:182)

at
com.opensymphony.webwork.dispatcher.ServletDispatc her.service(ServletDispatcher.java:162)

at javax.servlet.http.HttpServlet.service(HttpServlet .java:103)
at
com.caucho.server.http.FilterChainServlet.doFilter (FilterChainServlet.java:96)

at
com.enginegreen.denali.chrome.filter.ChromeFilter. doFilter(ChromeFilter.java:57)

at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)

at
com.enginegreen.denali.interceptor.HibernateFilter .doFilter(HibernateFilter.java:42)

at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)

at
com.enginegreen.denali.action.DenaliFilter.doFilte r(DenaliFilter.java:28)
at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)

at com.caucho.server.http.Invocation.service(Invocati on.java:315)
at
com.caucho.server.http.CacheInvocation.service(Cac heInvocation.java:135)
at
com.caucho.server.http.RunnerRequest.handleRequest (RunnerRequest.java:346)

at
com.caucho.server.http.RunnerRequest.handleConnect ion(RunnerRequest.java:274)

at com.caucho.server.TcpConnection.run(TcpConnection. java:139)
at java.lang.Thread.run(Thread.java:534)
WARN [ SystemErrorInterceptor ] -
com.enginegreen.denali.persistence.PersistenceExce ption:
net.sf.hibernate.JDBCException: could not initialize collection:
[com.enginegreen.ledger.model.InvoiceSummary.orderS ummarySet#78828]
at
com.enginegreen.ledger.invoice.impl.BillingClerkIm pl.renderInvoicesAsPDF(BillingClerkImpl.java:429)

at
com.enginegreen.denali.domain.billing.BillingManag erImpl.finalizeNextBillingPeriod(BillingManagerImp l.java:248)

at
com.enginegreen.denali.domain.billing.SecureBillin gManager.finalizeNextBillingPeriod(SecureBillingMa nager.java:96)

at
com.enginegreen.denali.action.billing.GenerateInvo icesAction.doExecute(GenerateInvoicesAction.java:1 21)

at
com.enginegreen.denali.action.WorkflowActionSuppor t.execute(WorkflowActionSupport.java:65)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:172)

at
com.enginegreen.denali.interceptor.ActionSourceInt erceptor.intercept(ActionSourceInterceptor.java:50 )

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.enginegreen.denali.interceptor.NullInterceptor .intercept(NullInterceptor.java:25)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.interceptor.AroundIntercept or.intercept(AroundInterceptor.java:37)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.interceptor.AroundIntercept or.intercept(AroundInterceptor.java:37)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.interceptor.AroundIntercept or.intercept(AroundInterceptor.java:37)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.interceptor.AroundIntercept or.intercept(AroundInterceptor.java:37)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.interceptor.AroundIntercept or.intercept(AroundInterceptor.java:37)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.enginegreen.denali.interceptor.security.AdminS ecurityInterceptor.intercept(AdminSecurityIntercep tor.java:31)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.enginegreen.denali.interceptor.SystemErrorInte rceptor.intercept(SystemErrorInterceptor.java:47)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.interceptor.TimerIntercepto r.intercept(TimerInterceptor.java:62)

at
com.opensymphony.xwork.DefaultActionInvocation.inv oke(DefaultActionInvocation.java:169)

at
com.opensymphony.xwork.DefaultActionProxy.execute( DefaultActionProxy.java:116)

at
com.opensymphony.webwork.dispatcher.ServletDispatc her.serviceAction(ServletDispatcher.java:182)

at
com.opensymphony.webwork.dispatcher.ServletDispatc her.service(ServletDispatcher.java:162)

at javax.servlet.http.HttpServlet.service(HttpServlet .java:103)
at
com.caucho.server.http.FilterChainServlet.doFilter (FilterChainServlet.java:96)

at
com.enginegreen.denali.chrome.filter.ChromeFilter. doFilter(ChromeFilter.java:57)

at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)

at
com.enginegreen.denali.interceptor.HibernateFilter .doFilter(HibernateFilter.java:42)

at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)

at
com.enginegreen.denali.action.DenaliFilter.doFilte r(DenaliFilter.java:28)
at
com.caucho.server.http.FilterChainFilter.doFilter( FilterChainFilter.java:88)

at com.caucho.server.http.Invocation.service(Invocati on.java:315)
at
com.caucho.server.http.CacheInvocation.service(Cac heInvocation.java:135)
at
com.caucho.server.http.RunnerRequest.handleRequest (RunnerRequest.java:346)

at
com.caucho.server.http.RunnerRequest.handleConnect ion(RunnerRequest.java:274)

at com.caucho.server.TcpConnection.run(TcpConnection. java:139)
at java.lang.Thread.run(Thread.java:534)
Caused by: net.sf.hibernate.JDBCException: could not initialize
collection:
[com.enginegreen.ledger.model.InvoiceSummary.orderS ummarySet#78828]
at
net.sf.hibernate.collection.AbstractCollectionPers ister.initialize(AbstractCollectionPersister.java: 287)

at
net.sf.hibernate.impl.SessionImpl.initializeCollec tion(SessionImpl.java:3226)

at
net.sf.hibernate.collection.PersistentCollection.f orceInitialization(PersistentCollection.java:340)

at
net.sf.hibernate.impl.SessionImpl.initializeNonLaz yCollections(SessionImpl.java:3089)

at
net.sf.hibernate.loader.Loader.doQueryAndInitializ eNonLazyCollections(Loader.java:138)

at net.sf.hibernate.loader.Loader.doList(Loader.java: 950)
at net.sf.hibernate.loader.Loader.list(Loader.java:94 1)
at
net.sf.hibernate.hql.QueryTranslator.list(QueryTra nslator.java:834)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl .java:1512)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.jav a:39)
at
com.enginegreen.ledger.invoice.impl.BillingClerkIm pl.renderInvoicesAsPDF(BillingClerkImpl.java:414)

... 42 more

******

Caused by: org.postgresql.util.PSQLException: ERROR: out of memory

at
org.postgresql.util.PSQLException.parseServerError (PSQLException.java:139)

at
org.postgresql.core.QueryExecutor.executeV3(QueryE xecutor.java:154)
at
org.postgresql.core.QueryExecutor.execute(QueryExe cutor.java:101)
at
org.postgresql.core.QueryExecutor.execute(QueryExe cutor.java:43)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execut e(AbstractJdbc1Statement.java:515)

at
org.postgresql.jdbc2.AbstractJdbc2Statement.execut e(AbstractJdbc2Statement.java:50)

at
org.postgresql.jdbc1.AbstractJdbc1Statement.execut eQuery(AbstractJdbc1Statement.java:231)

at
net.sf.hibernate.impl.BatcherImpl.getResultSet(Bat cherImpl.java:87)
at net.sf.hibernate.loader.Loader.getResultSet(Loader .java:795)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java :189)
at
net.sf.hibernate.loader.Loader.doQueryAndInitializ eNonLazyCollections(Loader.java:133)

at net.sf.hibernate.loader.Loader.loadCollection(Load er.java:910)
at net.sf.hibernate.loader.Loader.loadCollection(Load er.java:885)
at
net.sf.hibernate.loader.OneToManyLoader.initialize (OneToManyLoader.java:80)

at
net.sf.hibernate.collection.AbstractCollectionPers ister.initialize(AbstractCollectionPersister.java: 284)

... 52 more


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #3

P: n/a


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

Nov 23 '05 #4

P: n/a


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

Nov 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.