Sorry for the late reply Chad. No it didnt fix itself after a server restart. I ended up restoring from a snapshot a few days earlier before the issue happened. Not the best option but it worked.
On Wednesday, May 11, 2022 at 11:03:21 AM UTC-4 Chad Wilson wrote: > Broadly speaking this looks like a bug or race condition, although I have > never come across such an error before and can't see how it could happen > from the code. Unless we can find a way to replicate it, it might be > difficult to fix. > > In terms of working around it - does it fix itself after a server restart? > > -Chad > > On Tue, May 10, 2022 at 1:47 PM Sifu Tian <[email protected]> wrote: > >> 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 >> >> <https://groups.google.com/d/msgid/go-cd/e05d96e4-620e-48f9-a5a0-5e10fee8a53bn%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/754e0170-0862-4c6e-a039-f7404c71cbc2n%40googlegroups.com.
