Go Server and agent 22.1.0 On Tuesday, May 10, 2022 at 1:00:49 AM UTC-4 [email protected] wrote:
> Hi, which version of GoCD server and agent are you using? > > On Tue, May 10, 2022 at 11:11 AM Sifu Tian <[email protected]> wrote: > >> Hi Folks, >> >> While one of our pipelines were triggered, it failed to connect to an >> agent. GoCD reporting the error as the pipeline being hung. While >> attempting to stop the job, and error came up. >> >> ### Error updating database. Cause: >> org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: NULL not allowed >> for column "STATECHANGETIME"; SQL statement: INSERT INTO >> buildStateTransitions (currentState, stateChangeTime, buildId, stageId) >> VALUES (?, ?, ?, ?) [23502-200] ### The error may exist in >> com/thoughtworks/go/server/dao/maps/BuildStateTransition.xml ### The error >> may involve BuildStateTransition.insert-transition-param ### The error >> occurred while setting parameters ### SQL: INSERT INTO >> buildStateTransitions (currentState, stateChangeTime, buildId, stageId) >> VALUES (?, ?, ?, ?) ### Cause: >> org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: NULL not allowed >> for column "STATECHANGETIME"; SQL statement: INSERT INTO >> buildStateTransitions (currentState, stateChangeTime, buildId, stageId) >> VALUES (?, ?, ?, ?) [23502-200] ; SQL []; NULL not allowed for column >> "STATECHANGETIME"; SQL statement: INSERT INTO buildStateTransitions >> (currentState, stateChangeTime, buildId, stageId) VALUES (?, ?, ?, ?) >> [23502-200]; nested exception is >> org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: NULL not allowed >> for column "STATECHANGETIME"; SQL statement: INSERT INTO >> buildStateTransitions (currentState, stateChangeTime, buildId, stageId) >> VALUES (?, ?, ?, ?) [23502-200] >> >> It will not let me cancel this instance being run and it just hangs. >> Has anyone seen this error before or know how to solve? >> >> Any help would be greatly appreciated. >> >> Thanks![image: Screen Shot 2022-05-09 at 11.10.37 PM.png] >> >> -- >> 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]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/go-cd/22ae8275-39c3-4151-b6a1-4a6274b0e534n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/go-cd/22ae8275-39c3-4151-b6a1-4a6274b0e534n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/e05d96e4-620e-48f9-a5a0-5e10fee8a53bn%40googlegroups.com.
