Hello, I could be wrong but this looks to me like the sort of thing that should be raised as an issue on GitHub:
https://github.com/gocd/gocd/issues Regards, Jason On Wednesday, 2 December 2020 at 08:44:19 UTC-5 gdlai cn wrote: > > ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: This > version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' ### > The error may exist in com/thoughtworks/go/server/dao/maps/Stage.xml ### > The error may involve defaultParameterMap ### The error occurred while > setting parameters ### SQL: SELECT stages.name as stageName, > stages.counter as stageCounter, stages.pipelineId as pipelineId, > pipelines.name as pipelineName, pipelines.counter as pipelineCounter, > pipelines.label as pipelineLabel, stages.approvedBy, stages.cancelledBy, > stages.createdTime, stages.orderId, stages.result as stageResult, > stages.approvalType, stages.completedByTransitionId as > completedByTransitionId, stages.state as stageState, stages.latestRun, > stages.fetchMaterials, stages.cleanWorkingDir, stages.rerunOfCounter, > stages.artifactsDeleted, stages.configVersion, stages.lastTransitionedTime, > builds.*, builds.id as buildId, buildstatetransitions.currentState, > buildstatetransitions.statechangetime, buildstatetransitions.id as > stateId FROM stages INNER JOIN pipelines ON pipelines.id = > stages.pipelineId AND pipelines.name = ? INNER JOIN builds ON stages.id = > builds.stageId AND builds.ignored != true LEFT JOIN buildstatetransitions > ON builds.id = buildstatetransitions.buildId WHERE stages.id in ( SELECT > stages.id FROM stages INNER JOIN pipelines ON stages.pipelineId = > pipelines.id AND stages.name = ? AND pipelines.name = ? AND result = > 'Passed' ORDER BY id LIMIT ? OFFSET ?) AND stages.result = 'Passed' ORDER > BY stages.id, builds.name, buildstatetransitions.statechangetime ### > Cause: java.sql.SQLSyntaxErrorException: This version of MySQL doesn't yet > support 'LIMIT & IN/ALL/ANY/SOME subquery' ; bad SQL grammar []; nested > exception is java.sql.SQLSyntaxErrorException: This version of MySQL > doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' > > > MySql:8.0.22 > gocd: 20.10.0 > -- 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 go-cd+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/dac79cea-294c-4b27-b7c7-52fb52998c4dn%40googlegroups.com.
