You might want to check the full stack trace for other errors that might be happening before this, which might indicate corruption, and share those too. Sometimes errors about the DB being closed are the end result another failure, but not the root cause.
Other than that - What size is your H2 database on disk? - Which GoCD version are you running? If it's very large (multiple GB) and/or there are other errors in the stack traces that indicate something like H2 DB corruption you might want to consider trying exporting the DB and re-importing it to a fresh DB. There's a guideline of how to do this at https://gist.github.com/arvindsv/c7934bee26ce1c47e9d24f0a493d3c87 if you want to give it a go. -Chad On Tue, Nov 29, 2022 at 12:19 AM Adrien DEFOSSÉ <adrien.defo...@gmail.com> wrote: > Hi, > > Since a few weeks, we have got a recurring problem with our GoCD server. > Some times, it restart with the error: > > org.h2.jdbc.JdbcSQLNonTransientConnectionException: The database has been > closed [90098-200] > > In the last two weeks, it already happened three times. We tried to add > more memory to our service (a swarm service) but it doesn't seems to > resolve anything. > > I didn't see anyone with the same problem. Some advice? > > Thanks a lot. > > -- > 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/0728fa08-d408-4006-bb5f-787f7c3525b0n%40googlegroups.com > <https://groups.google.com/d/msgid/go-cd/0728fa08-d408-4006-bb5f-787f7c3525b0n%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/CAA1RwH8fprb4d-y6JiueEan83kQ2W_xH%3Dcj0wPESVSD6_gsV3g%40mail.gmail.com.
