[ 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