On Tue, 10 Sep 2024 at 5:02 PM, Komgrit Aneksri <tanakacu...@gmail.com> wrote:
> Hi team, > > I am facing issue about database. > > Error message below > Could not open JDBC Connection for transaction; nested exception is > org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already > in use: null. Possible solutions: close all other connection(s); use the > server mode [90020-200] > > Now I did restarted the gocd server then it is back to normal now. > > I used GoCD version 23.1.0 running on EKS > > And store files and database (h2) on EFS. > > I have found this issue 2 times to now (last Thursday and today) > > Cloud you please help me what should improve for fix this issue? > Please migrate to postgreSQL as soon as you can. The h2db works for many of us, but is file based. You are best served by moving to Postgres which manages files better. Please also move to the latest stable gocd release. That is more recent code and it is easier for all to coordinate discussions with recent code > Best regards, > Komgrit > > > > > > -- > 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 go-cd+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/go-cd/9d1a20c3-b463-4dd3-a376-b2bcd014091cn%40googlegroups.com > <https://groups.google.com/d/msgid/go-cd/9d1a20c3-b463-4dd3-a376-b2bcd014091cn%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 go-cd+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/go-cd/CANiY96a4Phs4kJRtGEGVL-ss%2BF8Bw26pwvgLUWf%3DFM2SbauEHw%40mail.gmail.com.
