Hi Aravind, Yes, we are using gocd version 19.7.0. We didn't know that go-postgresql addon only supports till postgress 9.6. Since the postgress 9.6 end of life is reaching this year November, we upgraded the postgress version to 10.15. Will try downgrading the postgress version and see how it goes.
Thank you. On Wednesday, June 9, 2021 at 9:06:03 PM UTC+5:30 Aravind SV wrote: > Are you sure you’re on 19.7.0? From the release notes, 20.5.0 > <https://www.gocd.org/releases/#20-5-0> introduced support for Postgres. > There used to be a paid add-on previously, but it only supported version > 9.6 of Postgres, if I remember correctly. > > * From*: Samhitha Rachakonda > * Subject*: [go-cd] Hibernate issue with gocd > * To*: go-cd > * Date*: Wed, 9 Jun 2021 02:43:47 -0700 (PDT) > Hello all, > > Our team is facing the following issue whenever we triggered a pipeline > which has the code from bitbucket either created from a new repo or a new > branch. > > gocd version - 19.7.0 > postgress version - 10.15 (recently migrated from 9.6 to 10.15) > > what are we doing to get this error - triggering the pipeline > actual result - it should start running the pipeline > expected result - it is throwing the following error. > > - Modification check failed for material: URL: > ssh://.../test-repo-gocd.git, Branch: master Affected pipelines are > test-gocd.09 Jun, 2021 at 15:05:29 Local Time > > Hibernate operation: could not retrieve generated id after insert: > [com.thoughtworks.go.domain.materials.git.GitMaterialInstance]; > uncategorized SQLException for SQL [insert into materials (flyweightName, > fingerprint, additionalData, url, username, branch, submoduleFolder, type) > values (?, ?, ?, ?, ?, ?, ?, 'GitMaterial')]; SQL state [55000]; error > code > [0]; ERROR: currval of sequence "materials_id_seq" is not yet defined in > this session; nested exception is org.postgresql.util.PSQLException: > ERROR: > currval of sequence "materials_id_seq" is not yet defined in this session > > Any thoughts? > Reply all > Reply to author > Forward > > -- > 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/352a7614-b0d8-4fe2-a2f8-831bb979d6f4n%40googlegroups.com > > <https://groups.google.com/d/msgid/go-cd/352a7614-b0d8-4fe2-a2f8-831bb979d6f4n%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/4b3b5f1f-ab83-4c96-98e6-f71734bbadedn%40googlegroups.com.
