History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: QB-2410
Type: Bug Bug
Status: Closed Closed
Resolution: Won't Fix
Priority: Major Major
Assignee: Steve Luo
Reporter: Julian Bassett
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
QuickBuild

org.h2.jdbc.JdbcSQLException: Out of memory. [90108-175]

Created: 16/Apr/15 01:54 PM   Updated: 20/May/15 08:37 AM
Component/s: None
Affects Version/s: 5.1.31
Fix Version/s: None

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown
File Attachments: None
Image Attachments:

1. screenshot-1.jpg
(255 kb)


 Description  « Hide
There seems to be a problem with the reports plugin

2015-04-16 00:04:32,583 [pool-1-thread-22217] ERROR com.pmease.quickbuild.DefaultBuildEngine - Error processing build request.
    com.pmease.quickbuild.plugin.report.engine.exception.DatabaseException: Open database [/xxx/builds/432446/reports/jira/DEFAULT] failed. Database status [No active connections].
        at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.open(DbStore.java:355)
        at com.pmease.quickbuild.plugin.report.engine.metadata.ReportCategory.saveReport(ReportCategory.java:367)
        at com.pmease.quickbuild.plugin.report.engine.metadata.ReportCategory.saveReport(ReportCategory.java:379)
        at com.pmease.quickbuild.plugin.tracker.core.contribution.IssuesBuildListener.buildFinished(IssuesBuildListener.java:147)
        at com.pmease.quickbuild.DefaultBuildEngine.run(DefaultBuildEngine.java:654)
        at com.pmease.quickbuild.DefaultBuildEngine.process(DefaultBuildEngine.java:379)
        at com.pmease.quickbuild.DefaultBuildEngine.access$000(DefaultBuildEngine.java:130)
        at com.pmease.quickbuild.DefaultBuildEngine$2.run(DefaultBuildEngine.java:1081)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:722)
    Caused by: com.pmease.quickbuild.plugin.report.engine.exception.DatabaseException: Unable to get connection from database url: jdbc:h2:/xxx/builds/432446/reports/jira/DEFAULT/jira
        at com.pmease.quickbuild.plugin.report.engine.datastore.ConnectionManager.getConnection(ConnectionManager.java:25)
        at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.getConnection(DbStore.java:384)
        at com.pmease.quickbuild.plugin.report.engine.datastore.DbStore.open(DbStore.java:308)
        ... 13 more
    Caused by: org.h2.jdbc.JdbcSQLException: Out of memory. [90108-175]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
        at org.h2.message.DbException.get(DbException.java:161)
        at org.h2.message.DbException.convert(DbException.java:278)
        at org.h2.engine.Database.openDatabase(Database.java:274)
        at org.h2.engine.Database.<init>(Database.java:239)
        at org.h2.engine.Engine.openSession(Engine.java:58)
        at org.h2.engine.Engine.openSession(Engine.java:162)
        at org.h2.engine.Engine.createSessionAndValidate(Engine.java:141)
        at org.h2.engine.Engine.createSession(Engine.java:124)
        at org.h2.engine.Engine.createSession(Engine.java:30)
        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:323)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:105)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:90)
        at org.h2.Driver.connect(Driver.java:73)
        at java.sql.DriverManager.getConnection(DriverManager.java:579)
        at java.sql.DriverManager.getConnection(DriverManager.java:221)
        at com.pmease.quickbuild.plugin.report.engine.datastore.ConnectionManager.getConnection(ConnectionManager.java:23)
        ... 15 more
    Caused by: java.lang.OutOfMemoryError: unable to create new native thread
        at org.h2.engine.Database.openDatabase(Database.java:261)
        ... 28 more


 All   Comments   Work Log   Change History      Sort Order:
Steve Luo [18/Apr/15 04:11 AM]
For this issue, there are two most possible reason:

1. The memory of your QuickBuild instance is small, you can increase the memory by editing file:
    $(quickbuild-home}/conf/wrapper.conf
    and change the line:
    wrapper.java.maxmemory=a bigger memory

2. The database itself is too large for QuickBuild to open. You can check below file to see how large this file is:
     /xxx/builds/432446/reports/jira/DEFAULT/jira.h2.db
    If this file is very large, you still have to add more memory to QuickBuild like aforementioned way.


Julian Bassett [23/Apr/15 09:11 AM]
The same (or at least similar) problem has occured again.
Memory seems to be enough
This time its a very small project ( 2 classes, 2 test classes)
The db file is not big.

Open database [/wxx/data/quickbuild/global-storage/root/svn2.eil.risnet.de/tools/ci/reports-example-ci/branches/systems/commit-stage/configurations/15866/reports/buildstats/DEFAULT] failed. Database status [No active connections].
caused by: Unable to get connection from database url: jdbc:h2:/wxx/data/quickbuild/global-storage/root/svn2.eil.risnet.de/tools/ci/reports-example-ci/branches/systems/commit-stage/configurations/15866/reports/buildstats/DEFAULT/buildstats
caused by: Out of memory. [90108-175]
caused by: unable to create new native thread

from build Log:

00:00:35,665 INFO - Checking out revision '1865490' of repository 'mainstream-repo'...
00:00:35,665 INFO - Checking out (url: http://xxx.de/tools/ci/reports-example//branches/systems, to: /wxx/app/buildagent/workspace/root/xxx.de/tools/ci/reports-example-ci/branches/systems/commit-stage, revision: 1865490)
00:00:40,994 INFO - Getting changes of 'mainstream-repo' since build '3.0.0-SNAPSHOT'...
00:00:41,453 INFO - Executing post-execute action...
00:00:41,453 ERROR - Step 'master>stage-commit>workspace-checkout_head' is failed: Open database [/wxx/data/quickbuild/global-storage/root/svn2.eil.risnet.de/tools/ci/reports-example-ci/branches/systems/commit-stage/builds/440118/reports/scm_activity/DEFAULT] failed. Database status [No active connections].

the contents of DEFAULT

[user@vvm780 DEFAULT]$ pwd
/xxx/quickbuild/global-storage/root/xxx/tools/ci/reports-example-ci/branches/systems/commit-stage/configurations/15866/reports/buildstats/DEFAULT
[user@vvm780 DEFAULT]$ ll
total 64
-rw-r--r--. 1 user group 59392 Apr 22 16:19 buildstats.h2.db
-rw-r--r--. 1 user group 100 Apr 23 00:00 buildstats.lock.db
-rw-r--r--. 1 user group 62 Apr 22 16:19 latest.id
[user@vvm780 DEFAULT]$

Please help


Steve Luo [23/Apr/15 09:36 AM]
How about restart your QuickBuild? I suggest you can restart the QuickBuild, in most cases, this can help h2 to recover from the previous error.

And how about upgrade to the latest QuickBuild, as we have upgraded h2 to version 1.3.175, it fixes some memory leak issue.

Julian Bassett [23/Apr/15 09:38 AM]
ok, will restart

Upgrading is on our road map, we may now speed it up.

thank you

Julian Bassett [12/May/15 07:29 AM]
Hello Steve,
we have upgraded on the weekend to version 6.0.11
the problem unfortunately remains.

Open database [/wxx/data/quickbuild/global-storage/root/xxxnet.de/rpo/Libraries/XXXXCommon/branches/RISplus/commit-stage/builds/460838/reports/jira/DEFAULT] failed. Database status [No active connections].
caused by: Unable to get connection from database url: jdbc:h2:/wxx/data/quickbuild/global-storage/root/xxxnet.de/rpo/Libraries/XXXXCommon/branches/RISplus/commit-stage/builds/460838/reports/jira/DEFAULT/jira
caused by: Out of memory. [90108-175]
caused by: unable to create new native thread

Julian Bassett [12/May/15 07:41 AM]
overview

Julian Bassett [12/May/15 07:43 AM]
The error message was from 00:06:25,132 12th May 2015

Steve Luo [12/May/15 07:59 AM]
Is it possible to share your database to me? That is create a zip file by compressing the directory below:
/wxx/data/quickbuild/global-storage/root/xxxnet.de/rpo/Libraries/XXXXCommon/branches/RISplus/commit-stage/builds/460838/reports/jira/

Julian Bassett [20/May/15 07:49 AM]
Hi Steve, thanks for your help on this matter after raising the ulimit for our linux user the problem has not occured again.
please close the ticket.