Hi Jai, Looks like the h2db database is corrupted.
Do you have a backup? Can you try replacing the database with the backup database and try to start the server. Ensure to stop the server before replacing the database. For more information on the backup and restoring the backup you can check this document here https://docs.gocd.io/current/advanced_usage/one_click_backup.html. Let me know if this helped. Thanks, Padma On Friday, 24 February 2017 22:12:48 UTC+5:30, Jai Byron wrote: > > Hi, > > Have inherited a Go Server setup running on Mac OS X (El Capitan) 10.11.6 > > Recently I've been unable to get the server to start. > > The error log suggests as DB error but am struggling to make sense of it. > > Here's a snippet from the go-server.log after a server restart. > > 2017-02-24 16:38:34,554 ERROR [main] H2EventListener:38 - Exception thrown > from database on sql statement: SELECT > pipelines.id as pipelineId, pipelines.name as pipelineName, > buildCauseType, label, buildCauseMessage, pipelines.counter as > pipelineCounter, pipelines.label as pipelineLabel, pipelines.naturalOrder > as naturalOrder, pipelines.comment as pipelineComment, stages.name > as stageName,stages.counter as stageCounter, stages.id as stageId, > stages.approvedBy as approvedBy, stages.approvalType as > approvalType, stages.result as stageResult, stages.latestRun, > stages.rerunOfCounter, builds.id as buildId, builds.name as > buildName, builds.state as buildState, builds.result as buildResult, > builds.scheduledDate as scheduledDate, stages.orderId as orderId > FROM pipelines INNER JOIN stages ON stages.pipelineId = > pipelines.id AND stages.latestRun = true > INNER JOIN builds ON builds.stageId = stages.id AND builds.ignored != > true INNER JOIN ( SELECT stages.pipelineId AS id > FROM stages WHERE stages.state = 'Building' AND > latestRun = true UNION SELECT max(pipelines.id) AS id > FROM pipelines GROUP BY pipelines.name > ) pipelines_to_show ON pipelines.id = pipelines_to_show.id > ORDER BY pipelines.id DESC, stages.orderId ASC > org.h2.jdbc.JdbcSQLException: General error: > "java.lang.ClassCastException: org.h2.index.PageBtreeLeaf cannot be cast to > org.h2.index.PageBtreeNode"; SQL statement: > SELECT pipelines.id as pipelineId, > pipelines.name as pipelineName, buildCauseType, label, buildCauseMessage, > pipelines.counter as pipelineCounter, pipelines.label as > pipelineLabel, pipelines.naturalOrder as naturalOrder, > pipelines.comment as pipelineComment, stages.name as > stageName,stages.counter as stageCounter, stages.id as stageId, > stages.approvedBy as approvedBy, stages.approvalType as > approvalType, stages.result as stageResult, stages.latestRun, > stages.rerunOfCounter, builds.id as buildId, builds.name as > buildName, builds.state as buildState, builds.result as buildResult, > builds.scheduledDate as scheduledDate, stages.orderId as orderId > FROM pipelines INNER JOIN stages ON stages.pipelineId = > pipelines.id AND stages.latestRun = true > INNER JOIN builds ON builds.stageId = stages.id AND builds.ignored != > true INNER JOIN ( SELECT stages.pipelineId AS id > FROM stages WHERE stages.state = 'Building' AND > latestRun = true UNION SELECT max(pipelines.id) AS id > FROM pipelines GROUP BY pipelines.name > ) pipelines_to_show ON pipelines.id = pipelines_to_show.id > ORDER BY pipelines.id DESC, stages.orderId ASC [50000-168] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) > > > Any ideas or suggestions would be most welcomed. > > Have also attached the full log. > > > Regards, > > Jai > -- You received this message because you are subscribed to the Google Groups "go-cd" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
