Amazing, this helped me identify the malicious pipeline which had state "Passed" in builds table. I really appreciate it.
This was most likely our error, since a while back when we were using pgpool with two replica there were tons of issues with the database, many builds were getting stuck in "Unknown" state and in the database we had to manually set state and result columns to "Completed" and to fill in manually the completedbytransactionid column and we ended up using only a single replica to avoid this. However something else is amiss as well, I'm unable to open history of this pipeline I get error "There was an unknown error performing the operation. Possible reason ()". Can you give me some hints which is the table and row that is being accessed for the build history? Thanks in advance. On Saturday, April 10, 2021 at 10:47:16 AM UTC+3 Aravind SV wrote: > Hello Nikolay, , > > That’s strange. Can you open an issue on GitHub > <https://github.com/gocd/gocd/issues/>? > > I think you should look for a row where the state column is “Passed”. > Looks like there’s some data that is wrong (not sure how). The valid values > of JobState are here > <https://github.com/gocd/gocd/blob/cccb4960bde1166ccd79277093295ed5a18573ed/domain/src/main/java/com/thoughtworks/go/domain/JobState.java#L18-L29> > . > > Someone who looks at the issue there might be able to help more. > > Regards, > Aravind > -- 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/5d24b830-0392-4b18-9fe9-43ffaaa16951n%40googlegroups.com.
