Hi Padma, Unfortunately we don't have a recent one as far as I'm aware.
Do we have any other options? On 28 February 2017 at 09:30, padma mullagiri <[email protected]> wrote: > 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 a topic in the > Google Groups "go-cd" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/go-cd/PA_P_4PFJ_g/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- 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.
