[ 
http://jira.codehaus.org/browse/CONTINUUM-1353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_122532
 ] 

tony nys commented on CONTINUUM-1353:
-------------------------------------

Currently we are using beta-4 in production.
Until now, we didn't have the problem.

Before the upgrade we used a workaround, a small sql program/script which 
regularly cleans up the db.
This script can be run also from continuum.
In this way, the berkely db tables are cleaned up.



> after a few weeks, continuum runs into outofmemory error
> --------------------------------------------------------
>
>                 Key: CONTINUUM-1353
>                 URL: http://jira.codehaus.org/browse/CONTINUUM-1353
>             Project: Continuum
>          Issue Type: Bug
>          Components: Core system
>    Affects Versions: 1.1-alpha-2
>            Reporter: tony nys
>            Priority: Blocker
>
> when clicking on the build history, memory of the jvm increases from 100MB 
> until 470MB
> after that it crashes with outofmemory error (JDO exception)
> Increasing the plexus jvm memory does have no affect: 
> %PLEXUS_JAVA_EXE% %PLEXUS_OPTS% -Xmx900M -XX:MaxPermSize=128m -classpath 
> "%PLEXUS_HOME%\core\boot\plexus-classworlds-1.2-alpha-7.jar" 
> -Dclassworlds.conf="%PLEXUS_HOME%\conf\classworlds.conf" 
> -Dplexus.core=%PLEXUS_CORE% -Dplexus.system.path="%PATH%" 
> -Djava.io.tmpdir=%PLEXUS_TMPDIR% -Dplexus.home="%PLEXUS_HOME%" 
> -Dappserver.base="%PLEXUS_BASE%" -Dtools.jar="%TOOLS_JAR%" 
> org.codehaus.plexus.classworlds.launcher.Launcher %PLEXUS_CMD_LINE_ARGS%
> So probably bug in fetch from db where all objects are retrieved ?
> For us this is a showstopper. Would MySQL DB be a workaround ? I guess the 
> query is the same, so will the memory usage be ?
> Where can I find the complete DDL script for mysql ? On the wiki there is 
> only 1 table ... ?
> javax.jdo.JDODataStoreException: Iteration request failed : 
> SELECT 
> THIS.CHANGEFILE_ID,THIS.MODEL_ENCODING,THIS."NAME",THIS.REVISION,THIS.STATUS,THIS.FILES_INTEGER_IDX
>  AS JPOXORDER0 FROM 
> CHANGEFILE THIS WHERE ? = THIS.FILES_CHANGESET_ID_OID AND 
> THIS.FILES_INTEGER_IDX >= ? ORDER BY JPOXORDER0 NestedThrowables: SQL 
> Exception: Java exception: 
> 'Java heap space: java.lang.OutOfMemoryError'.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to