Hi,
I have been recieving alot of emails from ofbiz, please kindly exclude me from your mailing list.
Thanks.
From: BJ Freeman <[EMAIL PROTECTED]>
Reply-To: [email protected]
To: [email protected]
Subject: Re: java.lang.OutOfMemoryError - still, please some advice?
Date: Mon, 31 Jul 2006 13:37:38 -0700
>I think the confusion is the cursors was for Import and Export, in
>web tools based on the email dated back in may.
>
>Ruth Hoffman sent the following on 7/31/2006 12:59 PM:
>>Hi BJ:
>>Thanks for the quick reply.
>>
>>In a recent email where I reported the same problem in an older
>>version of OFBiz, David and several others suggested that this had
>>been fixed or rather Webtools had been changed to use cursors. I'm
>>here to report that it does not appear to have any effect. I still
>>get an OutOfMemoryError.
>>
>>When I set xms (for example: MEMIF="-Xms512M -Xmx512M") I get the
>>following error (which was the subject of my orginal post - some
>>time ago - about Geronimo time outs):
>>
>>006-07-31 14:50:35,443 (http-0.0.0.0-8443-Processor2) [
>>RequestHandler.java:538:INFO ] servletName=control,
>>view=FindGeneric
>>2006-07-31 14:50:35,452 (http-0.0.0.0-8443-Processor2) [
>> Region.java:107:INFO ] real path for
>>[/templates/main_template.jsp] is:
>>/Users/ruthhoffman/427128ofbiz/framework/webtools/webapp/webtools/templates/main_template.jsp
>>
>>2006-07-31 14:52:21,717 (http-0.0.0.0-8443-Processor2)
>>[InheritableTransactionContext.java:311:ERROR] Unable to roll back
>>transaction
>>java.lang.IllegalStateException: Status is STATUS_NO_TRANSACTION
>> at
>>org.apache.geronimo.transaction.manager.TransactionImpl.rollback(TransactionImpl.java:438)
>>
>> at
>>org.apache.geronimo.transaction.context.InheritableTransactionContext.rollbackAndThrow(InheritableTransactionContext.java:308)
>>
>> at
>>org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:199)
>>
>> at
>>org.apache.geronimo.transaction.context.InheritableTransactionContext.commit(InheritableTransactionContext.java:146)
>>
>> at
>>org.apache.geronimo.transaction.context.GeronimoTransactionManager.commit(GeronimoTransactionManager.java:81)
>>
>> at
>>org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:181)
>>
>> at
>>org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:167)
>>
>> at
>>org.apache.jsp.entity.FindGeneric_jsp._jspService(FindGeneric_jsp.java:188)
>> at
>>org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
>> at
>>javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>> at
>>org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
>>
>> at
>>org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
>>++++++ lots of stuff left out +++++++++
>>java.lang.Exception: Stack trace
>> at java.lang.Thread.dumpStack(Thread.java:1082)
>> at
>>org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:194)
>>
>> at
>>org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:167)
>>
>> at
>>org.apache.jsp.entity.FindGeneric_jsp._jspService(FindGeneric_jsp.java:188)
>> at
>>org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
>> at
>>javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>> at
>>org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
>>
>> at
>>org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
>> at
>>org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
>>+++++ more stuff left out ++++++
>>java.lang.Thread.run(Thread.java:552)
>>javax.transaction.RollbackException: Transaction timout
>>org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:236)
>>
>>org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:143)
>>
>>org.apache.geronimo.transaction.context.InheritableTransactionContext.complete(InheritableTransactionContext.java:196)
>>
>>org.apache.geronimo.transaction.context.InheritableTransactionContext.commit(InheritableTransactionContext.java:146)
>>
>>org.apache.geronimo.transaction.context.GeronimoTransactionManager.commit(GeronimoTransactionManager.java:81)
>>
>>org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:181)
>>
>>org.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:167)
>>
>>org.apache.jsp.entity.FindG eneric_jsp._jspService(FindGeneric_jsp.java:188)
>>org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
>>javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>+++++ and on it goes ++++++
>>
>>
>>BJ Freeman wrote:
>>
>>>I am guessing, and david will correct me, that the view has not be
>>>set to use the cursors.
>>>I am not sure if the widgets next and previous are setup to switch
>>>to cursors if the data exceeds a certian amount.
>>>would be a nice feature though.
>>>
>>>Th only other options is to increase the Xms to more till you
>>>don't get the out of memory.
>>>
>>>if on windows, this will slow down the response, if the max you
>>>put in exceeds real memory.
>>>
>>>
>>>Ruth Hoffman sent the following on 7/31/2006 12:04 PM:
>>>
>>>>To be more precise, the table that I am trying to view has:
>>>>1,571,094 records.
>>>>
>>>>Ruth Hoffman wrote:
>>>>
>>>>>Hello All:
>>>>>Finally had a chance to try a recent version of OFBiz Webtools
>>>>>against my 14M+ record database. The only thing I'm doing here
>>>>>is selecting the Entity Reference tool & then selecting the link
>>>>>to "view data". As you can see, I'm still getting that nasty out
>>>>>of memory error. Here's some of the log file:
>>>>>
>>>>> 2006-07-31 13:38:00,996 (http-0.0.0.0-8443-Processor2) [
>>>>> Region.java:107:INFO ] real path for
>>>>>[/templates/main_template.jsp]
>>>>> is:
>>>>>
>>>>>/Users/ruthhoffman/427128ofbiz/framework/webtools/webapp/webtools/templates/main_template.jsp
>>>>>
>>>>> 2006-07-31 13:38:20,017 (http-0.0.0.0-8443-Processor4) [
>>>>> ContextFilter.java:183:INFO ] [Request]:
>>>>>/webtools/control/FindGeneric
>>>>> 2006-07-31 13:38:20,019 (http-0.0.0.0-8443-Processor4) [
>>>>> ControlServlet.java:90 :INFO ] The character encoding of the
>>>>>request
>>>>> is: [null]. The character encoding we will use for the
>>>>>request and
>>>>> response is: [UTF-8]
>>>>> 2006-07-31 13:38:20,021 (http-0.0.0.0-8443-Processor4) [
>>>>> ControlServlet.java:126:DEBUG] [[[FindGeneric] Servlet
>>>>>Starting,
>>>>> doing setup- total:0.0,since last(Begin):0.0]]
>>>>> 2006-07-31 13:38:20,023 (http-0.0.0.0-8443-Processor4) [
>>>>> ControlServlet.java:175:DEBUG] [[[FindGeneric] Setup done,
>>>>>doing
>>>>> Event(s) and View(s)- total:0.0,since last([FindGeneric]
>>>>>Ser...):0.0]]
>>>>> 2006-07-31 13:38:20,052 (http-0.0.0.0-8443-Processor4) [
>>>>> UtilXml.java:255:DEBUG] XML Read 0.026s:
>>>>> jndi:/0.0.0.0/webtools/WEB-INF/controller.xml
>>>>> 2006-07-31 13:38:20,056 (http-0.0.0.0-8443-Processor4) [
>>>>> ConfigXMLReader.java:544:INFO ] ConfigMap Created: (4) records
>>>>>in
>>>>> 0.0010s
>>>>> 2006-07-31 13:38:20,058 (http-0.0.0.0-8443-Processor4) [
>>>>> ConfigXMLReader.java:614:INFO ] HandlerMap Created: (2)
>>>>>records in 0.0s
>>>>> 2006-07-31 13:38:20,064 (http-0.0.0.0-8443-Processor4) [
>>>>> ConfigXMLReader.java:294:INFO ] RequestMap Created: (78)
>>>>>records in
>>>>> 0.0040s
>>>>> 2006-07-31 13:38:20,067 (http-0.0.0.0-8443-Processor4) [
>>>>> ConfigXMLReader.java:403:INFO ] ViewMap Created: (51) records
>>>>>in 0.0010s
>>>>> 2006-07-31 13:38:20,069 (http-0.0.0.0-8443-Processor4) [
>>>>> RequestHandler.java:203:INFO ] [Processing Request]:
>>>>>FindGeneric
>>>>> 2006-07-31 13:38:20,111 (http-0.0.0.0-8443-Processor4) [
>>>>> RequestManager.java:114:INFO ]
>>>>>[RequestManager.getRequestAttribute]
>>>>> Value for attribute "null" of uri "FindGeneric" not found
>>>>> 2006-07-31 13:38:20,113 (http-0.0.0.0-8443-Processor4) [
>>>>> RequestHandler.java:386:INFO ] [RequestHandler.doRequest]:
>>>>>Response
>>>>> is a view.
>>>>> 2006-07-31 13:38:20,115 (http-0.0.0.0-8443-Processor4) [
>>>>> RequestHandler.java:538:INFO ] servletName=control,
>>>>>view=FindGeneric
>>>>> 2006-07-31 13:38:20,117 (http-0.0.0.0-8443-Processor4) [
>>>>> Region.java:107:INFO ] real path for
>>>>>[/templates/main_template.jsp]
>>>>> is:
>>>>>
>>>>>/Users/ruthhoffman/427128ofbiz/framework/webtools/webapp/webtools/templates/main_template.jsp
>>>>>
>>>>> 2006-07-31 13:38:22,206 (http-0.0.0.0-8443-Processor4)
>>>>> [XAConnectionFactory.java:119:WARN ] no xares in rms for con
>>>>>
>>>>>[EMAIL PROTECTED]
>>>>> 2006-07-31 13:39:08,143 (http-0.0.0.0-8443-Processor4)
>>>>> [ApplicationDispatcher.java:704:ERROR] Servlet.service() for
>>>>>servlet
>>>>> jsp threw exception
>>>>> java.lang.OutOfMemoryError
>>>>> 2006-07-31 13:39:08,261 (http-0.0.0.0-8443-Processor4) [
>>>>> JspViewHandler.java:88 :ERROR]
>>>>> ---- exception report
>>>>> ----------------------------------------------------------
>>>>> ServletException rendering JSP view
>>>>> Exception: javax.servlet.ServletException
>>>>> Message: null
>>>>> ---- stack trace
>>>>>
>>>>>---------------------------------------------------------------
>>>>> javax.servlet.ServletException
>>>>>
>>>>>org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
>>>>>
>>>>>
>>>>>org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
>>>>>
>>>>>
>>>>>org.apache.jsp.entity.FindGeneric_jsp._jspService(FindGeneric_jsp.java:838)
>>>>>
>>>>>
>>>>>org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
& gt;>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>>>>
>>>>>org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
>>>>>
>>>>>
>>>>>org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
>>>>>
>>>>>
>>>>>org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
>>>>> javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>>>> org.apache.catalina.core.ApplicationFilterCha..
>>>>>
>>>>>To recap:
>>>>>OFBiz version: 427128 (checked out today - July 31, 2006)
>>>>>Postgres info from OFBiz log file:
>>>>>2006-07-31 13:36:04,584 (main) [
>>>>>DatabaseUtil.java:765:INFO ] Database Product Name is PostgreSQL
>>>>>2006-07-31 13:36:04,586 (main) [
>>>>>DatabaseUtil.java:766:INFO ] Database Product Version is 7.4.7
>>>>>2006-07-31 13:36:04,588 (main) [
>>>>>DatabaseUtil.java:774:INFO ] Database Driver Name is PostgreSQL
>>>>>Native Driver
>>>>>2006-07-31 13:36:04,590 (main) [
>>>>>DatabaseUtil.java:775:INFO ] Database Driver Version is
>>>>>PostgreSQL 8.0 JDBC3 with SSL (build 311)
>>>>>2006-07-31 13:36:04,591 (main) [
>>>>>DatabaseUtil.java:776:INFO ] Database Driver JDBC Version is 3.0
>>>>>
>>>>>Also, I'm having the same problem when I try to programmatically
>>>>>access this database and attempt to set the
>>>>>TYPE_SCROLL_INSENSITIVE. The Entity Engine never returns from a
>>>>>call - just runs out of memory.
>>>>>
>>>>>Ruth
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
