| << Back to previous view |
|
[QB-2410] org.h2.jdbc.JdbcSQLException: Out of memory. [90108-175]
|
|
| Status: | Closed |
| Project: | QuickBuild |
| Component/s: | None |
| Affects Version/s: | 5.1.31 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Julian Bassett | Assigned To: | Steve Luo |
| Resolution: | Won't Fix | Votes: | 0 |
| Remaining Estimate: | Unknown | Time Spent: | Unknown |
| Original Estimate: | Unknown | ||
| File Attachments: |
screenshot-1.jpg
|
| Description |
|
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 |
| Comments |
| Comment by 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. |
| Comment by 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 |
| Comment by 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. |
| Comment by 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 |
| Comment by 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 |
| Comment by Julian Bassett [ 12/May/15 07:41 AM ] |
| overview |
| Comment by Julian Bassett [ 12/May/15 07:43 AM ] |
| The error message was from 00:06:25,132 12th May 2015 |
| Comment by 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/ |
| Comment by 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. |