update from 6.0.0, Error processing build request #3348

pureivan · 9 years ago

use 6.0.28, update from 6.0.0
when the build flinish，in dashboard，will see exclamation mark near the configuration。
how to fix ？
see the server log：

2015-10-16 14:38:30,281 [pool-1-thread-180] ERROR com.pmease.quickbuild.DefaultBuildEngine - Error processing build request.
com.pmease.quickbuild.plugin.report.engine.exception.DatabaseException: Open database [D:\datas\qb_home\configurations\14\reports\scm_activity\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.changes.generator.ChangesStatsGenerator.generate(ChangesStatsGenerator.java:40)
at com.pmease.quickbuild.plugin.report.engine.contribution.publisher.StatisticsReportPublisher.doPublish(StatisticsReportPublisher.java:133)
at com.pmease.quickbuild.plugin.report.engine.contribution.publisher.StatisticsReportPublisher.collectStatistics(StatisticsReportPublisher.java:111)
at com.pmease.quickbuild.DefaultBuildEngine.process(DefaultBuildEngine.java:410)
at com.pmease.quickbuild.DefaultBuildEngine.access$000(DefaultBuildEngine.java:139)
at com.pmease.quickbuild.DefaultBuildEngine$2.run(DefaultBuildEngine.java:1102)
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:745)
Caused by: com.pmease.quickbuild.plugin.report.engine.exception.DatabaseException: Unable to get connection from database url: jdbc:h2:D:/datas/qb_home/configurations/14/reports/scm_activity/DEFAULT/scm_activity
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:349)
... 9 more
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.ArrayIndexOutOfBoundsException: 4096" [50000-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:284)
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:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at com.pmease.quickbuild.plugin.report.engine.datastore.ConnectionManager.getConnection(ConnectionManager.java:23)
... 11 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 4096
at org.h2.store.Data.writeVarInt(Data.java:1167)
at org.h2.store.Data.writeValue(Data.java:523)
at org.h2.index.PageBtreeIndex.writeRow(PageBtreeIndex.java:388)
at org.h2.index.PageBtreeNode.writeData(PageBtreeNode.java:446)
at org.h2.index.PageBtreeNode.write(PageBtreeNode.java:420)
at org.h2.store.PageStore.writeBack(PageStore.java:1015)
at org.h2.store.PageStore.writeBack(PageStore.java:412)
at org.h2.store.PageStore.recover(PageStore.java:1401)
at org.h2.store.PageStore.openExisting(PageStore.java:361)
at org.h2.store.PageStore.open(PageStore.java:285)
at org.h2.engine.Database.getPageStore(Database.java:2298)
at org.h2.engine.Database.open(Database.java:626)
at org.h2.engine.Database.openDatabase(Database.java:244)
... 24 more

replies 2
views 2628
stars 0

steveluo ADMIN · 9 years ago

It seems that the h2 database is corrupt. Please delete below directory:
D:\datas\qb_home\configurations\14\reports\scm_activity\DEFAULT

You can rebuild the SCM data as the following page:

http://wiki.pmease.com/display/QB60/Reb ... ation+data

pureivan · 9 years ago

[quote="steveluo"]It seems that the h2 database is corrupt. Please delete below directory:
D:\datas\qb_home\configurations\14\reports\scm_activity\DEFAULT

You can rebuild the SCM data as the following page:

http://wiki.pmease.com/display/QB60/Reb ... ation+data[/quote]

do this failed
17:40:03,374 ERROR - Step 'master>testrebuild' is failed.
com.pmease.quickbuild.plugin.report.engine.exception.DatabaseException: Open database [D:\datas\qb_home\builds\4642\reports\scm_activity\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.changes.ChangesHelper.getBuildChangesets(ChangesHelper.java:282)
at com.pmease.quickbuild.plugin.report.changes.generator.DefaultChangesRecorder.read(DefaultChangesRecorder.java:53)
at com.pmease.quickbuild.ServerServiceImpl.readChanges(ServerServiceImpl.java:305)
at com.pmease.quickbuild.model.Build.getChanges(Build.java:616)
at com.pmease.quickbuild.plugin.report.changes.generator.ChangesStatsProvider.isApplicable(ChangesStatsProvider.java:20)
at com.pmease.quickbuild.plugin.report.engine.contribution.publisher.StatisticsReportPublisher.collectStatistics(StatisticsReportPublisher.java:72)
at com.pmease.quickbuild.maintenance.StatisticsRebuildStep.rebuildStatistics(StatisticsRebuildStep.java:136)
at com.pmease.quickbuild.maintenance.StatisticsRebuildStep.run(StatisticsRebuildStep.java:112)
at com.pmease.quickbuild.maintenance.StatisticsRebuildStep$$EnhancerByCGLIB$$4dbe8b32.CGLIB$run$0(<generated>)
at com.pmease.quickbuild.maintenance.StatisticsRebuildStep$$EnhancerByCGLIB$$4dbe8b32$$FastClassByCGLIB$$a01613b0.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:215)
at com.pmease.quickbuild.DefaultScriptEngine$Interpolator.intercept(DefaultScriptEngine.java:273)
at com.pmease.quickbuild.maintenance.StatisticsRebuildStep$$EnhancerByCGLIB$$4dbe8b32.run(<generated>)
at com.pmease.quickbuild.stepsupport.Step.execute(Step.java:539)
at com.pmease.quickbuild.stepsupport.StepExecutionJob.executeStepAwareJob(StepExecutionJob.java:30)
at com.pmease.quickbuild.stepsupport.StepAwareJob.executeBuildAwareJob(StepAwareJob.java:45)
at com.pmease.quickbuild.BuildAwareJob.execute(BuildAwareJob.java:60)
at com.pmease.quickbuild.grid.GridJob.run(GridJob.java:106)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
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:745)
Caused by: com.pmease.quickbuild.plugin.report.engine.exception.DatabaseException: Unable to get connection from database url: jdbc:h2:D:/datas/qb_home/builds/4642/reports/scm_activity/DEFAULT/scm_activity;ACCESS_MODE_DATA=r
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:322)
... 23 more
Caused by: org.h2.jdbc.JdbcSQLException: The database is read only [90097-175]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:172)
at org.h2.message.DbException.get(DbException.java:149)
at org.h2.message.DbException.get(DbException.java:138)
at org.h2.engine.Database.checkWritingAllowed(Database.java:1784)
at org.h2.store.PageStore.logUndo(PageStore.java:1030)
at org.h2.store.PageFreeList.allocate(PageFreeList.java:97)
at org.h2.store.PageStore.allocatePage(PageStore.java:1160)
at org.h2.store.PageStore.allocatePage(PageStore.java:1147)
at org.h2.index.PageDataIndex.<init>(PageDataIndex.java:80)
at org.h2.table.RegularTable.<init>(RegularTable.java:84)
at org.h2.schema.Schema.createTable(Schema.java:586)
at org.h2.engine.Database.open(Database.java:671)
at org.h2.engine.Database.openDatabase(Database.java:244)
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:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at com.pmease.quickbuild.plugin.report.engine.datastore.ConnectionManager.getConnection(ConnectionManager.java:23)
... 25 more