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/CAA1RwH_mDwqYju%3DoubSMESNN47RmiWf8GAP-gkgtgJE72iU5Lw%40mail.gmail.com.
